DA0-002 Practice Test 13 — 15 Questions

Question 1

Which THREE of the following are components of Master Data Management (MDM)? (Select 3)

Accepted Answer

Data governance. MDM includes data governance, data integration, and data quality management to maintain a single source of truth.

Answer

Data encryption

Answer

Data archival

Question 2

A business needs to store large volumes of raw data in its native format for future analytics. Which storage architecture is most appropriate?

Accepted Answer

Data lake. A data lake is designed to store large volumes of raw data in its native format (structured, semi-structured, or unstructured) without requiring a predefined schema. This makes it ideal for future analytics where the data schema may not yet be known, as it supports schema-on-read rather than schema-on-write.

Answer

Relational database

Answer

Operational data store

Answer

Data warehouse

Question 3

A data analyst is troubleshooting a report that shows unusually high sales for a specific product. Upon investigation, the analyst finds that the product was returned by several customers, but the returns were recorded in a separate system and not reflected in the sales data. Which data integration concept was likely missing?

Accepted Answer

Data reconciliation. The core issue is that the sales data and returns data are inconsistent because they were not cross-verified. Data reconciliation is the process of comparing datasets to ensure they are in agreement and identifying discrepancies, such as returns not being reflected in sales figures. Without reconciliation, the analyst would not detect that the high sales number is inflated by unrecorded returns.

Answer

ETL (Extract, Transform, Load)

Answer

Data profiling

Answer

Data governance

Question 4

An organization needs to acquire data from a third-party vendor. The data will be used for regulatory reporting. Which of the following should be the primary consideration before acquiring the data?

Accepted Answer

Legal and compliance requirements. When acquiring data for regulatory reporting, legal and compliance requirements must be the primary consideration because the data must adhere to specific laws (e.g., GDPR, HIPAA, SOX) and industry regulations. Failing to ensure compliance can result in legal penalties, fines, or rejection of the report by regulatory bodies. This overrides technical or cost concerns, as non-compliant data is unusable for its intended purpose.

Answer

Volume of data

Answer

Data format

Answer

Cost of the data

Question 5

A data analyst is using pandas in Python to merge two DataFrames: sales (columns: sale_id, product_id, amount) and products (columns: product_id, product_name). Which pandas function should they use to combine these DataFrames on the 'product_id' column?

Accepted Answer

merge(). The pandas merge function is used to combine DataFrames on common columns. The syntax is pd.merge(sales, products, on='product_id').

Answer

combine()

Answer

join()

Answer

concat()

Question 6

Which TWO of the following are examples of data governance best practices?

Accepted Answer

Defining data owners for each dataset. Defining data owners for each dataset is a core data governance practice that establishes accountability and responsibility for data assets. Data owners are typically senior stakeholders who ensure data is managed according to policies, including access controls and quality standards. This practice aligns with frameworks like DAMA-DMBOK, which emphasizes stewardship and ownership as foundational to governance.

Answer

Creating indexes on frequently queried columns

Answer

Using a data lake for storage

Answer

Encrypting all data at rest

Question 7

A data analyst is conducting exploratory data analysis (EDA) on a dataset. Which TWO tasks are typically performed during EDA? (Select two.)

Accepted Answer

Identify outliers using the IQR method. Outlier detection and correlation analysis are key EDA activities. Model building and data sampling are separate steps.

Answer

Create a sampling plan

Answer

Build a predictive regression model

Answer

Deploy the model to production

Question 8

A market research firm collects survey responses where customers rate satisfaction on a scale of 'Very Unsatisfied', 'Unsatisfied', 'Neutral', 'Satisfied', 'Very Satisfied'. What type of data is being collected?

Accepted Answer

Ordinal. The data is ordinal because the satisfaction levels have a clear, ordered ranking from 'Very Unsatisfied' to 'Very Satisfied', but the intervals between categories are not necessarily equal. This type of categorical data preserves the order without assuming a consistent numerical difference between each level.

Answer

Interval

Answer

Ratio

Answer

Nominal

Question 9

A data analyst is performing data profiling on a customer table. Which TWO metrics are commonly used to assess the completeness of a column? (Select TWO.)

Accepted Answer

Row count. Completeness is measured by null count and row count; null count shows missing values, row count gives total rows.

Answer

Cardinality

Answer

Mean

Answer

Standard deviation

Question 10

A marketing manager wants to visualize the conversion funnel from website visits to final purchase. Which chart type is most appropriate?

Accepted Answer

Funnel chart. Funnel charts are specifically designed to show stages in a pipeline or conversion process, with decreasing values as prospects move through the funnel.

Answer

Treemap

Answer

Waterfall chart

Answer

Scatter plot

Question 11

A data analyst is using a recursive CTE to traverse an organizational hierarchy. What is the purpose of the anchor member in the recursive CTE?

Accepted Answer

It provides the initial seed or starting rows for the recursion.. The anchor member initializes the recursion with the base result set.

Answer

It filters the final output of the recursive CTE.

Answer

It specifies how to join the CTE with itself recursively.

Answer

It defines the termination condition for the recursion.

Question 12

In SQL, you want to retrieve all products whose names start with 'Pro'. Which WHERE clause should you use?

Accepted Answer

WHERE product_name LIKE 'Pro%'. LIKE with pattern 'Pro%' matches strings starting with 'Pro' followed by any characters. '%Pro%' matches any string containing 'Pro', 'Pro_' matches 'Pro' plus one character, and 'Pro' is exact match.

Answer

WHERE product_name LIKE '%Pro%'

Answer

WHERE product_name LIKE 'Pro_'

Answer

WHERE product_name = 'Pro'

Question 13

A dashboard designer wants to ensure the most important KPI is prominently displayed at the top left. Which design principle is being applied?

Accepted Answer

Visual hierarchy. Visual hierarchy arranges elements by importance, typically placing the most critical information where the eye naturally starts (top left in Western cultures).

Answer

Consistent color coding

Answer

Data-ink ratio

Answer

Appropriate precision

Question 14

A data analyst is creating a dashboard and wants to maximize the data-ink ratio. Which action supports this principle?

Accepted Answer

Removing gridlines and reducing chart borders.. Removing unnecessary gridlines and decorative elements reduces non-data ink, thereby increasing the data-ink ratio. The data-ink ratio is the proportion of ink used to display data versus total ink used in the chart.

Answer

Including detailed data tables alongside charts.

Answer

Using 3D effects to make bars stand out.

Answer

Adding a background image to make the dashboard visually appealing.

Question 15

A dashboard designer is creating a KPI dashboard for executives. Which of the following is a leading indicator?

Accepted Answer

Number of qualified leads. Number of qualified leads is a leading indicator as it predicts future sales, while revenue and customer churn are lagging indicators.

Answer

Net profit margin

Answer

Monthly revenue

Answer

Customer churn rate