DA0-002 Practice Test 16 — 15 Questions

Question 1

A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?

Accepted Answer

Data blending. Blending in Looker Studio allows combining data from different sources based on a common dimension, similar to a left join.

Answer

Community connector

Answer

Filter

Answer

Calculated field

Question 2

A financial analyst wants to create a dashboard that shows the monthly profit and loss, highlighting how each component (revenue, cost of goods sold, operating expenses) contributes to the final net profit. Which chart type is most appropriate?

Accepted Answer

Waterfall chart. A waterfall chart effectively shows how each incremental positive or negative value contributes to a final total, making it ideal for profit/loss breakdowns.

Answer

Pie chart

Answer

Stacked bar chart

Answer

Area chart

Question 3

A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Table calculations. Tableau's table calculations can compute running totals and year-over-year comparisons without modifying the data source.

Answer

Calculated fields

Answer

Level of Detail (LOD) expressions

Answer

Parameters

Question 4

A data analyst is using Tableau to build a dashboard. Which THREE features are available in Tableau for creating interactive dashboards?

Accepted Answer

Dashboard actions. Parameters, calculated fields, and dashboard actions are key Tableau features for interactivity. LOD expressions are also available but not required for interactivity per se. Power Query is a Power BI feature.

Answer

DAX measures

Answer

Power Query

Question 5

An analyst is creating a report in Power BI and needs to calculate year-to-date total sales compared to the same period last year. Which TWO DAX functions should be used? (Choose two.)

Accepted Answer

SAMEPERIODLASTYEAR. TOTALYTD computes year-to-date, and SAMEPERIODLASTYEAR shifts context to the prior year. CALCULATE modifies filter context, often used with time intelligence.

Answer

FILTER

Answer

Answer

SUMX

Question 6

A retail company generates a daily PDF report showing the previous day's sales by region and product category. The report is automatically emailed to store managers at 6:00 AM. Which type of report is this?

Accepted Answer

Scheduled report. Scheduled reports are automated and delivered on a regular cadence. This daily sales report is scheduled and automatically delivered.

Answer

Self-service report

Answer

Ad hoc report

Answer

Operational report

Question 7

A manager in operations needs a real-time dashboard showing production line status, including machine uptime and error counts. Which type of report is most appropriate?

Accepted Answer

Operational report. Operational reports provide real-time or near-real-time data for monitoring ongoing processes.

Answer

Analytical report

Answer

Ad hoc report

Answer

Scheduled report

Question 8

A data analyst creates a weekly KPI dashboard for executives. The analyst notes that the data is updated as of the previous day. Which report quality element should be included?

Accepted Answer

Data freshness timestamp. Data freshness indicates how recent the data is, which is crucial for interpreting the report's timeliness.

Answer

Data dictionary

Answer

Data lineage

Answer

Row-level security

Question 9

A data analyst needs to summarize customer satisfaction scores. The data contains a few extremely low scores that skew the distribution. Which measure of central tendency is most appropriate?

Accepted Answer

Median. The median is the most appropriate measure of central tendency when data contains extreme outliers, such as the very low customer satisfaction scores described. Unlike the mean, the median is resistant to skew because it depends only on the middle value(s) of the sorted dataset, not on the magnitude of extreme values. This makes it the standard choice for summarizing ordinal or skewed interval/ratio data in data analysis.

Answer

Range

Answer

Mode

Answer

Mean

Question 10

A sales report shows a 10% increase in revenue, but the analyst knows the data has limitations. Which TWO elements should be included to communicate uncertainty? (Select TWO.)

Accepted Answer

Caveats about data completeness. Confidence intervals and caveats help stakeholders understand data limitations.

Answer

Executive summary

Answer

Data dictionary definitions

Answer

Detailed row-level data

Question 11

A company is implementing a centralized reporting layer to replace departmental spreadsheets. Which TWO benefits are most directly achieved?

Accepted Answer

Improved data lineage. A centralized reporting layer ensures a single version of truth and improves data lineage by tracking data origins.

Answer

Elimination of all data errors

Answer

Reduced need for data governance

Answer

Faster report generation

Question 12

Which of the following is a characteristic of structured data?

Accepted Answer

It conforms to a fixed schema with rows and columns.. Structured data is defined by its adherence to a fixed schema, typically organized into rows and columns within relational databases. This rigid structure enables efficient querying and manipulation using SQL, as each field has a predefined data type and constraints. The correct answer highlights this fundamental characteristic, which distinguishes structured data from semi-structured or unstructured formats.

Answer

It has a flexible schema that can vary per record.

Answer

It cannot be analyzed using SQL.

Answer

It is stored as blobs in a data lake.

Question 13

A government agency's data analyst is commissioned to produce a report on public transportation usage trends. The report will be read by policymakers, transit planners, and the general public. The data includes ridership numbers, delay rates, and demographic breakdowns. The analyst needs to ensure the report is accessible and persuasive, especially to non-technical readers. The goal is to advocate for increased funding in underserved areas. The report must be data-driven but also tell a compelling story. What strategy should the analyst prioritize?

Accepted Answer

Create a narrative that highlights the impact of delayed trains on low-income commuters.. It directly addresses the need to make data accessible and persuasive to non-technical readers by weaving a narrative around a specific, relatable impact (delayed trains on low-income commuters). This approach aligns with the goal of advocating for increased funding in underserved areas, as it humanizes the data and creates a compelling story that policymakers and the public can understand and act upon, without requiring technical expertise.

Answer

Provide raw data in appendices only.

Answer

Use complex statistical analysis to show significance of trends.

Answer

Focus solely on ridership numbers without context.

Question 14

A data analyst at a marketing agency is working with a dataset containing customer demographics, purchase history, and social media engagement metrics. The agency wants to perform sentiment analysis on unstructured social media comments to identify brand perception. The dataset also includes structured fields like age, income, and purchase amounts. The analyst needs to choose a storage and processing platform that can handle both structured and unstructured data efficiently without requiring extensive schema definition upfront. Which platform should the analyst recommend?

Accepted Answer

Data lake. A data lake is the correct choice because it can store both structured data (e.g., age, income, purchase amounts) and unstructured data (e.g., social media comments) in its native format without requiring a predefined schema. This flexibility allows the analyst to ingest raw social media text for sentiment analysis and later apply schema-on-read for structured queries, avoiding the upfront schema definition needed by other platforms.

Answer

Relational database (RDBMS)

Answer

Data warehouse

Answer

NoSQL document database

Question 15

A data analyst is using SQL to filter a sales table for transactions that occurred in either 'Q1' or 'Q3' of 2023 and have a sale amount greater than $100. Which WHERE clause correctly implements this condition?

Accepted Answer

WHERE quarter = 'Q1' AND amount > 100 OR quarter = 'Q3' AND amount > 100. Both C and D correctly implement the filter. SQL's operator precedence gives AND higher priority than OR, so option C is parsed as (quarter = 'Q1' AND amount > 100) OR (quarter = 'Q3' AND amount > 100), which is equivalent to (quarter = 'Q1' OR quarter = 'Q3') AND amount > 100. Option D expresses the same condition directly with parentheses.

Answer

WHERE quarter IN ('Q1','Q3') OR amount > 100

Answer

WHERE quarter = 'Q1' OR quarter = 'Q3' AND amount > 100