DA0-002 Practice Test 5 — 10 Questions

Question 1

A data analyst is creating a self-service reporting environment. Which data governance practice ensures users see only data relevant to their department?

Accepted Answer

Row-level security. Row-level security restricts data access based on user roles, ensuring users only see authorized data.

Answer

Data lineage

Answer

Data dictionary

Answer

Single version of truth

Question 2

Which TWO are common pitfalls when communicating data insights?

Accepted Answer

Using misleading scales on charts. Using misleading scales on charts (e.g., truncating the y-axis or using non-zero baselines) distorts the visual representation of data, leading to incorrect interpretations. This violates the principle of data integrity in data visualization, as it can exaggerate or minimize trends, making it a common pitfall when communicating data insights.

Answer

Explaining assumptions clearly

Answer

Including a clear call to action

Answer

Providing context for the data

Question 3

A data analyst is examining the relationship between advertising spend (in dollars) and revenue (in dollars). The Pearson correlation coefficient r is calculated as +0.92. Which of the following interpretations is correct?

Accepted Answer

There is a strong positive linear relationship.. r = +0.92 indicates a strong positive linear relationship.

Answer

There is a strong negative linear relationship.

Answer

There is no linear relationship.

Answer

92% of the variation in revenue is explained by advertising spend.

Question 4

A data analyst is performing exploratory data analysis on a dataset containing house prices. They want to identify outliers in the 'price' column using the IQR method. The first quartile (Q1) is $200,000, the third quartile (Q3) is $350,000, and the IQR is $150,000. What is the upper bound for identifying outliers?

Accepted Answer

$575,000. The IQR method defines outliers as values below Q1 - 1.5*IQR or above Q3 + 1.5*IQR. Upper bound = 350,000 + (1.5 * 150,000) = 350,000 + 225,000 = $575,000.

Answer

$500,000

Answer

$425,000

Answer

$650,000

Question 5

A healthcare analytics team is responsible for producing a monthly dashboard for hospital administrators. The dashboard includes key metrics such as patient admission rates, average length of stay, readmission rates, and bed occupancy. For the current month, the data shows a significant increase in average length of stay. The data analyst suspects that this increase is due to a new chronic disease management program that was implemented at the beginning of the month. However, the analyst also notices that the data for the previous month had an error: some discharge dates were incorrectly recorded, causing the average length of stay to be artificially low. The analyst needs to communicate the insights to the administrators, who are concerned about the increase. Which of the following is the best course of action?

Accepted Answer

Correct the previous month's data, recalculate the change, and present the increase alongside an explanation of the new program and the data correction.. The best course of action because it addresses both the data quality issue and the business concern. By correcting the previous month's erroneous discharge dates, the analyst recalculates the true baseline, ensuring the reported increase in average length of stay is accurate. Presenting the corrected data alongside an explanation of the new chronic disease management program provides a complete, transparent narrative that separates the impact of the data error from the program's effect, which is essential for informed decision-making by hospital administrators.

Answer

Correct the previous month's data and present the adjusted increase, emphasizing the data error.

Answer

Present the raw data as-is and explain that the increase is due to the new program.

Answer

Delay the report until the next month to gather more data on the program's effect.

Question 6

A data analyst wants to extract the year from a date column 'order_date' in a SQL database. Which function should be used?

Accepted Answer

YEAR(order_date). The YEAR() function extracts the year from a date. DATEADD adds intervals, DATEDIFF calculates differences, GETDATE() returns current date.

Answer

DATEADD(year, order_date, 0)

Answer

DATEDIFF(year, order_date, GETDATE())

Answer

GETDATE()

Question 7

An analyst notices that a dashboard displays conflicting data from two sources. What is the first step in troubleshooting?

Accepted Answer

Check data transformation steps and join logic. The first step in troubleshooting conflicting data from multiple sources is to verify the data transformation steps and join logic. Conflicts often arise from incorrect joins (e.g., using INNER JOIN instead of LEFT JOIN), mismatched keys, or data type conversions that alter values. Checking these steps isolates the root cause before any other action, such as re-running queries or notifying stakeholders.

Answer

Re-run all queries

Answer

Notify stakeholders of potential error

Answer

Replace the data source with the one believed to be correct

Question 8

Based on the exhibit, what is the most likely cause of the import failure?

Accepted Answer

A data quality issue: the date field contains an invalid date.. The exhibit shows a date field containing '2023-02-30', which is an invalid date (February never has 30 days). This data quality issue causes the import to fail, as the system likely validates date values against calendar rules before inserting them into the target table. The error is not due to file emptiness, non-numeric characters, or corruption, but specifically a semantic data integrity violation.

Answer

The file is empty or contains only headers.

Answer

The price field includes non-numeric characters that cannot be parsed.

Answer

The source file is corrupted or in an unsupported format.

Question 9

A data analyst needs to share a weekly sales report with the marketing team. The report includes aggregated data from the data warehouse. To simplify access, the analyst creates a virtual table that encapsulates the complex query. Which database object should the analyst create?

Accepted Answer

View. A view is a virtual table that encapsulates a complex query, allowing users to access aggregated data without needing to understand the underlying SQL. In this scenario, the analyst creates a view to simplify access to the weekly sales report, as it presents pre-defined, aggregated data from the data warehouse as if it were a table.

Answer

Trigger

Answer

Stored procedure

Answer

Index

Question 10

Refer to the exhibit. What data quality issue is indicated?

Accepted Answer

Non-standardized data entry. The error shows that a non-numeric value 'N/A' is present in a numeric column, indicating non-standardized data entry. Duplication, inconsistency, or outliers are not directly shown.

Answer

Data inconsistency

Answer

Outlier

Answer

Data duplication