DA0-002 Practice Test 48 — 15 Questions

Question 1

A data analyst needs to show the cumulative revenue over time, with emphasis on the total magnitude. Which chart type is most appropriate?

Accepted Answer

Area chart. Area charts display cumulative values over time, filling the area under the line to emphasize magnitude.

Answer

Scatter plot

Answer

Bar chart

Answer

Pie chart

Question 2

In Tableau, an analyst wants to create a parameter that allows users to select a threshold for highlighting products with sales above that value. The parameter is used in a calculated field that returns TRUE if sales exceed the parameter value. Which type of calculated field is this?

Accepted Answer

Boolean calculation. A Boolean calculated field returns TRUE or FALSE based on a condition.

Answer

Table calculation

Answer

Aggregate calculation

Answer

Level of Detail expression

Question 3

A data analyst is designing a dashboard for executives to monitor company performance. Which THREE practices should the analyst follow to ensure effective storytelling with data? (Select three.)

Accepted Answer

Annotate key events on time-series charts. Effective data storytelling includes a narrative arc, choosing the right chart, and annotating key events.

Answer

Include as much data as possible to avoid missing details

Answer

Always use pie charts for part-to-whole comparisons

Question 4

A data analyst needs to create a visual that shows the distribution of customer ages across different regions. Which chart type is most appropriate?

Accepted Answer

Stacked bar chart. A stacked bar chart is most appropriate because it allows the analyst to compare the distribution of customer ages (typically grouped into bins) across multiple regions simultaneously. Each bar represents a region, and the segments within the bar show the proportion or count of each age group, making it easy to see both the overall distribution and regional differences.

Answer

Line chart

Answer

Scatter plot

Answer

Pie chart

Question 5

An analyst is reviewing a table that stores customer orders. The table contains columns: OrderID, CustomerName, Product1, Product1Qty, Product2, Product2Qty. This design violates which normal form?

Accepted Answer

First normal form (1NF). The table violates First Normal Form (1NF) because it contains repeating groups (Product1, Product1Qty, Product2, Product2Qty) instead of storing each product in a separate row. 1NF requires that each column contains atomic values and that there are no repeating groups or arrays. The presence of multiple product columns for a single order breaks this atomicity and normalization rule.

Answer

No violation

Answer

Third normal form (3NF)

Answer

Second normal form (2NF)

Question 6

A data analyst receives a request from a sales manager for a one-time report on Q4 performance by product line. The report is not expected to be repeated. Which type of report should the analyst create?

Accepted Answer

Ad hoc report. An ad hoc report is created for a specific, one-time request, as opposed to scheduled or recurring reports.

Answer

Scheduled report

Answer

Operational report

Answer

Self-service report

Question 7

A data analyst needs to communicate the findings of a marketing campaign analysis to the Vice President of Marketing. The VP typically only reads the first paragraph and wants the key takeaway immediately. Which format should the analyst use?

Accepted Answer

An executive summary. An executive summary provides a concise overview with headline numbers and key insights, suitable for busy executives.

Answer

A raw data extract

Answer

A detailed technical report

Answer

A data dictionary

Question 8

An organization wants to ensure that all reports use the same definitions for metrics like 'Active Customer' to avoid confusion. Which data governance element should be implemented?

Accepted Answer

Data dictionary. A data dictionary provides consistent definitions, calculation methods, sources, and update frequencies for metrics.

Answer

Row-level security

Answer

Single version of truth

Answer

Data lineage

Question 9

A data analyst is designing a dashboard for senior executives who need to quickly monitor key business metrics. Which TWO design principles should the analyst follow? (Choose two.)

Accepted Answer

Display only the most important KPIs. Senior executives need to monitor key business metrics at a glance, not be overwhelmed with extraneous data. Displaying only the most important KPIs ensures the dashboard is focused and actionable, aligning with the principle of delivering concise, high-level insights for quick decision-making.

Answer

Include detailed data tables for reference

Answer

Add complex interactive filters

Answer

Use as many colors as possible to make it visually appealing

Question 10

A data analyst uses Python's pandas library to read a CSV file into a DataFrame. Which function is used to read the file?

Accepted Answer

pd.read_csv(). pd.read_csv() is the standard pandas function to read a CSV file.

Answer

pd.import_csv()

Answer

pd.read_excel()

Answer

pd.load_csv()

Question 11

A data analyst is creating a report on customer satisfaction scores. The analyst wants to ensure that regional managers can only see data for their own region. Which security measure should be applied?

Accepted Answer

Row-level security. Row-level security restricts data visibility so that users see only the rows relevant to them, such as their region.

Answer

Data encryption

Answer

Single version of truth

Answer

Data masking

Question 12

Refer to the exhibit. A data analyst is reviewing the configuration of an executive dashboard. The dashboard refreshes daily at 6:00 AM. Which of the following best describes a potential issue with this dashboard for executive use?

Accepted Answer

The dashboard uses a table visualization which may not be suitable for quick insights.. An executive dashboard should provide quick, at-a-glance insights, and a table visualization forces the viewer to read through rows of data rather than immediately grasping trends or outliers. For high-level decision-making, visualizations like line charts, bar charts, or KPI tiles are more effective at conveying key metrics without cognitive overload.

Answer

The data sources do not include all necessary tables.

Answer

The alert condition for revenue is set too low.

Answer

The refresh schedule is too frequent.

Question 13

A data analyst is creating a weekly KPI email for executives. Which TWO attributes are most important for this type of report?

Accepted Answer

Providing an executive summary with key metrics. Scheduled reports for executives should be concise and automated, with clear headline metrics and context.

Answer

Allowing interactive drill-down

Answer

Including raw data tables

Answer

Including real-time data

Question 14

A marketing analyst needs to answer a one-time question about campaign performance for a specific week. Which report type is appropriate?

Accepted Answer

Ad hoc report. Ad hoc reports are designed for unique, on-demand queries.

Answer

Operational report

Answer

Self-service report

Answer

Scheduled report

Question 15

A data analyst is designing a self-service reporting platform for business users. Which TWO practices will help ensure data consistency and trust? (Select TWO.)

Accepted Answer

Implement a single version of truth. A single version of truth ensures everyone uses the same data, and a data dictionary provides clear definitions.

Answer

Allow users to create their own data sources

Answer

Grant row-level security to all users

Answer

Remove all data lineage tracking