DA0-002 Practice Test 29 — 15 Questions

Question 1

Match each data quality dimension to its description.

Accepted Answer

Accuracy: Data correctly reflects real-world values. The correct matches are: Accuracy - data correctly reflects real-world values; Completeness - all required data is present; Consistency - data values are the same across systems; Timeliness - data is available when needed. Common confusions include mixing timeliness with accuracy and consistency with completeness.

Answer

Accuracy: Data is available when needed

Answer

Completeness: Data values are the same across different systems

Question 2

An organization is implementing a centralized reporting layer to replace multiple departmental spreadsheets. Which governance principle does this support?

Accepted Answer

Single version of truth. A single version of truth ensures that all users access the same consistent data, eliminating discrepancies from siloed spreadsheets.

Answer

Data dictionary

Answer

Data lineage

Answer

Row-level security

Question 3

A financial report must be retained for seven years to comply with regulatory requirements. This is an example of which data governance principle?

Accepted Answer

Data retention. Data retention policies specify how long data must be kept to meet legal or regulatory obligations.

Answer

Data freshness

Answer

Data lineage

Answer

Data dictionary

Question 4

Drag and drop the steps to create a data visualization dashboard in the correct order.

Accepted Answer

Plan the dashboard, then Select appropriate charts, then Design the layout, then Build the dashboard, then Test the dashboard. Dashboard creation starts with planning, then chart selection, layout design, building, and testing.

Answer

Plan the dashboard, then Design the layout, then Select appropriate charts, then Build the dashboard, then Test the dashboard

Answer

Plan the dashboard, then Select appropriate charts, then Build the dashboard, then Design the layout, then Test the dashboard

Answer

Select appropriate charts, then Plan the dashboard, then Design the layout, then Build the dashboard, then Test the dashboard

Question 5

A data analyst is preparing a report on regional sales performance. The report will be viewed by regional managers who should only see their own region's data. Which TWO data governance measures are most relevant?

Accepted Answer

Row-level security. Row-level security restricts access to specific rows (regions), and a data dictionary ensures consistent metric definitions across regions.

Answer

Single version of truth

Answer

Data retention

Answer

Data lineage

Question 6

A data analyst is building a supervised learning model to predict customer churn. The target variable is binary (churn = yes/no). Which TWO modeling techniques are appropriate for this task? (Select two.)

Accepted Answer

Logistic regression. Logistic regression is appropriate because it models the probability of a binary outcome (churn yes/no) using a logistic function, making it a standard choice for binary classification tasks. It outputs a value between 0 and 1, which can be thresholded to predict the class label.

Answer

K-means clustering

Answer

Linear regression

Answer

Apriori algorithm

Question 7

A data analyst is preparing a report on customer satisfaction scores. To comply with GDPR, which THREE actions must be taken? (Select THREE.)

Accepted Answer

Ensure aggregates do not identify individuals. GDPR requires anonymization of PII, ensuring aggregate data does not allow re-identification, and respecting data retention policies.

Answer

Retain data indefinitely for analysis

Answer

Include customer names for context

Question 8

A financial analyst is creating a quarterly report compliant with SOX. Which requirement is most critical for the report's audit trail?

Accepted Answer

Audit trail of data changes. SOX requires audit trails to track changes and ensure data integrity for financial reports.

Answer

Row-level security

Answer

Data lineage

Answer

Data dictionary

Question 9

An analyst is conducting an A/B test on a new website layout. Which TWO of the following must be defined before the test begins?

Accepted Answer

The significance threshold (alpha). Sample size and significance level must be set a priori to ensure proper test design.

Answer

The final conversion rates for each group

Answer

The actual p-value from the test

Answer

The confidence interval for the lift

Question 10

A data analyst is building a self-service reporting environment. Which of the following is the primary benefit of this approach?

Accepted Answer

It reduces the number of ad hoc report requests to the analytics team.. Self-service BI empowers business users to create their own reports, reducing ad hoc requests to the analytics team.

Answer

It ensures all reports use the same data source.

Answer

It automatically generates executive summaries.

Answer

It improves data security by limiting access.

Question 11

A marketing team needs to store customer feedback from social media posts, including text, images, and emojis. Which data concept is most appropriate for this storage?

Accepted Answer

Unstructured data in a NoSQL document database. Customer feedback from social media includes text, images, and emojis, which lack a predefined schema and are best stored as unstructured data. NoSQL document databases (e.g., MongoDB) store such data in flexible JSON-like documents, allowing each record to have varying fields and data types without requiring a fixed schema.

Answer

Structured data in a relational database

Answer

Unstructured data in a relational database

Answer

Semi-structured data in an XML database

Question 12

A data analyst is creating a dashboard for executives to show monthly sales trends over the past year. Which chart type is most appropriate?

Accepted Answer

Line chart. A line chart is the most appropriate choice because it excels at showing continuous data trends over time, such as monthly sales over a year. The x-axis represents the time dimension (months), and the y-axis represents sales values, allowing executives to easily identify upward or downward trends, seasonality, and inflection points. This aligns with the goal of communicating data insights clearly and effectively.

Answer

Stacked bar chart

Answer

Scatter plot

Answer

Pie chart

Question 13

A data analyst needs to visualize the relationship between two continuous variables: advertising spend (in dollars) and monthly sales (in units). Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is the most appropriate chart for visualizing the relationship between two continuous variables, such as advertising spend (dollars) and monthly sales (units). It displays individual data points on an x-y axis, allowing the analyst to observe correlation, clustering, or outliers between the two numeric fields. This aligns with the DA0-001 objective of selecting visualizations based on data type and analytical goal.

Answer

Pie chart

Answer

Bar chart

Answer

Line chart

Question 14

Which TWO are examples of primary data? (Select two.)

Accepted Answer

Customer survey responses collected by the company themselves. Primary data is collected directly by the researcher or organization for a specific purpose. Customer survey responses gathered by the company itself are firsthand, original data that have not been previously published or aggregated by an external source. This aligns with the definition of primary data as original, unprocessed information collected from the source.

Answer

Industry reports from a trade association

Answer

Government census data

Answer

Social media data purchased from a vendor

Question 15

A data analyst is creating a dashboard for a retail company. The dashboard should provide insights into sales performance across multiple dimensions. Which TWO chart types are best suited for showing the contribution of each product category to total sales?

Accepted Answer

Pie chart. A pie chart is ideal for showing the contribution of each product category to total sales because it visually represents parts of a whole, making it easy to compare proportions at a glance. The stacked bar chart also effectively shows category contributions within a total, allowing for both absolute and relative comparisons across different time periods or segments. Both chart types directly address the need to visualize proportional breakdowns of a single aggregate metric.

Answer

Scatter plot

Answer

Histogram

Answer

Line chart