Courseiva

CompTIA Data+ (DA0-002) (DA0-002) — Questions 151–225

1004 questions total · 14 pages · All types, answers revealed

Page 2

Page 3 of 14

Page 4
151
MCQeasy

An analyst creates a pie chart showing market share of four companies: A (45%), B (30%), C (15%), D (10%). A stakeholder complains that it is difficult to compare C and D. Which alternative chart should the analyst recommend?

A.Horizontal bar chart
B.Line chart
C.Stacked bar chart
D.Scatter plot
AnswerA

A horizontal bar chart encodes each company's value as bar length on a common baseline, making the 15% versus 10% difference between C and D directly comparable. Pie slices at similar angles are far harder to distinguish accurately.

Why this answer

A horizontal bar chart makes it easy to compare the lengths of bars for categories C (15%) and D (10%) because the bars are aligned on a common baseline and differences in length are visually precise. Pie charts are poor for comparing similar small slices, whereas bar charts excel at this task.

Exam trap

DA0-002 often tests chart selection by presenting a pie chart with similar small slices, and candidates may choose a stacked bar chart instead of a horizontal bar chart, missing that stacked bars hinder comparison of individual segments.

How to eliminate wrong answers

Option B is wrong because a line chart is used to show trends over time, not to compare proportions of categories. Option C is wrong because a stacked bar chart shows part-to-whole relationships but makes it difficult to compare individual segments, especially small ones like C and D. Option D is wrong because a scatter plot shows the relationship between two numerical variables, not category proportions.

152
Multi-Selecthard

A data analyst at a healthcare organization is analyzing patient readmission rates. The analyst has a dataset with patient demographics, diagnosis codes, and length of stay. Before performing any statistical modeling, the analyst must address data quality issues. Which TWO of the following actions are most appropriate for ensuring the dataset is ready for analysis? (Choose two.)

Select 2 answers
A.Remove all records with any missing values to ensure a complete dataset.
B.Identify and remove duplicate patient records based on a unique patient identifier and admission date.
C.Convert all numerical columns to categorical bins to simplify the analysis.
D.Impute missing values in the length of stay column using the mean length of stay for all patients.
E.Standardize diagnosis codes to a consistent format (e.g., ICD-10) and validate against a reference list.
AnswersB, E

Duplicate records can skew readmission rates and other analyses. Using a unique patient identifier combined with admission date helps distinguish between multiple admissions for the same patient versus true duplicates. Removing duplicates ensures each admission is counted once, which is critical for accurate readmission metrics. This is a standard data cleaning step and directly addresses a common data quality issue in healthcare datasets.

Why this answer

Ensuring data quality involves identifying and correcting issues that could bias results. Removing duplicate patient records prevents overcounting admissions, and standardizing diagnosis codes ensures consistency for analysis. Mean imputation can distort data, binning numerical variables is not a quality fix, and listwise deletion can introduce bias and reduce sample size.

These two actions directly address common data quality problems in healthcare datasets.

Exam trap

The trap here is assuming that any missing data must be removed or imputed with a simple mean, when in fact proper handling depends on the missingness mechanism and the analysis goal.

153
Multi-Selecteasy

A dashboard designer is building a sales performance dashboard for executives. According to dashboard design principles, which TWO practices should be applied? (Choose two.)

Select 2 answers
A.Use color coding consistently to group related metrics
B.Use visual hierarchy to make the most important metric prominent
C.Avoid titles and labels to keep the dashboard clean
D.Include excessive precision on all numbers to show accuracy
E.Maximize chartjunk to make the dashboard visually appealing
AnswersA, B

Consistent colour coding assigns the same hue to related metrics across every chart, so executives instantly group categories without re-reading labels. This satisfies the design principle of reducing cognitive load, letting viewers compare sales metrics rapidly rather than decoding inconsistent palettes.

Why this answer

Option A is correct because consistent color coding lets executives instantly associate related metrics (e.g., all revenue measures in one hue) and compare them without reinterpreting the legend on each visual. Option B is correct because visual hierarchy—using size, position, and contrast to emphasize the single most important KPI—directs the executive's eye to the critical number first, which is a core dashboard design principle. Option C is wrong because titles and labels are essential for context and self-service interpretation; removing them creates ambiguity.

Option D is wrong because excessive precision clutters the display and slows comprehension—executives need rounded, decision-relevant values. Option E is wrong because chartjunk (decorative, non-data elements) distracts from the message and violates the principle of maximizing the data-ink ratio.

Exam trap

DA0-002 often tests the misconception that 'more data and decoration equals better dashboards,' tricking candidates into selecting options that add clutter (excessive precision, chartjunk) or remove essential context (no titles/labels), when the correct principles emphasize clarity, consistency, and hierarchy.

154
MCQmedium

A data analyst needs to extract data from a transactional database and load it into a data warehouse for reporting. Which process typically transforms the data before loading it into the warehouse?

A.Data virtualization
B.ELT
C.ETL
D.Data replication
AnswerC

ETL transforms data in a staging area before loading, satisfying the stem's requirement that transformation occur prior to warehouse load. Extract pulls from the transactional database, Transform cleanses and conforms it, then Load writes to the warehouse. ELT instead loads raw data first and transforms inside the warehouse, which contradicts the stated sequence.

Why this answer

ETL (Extract, Transform, Load) transforms data in a staging area before loading it into the target warehouse, which matches the question's requirement that transformation happens before loading. This is the classic pattern for data warehouses where the target schema is fixed and data quality must be enforced upstream. ELT, by contrast, loads raw data first and transforms it inside the warehouse using its compute engine.

Exam trap

The trap here is conflating ETL and ELT — candidates who skim the question miss the phrase 'transforms the data before loading' and pick ELT because it is the more modern pattern.

How to eliminate wrong answers

Option A is wrong because data virtualization presents a virtual query layer over source systems without physically moving or transforming data into a warehouse. Option B is wrong because ELT loads raw data into the warehouse first and performs transformations afterward using the warehouse's compute — the opposite order from what the question describes. Option D is wrong because data replication copies data between systems for availability or synchronization; it does not include a transformation stage before loading.

155
MCQhard

A data analyst is presenting a story to executives about a decline in sales. The analyst wants to show the key events that led to the decline, such as a product recall and a competitor's launch. Which storytelling technique should be used?

A.Using a pie chart to show current market share
B.Adding a waterfall chart to show incremental changes
C.Annotating the line chart with event markers
D.Using a treemap to show hierarchical proportions
AnswerC

Event markers placed on the line chart tie each annotation to the exact point in time when the recall and competitor launch occurred, letting executives see cause and effect. This satisfies the requirement to show the key events driving the sales decline.

Why this answer

Annotating a line chart with event markers ties specific business events (product recall, competitor launch) to the points in time where sales changed, making the causal narrative visually explicit. This is the standard storytelling technique for explaining a trend's drivers over time.

Exam trap

The trap is choosing a chart type that shows composition or variance (pie, waterfall, treemap) when the question is about correlating discrete events with a time-series trend — only time-aligned annotation on a line chart tells that story.

How to eliminate wrong answers

Option A is wrong because a pie chart shows part-to-whole composition at a single point in time and cannot convey a temporal sequence of events. Option B is wrong because a waterfall chart shows incremental positive/negative contributions to a total, which is useful for variance decomposition but not for correlating events with a time-series decline. Option D is wrong because a treemap shows hierarchical proportions, not time-based event causation.

156
MCQmedium

A company needs to store raw data from IoT sensors for future machine learning projects. The data is expected to be massive and in various formats. Which storage solution is most appropriate?

A.Data mart
B.Data warehouse
C.Data lake
D.Relational database
AnswerC

A data lake stores raw data in its native format, schema-on-read, so massive volumes of varied IoT sensor output can land without upfront transformation. This satisfies the stem's requirement for diverse formats retained for future machine learning, where structure is imposed only at analysis time.

Why this answer

A data lake stores raw data in its native format without predefined schema, ideal for large volumes of varied data for future use.

157
MCQhard

A data analyst is working with a dataset that includes a column 'Annual Income' with values ranging from $20,000 to $500,000. The analyst wants to reduce the impact of extreme values on a machine learning model. Which technique should the analyst apply?

A.Log transformation
B.Z-score standardization
C.Winsorizing
D.Min-max normalization
AnswerC

Winsorizing replaces extreme values with a specified percentile, such as the 5th and 95th percentiles, effectively capping outliers. This reduces their impact on the model while retaining the data points. It is a robust technique for handling outliers in skewed data like income.

Why this answer

The correct answer is Winsorizing because it directly caps extreme values at a chosen percentile, reducing their influence on the model. Min-max normalization and z-score standardization do not mitigate outliers, and log transformation only reduces skewness without bounding values.

Exam trap

The trap here is thinking that any scaling method handles outliers; however, only techniques like Winsorizing explicitly limit extreme values.

158
MCQeasy

A data analyst wants to show the proportion of total sales for each product category. There are 4 categories. Which chart type is most appropriate?

A.Pie chart
B.Line chart
C.Scatter plot
D.Histogram
AnswerA

A pie chart maps each category to a slice whose angle is proportional to its share of the whole, directly showing part-to-whole proportions across the four categories. Bar charts compare magnitudes but do not convey proportion of total sales as clearly.

Why this answer

A pie chart is designed to show parts of a whole, making it the most appropriate choice for displaying the proportion of total sales contributed by each of four product categories. With only four categories, the slices remain readable and the proportional relationship is immediately clear. Pie charts work best when the number of categories is small (typically 5 or fewer) and the values sum to a meaningful total.

Exam trap

The trap is confusing 'proportion of a whole' with 'comparison across categories' — candidates may pick a bar chart for precision, but the question specifically asks for proportion, which is the defining use case for a pie chart.

How to eliminate wrong answers

Option B is wrong because a line chart is used to display trends over a continuous variable such as time; it does not convey proportions of a whole and would misrepresent categorical sales data. Option C is wrong because a scatter plot shows the relationship between two numerical variables, not the composition of a total across categories. Option D is wrong because a histogram displays the frequency distribution of a single continuous variable by binning values, which is unrelated to showing category proportions.

159
Multi-Selecthard

Which THREE of the following are best practices when performing data extraction for a data pipeline?

Select 3 answers
A.Performing a full refresh every time
B.Implementing error handling and logging
C.Documenting the extraction process
D.Ignoring data quality issues during extraction
E.Using incremental extraction where possible
AnswersB, C, E

Extraction jobs fail silently on source timeouts, schema drift or malformed records, so try/catch blocks with structured logging capture the failure point and row counts. This satisfies the stem's best-practise requirement by making pipeline failures detectable and diagnosable rather than corrupting downstream loads.

Why this answer

Option B is correct because robust error handling and logging are essential in a data pipeline: they capture failures (e.g., connection timeouts, schema mismatches, partial loads) and provide an audit trail for troubleshooting and reprocessing without silently losing data. Option C is correct because documenting the extraction process records source systems, connection details, extraction frequency, filters, and transformation assumptions, which enables maintainability, reproducibility, and knowledge transfer across teams. Option E is correct because incremental extraction (e.g., using high-water marks, change data capture, or timestamp/ID deltas) reduces load on source systems and shortens pipeline runtime compared with repeatedly pulling entire datasets.

Option A is not a best practice because a full refresh every time is inefficient, increases source-system load, and lengthens processing windows when only changed data is needed. Option D is not a best practice because ignoring data quality issues during extraction allows bad, missing, or malformed records to propagate downstream, corrupting analytics and requiring costly rework.

Exam trap

CompTIA often tests the misconception that full refreshes are always safer or simpler, but the trap is that they ignore the operational cost and scalability issues, while incremental extraction with proper error handling is the standard in production pipelines.

160
MCQmedium

During a data presentation, an audience member questions the accuracy of the data shown. Which of the following is the best way for the analyst to respond?

A.Provide documentation of data sources and transformation steps
B.Change the topic
C.Offer to send the raw data later
D.Dismiss the question and continue
AnswerA

Supplying documentation of sources and transformation steps lets the questioner independently verify lineage, directly addressing the accuracy challenge with evidence rather than assertion. This traceability demonstrates the figures were derived through auditable, repeatable processes, which is the defensible response when data credibility is questioned during a presentation.

Why this answer

Providing documentation of data sources and transformation steps directly addresses the audience member's concern about accuracy by demonstrating transparency and traceability. This approach aligns with best practices in data governance, as it allows the audience to verify the data lineage and any ETL processes that may have introduced errors. It also builds trust by showing the analyst has a clear understanding of the data pipeline.

Exam trap

The trap here is that candidates may choose Option C, thinking that providing raw data is sufficient, but they overlook that raw data without transformation documentation does not prove accuracy and may even raise more questions about how the data was prepared.

How to eliminate wrong answers

Option B is wrong because changing the topic avoids the question entirely, which undermines the credibility of the analyst and fails to address the legitimate concern about data accuracy. Option C is wrong because offering to send raw data later delays the response and does not provide immediate clarification; raw data alone may also be insufficient without context on how it was processed. Option D is wrong because dismissing the question and continuing is dismissive and unprofessional, likely eroding audience trust and suggesting the analyst cannot defend the data's integrity.

161
Multi-Selecthard

A data warehouse team is considering moving from an ETL to an ELT approach. Which THREE of the following are advantages of ELT over ETL?

Select 3 answers
A.Requires less storage space in the data warehouse
B.Reduces data loading time because transformations are done after loading
C.Allows data to be reprocessed easily if transformation logic changes
D.Ensures data is cleaned before loading
E.Eliminates the need for a separate ETL server
AnswersB, C, E

Data is loaded quickly without transformation, reducing initial load time.

Why this answer

In ELT, data is loaded into the data warehouse first and transformations are applied afterward. This reduces the initial loading time since no transformation processing occurs during the load phase, allowing raw data to be ingested more quickly.

Exam trap

CompTIA often tests the misconception that ELT reduces storage requirements, but in reality, ELT increases storage needs because raw data is persisted alongside transformed data, whereas ETL can discard raw data after transformation.

162
MCQeasy

A data analyst at a logistics company is designing a new database table to store shipment records. Each shipment has a unique tracking number, a weight in kilograms, a destination city, and a delivery date. The analyst needs to choose a data type for the tracking number that ensures uniqueness and efficient lookups. Which data type is most appropriate for the tracking number?

A.Boolean
B.Integer
C.Date/time
D.Character string
AnswerD

Character string (VARCHAR or CHAR) is ideal for tracking numbers because it preserves leading zeros, supports alphanumeric formats, and handles varying lengths. It ensures the exact identifier is stored without numeric conversion issues. Uniqueness can be enforced with a primary key or unique constraint. This data type also supports efficient indexing for lookups, making it the most appropriate choice for shipment tracking numbers.

Why this answer

Tracking numbers are identifiers that may include letters, leading zeros, and varying lengths, so a character string data type preserves their exact format and supports unique constraints. Integer, Boolean, and date/time types each fail to represent the full range of possible tracking numbers, risking data loss or inability to enforce uniqueness. Character strings also allow efficient indexing for fast lookups.

Exam trap

The trap here is assuming that a numeric-looking identifier should be stored as an integer, which discards leading zeros and breaks alphanumeric formats.

163
MCQeasy

A dataset contains the ages of 100 customers. The analyst wants to transform the ages to a 0-1 range for use in a distance-based algorithm. Which technique should be used?

A.Square root transformation
B.Log transformation
C.Z-score normalization
D.Min-max normalization
AnswerD

Min-max normalization rescales each value using (x − min) / (max − min), mapping the age range linearly onto 0–1. This satisfies the stem's requirement for a bounded 0–1 range, which distance-based algorithms such as k-means or k-NN need so no single feature dominates the distance calculation.

Why this answer

Min-max normalization transforms features to a fixed range, typically 0 to 1, by subtracting the minimum and dividing by the range. This is exactly what is needed to scale ages to a 0-1 range for distance-based algorithms.

Exam trap

The trap is confusing normalization with standardization. Candidates might choose Z-score normalization because it's commonly used, but it does not produce a 0-1 range. The question explicitly asks for 0-1 range, so min-max is correct.

How to eliminate wrong answers

Option A is wrong because square root transformation is used to reduce skewness, not to scale to a specific range. Option B is wrong because log transformation is used to handle skewed data or exponential relationships, not for range scaling. Option C is wrong because Z-score normalization standardizes data to have mean 0 and standard deviation 1, which does not guarantee a 0-1 range.

164
MCQmedium

A data analyst is creating a dashboard for a hospital's emergency department. The dashboard must display the current wait time, the number of patients waiting, and the average wait time over the past 24 hours. The analyst wants to ensure that the most critical information is immediately visible to the charge nurse. Which design principle should the analyst apply?

A.Use a consistent color scheme and place the most important metric in the top-left corner with a larger font size.
B.Place all metrics in a single table for easy comparison.
C.Include detailed data labels on all charts to provide context.
D.Use a variety of chart types to make the dashboard visually interesting.
AnswerA

Placing the most important metric in the top-left corner with a larger font size leverages the natural reading pattern (top-left to bottom-right) and visual hierarchy. This ensures the charge nurse sees the critical information first. A consistent color scheme reduces cognitive load and helps distinguish different metrics without confusion.

Why this answer

The charge nurse needs to see the most critical information—current wait time—immediately. Applying visual hierarchy by placing that metric in the top-left corner with a larger font size ensures it is noticed first. A consistent color scheme aids quick interpretation without distraction, supporting rapid decision-making in a fast-paced environment.

Exam trap

The trap here is thinking that more visual variety or detailed labels will improve the dashboard, but these can actually hinder quick access to the most important information.

165
Multi-Selectmedium

Which TWO actions are best practices for creating effective data visualizations?

Select 2 answers
A.Avoid using more than five slices in a pie chart
B.Maximize data-ink ratio by removing all whitespace
C.Always include gridlines with high contrast
D.Use 3D effects to make charts look professional
E.Use color to represent data values consistently
AnswersA, E

Capping pie slices at five preserves accurate part-to-whole comparison, since human perception struggles to judge angles beyond a handful of wedges. This satisfies the best-practice constraint by preventing cluttered, unreadable charts, so viewers can distinguish each category's proportion at a glance rather than squinting at slivers.

Why this answer

Option A is correct because limiting a pie chart to about five slices keeps each wedge large enough to compare visually; beyond that, similar-sized slices become indistinguishable and the chart loses its purpose, so consolidating minor categories into an 'Other' slice is a recognized best practice. Option E is correct because assigning colors consistently to the same data values or categories across all visuals in a report prevents misreading and lets viewers track a series reliably, which is a core principle of effective encoding. The unmarked options do not belong: B is wrong because maximizing data-ink ratio means removing non-data ink, not all whitespace, since whitespace improves grouping and readability; C is wrong because high-contrast gridlines compete with the data and should be muted or omitted when not needed; and D is wrong because 3D effects distort proportions and add perspective that misrepresents values rather than making charts more professional.

Exam trap

CompTIA often tests the misconception that maximizing data-ink ratio means eliminating all whitespace, when in fact whitespace is a critical design element for readability and should be preserved judiciously.

166
MCQeasy

A data analyst is cleaning a dataset and finds missing values in a categorical variable representing customer region. Which imputation method is most appropriate?

A.Drop rows with missing values
B.Mode imputation
C.Mean imputation
D.Median imputation
AnswerB

Mode imputation fills missing categorical entries with the variable's most frequent region, preserving the existing distribution and requiring no numeric assumptions. It suits categorical data, where mean or median imputation is meaningless, satisfying the requirement to handle missing region values sensibly.

Why this answer

Mode imputation is the most appropriate method for a categorical variable because it replaces missing values with the most frequently occurring category, preserving the distribution of the data. Unlike mean or median imputation, which are designed for numerical data, mode imputation maintains the categorical nature of the variable and avoids introducing invalid values. This approach is simple and effective when missing data is random and the category is well-represented.

Exam trap

The trap here is that candidates often confuse imputation methods across data types, incorrectly applying mean or median imputation to categorical variables because they focus on central tendency without considering data type appropriateness.

How to eliminate wrong answers

Option A is wrong because dropping rows with missing values can lead to significant data loss and potential bias, especially if the missingness is not completely random, reducing the dataset's representativeness. Option C is wrong because mean imputation is only appropriate for numerical data, not categorical variables, as calculating the mean of categories is meaningless and would produce non-categorical values. Option D is wrong because median imputation is also designed for numerical data and cannot be applied to categorical variables, as the median requires ordered numerical values to compute.

167
MCQeasy

A data analyst is preparing a dataset for analysis and needs to combine data from two tables: 'orders' and 'customers'. The 'orders' table contains a 'customer_id' column, and the 'customers' table contains a 'customer_id' column as the primary key. The analyst wants to include all orders, even those without matching customers. Which type of join should be used?

A.RIGHT JOIN
B.INNER JOIN
C.LEFT JOIN
D.FULL OUTER JOIN
AnswerC

A LEFT JOIN returns all rows from the left table (orders) and matching rows from the right table (customers). If there is no match, NULLs are returned for customer columns. This ensures all orders are included, satisfying the requirement to keep orders without matching customers.

Why this answer

To preserve all rows from the orders table regardless of matching customers, a LEFT JOIN is appropriate. It keeps every order and appends customer details when available. Other join types either exclude unmatched orders or include extra unmatched customers, which is not desired.

Exam trap

The trap here is assuming that a FULL OUTER JOIN is needed to keep all orders, but it also brings in customers without orders.

168
Multi-Selectmedium

A data analyst needs to identify duplicate customer records based on email and phone number. Which SQL techniques can be used to find duplicates? (Select TWO).

Select 2 answers
A.SELECT email, phone FROM customers ORDER BY email, phone
B.SELECT DISTINCT email, phone FROM customers
C.SELECT email, phone, ROW_NUMBER() OVER (PARTITION BY email, phone ORDER BY customer_id) AS rn FROM customers WHERE rn > 1
D.Use a CTE to assign ROW_NUMBER() and then select rows where rn > 1
E.SELECT email, phone, COUNT(*) FROM customers GROUP BY email, phone HAVING COUNT(*) > 1
AnswersD, E

ROW_NUMBER() partitioned by email and phone assigns sequential integers within each duplicate group, so filtering rn > 1 isolates every redundant row. This satisfies the requirement to identify duplicates while retaining full row detail, unlike aggregation alone.

Why this answer

Option E is correct because grouping by email and phone with GROUP BY and filtering with HAVING COUNT(*) > 1 returns exactly those email/phone combinations that appear more than once, which is the standard way to detect duplicate records. Option D is correct because a CTE can compute ROW_NUMBER() OVER (PARTITION BY email, phone ORDER BY customer_id) and then the outer query filters WHERE rn > 1, reliably identifying all rows beyond the first occurrence of each duplicate key. Option A is not correct because ORDER BY only sorts rows and does not detect or filter duplicates.

Option B is not correct because SELECT DISTINCT removes duplicates and returns only unique combinations, the opposite of finding them. Option C is not correct because a window function cannot be referenced in the WHERE clause of the same query level, so WHERE rn > 1 would fail; the ROW_NUMBER() must be wrapped in a subquery or CTE as in option D.

Exam trap

DA0-002 often tests SQL logical processing order, tricking candidates into selecting a query that references a window-function alias in WHERE, which is invalid because window functions are evaluated after WHERE.

169
Multi-Selectmedium

A data analyst is comparing characteristics of structured and unstructured data. Which TWO of the following are characteristics of structured data? (Choose two.)

Select 2 answers
A.Data is typically stored as raw text
B.Data lacks a fixed format
C.Data is stored in predefined schemas
D.Data often requires NoSQL databases for storage
E.Data can be easily queried using SQL
AnswersC, E

Structured data conforms to a predefined schema, such as relational tables with declared columns and data types. This enforced organisation is what enables consistent storage, validation and predictable retrieval, distinguishing it from unstructured content like free text or media.

Why this answer

Option C is correct because structured data is organized according to a predefined schema—such as tables with defined columns, data types, and relationships—which is the defining trait of structured data in relational systems. Option E is correct because structured data stored in relational tables can be directly queried with SQL, using SELECT, JOIN, WHERE, and other standard statements. The unmarked options do not belong: raw text (A) and lack of a fixed format (B) describe unstructured data such as documents or free-form text, and NoSQL databases (D) are typically used for semi-structured or unstructured data rather than being a characteristic of structured data.

Exam trap

The trap here is that candidates often confuse 'lack of fixed format' (unstructured) with 'flexibility in storage' (NoSQL), leading them to select options B or D, which describe unstructured or semi-structured data, not structured data.

170
MCQmedium

Refer to the exhibit. A data analyst is troubleshooting a failed dashboard refresh. The error log shows repeated SQL syntax errors. Which of the following is the most likely cause?

A.The database server is offline.
B.The query contains a syntax mistake.
C.The user does not have permissions to access the table.
D.The network connection timed out.
AnswerB

Repeated SQL syntax errors indicate malformed SQL statements in the query itself, such as misspelled keywords, misplaced commas or unbalanced parentheses. Correcting the query's syntax resolves the refresh failure, since the database rejects unparseable statements before execution.

Why this answer

The error log explicitly states 'repeated SQL syntax errors,' which directly indicates that the SQL query being executed is malformed. A syntax mistake in the query (e.g., missing keyword, incorrect clause order, or mismatched parentheses) will cause the database to reject the statement before any execution begins, leading to the exact error described.

Exam trap

CompTIA often tests the distinction between error types (syntax vs. runtime vs. connectivity) to see if candidates can map the exact error message to its root cause, rather than guessing based on general troubleshooting assumptions.

How to eliminate wrong answers

Option A is wrong because if the database server were offline, the error would be a connection timeout or 'cannot connect to server' message, not a SQL syntax error. Option C is wrong because a permissions issue would produce an 'access denied' or 'permission denied' error, not a syntax error. Option D is wrong because a network timeout would result in a timeout or connection reset error, not a SQL syntax error.

171
MCQeasy

A data analyst needs to visualize the relationship between two continuous variables: advertising spend (in dollars) and monthly sales (in units). Which chart type is most appropriate?

A.Scatter plot
B.Pie chart
C.Bar chart
D.Line chart
AnswerA

Scatter plots are used to display the relationship between two continuous variables.

Why this answer

A scatter plot is the most appropriate chart for visualizing the relationship between two continuous variables, such as advertising spend (dollars) and monthly sales (units). It displays individual data points on an x-y axis, allowing the analyst to observe correlation, clustering, or outliers between the two numeric fields. This aligns with the DA0-001 objective of selecting visualizations based on data type and analytical goal.

Exam trap

The trap here is that candidates often choose a line chart (Option D) because they mistakenly think 'relationship' implies a trend over time, but line charts require a sequential or time-based x-axis, not two independent continuous variables.

How to eliminate wrong answers

Option B (Pie chart) is wrong because pie charts are designed to show proportions of a whole for categorical data, not the relationship between two continuous variables. Option C (Bar chart) is wrong because bar charts compare discrete categories or aggregated values, not the direct correlation between two continuous numeric fields. Option D (Line chart) is wrong because line charts are typically used to show trends over time or ordered sequences, not the general relationship between two independent continuous variables.

172
MCQmedium

A data engineer is ingesting streaming data from a fleet of delivery vehicles. Each vehicle sends GPS coordinates, speed, and timestamp every second. The engineer needs to store this data for real-time dashboards and also retain it for long-term historical analysis. Which data storage approach best balances real-time access and cost-effective long-term retention?

A.Store all data in a relational database with row-based storage
B.Keep all data in memory using an in-memory cache
C.Use a time-series database for recent data and archive to object storage
D.Store all data in a key-value store with no secondary indexes
AnswerC

A time-series database is optimized for high-ingest, timestamped data and supports fast real-time queries for dashboards. Archiving older data to object storage (e.g., S3) provides low-cost, durable long-term retention. This hybrid approach balances performance and cost, allowing recent data to be queried quickly while historical data remains accessible for batch analysis.

Why this answer

A time-series database handles high-velocity timestamped writes and enables fast real-time queries for dashboards. Archiving older data to object storage reduces cost while preserving durability for historical analysis. Row-based relational databases, key-value stores without indexes, and in-memory caches each fail to balance real-time performance with cost-effective long-term retention for streaming vehicle telemetry.

Exam trap

The trap here is choosing a single storage technology for both real-time and archival needs, ignoring that a hybrid approach is often required to balance performance and cost.

173
MCQmedium

Refer to the exhibit. A data analyst receives this error when running a data load script. What is the most likely cause?

A.The email field is too long
B.The database connection is lost
C.The customer_id 12345 already exists in the table
D.The name field is null
AnswerC

The load fails because customer_id 12345 already exists, breaching the primary key or unique constraint on that column. The insert is rejected rather than duplicating the row, confirming a uniqueness violation rather than a datatype or connection fault.

Why this answer

The error shown in the exhibit is a duplicate key / unique constraint violation, which occurs when the load script attempts to insert a customer_id value that already exists in the target table. Since customer_id is the primary key (or has a unique constraint), the database rejects the insert with a duplicate entry error. The most likely cause is that customer_id 12345 is already present in the table, so the load must use an upsert, deduplication, or filtered insert strategy.

Exam trap

DA0-002 often tests whether candidates can distinguish between constraint violations (duplicate key, NOT NULL, foreign key) and other error classes like connection loss or data truncation, so the trap is picking a generic 'connection lost' answer instead of reading the specific error code.

How to eliminate wrong answers

Option A is wrong because a field-length overflow produces a 'data too long for column' or truncation error, not a duplicate-key violation. Option B is wrong because a lost database connection raises a connection timeout or 'server has gone away' error, not a constraint violation on a specific row. Option D is wrong because a NULL value in a NOT NULL column raises a 'column cannot be null' error, which is a different constraint class than a duplicate primary key.

174
MCQmedium

A data analyst wants to randomly select 100 customers from a database for a survey, ensuring that the sample reflects the proportion of male and female customers in the population. Which sampling method is most appropriate?

A.Stratified sampling
B.Cluster sampling
C.Simple random sampling
D.Systematic sampling
AnswerA

Stratified sampling divides the population into strata (male and female) then samples proportionally within each, guaranteeing the sample mirrors the population's gender proportions. Simple random sampling could skew those proportions by chance, failing the stem's proportionality constraint.

Why this answer

Stratified sampling divides the population into homogeneous subgroups (strata) — here, male and female — and then draws random samples from each stratum in proportion to its size in the population. This guarantees the sample mirrors the population's gender proportions, which is exactly what the analyst requires. Simple random sampling could, by chance, under- or over-represent one gender.

Exam trap

The trap here is confusing stratified sampling with cluster sampling — both involve grouping, but stratification samples within every group to ensure representation, while clustering samples entire groups and ignores proportional representation.

How to eliminate wrong answers

Option B is wrong because cluster sampling divides the population into clusters (e.g., geographic regions) and randomly selects entire clusters, which does not guarantee proportional representation of gender and typically increases sampling error. Option C is wrong because simple random sampling selects individuals purely by chance without regard to strata, so the sample's gender ratio may deviate from the population's. Option D is wrong because systematic sampling picks every kth element from an ordered list; if the list has a periodic pattern related to gender, the sample can be biased, and it does not enforce proportional representation.

175
MCQmedium

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

A.Funnel chart
B.Treemap
C.Waterfall chart
D.Scatter plot
AnswerA

A funnel chart plots sequential stages with progressively narrowing bars, directly showing drop-off between website visits and final purchase. This matches the marketing manager's need to visualise conversion rates at each step of the buying journey.

Why this answer

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

176
MCQeasy

Which data sampling method involves selecting every k-th element from a list after a random start?

A.Systematic sampling
B.Cluster sampling
C.Stratified sampling
D.Simple random sampling
AnswerA

Systematic sampling selects every k-th element after a random starting point, directly matching the stem's definition. The random start prevents bias from periodic patterns in the list, while the fixed interval k ensures even coverage across the dataset. This satisfies the constraint of deterministic interval selection combined with randomised initiation.

Why this answer

Systematic sampling selects every k-th element from a list after choosing a random starting point. For example, with k=10 and a random start of 3, you pick elements 3, 13, 23, and so on. This makes it efficient for large, ordered populations while still providing a probabilistic sample.

Exam trap

DA0-002 often tests the confusion between systematic (every k-th) and stratified (proportional subgroups) sampling — candidates mix up the interval-based method with the subgroup-based method.

How to eliminate wrong answers

Option B is wrong because cluster sampling divides the population into clusters (e.g., schools, cities) and randomly selects entire clusters, then samples all or some members within them. Option C is wrong because stratified sampling divides the population into homogeneous strata (e.g., age groups) and randomly samples from each stratum. Option D is wrong because simple random sampling gives every element an equal, independent chance of selection with no fixed interval.

177
MCQeasy

A data analyst is extracting data from a relational database using SQL. Which clause is essential for limiting the rows retrieved to only those needed?

A.GROUP BY
B.ORDER BY
C.WHERE
D.HAVING
AnswerC

The WHERE clause applies row-level predicates, filtering records so only those matching specified conditions are returned. It satisfies the requirement to limit retrieved rows, reducing data transfer and processing compared with retrieving the full table.

Why this answer

WHERE. The WHERE clause is used to filter rows from a table based on specified conditions, limiting the result set to only the rows that meet those conditions. Option A (GROUP BY) is incorrect because it groups rows with same values into summary rows, not for filtering.

Option B (ORDER BY) is incorrect because it sorts the result set, not filters. Option D (HAVING) is incorrect because it filters groups after aggregation, not individual rows. Therefore, WHERE is essential for limiting rows retrieved.

178
Multi-Selecthard

An analyst is conducting an A/B test on a new website layout. Which TWO of the following must be defined before the test begins?

Select 2 answers
A.The final conversion rates for each group
B.The actual p-value from the test
C.The confidence interval for the lift
D.The significance threshold (alpha)
E.The sample size required for adequate statistical power
AnswersD, E

Fixing alpha before the test begins controls the false-positive rate and prevents p-hacking after results arrive. The stem demands pre-defined parameters; without a declared significance threshold, the analyst cannot objectively judge whether the observed difference between layouts is statistically meaningful.

Why this answer

Option D is correct because the significance threshold (alpha), typically set at 0.05, must be fixed in advance to determine the probability of a Type I error and to provide the criterion against which the resulting p-value will be judged. Option E is correct because the required sample size must be calculated beforehand, based on the desired statistical power (commonly 0.80), the baseline conversion rate, and the minimum detectable effect, to ensure the test can reliably detect a real difference. Options A, B, and C are not pre-test definitions: the final conversion rates and the actual p-value are outcomes observed only after the test concludes, and the confidence interval for the lift is likewise a post-hoc computed estimate rather than an input specified before the test begins.

Exam trap

DA0-002 often tests the confusion between pre-test design parameters (alpha, sample size, MDE) and post-test outputs (p-value, confidence interval, observed conversion rates), so candidates must recognize which values can only exist after data collection.

179
MCQmedium

A data engineer loads a CSV export into a table. The source system writes the value '007' for a product code, but after loading, an analyst queries the table and sees the value 7. The analyst needs the leading zero preserved for downstream matching against another system. Which action should the engineer take?

A.Create a derived column that concatenates a literal zero with the numeric product code
B.Change the column data type to a numeric type with a display format that pads to three digits
C.Add a check constraint that rejects any product code shorter than three characters
D.Store the product code in a character or string column so the leading zero is retained
AnswerD

A character or string column treats '007' as a sequence of characters, preserving the leading zero exactly as written. This lets downstream matches against another system that uses the same textual code succeed. Since the code is an identifier rather than a quantity to calculate, storing it as text is the correct modeling choice.

Why this answer

Product codes are identifiers, not quantities, so leading zeros are meaningful and must be preserved. Storing the value in a character column keeps '007' intact and allows reliable matching with other systems, whereas numeric storage strips the zero and presentation formats do not survive joins or exports.

Exam trap

The trap here is believing that a numeric display format or a derived expression can permanently restore a leading zero, when the stored data type itself has already discarded it.

180
MCQmedium

A data scientist is building a model to predict customer churn. The company's internal CRM system provides customer demographics and transaction history. They also purchase demographic data from a third-party vendor. How should the purchased data be classified?

A.Secondary data
B.Internal data
C.Structured data
D.Primary data
AnswerA

Purchased vendor demographics were collected by another party for its own purposes, not by the company for this churn model. That external origin makes it secondary data, satisfying the stem's classification requirement for the third-party demographic feed.

Why this answer

Purchased demographic data from a third-party vendor is classified as secondary data because it was originally collected by another entity for a different purpose and is being reused by the data scientist for churn prediction. Secondary data contrasts with primary data, which is collected firsthand for the specific analysis at hand. This classification is independent of whether the data is structured or unstructured.

Exam trap

The trap here is that candidates confuse 'secondary data' with 'structured data' because purchased data is often delivered in a structured format like CSV, but the classification is based on data origin and collection purpose, not its structure.

How to eliminate wrong answers

Option B (Internal data) is wrong because the purchased data originates from an external vendor, not from the company's own CRM or internal systems. Option C (Structured data) is wrong because the classification of data as primary or secondary is about its origin and collection purpose, not its format; purchased data could be structured or unstructured. Option D (Primary data) is wrong because primary data is collected directly by the researcher for the specific study, whereas this data was pre-existing and collected by a third party.

181
MCQmedium

A data analyst needs to visualize the distribution of customer ages in a dataset. The analyst wants to see the frequency of ages grouped into bins. Which chart type should be used?

A.Pie chart
B.Histogram
C.Box plot
D.Bar chart
AnswerB

A histogram bins a continuous numeric variable, such as customer age, into intervals and plots the frequency of observations per bin as adjacent bars. This directly satisfies the requirement to visualise distribution and frequency of ages grouped into bins.

Why this answer

A histogram is the correct choice because it is purpose-built for showing the frequency distribution of a continuous numeric variable by grouping values into bins (e.g., ages 18–25, 26–33). Each bar's height represents the count of observations falling into that bin, directly answering the analyst's need to see frequency by age group. Unlike a bar chart, the bars are adjacent with no gaps, reflecting the continuous nature of the underlying variable.

Exam trap

DA0-002 often tests the histogram-vs-bar-chart distinction — candidates pick bar chart because both use rectangular bars, missing that histograms bin continuous data while bar charts compare discrete categories.

How to eliminate wrong answers

Option A is wrong because a pie chart shows parts-of-a-whole proportions for categorical data and cannot represent binned frequency distributions of a continuous variable. Option C is wrong because a box plot summarizes a distribution via quartiles, median, and whiskers — it shows spread and outliers but not the frequency count per bin. Option D is wrong because a bar chart is designed for categorical comparisons with gaps between bars, not for binning a continuous numeric variable like age.

182
MCQhard

A data engineer is designing a data pipeline where raw data is loaded into a cloud data warehouse (Snowflake) and then transformed using SQL. This approach is called:

A.ELT
B.ETL
C.Data migration
D.Data wrangling
AnswerA

ELT loads raw data into Snowflake before any transformation, satisfying the stem's requirement that data lands in the warehouse first and SQL runs afterwards. Unlike ETL, where transformation precedes loading, here Snowflake's compute performs the SQL transformations, matching the described pipeline exactly.

Why this answer

ELT (Extract, Load, Transform) loads raw data into the target warehouse first and then performs transformations using the warehouse's compute engine — exactly the pattern described with Snowflake. This leverages Snowflake's elastic compute and SQL capabilities to transform data in place, avoiding a separate transformation tier. ETL, by contrast, transforms data before loading it into the warehouse.

Exam trap

DA0-002 often tests the ETL vs. ELT distinction — candidates pick ETL by default because it is the older, more familiar term, ignoring the clue that transformation happens after loading into the warehouse.

How to eliminate wrong answers

Option B is wrong because ETL transforms data in an intermediate staging/processing layer (e.g., Informatica, SSIS) before loading it into the warehouse, which is the opposite order from the scenario described. Option C is wrong because data migration refers to moving data between systems (e.g., on-prem to cloud), not to a load-then-transform pipeline pattern. Option D is wrong because data wrangling is the manual/semi-automated cleaning and reshaping of data, a subset of transformation work, not the architectural pipeline pattern itself.

183
MCQmedium

A stakeholder asks for the exact number of customers who churned last month. Which metric should the analyst report?

A.Churn trend
B.Churn rate percentage
C.Count of churned customers
D.Churn probability
AnswerC

The stakeholder requested an exact number, so a discrete count of churned customers answers precisely. Rates or percentages would obscure the absolute figure requested, making the raw count the appropriate metric for this reporting need.

Why this answer

The stakeholder explicitly asks for the 'exact number' of customers who churned, which is a discrete count. Option C, 'Count of churned customers,' directly provides this integer value without any normalization or ratio. The analyst should report the raw metric that matches the request's specificity.

Exam trap

The trap here is that candidates often confuse 'churn rate percentage' (a relative metric) with the 'exact count' (an absolute metric), assuming the stakeholder wants the rate when they explicitly ask for the number.

How to eliminate wrong answers

Option A is wrong because a 'churn trend' shows the direction or pattern over time (e.g., increasing or decreasing), not a single exact number. Option B is wrong because 'churn rate percentage' is a ratio (churned customers divided by total customers), which normalizes the count and does not give the exact number requested. Option D is wrong because 'churn probability' is a predictive model output (e.g., a score between 0 and 1) indicating likelihood of future churn, not a historical count of past churned customers.

184
Multi-Selecthard

Which THREE of the following are common mistakes when creating data visualizations? (Choose 3.)

Select 3 answers
A.Choosing the correct chart type for the data
B.Using a 3D pie chart
C.Labeling axes clearly
D.Using a non-zero baseline for bar charts
E.Truncating the y-axis to exaggerate differences
AnswersB, D, E

A 3D pie chart distorts segment proportions through perspective foreshortening, so viewers cannot compare slices accurately — a common visualisation error. It also wastes ink on depth that encodes no data, violating the stem's requirement to identify frequent mistakes made when creating data visualisations.

Why this answer

Option B is correct because 3D pie charts distort the proportions of slices through perspective and depth, making values harder to compare accurately and adding visual clutter that misleads viewers. Option D is correct because bar charts encode value by bar length, so a non-zero baseline breaks that proportional encoding and visually exaggerates or shrinks differences between categories. Option E is correct because truncating the y-axis (especially on line or bar charts) compresses or magnifies the visible range, which can manufacture trends or differences that are not meaningful in the underlying data.

Options A and C are not mistakes but best practices: choosing the correct chart type for the data ensures the visual encoding matches the data relationship, and labeling axes clearly gives viewers the units, scale, and context needed to interpret the chart correctly.

Exam trap

CompTIA often tests the misconception that adding visual flair (like 3D effects) improves a chart, when in reality it reduces accuracy; the trap here is that candidates may think 3D pie charts are acceptable because they look 'professional' or 'modern'.

185
Multi-Selecteasy

Which TWO color choices are appropriate for a categorical data visualization? (Select two.)

Select 2 answers
A.Distinct hues
B.Sequential color scheme
C.Monochrome
D.Rainbow gradient
E.Colorblind-friendly palette
AnswersA, E

Categorical variables have no inherent order, so each category needs a visually distinct hue to be told apart. Distinct hues give maximum perceptual separation between categories, satisfying the requirement that colour encodes identity rather than magnitude.

Why this answer

Option A (Distinct hues) is correct because categorical data represents discrete, unordered groups, so each category needs a visually distinct color that is easily told apart from the others. Option E (Colorblind-friendly palette) is correct because an appropriate categorical visualization must remain distinguishable for viewers with color vision deficiencies, so palettes chosen to be perceptually separable across common types of color blindness are the right choice. Sequential color schemes (B) are designed to encode ordered, continuous magnitude rather than unordered categories, so they do not fit.

Monochrome (C) uses variations of a single hue, which implies ordering and offers too little separation for distinct categories. A rainbow gradient (D) is a continuous, ordered spectrum that can create false impressions of ranking and is not reliably discriminable, so it is not appropriate for categorical data.

Exam trap

CompTIA often tests the misconception that any color scheme can be used for any data type, but the trap here is confusing sequential or rainbow schemes (which imply order) with categorical data that requires distinct, unordered hues.

186
MCQeasy

A business user asks a data analyst to include several charts in a weekly report. The user wants to see the trend of sales over the last 12 months at a glance. Which chart type should the analyst use?

A.Line chart
B.Stacked bar chart
C.Treemap
D.Pie chart
AnswerA

A line chart plots the continuous time dimension on the x-axis and sales on the y-axis, connecting points to expose direction and rate of change. This makes the twelve-month trend immediately visible at a glance.

Why this answer

A line chart is the correct choice because it is specifically designed to display trends over continuous time intervals, such as sales over 12 months. The x-axis represents time (months), and the y-axis represents sales values, allowing the user to quickly see upward, downward, or cyclical patterns. This aligns with the requirement to visualize a trend at a glance, which is a core strength of line charts in data visualization.

Exam trap

The trap here is that candidates often confuse a stacked bar chart's ability to show cumulative totals over time with a clear trend line, but the stacked segments actually make it harder to discern the overall sales trajectory at a glance.

How to eliminate wrong answers

Option B (Stacked bar chart) is wrong because it emphasizes part-to-whole relationships across categories over time, not a single trend line; it can obscure the overall sales trend due to stacked segments. Option C (Treemap) is wrong because it uses nested rectangles to show hierarchical proportions, making it unsuitable for time-series trend analysis. Option D (Pie chart) is wrong because it shows proportions of a whole at a single point in time, not changes over a continuous period like 12 months.

187
MCQeasy

Which SQL function can be used to extract the year from a date column 'order_date'?

A.DATEDIFF(year, order_date)
B.DATEADD(year, order_date)
C.YEAR(order_date)
D.FORMAT(order_date, 'yyyy')
AnswerC

YEAR(order_date) returns the year portion as an integer directly from the date value, satisfying the requirement to extract only the year. Unlike DATEPART, which needs a datepart argument, YEAR is a dedicated function that isolates that single component without additional parameters.

Why this answer

The YEAR function extracts the year portion from a date.

188
MCQmedium

A company needs to visualize monthly sales revenue for the past five years to identify seasonal trends. Which chart type is most appropriate?

A.Line chart with months on the x-axis and revenue on the y-axis
B.Stacked bar chart showing each year as a segment
C.Scatter plot with revenue vs. month number
D.Pie chart for each year showing revenue distribution
AnswerA

A line chart plots revenue against a continuous time axis, so five years of monthly points form an unbroken series where recurring peaks and troughs are directly visible. Months on the x-axis preserve chronological order, which is what exposes the seasonal pattern the company needs.

Why this answer

A line chart with months on the x-axis and revenue on the y-axis is ideal for visualizing monthly sales revenue over five years to identify seasonal trends. It clearly shows patterns, trends, and seasonal fluctuations over time, making it easy to compare year-over-year performance.

Exam trap

DA0-002 often tests the appropriate chart type for time series data; candidates may choose bar or pie charts, but line charts are best for showing trends over time.

How to eliminate wrong answers

Option B is wrong because a stacked bar chart showing each year as a segment would not effectively display monthly variations within each year; it would aggregate data and obscure seasonal trends. Option C is wrong because a scatter plot with revenue vs. month number does not show time series continuity and is better for correlation analysis. Option D is wrong because pie charts for each year show revenue distribution but not trends over time; they are used for part-to-whole comparisons at a single point.

189
MCQhard

An organization is implementing a centralized reporting layer to replace multiple departmental spreadsheets. Which governance principle does this support?

A.Single version of truth
B.Data dictionary
C.Data lineage
D.Row-level security
AnswerA

Consolidating departmental spreadsheets into one reporting layer establishes a single version of truth: every consumer queries the same governed data rather than reconciling divergent copies. This removes conflicting figures and supports consistent, auditable reporting across the organisation.

Why this answer

A single version of truth ensures that all users access the same consistent data, eliminating discrepancies from siloed spreadsheets.

190
Multi-Selectmedium

An analyst needs to identify outliers in a numeric column 'transaction_amount' using the interquartile range (IQR) method. Which TWO steps are part of this process? (Select TWO).

Select 2 answers
A.Subtract 1.5 times the IQR from Q1 and add 1.5 times the IQR to Q3 to define bounds
B.Calculate the median of the column
C.Calculate the first quartile (Q1) and third quartile (Q3)
D.Sort the data and remove the top and bottom 5%
E.Compute the mean and standard deviation of the column
AnswersA, C

The IQR method defines outlier bounds at Q1 minus 1.5 times the IQR and Q3 plus 1.5 times the IQR. Values falling outside these fences are flagged as outliers, directly satisfying the stem's requirement to identify the bounding step.

Why this answer

The IQR method requires first calculating the first quartile (Q1) and third quartile (Q3) of the numeric column, since the IQR is defined as Q3 minus Q1 — this makes option C correct. Once Q1, Q3, and the IQR are known, the outlier bounds are established by subtracting 1.5 × IQR from Q1 (lower fence) and adding 1.5 × IQR to Q3 (upper fence), so option A is correct. Values falling outside these fences are flagged as outliers.

Option B is not required because the median is not used in the IQR fence calculation. Option D describes trimming extremes by percentile, which is a different technique and not part of the IQR method. Option E describes a z-score approach using mean and standard deviation, which is an alternative outlier-detection method, not the IQR method.

191
MCQmedium

You are analyzing sales data and need to calculate the moving average of monthly sales over the previous 3 months for each month. Which type of function is best suited for this task?

A.String function
B.Window function with OVER()
C.Aggregate function with GROUP BY
D.Date function
AnswerB

A window function with OVER() computes an aggregate across a defined frame of preceding rows while retaining each row's detail. This satisfies the three-month moving average requirement, which GROUP BY cannot produce without collapsing the monthly rows.

Why this answer

A window function with OVER() computes a value across a defined set of rows related to the current row without collapsing them, which is exactly what a moving average over the previous 3 months requires. The OVER() clause defines the window (e.g., ROWS BETWEEN 2 PRECEDING AND CURRENT ROW), and the aggregate (AVG) is applied per row while preserving all rows.

Exam trap

The trap is choosing GROUP BY because 'average' sounds like an aggregate — but GROUP BY collapses rows, whereas a moving average requires per-row output, which only window functions provide.

How to eliminate wrong answers

Option A is wrong because string functions manipulate text (e.g., SUBSTRING, CONCAT) and have nothing to do with numeric rolling calculations. Option C is wrong because an aggregate function with GROUP BY collapses rows into groups, so you would lose the per-month detail and could not produce a rolling 3-month average for each month. Option D is wrong because date functions extract or manipulate date parts (e.g., EXTRACT, DATE_ADD) but do not compute moving averages.

192
MCQeasy

A data analyst needs to communicate findings to a non-technical audience that is concerned with overall performance but not interested in details. Which approach is best?

A.Provide a summary dashboard with key KPIs
B.Include complex model outputs
C.Share raw data tables
D.Use detailed statistical jargon
AnswerA

A summary dashboard with key KPIs matches the non-technical audience's need for overall performance without granular detail. Aggregated visual indicators surface trends immediately, avoiding raw tables or statistical nuance that would obscure the message. This directly satisfies the stem's constraint of communicating findings at an executive level rather than an analytical one.

Why this answer

A summary dashboard with key KPIs is best because it distills complex data into visual, high-level metrics that non-technical stakeholders can quickly grasp. This approach aligns with the principle of data storytelling, where the focus is on actionable insights rather than technical details. Dashboards using tools like Tableau or Power BI allow for interactive filtering without overwhelming the audience.

Exam trap

The trap here is that candidates may overestimate the audience's technical comfort and choose raw data or jargon, forgetting that the question explicitly states the audience is 'non-technical' and 'not interested in details.'

How to eliminate wrong answers

Option B is wrong because complex model outputs (e.g., regression coefficients or decision tree splits) require statistical literacy and obscure the main performance narrative, causing confusion. Option C is wrong because raw data tables present unaggregated, granular information that is difficult to interpret and irrelevant for high-level performance review. Option D is wrong because detailed statistical jargon (e.g., p-values, confidence intervals) alienates non-technical audiences and violates the principle of communicating insights in plain language.

193
Multi-Selectmedium

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.)

Select 2 answers
A.Executive summary
B.Caveats about data completeness
C.Confidence intervals around the revenue figure
D.Data dictionary definitions
E.Detailed row-level data
AnswersB, C

Stating caveats about data completeness discloses which records, periods or regions are missing or partial, so readers understand the 10% figure may be overstated or understated. This satisfies the requirement to communicate uncertainty rather than presenting the increase as definitive.

Why this answer

Option B (Caveats about data completeness) is correct because explicitly stating known limitations, such as missing records, excluded regions, or incomplete reporting periods, directly communicates where the 10% revenue increase may be unreliable or biased. Option C (Confidence intervals around the revenue figure) is correct because a confidence interval quantifies the statistical uncertainty of the estimate, showing a plausible range (e.g., 10% ± 3%) rather than implying the point estimate is exact. Together, these elements address both qualitative and quantitative uncertainty, which is essential when the analyst knows the data has limitations.

Option A (Executive summary) is a structural section that summarizes findings but does not itself convey uncertainty. Option D (Data dictionary definitions) documents field meanings and metadata, not the reliability of the result. Option E (Detailed row-level data) provides granular detail but does not communicate uncertainty about the aggregate revenue figure.

Exam trap

DA0-002 often tests the difference between descriptive reporting elements (executive summary, data dictionary) and uncertainty-communication elements, so the trap is selecting a document artifact instead of a caveat or confidence interval.

194
MCQmedium

A marketing team runs an A/B test comparing two webpage designs. The null hypothesis states there is no difference in conversion rates. The p-value is 0.08 at α=0.05. Which is the correct interpretation?

A.The null hypothesis is rejected, indicating the designs are different.
B.The alternative hypothesis is accepted, showing the new design is better.
C.There is insufficient evidence to conclude a difference between the designs.
D.There is a statistically significant difference between the designs.
AnswerC

At α=0.05, a p-value of 0.08 exceeds the significance threshold, so the null hypothesis is not rejected. The test simply lacks statistical evidence of a conversion-rate difference; it does not prove the designs perform identically.

Why this answer

A p-value of 0.08 exceeds the significance level α=0.05, so we fail to reject the null hypothesis. Failing to reject the null means there is not enough statistical evidence to conclude that a real difference exists between the two webpage designs. The result is not statistically significant at the 5% threshold.

Exam trap

The trap here is confusing 'fail to reject the null' with 'the null is true' or 'the alternative is accepted' — candidates often pick A or B by treating a non-significant p-value as proof of no effect or as evidence for the alternative.

How to eliminate wrong answers

Option A is wrong because rejecting the null requires p ≤ α (0.08 > 0.05), so rejection is not warranted. Option B is wrong because we never 'accept' the alternative hypothesis — we only fail to reject the null; also, the test does not establish that the new design is better. Option D is wrong because a p-value above α indicates the difference is not statistically significant, so claiming significance misreads the threshold.

195
MCQeasy

Which measure best describes the spread of the middle 50% of a dataset?

A.IQR
B.Range
C.Standard deviation
D.Variance
AnswerA

The interquartile range is the difference between the third and first quartiles (Q3 minus Q1), so it spans exactly the middle 50% of ordered observations. Unlike range or standard deviation, it ignores extreme values, describing central spread precisely.

Why this answer

Interquartile range (IQR) is the range between Q1 and Q3, covering the middle 50%.

196
MCQmedium

A data analyst is performing data profiling on a customer dataset. Which metric would best reveal the number of distinct values in the 'state' column?

A.Mean
B.Row count
C.Cardinality
D.Null count
AnswerC

Cardinality counts the distinct values present in a column, so profiling the 'state' column returns how many unique states appear. This directly satisfies the stem's requirement to reveal the number of distinct values, distinguishing it from row count or null-count metrics.

Why this answer

Cardinality measures the number of distinct values in a column, so it directly reveals how many unique states appear in the 'state' column. This is a standard data profiling metric used to understand column variability and potential categorical encoding needs. Mean, row count, and null count do not provide distinct value counts.

Exam trap

The trap is that candidates might confuse cardinality with row count or null count, but cardinality specifically counts distinct values, which is the key to profiling categorical columns.

How to eliminate wrong answers

Option A is wrong because mean is a measure of central tendency for numeric data and is not applicable to categorical columns like 'state'. Option B is wrong because row count gives the total number of records, not the number of distinct values. Option D is wrong because null count only counts missing values, not the variety of non-null values.

197
MCQhard

A data analyst publishes a quarterly financial report in which the same revenue figure is printed on a summary page, a regional breakdown page, and an appendix table. The three values currently come from three separately written queries. Which practice most directly reduces the risk of the pages disagreeing?

A.Increase the refresh frequency of all three queries so they run within the same hour.
B.Add a footnote to each page stating the date the query was last executed.
C.Instruct each report author to cross-check their number against the other two pages before publishing.
D.Define the revenue metric once in a governed semantic layer and have all three pages consume that shared definition.
AnswerD

A governed semantic layer centralizes the metric's filter logic, joins, and aggregation, so every page that consumes the metric inherits identical results. Divergence becomes structurally impossible rather than a matter of author discipline, and a future change to the revenue rule propagates everywhere at once. This is the standard remedy for the same metric appearing in multiple report locations.

Why this answer

When one metric appears in several places, the durable fix is to compute it once in a governed semantic layer and let every consumer reference that definition. Shared logic removes the class of error where independently authored queries drift in filters, joins, or aggregation. Consistency then becomes a property of the architecture rather than of individual author diligence.

Exam trap

The trap here is treating freshness or manual review as the cure for inconsistent numbers when the real cause is three separate metric definitions.

198
MCQmedium

An analyst uses K-means clustering on customer purchase data. After plotting the within-cluster sum of squares for different values of k, they observe an elbow at k=4. What is the most appropriate number of clusters?

A.4
B.6
C.5
D.3
AnswerA

An elbow at k=4 indicates that adding further clusters yields diminishing reductions in within-cluster sum of squares, so four captures the data's structure without overfitting. Selecting four directly satisfies the stem's elbow-method criterion, giving the most appropriate cluster count for the purchase data.

Why this answer

The elbow method plots within-cluster sum of squares (WCSS) against k and looks for the 'elbow' — the point where adding more clusters yields diminishing reductions in WCSS. An elbow at k=4 means the marginal gain from k=4 to k=5 is small, so k=4 is the recommended number of clusters. Choosing k=4 balances model simplicity with fit quality.

Exam trap

DA0-002 often tests the misconception that the elbow value itself is the answer versus confusing it with the 'optimal' k from silhouette analysis — candidates sometimes pick a value adjacent to the elbow or assume more clusters is always better.

How to eliminate wrong answers

Option B (6) is wrong because it is past the elbow — adding clusters beyond the elbow yields minimal WCSS reduction and risks overfitting. Option C (5) is wrong because the elbow is at 4, not 5; the analyst would be adding an unnecessary cluster. Option D (3) is wrong because it is before the elbow — WCSS would still drop substantially by moving to 4, indicating underfitting.

199
MCQmedium

A data analyst is analyzing a time series of monthly sales for a retail store. The analyst observes a repeating pattern every 12 months. Which component of the time series is the analyst observing?

A.Noise
B.Trend
C.Cyclicality
D.Seasonality
AnswerD

Seasonality is a repeating pattern that occurs at fixed intervals, such as monthly, quarterly, or yearly. The 12-month repeating pattern in monthly sales data is a classic example of seasonality, often driven by holidays, weather, or school schedules. This component is predictable and consistent in timing. The analyst is observing seasonality because the pattern repeats every 12 months.

Why this answer

Seasonality is the time series component that captures repeating patterns at fixed intervals, such as every 12 months in monthly data. The analyst's observation of a yearly repeating pattern in sales is a direct example of seasonality. Trend, cyclicality, and noise do not describe fixed-period repetitions.

Therefore, seasonality is the correct component.

Exam trap

The trap here is confusing seasonality with cyclicality; both are repeating patterns, but seasonality has a fixed period, while cyclicality is irregular and often longer term.

200
MCQmedium

A data analyst needs to visualize the distribution of customer ages in a dataset containing 10,000 records. The analyst wants to see the shape of the distribution and identify any outliers. Which chart type is most appropriate?

A.Line chart
B.Histogram
C.Box plot
D.Pie chart
AnswerB

A histogram bins continuous age values into intervals, directly revealing distribution shape, skew and modality across 10,000 records. Outliers appear as isolated bars at the extremes, which a box plot would only summarise. It satisfies the stem's dual requirement: seeing overall shape and spotting outliers.

Why this answer

A histogram is most appropriate because it displays the full shape of a continuous distribution (e.g., normal, skewed, bimodal) across bins, and the tails of the histogram make extreme values visually apparent. With 10,000 records, binning ages reveals both the overall distribution shape and where outliers fall at the extremes. Box plots also show outliers, but they compress the distribution into five summary statistics and hide the shape.

Exam trap

DA0-002 often tests histogram vs. box plot — candidates pick box plot because the question mentions outliers, forgetting the question also asks for distribution shape, which only a histogram reveals.

How to eliminate wrong answers

Option A is wrong because a line chart is for trends over time or ordered sequences, not for showing the frequency distribution of a single continuous variable. Option C is wrong because although a box plot flags outliers via points beyond the whiskers, it does not reveal the shape of the distribution (modality, skewness) that the analyst explicitly wants. Option D is wrong because a pie chart shows categorical proportions and cannot represent a continuous distribution or its outliers.

201
MCQmedium

A dataset has missing values in the 'age' column. The distribution of age is approximately normal with few outliers. Which imputation method is most appropriate?

A.Mean imputation
B.Forward-fill
C.Delete all rows with missing data
D.Mode imputation
AnswerA

Age is approximately normal with few outliers, so the mean is a stable, representative estimate and preserves the sample mean. Mean imputation satisfies this distributional constraint better than median or mode, which suit skewed data or categorical fields respectively.

Why this answer

Mean imputation is appropriate when the data is approximately normally distributed and has few outliers, because the mean is a representative measure of central tendency for symmetric distributions. It preserves the overall mean of the variable and is simple to implement. Forward-fill and mode imputation are better for time-series or categorical data, respectively, and deleting rows can introduce bias and reduce sample size.

Exam trap

DA0-002 often tests the assumption that mean imputation is always appropriate, but the trap is failing to recognize that it is only suitable for continuous, normally distributed data without outliers; mode is for categorical, forward-fill for time-series.

How to eliminate wrong answers

Option B is wrong because forward-fill is used for time-series data where the next value is likely similar to the previous one, not for independent observations like age. Option C is wrong because deleting all rows with missing data can lead to significant data loss and bias if the missingness is not completely random. Option D is wrong because mode imputation is used for categorical variables, not continuous variables like age, and it can distort the distribution.

202
MCQeasy

Which chart type is best for displaying the distribution of a continuous variable, such as the age distribution of customers?

A.Box plot
B.Line chart
C.Histogram
D.Pie chart
AnswerC

A histogram bins a continuous variable into intervals and plots frequency per bin, revealing the shape, spread and skew of the age distribution. Bar charts suit categorical counts, and box plots summarise rather than display the full distribution.

Why this answer

A histogram is the correct choice because it groups continuous data (like age) into bins along the x-axis and displays the frequency of observations within each bin as bars, making the distribution shape immediately visible. This directly addresses the need to show how customer ages are spread across the range, which is the definition of a distribution for a continuous variable.

Exam trap

CompTIA Data+ often tests the distinction between a histogram and a bar chart, where candidates mistakenly choose a bar chart (not listed here) or a box plot because they confuse 'distribution' with 'summary statistics' or 'categorical comparison'.

How to eliminate wrong answers

Option A is wrong because a box plot summarizes the distribution using five-number summary statistics (min, Q1, median, Q3, max) and highlights outliers, but it does not show the detailed shape or modality of the distribution as a histogram does. Option B is wrong because a line chart is designed to show trends over time or ordered categories by connecting data points, not to display the frequency distribution of a single continuous variable. Option D is wrong because a pie chart is used to show proportions of a whole for categorical data, and it cannot represent the distribution of a continuous variable like age.

203
MCQeasy

A data analyst is comparing the average test scores of students who attended a tutoring program versus those who did not. Which statistical test is most appropriate for determining if there is a significant difference between the means of these two independent groups?

A.Paired t-test
B.Chi-square test
C.Two-sample t-test
D.ANOVA
AnswerC

The two-sample t-test compares means drawn from two independent groups, which matches the tutoring versus non-tutoring cohorts. It partitions variance between and within groups to produce a p-value for the null hypothesis of equal population means, satisfying the requirement to test significance between two unrelated samples.

Why this answer

The independent samples t-test is used to compare the means of two independent groups.

204
Multi-Selecthard

Which THREE data quality dimensions are commonly assessed in a data profiling task?

Select 3 answers
A.Scalability
B.Consistency
C.Uniqueness
D.Availability
E.Completeness
AnswersB, C, E

Consistency ensures uniform data representation, a common profiling check.

Why this answer

Consistency is a core data quality dimension assessed in data profiling because it evaluates whether data values are free from contradiction and adhere to the same representation rules across records. In profiling tools like Informatica or Talend, consistency checks identify violations such as 'NY' vs 'New York' in a state column, ensuring semantic uniformity.

Exam trap

CompTIA often tests the distinction between data quality dimensions (completeness, consistency, uniqueness) and system-level attributes (scalability, availability), leading candidates to mistakenly select non-quality terms like 'Availability' or 'Scalability' because they sound relevant to data management.

205
Multi-Selectmedium

Which TWO of the following are considered structured data?

Select 2 answers
A.A PDF report with free-form text
B.A relational database table
C.A JPEG image of a product
D.A JSON file with nested key-value pairs
E.A CSV file containing sales records
AnswersB, E

Tables have a fixed schema.

Why this answer

A relational database table stores data in a predefined schema of rows and columns, where each column has a fixed data type. This rigid structure allows for efficient querying, indexing, and relational operations, making it a classic example of structured data.

Exam trap

The trap here is that candidates often mistake semi-structured data (like JSON) for structured data because it has key-value pairs, but the DA0-001 exam strictly defines structured data as having a fixed, predefined schema—typically found in relational databases or CSV files with consistent column headers.

206
MCQhard

In Looker Studio, a data analyst has two data sources: one with customer IDs and transactions, and another with customer demographics. They need to create a chart that includes fields from both sources. Which feature should they use?

A.Data blending
B.Calculated fields
C.Community connectors
D.Dashboard filters
AnswerA

Data blending lets Looker Studio combine fields from multiple sources in one chart by joining them on a shared dimension, such as customer ID. This satisfies the requirement to display transaction and demographic fields together without pre-joining the underlying data.

Why this answer

Data blending in Looker Studio allows you to combine data from two or more separate data sources based on a common key (e.g., customer ID). This enables you to create a chart that uses fields from both the transactions source and the demographics source without needing to merge the data at the database level. Without blending, a single chart can only reference fields from one data source at a time.

Exam trap

The trap here is that candidates often confuse data blending with calculated fields, thinking a formula can reference fields from another source, but Looker Studio restricts calculated fields to operate only within a single data source.

How to eliminate wrong answers

Option B is wrong because calculated fields create new fields within a single data source using formulas, but they cannot pull in fields from a second, unrelated data source. Option C is wrong because community connectors are used to connect to external data sources (e.g., APIs), not to combine data from two already-connected sources within a report. Option D is wrong because dashboard filters control which data is displayed across charts, but they do not merge or join fields from different data sources into a single chart.

207
Matchingmedium

Match each data sampling method to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Each member has equal chance of selection

Population divided into subgroups; random sample from each

Randomly select entire groups (clusters)

Select every k-th element from a list

Sample based on ease of access

Why these pairings

In matching, ensure you distinguish between methods: simple random gives equal chance; stratified divides by characteristic; cluster divides into groups and picks whole groups; systematic uses a fixed interval.

208
MCQmedium

A data analyst is creating a report to compare the performance of different sales regions. The report will be used by regional managers to identify areas needing improvement. Which of the following visualization techniques would be most effective?

A.A bar chart comparing each region's sales
B.A line chart showing overall company sales
C.A pie chart showing each region's contribution
D.A scatter plot of sales vs. expenses
AnswerA

A bar chart maps each region to a discrete bar, letting managers compare magnitudes across categories at a glance. This directly satisfies the requirement to rank regions and spot underperformance, which continuous or part-to-whole charts would obscure.

Why this answer

A bar chart is most effective because it allows direct, side-by-side comparison of discrete categories (sales regions) using a common baseline, making it easy for regional managers to quickly identify which regions are underperforming. The vertical bars encode exact values with high perceptual accuracy, supporting the report's goal of highlighting areas needing improvement.

Exam trap

The trap here is that candidates often choose a pie chart (Option C) because they think 'contribution to the whole' is the goal, but the question asks for comparing performance across regions, which requires a common baseline — a task for which pie charts are notoriously poor.

How to eliminate wrong answers

Option B is wrong because a line chart is designed to show trends over continuous time intervals, not to compare discrete categories like sales regions; it would obscure regional differences by aggregating data into a single overall trend. Option C is wrong because a pie chart shows parts of a whole, making it difficult to compare individual region performance accurately due to the lack of a common baseline and poor perceptual precision for small differences. Option D is wrong because a scatter plot is used to explore the relationship between two continuous variables (e.g., correlation between sales and expenses), not to compare performance across distinct categories like regions.

209
MCQhard

In a linear regression model predicting house prices, the coefficient for the number of bedrooms is $30,000 and the intercept is $50,000. If a house has 3 bedrooms, what is the predicted price?

A.$80,000
B.$150,000
C.$90,000
D.$140,000
AnswerD

Applying the regression equation gives $50,000 + ($30,000 × 3) = $140,000. The intercept supplies the baseline price, and the bedroom coefficient scales linearly with the count, so three bedrooms add $90,000 to the base, satisfying the stem's prediction request.

Why this answer

The linear regression equation is Price = Intercept + (Coefficient × Bedrooms) = $50,000 + ($30,000 × 3) = $50,000 + $90,000 = $140,000. This is a direct application of the slope-intercept form of a simple linear regression model with one predictor.

Exam trap

DA0-002 often tests whether candidates correctly apply the regression equation, and the trap is forgetting to add the intercept or misreading the coefficient as the total price rather than the per-unit change.

How to eliminate wrong answers

Option A is wrong because $80,000 results from adding only $30,000 to the intercept, which would correspond to one bedroom, not three. Option B is wrong because $150,000 results from multiplying $50,000 by 3, incorrectly treating the intercept as a per-bedroom value. Option C is wrong because $90,000 is just the coefficient times bedrooms ($30,000 × 3) without adding the intercept, omitting the base price.

210
MCQeasy

Which report type is best suited for monitoring the real-time status of manufacturing equipment on the factory floor?

A.Scheduled report
B.Self-service report
C.Analytical report
D.Operational report
AnswerD

An operational report displays current, near-real-time records with minimal aggregation, so it reflects live equipment status on the factory floor. Summarised or historical report types lag behind and cannot show the immediate state required for monitoring.

Why this answer

Operational reports provide real-time data for monitoring ongoing operations.

211
MCQmedium

A data team is designing an ETL process to extract data from an operational database daily. The database experiences heavy write loads during business hours. What is the best practice to minimize impact on operations?

A.Extract directly from the primary database with high priority
B.Run the extraction during peak hours to ensure data freshness
C.Schedule extraction at midnight when load is low
D.Use replication or a read replica to extract data
AnswerD

A read replica or replicated copy serves extraction queries on separate hardware, so the heavy business-hours write load on the operational database is not contended by the daily ETL reads. This satisfies the stated constraint of minimising operational impact.

Why this answer

Extracting from a read replica or replicated copy isolates the ETL workload from the primary database that serves production transactions. This prevents the heavy read queries of the ETL process from competing with business-critical writes and locks, preserving performance for users. It is the standard best practice for minimizing operational impact while still obtaining the needed data.

Exam trap

The trap here is assuming that off-peak scheduling (midnight) is always sufficient, but the question emphasizes heavy write loads during business hours and asks for best practice to minimize impact—isolating the workload via replication is the more robust answer.

How to eliminate wrong answers

Option A is wrong because extracting directly from the primary database with high priority would compete with production write loads, potentially causing contention, blocking, and performance degradation. Option B is wrong because running extraction during peak hours directly contradicts the goal of minimizing impact on operations, as it adds load when the system is already busiest. Option C is wrong because scheduling at midnight only reduces impact if the database is actually idle then; many operational databases have batch jobs, backups, or global users active at night, and it does not provide a structural isolation like a replica does.

212
MCQmedium

In time series analysis, which component represents regular patterns that repeat over fixed periods, such as daily or yearly?

A.Seasonality
B.Trend
C.Cyclical
D.Irregular
AnswerA

Seasonality describes fluctuations that recur at fixed intervals, such as daily, weekly or yearly cycles, and is modelled separately from trend and residual noise. It is the component capturing the regular repeating pattern the stem describes, not the long-term direction or random variation.

Why this answer

Seasonality refers to patterns that repeat at regular intervals.

213
MCQmedium

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?

A.Scheduled report
B.Operational report
C.Ad hoc report
D.Self-service report
AnswerC

An ad hoc report is generated once for a specific, non-recurring request, matching the Q4 product-line analysis that will not be repeated. Recurring or scheduled reporting types would impose unnecessary ongoing effort for a one-time need.

Why this answer

An ad hoc report is a one-time, on-demand report created for a specific question and not scheduled or reused. The scenario explicitly states the report is not expected to be repeated, which is the defining characteristic of ad hoc reporting. Scheduled, operational, and self-service reports all imply recurring or ongoing use.

Exam trap

The trap is overthinking 'self-service' as the modern answer — candidates pick it because it sounds agile, but the question hinges on the one-time, non-recurring nature, which maps to ad hoc.

How to eliminate wrong answers

Option A is wrong because a scheduled report runs automatically on a recurring cadence, which contradicts the 'one-time, not repeated' requirement. Option B is wrong because an operational report supports day-to-day running of the business on an ongoing basis, not a single Q4 retrospective. Option D is wrong because self-service reporting means business users build their own reports via a tool, which is about who creates it, not the one-time nature of this request.

214
Multi-Selecthard

A data analyst is integrating customer data from two source systems: a CRM and a billing system. The CRM uses a customer ID format of 'CUST-12345', while the billing system uses '12345'. The analyst needs to join records on customer ID. Which two steps are necessary to prepare the data for a successful join? (Choose two.)

Select 2 answers
A.Extract the numeric portion from the CRM customer ID to match the billing system format.
B.Apply a hash function to both customer ID fields to anonymize them.
C.Convert both customer ID fields to a consistent string data type.
D.Sort both datasets by customer ID before joining.
E.Create a cross-reference table mapping CRM IDs to billing IDs.
AnswersA, C

Extracting the numeric portion from the CRM ID removes the 'CUST-' prefix, making it compatible with the billing system's numeric ID. This is essential for a direct join on the ID fields. Without this step, the join would fail because the formats differ. It standardizes the key across both sources.

Why this answer

The necessary steps are to extract the numeric portion from the CRM ID and to ensure both ID fields share a consistent data type. These actions standardize the join key, allowing records to match correctly across the two systems. Without them, the join would fail due to format and type mismatches, leading to incomplete or incorrect integration.

Exam trap

The trap here is assuming that a simple CAST or CONVERT is enough, but the format difference ('CUST-' prefix) must also be resolved before the join can succeed.

215
MCQeasy

After a marketing campaign, sales increased by 15%. The analyst wants to understand which customer segment contributed most to the increase. Which type of analysis is this?

A.Predictive analysis
B.Diagnostic analysis
C.Prescriptive analysis
D.Descriptive analysis
AnswerB

Diagnostic analysis examines why an outcome occurred by drilling into contributing factors. Here it isolates which customer segment drove the 15% sales lift, satisfying the requirement to explain the increase's source rather than merely describing it or forecasting future values.

Why this answer

Diagnostic analysis is used to understand the root cause of an event or change. In this scenario, the analyst already knows sales increased by 15% and wants to determine which customer segment drove that increase, which is a classic diagnostic question. This type of analysis goes beyond describing what happened to explain why it happened.

Exam trap

The trap here is confusing diagnostic analysis with descriptive analysis, as both deal with past data, but descriptive only summarizes what happened while diagnostic explains why it happened.

How to eliminate wrong answers

Option A is wrong because predictive analysis uses historical data to forecast future outcomes, not to explain past changes. Option C is wrong because prescriptive analysis recommends actions or decisions to achieve a desired outcome, not to diagnose the cause of a past event. Option D is wrong because descriptive analysis summarizes what happened (e.g., 'sales increased by 15%') but does not investigate which segment contributed most to the increase.

216
Multi-Selectmedium

A business analyst is asked to distinguish between KPIs and metrics for a new dashboard. According to CompTIA Data+, which TWO statements correctly differentiate KPIs from metrics? (Choose two.)

Select 2 answers
A.KPIs and metrics are interchangeable terms
B.Metrics are always more important than KPIs
C.KPIs are directly tied to strategic business objectives
D.Metrics are operational measurements that may not be strategic
E.KPIs are always lagging indicators
AnswersC, D

KPIs measure progress toward strategic business objectives, whereas metrics are broader, general measurements of activity. This satisfies the stem's requirement to differentiate the two concepts: a KPI's defining characteristic is its direct alignment with organisational strategy, not merely tracking operational data points.

Why this answer

Option C is correct because KPIs (Key Performance Indicators) are by definition tied directly to strategic business objectives — they measure how well an organization is progressing toward its most important goals, which is what distinguishes them from ordinary metrics. Option D is correct because metrics are general operational measurements (e.g., page views, CPU utilization, daily transaction counts) that track activity but are not necessarily linked to strategic objectives, whereas a KPI is a selected metric elevated for its strategic relevance. Options A, B, and E do not belong: KPIs and metrics are not interchangeable (A), importance is determined by strategic alignment rather than metrics always outranking KPIs (B), and KPIs can be leading or lagging indicators depending on the objective, so they are not always lagging (E).

Exam trap

DA0-002 often tests the misconception that KPIs and metrics are synonyms or that KPIs are always lagging — the exam expects candidates to recognize that strategic linkage, not measurement type, defines a KPI.

217
MCQmedium

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

A.Operational report
B.Self-service report
C.Ad hoc report
D.Scheduled report
AnswerC

Ad hoc reports are built on demand to answer a single, non-recurring question, so they suit this one-time campaign query for a specific week. Standard or recurring reports would waste effort and cannot flex to the analyst's immediate, unique need.

Why this answer

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

218
MCQmedium

A data engineer is designing a data warehouse for a retail company. The fact table must record each sale transaction, including product ID, store ID, date, and quantity sold. The product details (name, category, price) are stored in a separate table. This design is an example of which data modeling concept?

A.Star schema
B.Data lake
C.Normalization
D.Snowflake schema
AnswerA

A star schema satisfies this design because it centres a fact table of sale transactions — product ID, store ID, date, quantity — surrounded by denormalised dimension tables such as product, holding name, category and price. The separate product table is precisely that dimension, keeping descriptive attributes out of the fact grain.

Why this answer

This design is a classic star schema, where a central fact table (sales transactions) contains foreign keys to dimension tables (product, store, date). The fact table stores quantitative measures (quantity sold) and foreign keys, while dimension tables hold descriptive attributes (product name, category, price). This separation optimizes query performance for OLAP workloads by reducing joins and enabling straightforward aggregations.

Exam trap

The trap here is that candidates confuse star schema with snowflake schema, but the key differentiator is whether dimension tables are further normalized (snowflake) or kept denormalized (star), and this question's single product table clearly indicates a star schema.

How to eliminate wrong answers

Option B is wrong because a data lake stores raw, unprocessed data in its native format (e.g., CSV, Parquet) without a predefined schema, whereas this design explicitly separates facts and dimensions with a structured schema. Option C is wrong because normalization would split data into many related tables to eliminate redundancy (e.g., separating product category into its own table), but here product details are kept in a single dimension table, which is denormalized. Option D is wrong because a snowflake schema further normalizes dimension tables into sub-dimensions (e.g., splitting product category into a separate table), but this design keeps product details in one table, making it a star schema, not a snowflake.

219
MCQeasy

A data analyst is designing a dashboard for executives. Which best practice should be followed regarding the placement of key performance indicators (KPIs)?

A.Include as many charts as possible on a single screen to avoid scrolling
B.Hide KPIs behind filters to reduce initial load time
C.Use distinct colors to highlight all KPIs equally
D.Place the most important KPIs in the top-left corner
AnswerD

Placing the most important KPIs top-left aligns with the F-pattern reading sequence executives naturally follow, ensuring critical metrics are seen first without scrolling. This satisfies the stem's dashboard-design constraint by prioritising visibility of key indicators, since Western readers scan from the upper-left before moving across and down.

Why this answer

Placing the most important KPIs in the top-left corner follows natural reading patterns (left-to-right, top-to-bottom), ensuring executives see critical metrics first. Option A is wrong because including too many charts on a single screen reduces readability and can overwhelm users. Option B is wrong because hiding KPIs behind filters defeats the purpose of having them visible at a glance.

Option C is wrong because using distinct colors for all KPIs equally does not prioritize information; it may actually create visual clutter and reduce clarity.

220
MCQhard

An e-commerce company stores customer support emails in a text database, product images in a blob store, and sales transactions in a SQL table. Which data store holds only structured data?

A.Blob store
B.Text database
C.SQL table
D.None
AnswerC

The SQL table stores sales transactions in a fixed relational schema with defined columns and types, making it structured data. The text database and blob store hold unstructured content, satisfying the stem's request to identify the structured store.

Why this answer

Structured data conforms to a predefined schema with rows and columns, enforcing data types and relationships. A SQL table is the canonical example of a structured data store because it organizes data into tables with fixed schemas, supports ACID transactions, and enables relational queries via SQL. In contrast, blob stores and text databases store unstructured or semi-structured data without a rigid schema.

Exam trap

The trap here is that candidates confuse 'structured data' with any data that has some organization (like tags in a blob store or fields in a text document), but only a SQL table enforces a rigid, predefined schema with typed columns and relational constraints, which is the defining characteristic of structured data.

How to eliminate wrong answers

Option A is wrong because a blob store (e.g., Amazon S3, Azure Blob Storage) stores binary large objects such as images, videos, or documents as opaque blobs with no inherent schema or structure — it is designed for unstructured data. Option B is wrong because a text database (e.g., a NoSQL document store like MongoDB or a plain text file repository) stores free-form text or semi-structured documents (e.g., JSON, XML) that lack a fixed, predefined schema and are not organized into rows and columns. Option D is wrong because the SQL table explicitly holds structured data, so 'None' is incorrect.

221
MCQmedium

A data analyst wants to concatenate first_name and last_name columns with a space in between. Which string function combination should be used in SQL?

A.first_name + ' ' + last_name
B.SUBSTRING(first_name, 1, 1) + '.' + last_name
C.CONCAT(first_name, last_name)
D.CONCAT(first_name, ' ', last_name)
AnswerD

CONCAT joins its arguments directly, so passing first_name, a literal space, and last_name inserts exactly one space between the names without requiring a separator parameter. This satisfies the stem's requirement to concatenate both columns with a space in between, and CONCAT also handles NULL inputs more gracefully than the || operator.

Why this answer

CONCAT(first_name, ' ', last_name) is correct because CONCAT accepts multiple arguments and joins them in order; inserting a literal space string ' ' between the two column arguments produces the desired 'first last' format. This is the standard, portable SQL approach for joining columns with a delimiter.

Exam trap

The trap is assuming the + operator is universal string concatenation across all SQL dialects, or forgetting that CONCAT without a delimiter argument produces no space — the exam tests whether you read the requirement for a space between the names.

How to eliminate wrong answers

Option A is wrong because the + operator is not universal string concatenation in SQL — it works in SQL Server and some dialects but is invalid or interpreted as arithmetic in others (e.g., PostgreSQL, Oracle), and it does not reliably handle NULLs the way CONCAT does. Option B is wrong because SUBSTRING(first_name, 1, 1) extracts only the first initial of the first name and concatenates it with a period and the last name, producing 'J.Smith' rather than 'John Smith'. Option C is wrong because CONCAT(first_name, last_name) joins the two columns with no separator, yielding 'JohnSmith' with no space.

222
MCQmedium

A data analyst is working with a dataset that contains a column 'income' with a highly skewed distribution. The analyst wants to apply a transformation to make the distribution more symmetric for use in a linear regression model. Which transformation is most appropriate?

A.Min-max normalization
B.Binning into equal-width intervals
C.Standardization (z-score normalization)
D.Logarithmic transformation
AnswerD

A logarithmic transformation is commonly used to reduce right skewness in positive data. Income data often has a long right tail, and taking the log compresses larger values more than smaller ones, making the distribution more symmetric. This can improve the performance of linear regression by making the relationship more linear and stabilizing variance. Thus, it is the most appropriate choice for this scenario.

Why this answer

A logarithmic transformation is effective for reducing right skewness in positive data like income. It compresses the upper tail, making the distribution more symmetric and improving linearity for regression. Standardization and min-max normalization only rescale without changing shape.

Binning discards information and does not achieve symmetry. Therefore, the logarithmic transformation is the correct choice.

Exam trap

The trap here is confusing scaling transformations (like standardization) with shape-changing transformations (like log). Scaling does not fix skewness.

223
Multi-Selectmedium

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

Select 3 answers
A.Data governance
B.Data quality management
C.Data encryption
D.Data archival
E.Data integration
AnswersA, B, E

Data governance is a core MDM component, defining ownership, stewardship, policies and standards that keep master data trustworthy across domains. It satisfies the stem's requirement to identify MDM components, providing the control framework within which mastering and integration operate.

Why this answer

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

224
MCQeasy

A marketing analyst is reviewing a dataset of campaign responses. The 'response' column contains values 'Yes', 'No', 'Y', 'N', 'yes', and 'no'. Before analysis, the analyst needs to count how many customers responded positively. Which data preparation step is most appropriate?

A.Convert the column to uppercase to make all values consistent.
B.Filter out rows with 'Y' and 'N' because they are abbreviations.
C.Create a new binary column where 'Yes' and 'Y' are 1, and all else 0.
D.Standardize the values to 'Yes' and 'No' using case normalization and mapping.
AnswerD

Standardizing the values ensures consistency, so that 'Y', 'yes', and 'Yes' are all recognized as positive responses. This simplifies counting and prevents undercounting due to case or abbreviation variations. It is a fundamental data cleaning step that improves data quality and analysis accuracy. Without it, aggregations would be misleading.

Why this answer

The analyst should standardize the values to 'Yes' and 'No' by normalizing case and mapping abbreviations. This ensures all positive responses are consistently represented, enabling accurate counting and analysis. Without standardization, variations like 'Y' and 'yes' would be treated as separate categories, leading to incorrect insights.

Exam trap

The trap here is assuming that converting to uppercase alone solves the problem, but it ignores abbreviations like 'Y' that still need mapping.

225
MCQhard

A data scientist is building a K-means clustering model for customer segmentation. After plotting the within-cluster sum of squares (WCSS) against the number of clusters (k), she observes that the WCSS decreases sharply until k=5 and then levels off. Which value of k should she choose based on the elbow method?

A.k=5
B.k=6
C.k=4
D.k=3
AnswerA

The elbow method selects the k where WCSS reduction transitions from steep to shallow, forming the bend. At k=5 the curve flattens, meaning additional clusters yield diminishing compactness gains. Choosing k=5 satisfies the stem's observed inflection point, balancing model simplicity against within-cluster variance.

Why this answer

The elbow method plots WCSS against k and looks for the 'elbow' — the point where the rate of decrease sharply changes from steep to shallow. Since WCSS drops sharply until k=5 and then levels off, k=5 is the optimal choice because additional clusters beyond that yield diminishing returns.

Exam trap

DA0-002 often tests the misconception that the lowest WCSS (highest k) is best; candidates must recognize that the elbow method selects the inflection point, not the minimum WCSS.

How to eliminate wrong answers

Option B (k=6) is wrong because it is past the elbow, adding a cluster with minimal WCSS reduction and risking overfitting. Option C (k=4) is wrong because it is before the elbow, meaning the model is under-clustered and WCSS is still decreasing steeply. Option D (k=3) is wrong for the same reason — it is even further from the elbow and would leave significant within-cluster variance unexplained.

Page 2

Page 3 of 14

Page 4