DA0-002 Quick Quiz — 10 Questions

Question 1

A data analyst needs to count the number of customers who have placed at least one order. Which SQL query should be used?

Accepted Answer

SELECT COUNT(DISTINCT customer_id) FROM orders. COUNT(DISTINCT customer_id) counts each unique customer exactly once, which is precisely what is needed to answer 'how many customers placed at least one order' — a customer with multiple orders is counted only once. This is the standard SQL pattern for counting distinct entities in a fact table.

Answer

SELECT DISTINCT COUNT(customer_id) FROM orders

Answer

SELECT SUM(customer_id) FROM orders

Answer

SELECT COUNT(customer_id) FROM orders

Question 2

A marketing team uses K-means clustering to segment customers based on purchase history. To determine the optimal number of clusters, they plot the within-cluster sum of squares (WCSS) against k and look for an elbow. What is the purpose of this method?

Accepted Answer

To find the point where the rate of decrease in WCSS slows down. The elbow method helps choose k where adding more clusters yields diminishing returns in reducing variance.

Answer

To identify the value of k that minimizes WCSS

Answer

To determine the initial centroids for the algorithm

Answer

To ensure all clusters have equal size

Question 3

During an ETL process, a data quality check fails due to duplicate customer IDs. Which data quality dimension is violated?

Accepted Answer

Uniqueness. Duplicate customer IDs violate the uniqueness dimension because uniqueness ensures that each record in a dataset has a distinct identifier with no duplicates. In an ETL process, a primary key or unique constraint on the customer ID column would reject duplicate values, causing the data quality check to fail. This is distinct from consistency, which checks for logical agreement across data sources.

Answer

Consistency

Answer

Completeness

Answer

Accuracy

Question 4

A dashboard designer is creating a sales performance dashboard and wants to minimize non-data ink to improve clarity. Which action best follows the principle of maximizing the data-ink ratio?

Accepted Answer

Removing gridlines that do not add value to the chart. It directly follows Tufte's data-ink ratio principle by removing non-data ink (gridlines that don't aid interpretation) while preserving the core data. This maximizes the proportion of ink devoted to actual sales metrics, improving clarity without sacrificing information.

Answer

Including a detailed company logo on every chart

Answer

Adding a background image to make the dashboard more visually appealing

Answer

Using 3-D effects on bars to make them stand out

Question 5

A data analyst creates a report showing sales by product category. The analyst notices that one category has a very high sales figure due to a one-time bulk order. Which of the following is the best way to communicate this insight to stakeholders?

Accepted Answer

Add a note to the chart explaining the bulk order.. It maintains data integrity while providing necessary context. Adding a note to the chart allows stakeholders to understand the anomaly without distorting the underlying data. This approach aligns with best practices in data communication, where transparency about outliers is critical for accurate interpretation.

Answer

Delete the bulk order from the dataset.

Answer

Remove the category with the bulk order from the report.

Answer

Use a pie chart to show the proportion of each category.

Question 6

An analyst creates a dashboard with a large amount of decorative graphics and background images. According to CompTIA Data+, which design principle is being violated?

Accepted Answer

Data-ink ratio. The data-ink ratio, a concept from Edward Tufte, states that a visualization should maximize the proportion of ink used to represent actual data relative to total ink used. By adding excessive decorative graphics and background images, the analyst reduces this ratio, making the dashboard less efficient and potentially obscuring the data. CompTIA Data+ emphasizes minimizing non-data ink to improve clarity and insight extraction.

Answer

Visual hierarchy

Answer

Appropriate precision

Answer

Consistent color coding

Question 7

A small business wants to acquire customer feedback through a short questionnaire emailed after purchase. Which data acquisition method does this represent?

Accepted Answer

Survey. A survey is a structured data collection method where respondents answer predefined questions, typically via a form or questionnaire. In this scenario, the business is using a short questionnaire emailed after purchase to gather customer feedback, which directly aligns with the definition of a survey as a data acquisition method.

Answer

Transaction log

Answer

Interview

Answer

Observation

Question 8

A large online retailer stores customer orders in a PostgreSQL database. Each order has a unique order ID, and the database is normalized to 3NF. Which type of data is this?

Accepted Answer

Structured data. The data is structured because it resides in a normalized PostgreSQL database with a unique order ID and conforms to a fixed schema (3NF). Structured data is organized into rows and columns with defined data types, enabling efficient SQL querying and ACID compliance. PostgreSQL's relational model enforces this structure through tables, constraints, and indexes.

Answer

Semi-structured data

Answer

Unstructured data

Answer

Metadata

Question 9

A retail company has a dashboard that tracks daily sales across all stores. The dashboard is used by the CEO during monthly board meetings. Recently, the CEO complained that the dashboard is confusing and takes too long to interpret. The data analyst is asked to redesign the dashboard to improve usability. The analyst has access to all sales data. The CEO prefers a high-level overview with the ability to drill down into regions if needed. The analyst must decide on a course of action. What should the analyst do first?

Accepted Answer

Interview the CEO to determine key performance indicators and preferred layout.. The correct first step is to interview the CEO to determine key performance indicators and preferred layout. This ensures the dashboard is designed around the specific high-level metrics the CEO needs for monthly board meetings, with the ability to drill down into regions. Starting with stakeholder requirements prevents wasted effort on irrelevant visualizations or formats.

Answer

Revamp the dashboard with as many visualizations as possible.

Answer

Conduct a survey of all employees to understand their needs.

Answer

Create a static PDF report instead of a dashboard.

Question 10

A business analyst wants to show the relationship between advertising spend (independent variable) and sales revenue (dependent variable) for 12 different regions. Each region will be represented by a point. Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is the most appropriate chart type because it directly visualizes the relationship between two continuous variables—advertising spend (independent) and sales revenue (dependent)—by plotting each of the 12 regions as a point. This allows the analyst to assess correlation, trends, and outliers, which is the core purpose of scatter plots in data visualization.

Answer

Line chart

Answer

Bar chart

Answer

Histogram