# Free DA0-002 practice questions

> 10 free DA0-002 practice questions with the correct answer and an explanation.

Page: https://devopscodelab.com/exams/comptia-da0-002/free-practice-questions/
Practice exams: https://devopscodelab.com/exams/comptia-da0-002/

### Question 1 of 10

An organization wants a single platform that stores raw files of any format cheaply like a data lake, while also supporting ACID transactions, schema enforcement, and BI queries directly on that storage. Which architecture meets these requirements?

- A. Data mart
- B. Data lakehouse
- C. Enterprise data warehouse
- D. Operational data store

**Answer:** B

**Explanation:** A data lakehouse combines low-cost lake storage for any file format with warehouse features such as ACID transactions and schema enforcement through open table formats. A data mart is a subject-specific subset of a warehouse and does not hold raw files of every type. An operational data store integrates current transactional data for operational reporting and is not designed for raw, multi-format storage. A traditional enterprise data warehouse enforces schemas on load but does not cheaply store raw unstructured files.

### Question 2 of 10

A product dimension stores category and department attributes. When a product moves to a new category, analysts must still report historical sales under the category that applied at the time of sale. Which design meets this requirement?

- A. Type 2 slowly changing dimension with new rows and effective dates
- B. Type 1 slowly changing dimension that overwrites the category in place
- C. Store the category directly in the fact table as a numeric measure
- D. Type 1 dimension plus a nightly full reload of the fact table

**Answer:** A

**Explanation:** A Type 2 slowly changing dimension inserts a new row with its own surrogate key and effective dates whenever an attribute changes, so older facts stay linked to the old category. A Type 1 dimension overwrites the value and loses history, and reloading the facts does not restore it. Category is a descriptive attribute, not a measure, and duplicating it into the fact table breaks the dimensional model and complicates maintenance.

### Question 3 of 10

A marketing analyst must combine January and February transaction tables that have identical columns into one table containing all rows from both months. Which operation should be used?

- A. Pivot of the month column
- B. Inner join on transaction ID
- C. Left join on customer ID
- D. Append (union) of the two tables

**Answer:** D

**Explanation:** Appending, or a UNION, stacks rows from tables that share the same columns, which is exactly what combining two months of identically structured data requires. An inner join on transaction ID would match rows across months, and since IDs differ, it would return few or no rows. Pivoting reshapes rows into columns rather than combining tables. A left join on customer ID would widen the result with columns from the second table and duplicate rows for repeat customers.

### Question 4 of 10 (choose 2)

A complex report query repeats the same expensive subquery that filters and aggregates a large sales table in four different places. Which TWO approaches would MOST reduce duplicated work? (Choose two.)

- A. Wrap each subquery in SELECT DISTINCT to reduce the rows that it returns
- B. Materialize the subquery result once in a temporary table and reuse it
- C. Define the subquery once in a common table expression and reference it
- D. Replace each subquery with a CROSS JOIN against the full sales table
- E. Add ORDER BY to each subquery so its results are returned already sorted

**Answer:** B, C

**Explanation:** A temporary table computes the expensive aggregation once and lets every reference read the small result, and a common table expression defines the logic once so it is easier to maintain and can be optimized or materialized by the engine. Adding ORDER BY inside subqueries adds sorting work without reducing repetition. A cross join multiplies rows instead of reducing work. DISTINCT adds deduplication cost and does not stop the subquery from running repeatedly.

### Question 5 of 10

A retailer wants to know whether preferred payment method (card, cash, mobile) is independent of customer age group (18–34, 35–54, 55+). Both variables are categorical counts. Which statistical test is MOST appropriate?

- A. Chi-square test of independence
- B. Pearson product-moment correlation
- C. Simple linear regression
- D. Two-sample independent t-test

**Answer:** A

**Explanation:** The chi-square test of independence compares observed and expected counts in a contingency table to determine whether two categorical variables are related. A two-sample t-test compares the means of a numeric variable between two groups. Pearson correlation measures the linear relationship between two numeric variables. Simple linear regression predicts a numeric outcome and does not fit two categorical variables.

### Question 6 of 10

A quality team tests whether a new process changes the defect rate. Their test concludes the process reduces defects, but a later large-scale rollout shows no real change. Which error did the original test MOST likely commit?

- A. Type I error
- B. Survivorship bias
- C. Type II error
- D. Sampling frame error

**Answer:** A

**Explanation:** A Type I error is a false positive: rejecting a true null hypothesis and concluding an effect exists when it does not. A Type II error is the opposite, failing to detect an effect that is real. A sampling frame error concerns the list from which the sample is drawn and does not by itself describe a false conclusion of effect. Survivorship bias arises from analyzing only cases that passed a selection filter, which the scenario does not describe.

### Question 7 of 10

An analyst runs an A/B test on a checkout page and obtains a p-value of 0.03 with a significance level of 0.05. Which conclusion is correct?

- A. Accept the alternative with 97% certainty that it is the true effect
- B. Fail to reject the null hypothesis; the difference is due to chance
- C. Reject the null hypothesis; the difference is statistically significant
- D. The test is inconclusive until the p-value is below 0.01

**Answer:** C

**Explanation:** Because the p-value of 0.03 is below the chosen alpha of 0.05, the null hypothesis of no difference is rejected and the result is statistically significant. Failing to reject would be the conclusion only if the p-value exceeded alpha. A p-value is not the probability that the alternative hypothesis is true, so '97% certainty' misinterprets it. The 0.01 threshold is not required; the significance level was set at 0.05 before the test.

### Question 8 of 10 (choose 2)

A dashboard will be used by employees who have color vision deficiencies. Which TWO design practices improve accessibility? (Choose two.)

- A. Choose a colorblind-safe palette with strong contrast between hues
- B. Use a red-green diverging palette to highlight good and bad values
- C. Add data labels or patterns so meaning does not rely on color alone
- D. Encode categories by subtle shade differences within one hue
- E. Use thin light-gray fonts to keep the visual design minimal

**Answer:** A, C

**Explanation:** Labels, patterns, or icons ensure the information is conveyed even if color cannot be distinguished, and colorblind-safe palettes with good contrast keep series distinguishable. Red-green palettes are the hardest combination for the most common forms of color vision deficiency. Thin light-gray fonts reduce contrast and readability. Subtle shades of one hue are difficult to tell apart for all viewers, especially those with color vision deficiencies.

### Question 9 of 10

Executives complain that a sales dashboard takes too long to understand. It has 14 visuals, five colors per chart, and several 3D pie charts. Which change would MOST improve comprehension?

- A. Convert all visuals into data tables so exact values are visible
- B. Add a detailed text paragraph explaining each visual on the page
- C. Reduce to the key KPIs, use a consistent palette, and use 2D charts
- D. Increase the refresh frequency so that the numbers stay current

**Answer:** C

**Explanation:** Limiting the page to the metrics executives need, applying a consistent color palette, and replacing 3D pies with flat charts reduces clutter and distortion, which is what is slowing comprehension. Long text paragraphs add reading load instead of reducing it. Converting everything to tables removes the visual pattern recognition that dashboards provide. Refresh frequency affects data currency, not how quickly the page can be understood.

### Question 10 of 10

Which role is typically responsible for defining business rules, quality expectations, and correct usage of a specific data domain such as customer data, while not managing the underlying storage infrastructure?

- A. Data steward
- B. Database administrator
- C. Data custodian
- D. Data processor

**Answer:** A

**Explanation:** A data steward manages the meaning, quality rules, and proper use of a data domain on behalf of the business. A data custodian maintains the technical environment, such as storage, backups, and access mechanisms. A database administrator is a technical custodian-type role focused on database operations. Data processor is a privacy-law term for a party that processes personal data on behalf of a controller.

Ready for a timed run? Take the free 15-question DA0-002 mini exam: https://devopscodelab.com/app/exams/comptia-da0-002/mini/

DevOpsCode Lab is not affiliated with CompTIA. DA0-002 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
