DA0-002
Free DA0-002 practice questions
10 questions from our DA0-002 practice tests, each with the correct answer and a written explanation. Read them with the answers shown, or switch to quiz mode and answer first.
Question 1 of 10, Data Concepts and Environments
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?
- AData mart
- BData lakehouse Correct answer
- CEnterprise data warehouse
- DOperational data store
Answer and 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, Data Concepts and Environments
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?
- AType 2 slowly changing dimension with new rows and effective dates Correct answer
- BType 1 slowly changing dimension that overwrites the category in place
- CStore the category directly in the fact table as a numeric measure
- DType 1 dimension plus a nightly full reload of the fact table
Answer and 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, Data Acquisition and Preparation
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?
- APivot of the month column
- BInner join on transaction ID
- CLeft join on customer ID
- DAppend (union) of the two tables Correct answer
Answer and 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, Data Acquisition and Preparation. 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.)
- AWrap each subquery in SELECT DISTINCT to reduce the rows that it returns
- BMaterialize the subquery result once in a temporary table and reuse it Correct answer
- CDefine the subquery once in a common table expression and reference it Correct answer
- DReplace each subquery with a CROSS JOIN against the full sales table
- EAdd ORDER BY to each subquery so its results are returned already sorted
Answer and 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, Data Analysis
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?
- AChi-square test of independence Correct answer
- BPearson product-moment correlation
- CSimple linear regression
- DTwo-sample independent t-test
Answer and 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, Data Analysis
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?
- AType I error Correct answer
- BSurvivorship bias
- CType II error
- DSampling frame error
Answer and 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, Data Analysis
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?
- AAccept the alternative with 97% certainty that it is the true effect
- BFail to reject the null hypothesis; the difference is due to chance
- CReject the null hypothesis; the difference is statistically significant Correct answer
- DThe test is inconclusive until the p-value is below 0.01
Answer and 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, Visualization and Reporting. Choose 2.
A dashboard will be used by employees who have color vision deficiencies. Which TWO design practices improve accessibility? (Choose two.)
- AChoose a colorblind-safe palette with strong contrast between hues Correct answer
- BUse a red-green diverging palette to highlight good and bad values
- CAdd data labels or patterns so meaning does not rely on color alone Correct answer
- DEncode categories by subtle shade differences within one hue
- EUse thin light-gray fonts to keep the visual design minimal
Answer and 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, Visualization and Reporting
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?
- AConvert all visuals into data tables so exact values are visible
- BAdd a detailed text paragraph explaining each visual on the page
- CReduce to the key KPIs, use a consistent palette, and use 2D charts Correct answer
- DIncrease the refresh frequency so that the numbers stay current
Answer and 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, Data Governance
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?
- AData steward Correct answer
- BDatabase administrator
- CData custodian
- DData processor
Answer and 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.