986 questions total · 14pages · All types, answers revealed
Drag and drop the steps for the ETL (Extract, Transform, Load) process in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
ETL begins with extraction, followed by cleaning, transformation, loading, and verification.
A marketing analyst wants to segment customers based on their purchase history, including total spent, number of transactions, and average order value. The analyst runs k-means clustering with k=5 on the raw data but notices that the cluster assignments change significantly every time the algorithm is executed. What should the analyst do first to obtain consistent and meaningful clusters?
Normalization ensures all features contribute equally, and a fixed seed ensures reproducible results.
Why this answer
The instability in cluster assignments is caused by the algorithm's sensitivity to the scale of features and the random initialization of centroids. Normalizing the features ensures that each variable contributes equally to the distance calculations, while setting a fixed random seed makes the initial centroid selection deterministic, leading to reproducible results.
Exam trap
The trap here is that candidates may think the instability is due to the choice of k or the algorithm itself, rather than recognizing that k-means is sensitive to feature scaling and random initialization, which are the first things to address for consistency.
How to eliminate wrong answers
Option B is wrong because hierarchical clustering does not require specifying k, but it still suffers from sensitivity to data scaling and does not address the core issue of random initialization causing variability. Option C is wrong because increasing k to 10 would likely increase instability and overfit noise, not resolve the fundamental problem of non-deterministic centroids. Option D is wrong because PCA reduces dimensionality but does not stabilize the k-means algorithm; the cluster assignments would still vary with different random seeds unless combined with normalization and a fixed seed.
Refer to the exhibit. Which clause is used to aggregate the data by department?
GROUP BY groups rows by department, allowing COUNT to compute per-department totals.
Why this answer
The GROUP BY clause is used to aggregate data by department because it groups rows that have the same values in the specified column(s), allowing aggregate functions like SUM, AVG, or COUNT to be applied per group. In SQL, without GROUP BY, aggregate functions would operate on the entire result set, not per department.
Exam trap
CompTIA often tests the distinction between WHERE (row-level filter) and HAVING (group-level filter), leading candidates to confuse HAVING with GROUP BY when the question asks for the clause that performs aggregation.
How to eliminate wrong answers
Option A is wrong because HAVING is used to filter groups after aggregation, not to define the grouping itself. Option B is wrong because WHERE filters individual rows before aggregation and cannot group data by department. Option C is wrong because ORDER BY sorts the result set but does not perform any aggregation or grouping.
An analyst wants to visualize the relationship between advertising spend (x-axis) and revenue (y-axis) for 100 different products. Each product is in one of three categories. Which chart type best displays this data?
Scatter plots show correlation, and color adds a third dimension.
Why this answer
A scatter plot with color-coded categories effectively shows relationships between two continuous variables and a third categorical dimension.
A data analyst creates a weekly KPI dashboard for executives. The analyst notes that the data is updated as of the previous day. Which report quality element should be included?
Correct. Data freshness notes the last update time.
Why this answer
Data freshness indicates how recent the data is, which is crucial for interpreting the report's timeliness.
When designing a report for executive leadership, which aspect is most important?
Executives prefer summaries that highlight important findings and recommendations.
Why this answer
Executive leadership requires actionable insights, not raw data. High-level summaries with key insights (Option D) allow leaders to quickly grasp trends, make decisions, and align with business goals without getting bogged down in technical details. This aligns with the DA0-001 objective of communicating data insights effectively to non-technical stakeholders.
Exam trap
The trap here is that candidates confuse 'thoroughness' with 'effectiveness' and assume executives need all supporting data (raw tables, queries, notes) to trust the report, when in fact executives value brevity and actionable insights over technical completeness.
How to eliminate wrong answers
Option A is wrong because detailed technical notes are irrelevant for executives who need concise, decision-ready information, not implementation specifics. Option B is wrong because raw data tables are overwhelming and require interpretation, which executives lack time for; they need aggregated insights. Option C is wrong because raw SQL queries are code, not a report; executives cannot derive meaning from queries, and including them violates the principle of audience-appropriate communication.
You are a data analyst at a logistics company. The operations manager wants to reduce delivery delays. You have historical data including order date, delivery date, distance, weather conditions, and driver ID. Initial analysis shows that the average delivery time has increased over the past six months. You suspect that weather is a contributing factor, but you need to confirm. The company also wants to build a model to predict delivery times to better manage customer expectations. The data contains missing values for weather conditions in about 10% of records, and some driver IDs are incorrect. You have limited time and resources. What should you do first?
Cleaning ensures data integrity, and EDA guides modeling choices.
Why this answer
Data cleaning and exploratory data analysis (EDA) are foundational steps before any modeling or time series work. With missing weather data (10%) and incorrect driver IDs, proceeding without cleaning would introduce bias and errors. EDA will reveal patterns, correlations, and data quality issues, enabling informed decisions on imputation and feature engineering for the predictive model.
Exam trap
CompTIA often tests the misconception that you can jump directly to modeling or advanced analysis without first ensuring data quality, ignoring the 'garbage in, garbage out' principle.
How to eliminate wrong answers
Option A is wrong because time series analysis assumes clean, consistent data; applying it directly with missing values and incorrect IDs would yield unreliable patterns and waste resources. Option C is wrong because collecting more data is time-consuming and does not address the existing incorrect driver IDs or the need to understand current data quality; it also assumes missing values are random, which may not hold. Option D is wrong because building a predictive model on uncleaned data with imputed weather values without prior EDA risks overfitting, misinterpretation of feature importance, and propagation of errors from incorrect IDs.
Which THREE actions improve the accessibility of data visualizations for users with visual impairments? (Select exactly three.)
Text alternatives allow screen readers to convey information.
Why this answer
Options A, C, and D are correct. Text alternatives (A) allow screen readers to convey chart data. Clear labels (C) improve readability for all users.
Sufficient color contrast (D) helps users with low vision. Using only color (B) to convey information excludes colorblind users, and animated transitions (E) can be distracting and are not an accessibility improvement.
An analyst creates a stacked bar chart showing quarterly sales by product category. The chart becomes hard to read because some categories have very small contributions. Which redesign is most effective?
Grouping small items simplifies the chart and improves readability.
Why this answer
Combining small categories into an 'Other' group reduces visual clutter and improves readability by aggregating negligible contributions into a single bar segment. This technique preserves the overall trend while eliminating the noise from many tiny slices that make the stacked bar chart hard to interpret.
Exam trap
The trap here is that candidates often think adding more visual elements (3D, wider bars) or changing chart types (pie) will fix readability, when the real solution is data aggregation to reduce cognitive load.
How to eliminate wrong answers
Option B is wrong because using a pie chart for each quarter does not solve the problem of small categories; it merely shifts the same issue to a different chart type, where tiny slices are even harder to compare across quarters. Option C is wrong because increasing bar width does not address the core problem of too many small segments; it only stretches the visual horizontally without reducing the number of categories. Option D is wrong because switching to a 3D stacked column chart introduces perspective distortion and occlusion, making small contributions even more difficult to discern and violating best practices for accurate data visualization.
A data analyst is cleaning a dataset and finds that the 'age' column has several missing values. Which method of handling missing values is least likely to introduce bias if the missingness is completely at random?
If MCAR, listwise deletion gives unbiased estimates, though with less power.
Why this answer
Listwise deletion (removing rows with missing values) is simple and unbiased if data is MCAR, but it reduces sample size. However, it is least likely to introduce bias among the options when MCAR holds.
A data analyst is comparing the means of two independent groups using a t-test. The sample sizes are small and the data is not normally distributed. Which condition is violated for a valid t-test?
Normality is an assumption of t-test.
Why this answer
The t-test assumes normality of the data, especially with small samples. Violation of normality can affect the validity.
A data analyst finds that the "Age" column contains values like "N/A", "unknown", and negative numbers. Which data quality dimension is primarily affected?
Correct. The values are not valid for the Age attribute.
Why this answer
Validity refers to the degree to which data conforms to defined business rules or constraints. Invalid entries (non-numeric, negative) violate the expected data type and range.
A data analyst needs to sample records from a large dataset for a quick analysis. Which TWO sampling methods are examples of probability sampling?
Every element has an equal probability of selection.
Why this answer
Simple random sampling and systematic sampling are probability-based methods where every element has a known chance of selection.
An IT operations team monitors 200 servers. Each server reports CPU utilization (0-100%) every five minutes for the past year. The team wants to visualize the data to identify servers that are consistently over 80% utilization and detect any unusual spikes. They have a large dataset with 100,000+ records per server. The current visualization is a single scatter plot with CPU utilization on the y-axis, time on the x-axis, and each server as a different colored point. The chart is extremely cluttered, with points overlapping and colors indistinguishable. What should the team do to improve the visualization?
Heatmaps compactly show high-density data; small multiples allow per-server trend analysis without overlapping.
Why this answer
Heatmaps and small multiples (trellis charts) are effective for visualizing large, dense datasets with multiple categories. A heatmap can show CPU utilization intensity over time for all servers in a compact form, making it easy to identify consistently high utilization and spikes. Small multiples create separate charts per server, avoiding overlap and allowing comparison.
Option B is wrong because a single line chart with 200 lines would be even more cluttered than the scatter plot, making it impossible to distinguish individual servers. Option C is wrong because trend lines remove the individual data points needed to detect unusual spikes, and they would not show the actual utilization values. Option D is wrong because increasing the size of data points would worsen the overlap and clutter, making the chart even less readable.
A data analyst needs to summarize customer satisfaction scores. The data contains a few extremely low scores that skew the distribution. Which measure of central tendency is most appropriate?
The median is robust to outliers and provides a better central value for skewed data.
Why this answer
The median is the most appropriate measure of central tendency when data contains extreme outliers, such as the very low customer satisfaction scores described. Unlike the mean, the median is resistant to skew because it depends only on the middle value(s) of the sorted dataset, not on the magnitude of extreme values. This makes it the standard choice for summarizing ordinal or skewed interval/ratio data in data analysis.
Exam trap
The trap here is that candidates often default to the mean as the 'average' without considering outlier impact, but CompTIA Data+ tests the understanding that the mean is non-robust and the median is the correct choice for skewed data in the Analyzing and Modeling domain.
How to eliminate wrong answers
Option A (Range) is wrong because it is a measure of dispersion (the difference between the maximum and minimum values), not a measure of central tendency, and it is heavily influenced by outliers. Option B (Mode) is wrong because it identifies the most frequently occurring score, which may not represent the center of the distribution and can be misleading when outliers are present but not frequent. Option D (Mean) is wrong because it is sensitive to extreme values; the few extremely low scores will pull the arithmetic mean downward, misrepresenting the typical customer satisfaction experience.
Which of the following is an example of qualitative data?
Comments are text, non-numeric, qualitative data.
Why this answer
Customer feedback comments are qualitative data because they consist of non-numerical, descriptive text that captures opinions, sentiments, or experiences. Unlike quantitative data, which can be measured or counted, qualitative data is categorical and often requires thematic analysis to derive insights.
Exam trap
The trap here is that candidates often confuse 'qualitative' with 'quantifiable' and may incorrectly select a numeric option like stock price or website visitors, not realizing that qualitative data is inherently non-numeric and descriptive.
How to eliminate wrong answers
Option A is wrong because stock price is a numerical value that can be measured and compared, making it quantitative data. Option C is wrong because the number of website visitors is a count, which is a discrete numerical value and thus quantitative data. Option D is wrong because product weight in grams is a continuous numerical measurement, falling under quantitative data.
An analyst wants to identify outliers in a dataset using the IQR method. Which values are typically considered outliers?
Standard IQR outlier definition.
Why this answer
Outliers are values below Q1 - 1.5*IQR or above Q3 + 1.5*IQR.
In pandas, you have a DataFrame 'df' with columns 'product' and 'sales'. You want to calculate the total sales per product. Which method should you use?
Correctly aggregates sales by product.
Why this answer
df.groupby('product')['sales'].sum() groups by product and sums sales. df.pivot_table can also do it but is more complex. df.merge is for joining, df.apply is for applying a function element-wise or row/column-wise.
A data analyst is performing a join between two tables: 'employees' and 'departments'. The 'employees' table has a foreign key 'dept_id' referencing the 'departments' table. Which two join types would include all rows from the 'employees' table, regardless of whether there is a matching department? (Select TWO)
LEFT JOIN returns all rows from the left (employees) table.
Why this answer
LEFT JOIN and RIGHT JOIN (if reversed) can include all rows from the left table. Specifically, LEFT JOIN includes all rows from the left table. FULL OUTER JOIN also includes all rows from both tables, but the question says 'all rows from the employees table' – that is satisfied by LEFT JOIN and also by FULL OUTER JOIN (which includes all from employees).
However, the correct answer set: LEFT JOIN and FULL OUTER JOIN. The question says 'include all rows from the employees table' – RIGHT JOIN does not guarantee that unless employees is on the right side. So the correct two are LEFT JOIN and FULL OUTER JOIN.
A data analyst is performing data cleaning on a dataset and identifies several outliers in the 'age' column. Which TWO methods are appropriate for handling these outliers? (Select two.)
Capping limits outliers to a specified percentile.
Why this answer
Capping limits extreme values to a threshold, and removal deletes outlier records. Transformation (e.g., log) can reduce impact but is more for skewness. Imputation and binning are for missing data or discretization, not directly for outliers.
Match each database concept to its definition.
Drag a concept onto its matching description — or click a concept then click the description.
Unique identifier for each record in a table
Field that links to primary key in another table
Structure to speed up data retrieval
Virtual table based on a query result
Process to reduce data redundancy
Why these pairings
Primary keys uniquely identify records, foreign keys link tables, indexes speed retrieval, and normalization reduces redundancy. Common confusions include swapping primary and foreign key definitions.
A data analyst is building a model to predict customer churn. The dataset has 10,000 records with 500 churned customers. The model predicts churn with 95% accuracy, but only identifies 10% of actual churners. Which metric best highlights this issue?
Recall is low (10%), showing the model fails to detect churners.
Why this answer
Recall (also known as sensitivity or true positive rate) measures the proportion of actual positives correctly identified. With only 10% of actual churners detected, the model has a recall of 0.1, which directly highlights the failure to capture churners despite high overall accuracy.
Exam trap
The trap here is that candidates may choose accuracy because it is a familiar and seemingly high value (95%), failing to recognize that in imbalanced datasets, accuracy can be deceptive and does not reflect poor performance on the minority class.
How to eliminate wrong answers
Option A is wrong because accuracy (95%) is misleading in imbalanced datasets; it can be high even if the model fails to detect churners, as the majority class (non-churners) dominates. Option B is wrong because the F1 score is the harmonic mean of precision and recall; while it would be low here, it does not directly isolate the issue of missing churners—recall is the metric that specifically measures detection of the positive class. Option D is wrong because precision measures the proportion of predicted churners that are actual churners; it does not reflect how many actual churners were missed, which is the core problem.
In an A/B test, the null hypothesis states that there is no difference between the control and treatment groups. After running the test, the p-value is 0.04. Assuming α = 0.05, what is the correct conclusion?
Correct conclusion.
Why this answer
Since p-value (0.04) < α (0.05), we reject the null hypothesis, indicating a statistically significant difference.
A dataset contains a column 'Income' with values in different scales (some in thousands, some in hundreds). What is the best way to standardize this column for use in a machine learning model?
Standard scaling centers and scales data, suitable for inconsistent scales.
Why this answer
Standard scaling (Z-score normalization) is the best approach because it transforms the data to have a mean of 0 and a standard deviation of 1, making values on different scales (thousands vs hundreds) directly comparable. Min-max scaling also rescales to [0,1], but it is sensitive to outliers and does not handle different scales as effectively when the distribution is not uniform. Log transformation is for reducing skewness, not for standardizing scales.
Removing the column discards useful information.
In SQL, you want to retrieve all products whose names start with 'Pro'. Which WHERE clause should you use?
Matches product names starting with 'Pro'.
Why this answer
LIKE with pattern 'Pro%' matches strings starting with 'Pro' followed by any characters. '%Pro%' matches any string containing 'Pro', 'Pro_' matches 'Pro' plus one character, and 'Pro' is exact match.
A data analyst is documenting a report for external stakeholders. Which THREE elements should be included to ensure report quality and transparency?
Indicates how current the data is.
Why this answer
Data freshness, methodology notes, and limitations/assumptions help users assess the reliability and context of the report.
After building a binary classification model, the data analyst obtains the following confusion matrix: True Positives=80, True Negatives=100, False Positives=20, False Negatives=30. What is the F1 score?
Precision=0.8, Recall≈0.727, F1≈0.76.
Why this answer
The F1 score is the harmonic mean of precision and recall. Precision = TP/(TP+FP) = 80/(80+20) = 0.80. Recall = TP/(TP+FN) = 80/(80+30) ≈ 0.7273.
F1 = 2 * (0.80 * 0.7273) / (0.80 + 0.7273) ≈ 0.7619, which rounds to 0.76. Option A is correct.
Exam trap
CompTIA often tests the distinction between precision, recall, and F1, and the trap here is that candidates mistakenly use accuracy or a simple average instead of the harmonic mean, or they confuse recall with F1.
How to eliminate wrong answers
Option B (0.73) is wrong because it approximates recall (0.727) instead of computing the harmonic mean. Option C (0.80) is wrong because it uses precision alone, ignoring recall. Option D (0.69) is wrong because it likely results from a miscalculation, such as averaging precision and recall arithmetically (0.80+0.727)/2 ≈ 0.76, not 0.69, or from an incorrect formula like (TP+TN)/(TP+TN+FP+FN) = 180/230 ≈ 0.78, which is accuracy, not F1.
An analyst is creating a report for both technical and executive audiences. Which two strategies are effective? (Choose TWO.)
This matches each audience's preference for information depth.
Why this answer
It tailors the data presentation to the audience: visual summaries (e.g., dashboards with KPIs) allow executives to quickly grasp high-level trends, while detailed tables (e.g., pivot tables or raw query results) give technical users the granularity they need for deep analysis. This dual approach ensures both groups can derive actionable insights without being overwhelmed or underwhelmed by the data.
Exam trap
The trap here is that candidates often choose Option A (include all raw data) thinking it provides completeness, but the DA0-001 exam emphasizes that raw data should be summarized or filtered for relevance, not dumped wholesale into a report.
A dashboard shows sales by region using a map with color intensity. Users complain that two regions with very different sales appear nearly the same color. What is the most likely cause?
Sequential palettes can have low perceptual difference between adjacent values.
Why this answer
The issue is that the color scale uses a sequential palette with insufficient contrast between adjacent data values. When the color gradient is too narrow or uses similar hues, regions with significantly different sales figures map to nearly identical colors, making the visualization ineffective. This is a common problem in data visualization when the color mapping does not span the full range of the data or uses a perceptually uniform palette poorly.
Exam trap
The trap here is that candidates may attribute the problem to hardware limitations (monitor resolution) or user physiology (color blindness) rather than recognizing it as a fundamental data visualization design flaw in the color scale selection.
How to eliminate wrong answers
Option A is wrong because map projection distortion affects the shape and area of regions, not the color intensity used to represent sales values. Option C is wrong because monitor resolution affects the sharpness of the display, not the perceived color difference between two distinct data values on the same screen. Option D is wrong because while color blindness can cause confusion between certain colors, the complaint is that two regions with very different sales appear nearly the same color, which points to a scale design issue rather than a user vision deficiency.
A university database stores student information in a normalized schema. The 'students' table has a primary key 'student_id'. The 'enrollments' table has a foreign key 'student_id' referencing 'students'. Which two of the following are true about primary and foreign keys? (Select TWO)
Foreign keys enforce that values match the referenced primary key.
Why this answer
A foreign key enforces referential integrity by ensuring that every value in the foreign key column of the 'enrollments' table matches a valid primary key value in the 'students' table. This prevents orphaned records and maintains consistency across related tables in a normalized relational database.
Exam trap
The trap here is that candidates often assume a foreign key can reference any column, forgetting that the referenced column must have a unique constraint (primary key or unique) to ensure a single target row, which is a common point of confusion in DA0-001.
A data analyst is creating a report that includes customer names and addresses. To comply with privacy regulations, which TWO actions should the analyst take?
Aggregation prevents identifying individuals.
Why this answer
Anonymizing PII (e.g., removing or masking names/addresses) and aggregating data prevent individual identification, which is required for GDPR compliance.
A data analyst wants to combine first_name and last_name columns into a single full_name column in a SQL query. Which string function should be used?
CONCAT() concatenates strings.
Why this answer
CONCAT() joins two or more strings together.
Which TWO actions will improve the readability of a bar chart showing quarterly sales across five regions?
Sorted bars make it easy to identify largest and smallest values.
Why this answer
Sorting bars by sales (B) allows immediate comparison of relative performance. Adding data labels on each bar (C) provides exact figures, enhancing readability. Option A is incorrect because overlaying a line chart on a bar chart mixes data types and can obscure the bar values.
Option D (vertical gridlines for every bar) often adds visual clutter without improving readability. Option E (3D bar chart) distorts perspective and makes accurate comparison difficult.
A data analyst is preparing a presentation on customer churn. The audience consists of both technical and non-technical stakeholders. Which visualization approach is most effective?
Easy to interpret for both technical and non-technical audiences.
Why this answer
A simple bar chart showing churn rate by segment is most effective because it directly communicates the key metric (churn rate) across categorical segments (e.g., customer demographics or plan types) in a format that is immediately understandable to both technical and non-technical stakeholders. Bar charts excel at comparing discrete categories without requiring statistical literacy, making them ideal for mixed audiences in a presentation context.
Exam trap
The trap here is that candidates often choose complex visualizations like heatmaps or scatter plots to appear 'data-savvy', forgetting that the primary goal is clear communication to a mixed audience, not technical sophistication.
How to eliminate wrong answers
Option A is wrong because a box plot, while useful for showing distribution and outliers, requires understanding of quartiles and median, which is not intuitive for non-technical stakeholders and does not directly highlight churn rate by segment. Option B is wrong because a heatmap showing correlation of churn factors is a multivariate tool that implies a level of statistical understanding (e.g., interpreting correlation coefficients) that non-technical audiences typically lack, and it does not present churn rate in a straightforward, actionable manner. Option D is wrong because a scatter plot with multiple variables is designed to reveal relationships between continuous variables and can become cluttered or confusing when used for categorical comparisons, making it unsuitable for a mixed audience that needs clear, digestible insights.
Refer to the exhibit. An Avro schema is defined as shown. Which data design concept does this represent?
Avro uses a predefined schema that is applied when data is written, typical of schema-on-write.
Why this answer
Avro requires defining the schema before writing data, imposing structure at write time (schema-on-write). Schema-on-read would apply structure when reading, and schema-less design has no predefined schema.
A retail company has collected data on monthly advertising spend (in thousands of dollars) and corresponding sales (in thousands of dollars) over the past 12 months. The analyst creates a scatter plot to visualize the relationship between advertising spend and sales. The plot shows a cluster of points with a positive trend, but there is one extreme outlier where spend was $100,000 but sales were only $20,000. Upon investigation, the analyst discovers that the outlier is due to a data entry error: the sales figure should have been $200,000. The analyst wants to present the overall trend accurately in a meeting. Which course of action should the analyst take first?
Correct. Removing the erroneous data point ensures the scatter plot reflects the true relationship.
Why this answer
Since the outlier is due to a data entry error, the appropriate first step is to correct the data (change the sales figure to $200,000) or remove the outlier, then recreate the scatter plot. This ensures the visualization accurately reflects the true relationship. Option A is incorrect: a bar chart with binned averages would still be affected by the erroneous data point and would not show the individual relationship clearly.
Option B is incorrect: adding a trend line to the current plot would still be influenced by the erroneous outlier, potentially distorting the trend. Option D is incorrect: a line chart is typically used for time series data, and this is not a time series; moreover, it would still include the outlier.
A data analyst is preparing to build a predictive model. Which TWO steps are essential to ensure model validity? (Choose two.)
Cross-validation provides a more reliable estimate of model performance.
Why this answer
Cross-validation is essential for model validity because it partitions the data into multiple folds, training on k-1 folds and validating on the remaining fold, which provides a robust estimate of model performance and reduces overfitting. This technique ensures that the model generalizes well to unseen data by repeatedly testing different subsets, making it a standard practice in predictive modeling.
Exam trap
The trap here is that candidates may think using the entire dataset for training (Option D) is acceptable because it maximizes data for learning, but they overlook the necessity of a separate testing set to validate model performance and avoid overfitting.
You have a hierarchical table 'Employees' with columns emp_id, emp_name, manager_id (referencing emp_id). You need to generate a full reporting chain from a given employee up to the CEO. Which SQL construct is most appropriate?
Recursively joins the table to itself to traverse the hierarchy.
Why this answer
Recursive CTEs are designed for hierarchical data, allowing iteration through parent-child relationships. Non-recursive CTEs cannot loop. Self-join with multiple levels is possible but requires knowing the depth.
Window functions are not suitable for tree traversal.
A data analyst needs to combine data from two tables: one containing customer information and another containing order details. The analyst wants to include all customers, even those who have not placed any orders. Which type of join should be used?
LEFT JOIN includes all rows from the left table, even if no match exists in the right table.
Why this answer
A LEFT JOIN returns all rows from the left table (customers) and matching rows from the right table (orders). If a customer has no orders, the order columns will contain NULLs. This satisfies the requirement to include all customers, even those without orders.
Exam trap
The trap here is that candidates often confuse LEFT JOIN with FULL OUTER JOIN, thinking they need to preserve all rows from both tables, when the requirement only specifies preserving all customers.
How to eliminate wrong answers
Option A is wrong because a FULL OUTER JOIN returns all rows from both tables, which would include unmatched orders (if any) and is unnecessary when only all customers are needed. Option C is wrong because an INNER JOIN returns only rows with matches in both tables, excluding customers who have not placed orders. Option D is wrong because a RIGHT JOIN returns all rows from the right table (orders) and matching customers, which would omit customers without orders if the customer table is on the left.
A data engineer is comparing data warehouses and data lakes. Which statement accurately describes a data warehouse?
Data warehouses are designed for analytical queries on structured data.
Why this answer
A data warehouse is optimized for complex queries on structured data because it uses a schema-on-write approach, where data is cleaned, transformed, and organized into relational tables (e.g., star or snowflake schemas) before loading. This pre-processing enables efficient execution of aggregations, joins, and reporting queries using SQL, making it ideal for business intelligence and analytics. In contrast, data lakes store raw data in native formats and rely on schema-on-read, which is less performant for structured query patterns.
Exam trap
The trap here is that candidates confuse the storage location (object storage) or data state (raw vs. processed) with the defining characteristic of a data warehouse, which is its schema-on-write design and optimization for structured query performance.
How to eliminate wrong answers
Option A is wrong because data warehouses typically store data in structured, columnar formats (e.g., Parquet, ORC) within relational databases or dedicated storage engines, not in object storage like Amazon S3 or Azure Blob Storage, which is characteristic of data lakes. Option C is wrong because data warehouses store processed, transformed, and cleansed data optimized for analysis, not raw, unprocessed data; raw data is a hallmark of data lakes. Option D is wrong because data warehouses use schema-on-write, where the schema is defined and enforced at data ingestion time, whereas schema-on-read is a property of data lakes where the schema is applied only when the data is queried.
A data analyst is preparing a dataset for analysis and needs to address data quality issues. Which TWO of the following are common data cleaning tasks?
Correct.
Why this answer
Handling missing values and removing duplicates are standard data cleaning tasks.
Refer to the exhibit. An analyst runs a query to count orders in June 2023 and gets 12,345. However, a dashboard shows 12,298 for the same month. What is the most likely cause?
If orders are stored in UTC and the dashboard converts to local time, some orders may fall into a different month.
Why this answer
The most likely cause is that the dashboard applies a time zone conversion to the order timestamps, while the analyst's query counts orders based on UTC or a different time zone. If the dashboard converts timestamps to a local time zone (e.g., US/Eastern), orders placed near midnight UTC may fall into a different calendar day or month, causing a discrepancy of 47 orders. This is a common issue when raw data is stored in UTC but reporting tools apply a time zone offset without adjusting the query logic.
Exam trap
CompTIA often tests the concept that time zone conversion can cause subtle count discrepancies in reporting, and the trap here is that candidates assume the dashboard is always correct or that the query must have an error, rather than recognizing that both can be technically correct but apply different time zone interpretations.
How to eliminate wrong answers
Option B is wrong because a syntax error would typically cause the query to fail entirely or return an error, not produce a valid count of 12,345 that differs from the dashboard. Option C is wrong because excluding canceled orders would reduce the count, but the query returned a higher number (12,345) than the dashboard (12,298), so the query includes more orders, not fewer. Option D is wrong because using a different data source would likely produce a fundamentally different dataset, not a small, consistent offset of 47 orders; the close proximity of the counts suggests the same underlying data with a transformation difference.
Match each ETL process step to its description.
Drag a concept onto its matching description — or click a concept then click the description.
Retrieve data from source systems
Clean, format, and apply business rules
Insert processed data into target system
Analyze source data to understand structure
Correct or remove inaccurate records
Why these pairings
In ETL, Extract involves retrieving data from sources, Transform involves cleaning and converting data, and Load involves writing data to a target system. Common confusions include swapping the definitions of Extract and Transform, or misattributing real-time data capture to Load.
In a Power BI report, a user wants to create a measure that calculates total sales for the current year up to today. Which DAX function should they use?
TOTALYTD calculates year-to-date values correctly.
Why this answer
TOTALYTD is a time intelligence function that calculates year-to-date values.
A marketing team wants to segment customers into distinct groups based on purchasing behavior. The data includes numeric features such as frequency, monetary value, and recency. Which unsupervised learning algorithm should be used?
K-means is an unsupervised clustering algorithm suitable for grouping customers based on numeric attributes.
Why this answer
K-means clustering is the correct choice because it is an unsupervised learning algorithm that partitions data into K distinct clusters based on feature similarity. For segmenting customers by purchasing behavior (frequency, monetary value, recency), K-means groups customers with similar numeric patterns without requiring labeled outcomes, making it ideal for exploratory segmentation.
Exam trap
The trap here is that candidates may confuse unsupervised clustering (K-means) with supervised classification (decision tree) or regression (linear regression), mistakenly thinking any algorithm that 'groups' data must be supervised, or that association rules are for segmentation rather than transaction pattern mining.
How to eliminate wrong answers
Option A is wrong because a decision tree is a supervised learning algorithm used for classification or regression, requiring labeled target variables, not for unsupervised segmentation of unlabeled customer data. Option C is wrong because linear regression is a supervised learning algorithm that models the relationship between independent and dependent variables, predicting a continuous output, not for discovering hidden groups in unlabeled data. Option D is wrong because association rules are used for market basket analysis to find frequent itemsets and co-occurrence patterns (e.g., products bought together), not for clustering customers into distinct groups based on numeric features.
An analyst is performing EDA and wants to measure the strength and direction of linear relationship between two continuous variables. Which statistical measure should they compute?
Correlation measures linear relationship.
Why this answer
Correlation coefficient (Pearson's r) measures linear relationship strength and direction.
During data acquisition, a data engineer uses a tool to extract data from a source system incrementally based on a timestamp column. Which method is being used?
CDC uses timestamps or logs to extract only changed data.
Why this answer
Change data capture (CDC) captures modifications since the last extraction. Full extraction retrieves all data each time, snapshot extracts a point-in-time copy, and manual is not automated.
A data analyst reports being unable to run the query shown in the exhibit. The data governance team reviews the access control policy. Which of the following is the most likely explanation for the denied access?
The log specifically mentions insufficient permissions on the email column.
Why this answer
The log explicitly states 'insufficient permissions on column email', indicating column-level security. Option A is wrong because the log does not mention table-level privilege issues. Option B is wrong because the role status is not indicated in the log.
Option D is wrong because the query syntax is correct.
Which TWO are examples of leading indicators in a business context? (Select two.)
Engagement often predicts future retention and sales.
Why this answer
Leading indicators predict future performance; number of qualified leads and customer engagement score forecast future sales.
A data analyst is using pandas to read a CSV file named 'sales.csv'. Which line of code correctly reads the file into a DataFrame?
Correct syntax.
Why this answer
The pandas function read_csv reads a CSV file into a DataFrame.
A data engineer is designing a system to handle high-velocity clickstream data from a website. The system must allow low-latency writes and support key-value lookups. Which type of database is most appropriate?
Key-value stores excel at high-speed writes and lookups.
Why this answer
A key-value store like Redis is optimized for high-velocity writes and low-latency key-value lookups, making it ideal for clickstream data.
Which of the following data types is characterized by a flexible schema and is commonly represented using JSON or XML?
JSON and XML are typical semi-structured formats.
Why this answer
JSON and XML are examples of semi-structured data, which has a flexible schema unlike structured data (fixed schema) or unstructured data (no schema).
A company is merging two databases from different departments. In Database A, customer IDs are integers. In Database B, customer IDs are alphanumeric strings. To merge, the data analyst must reconcile these differences. Which step should be taken first?
Profiling helps determine the best strategy for reconciliation.
Why this answer
Data profiling is the essential first step before any transformation or mapping. It allows the analyst to examine the actual formats, patterns, and relationships in both ID columns (e.g., whether Database B's alphanumeric IDs contain embedded numeric sequences or consistent prefixes). Without profiling, any conversion or mapping would be based on assumptions that could lead to data loss or incorrect merges.
Exam trap
The trap here is that candidates assume immediate conversion (Option B) is the simplest solution, but the exam tests the principle that data profiling must precede any transformation to avoid irreversible data corruption.
How to eliminate wrong answers
Option A is wrong because dropping the ID column and using a surrogate key discards the existing business meaning and relationships, which may be critical for linking records across departments. Option B is wrong because converting all IDs to integers using CAST will fail on alphanumeric strings that contain non-numeric characters, causing errors or data loss. Option D is wrong because creating a mapping table based solely on the first character is arbitrary and ignores the full ID structure, leading to incorrect or incomplete mappings.
Which THREE data sources are suitable for web scraping? (Select three.)
HTML is the primary source for web scraping.
Why this answer
HTML pages are suitable for web scraping because they contain structured or semi-structured data in markup format that can be parsed using libraries like BeautifulSoup or Scrapy. Web scrapers extract information from the DOM tree by targeting specific tags, classes, or attributes, making HTML a primary source for scraping.
Exam trap
The trap here is that candidates may confuse 'web scraping' with any form of data extraction, but the exam specifically tests the understanding that scraping involves HTTP-based retrieval of web content, not direct file downloads or database queries.
A data scientist is cleaning a dataset and notices missing values in several columns. Which THREE techniques are appropriate for handling missing data? (Select THREE.)
Imputation with mean/median is a common technique for numeric data.
Why this answer
Replacing missing values with the mean (for normally distributed data) or median (for skewed data) is a standard imputation technique that preserves the central tendency of the dataset without introducing bias. This method is appropriate when the missingness is random and the proportion of missing data is low, as it maintains the sample size for analysis.
Exam trap
CompTIA often tests the misconception that ignoring missing values (Option B) is acceptable, but the DA0-001 exam expects candidates to recognize that most analytical tools require explicit handling of nulls, and simply proceeding without action leads to runtime errors or flawed results.
A mid-sized e-commerce company stores customer data in a relational database. The database has a table named 'Customers' with columns: CustomerID (primary key), FirstName, LastName, Email, Phone, Address, City, State, ZipCode, and SignUpDate. The company is migrating to a new CRM system that requires a denormalized structure for performance reasons. The new system expects a single table 'CustomerDetails' with columns: CustomerID, FullName (concatenation of first and last name), ContactInfo (JSON object containing email, phone, and address), SignUpDate, and Region (derived from state). The data analyst must design an ETL process to transform the data. During a test run, the analyst notices that some records have missing Phone or Address values. Which of the following is the best approach to handle missing data in the ContactInfo JSON object?
Null explicitly indicates missing data.
Why this answer
Representing missing fields as null in the JSON object preserves the data structure and allows downstream systems to explicitly handle null values. This approach maintains data integrity without discarding records or introducing ambiguous placeholder strings that could be misinterpreted as actual data.
Exam trap
The trap here is that candidates may confuse 'handling missing data' with 'filling in missing data,' leading them to choose placeholder strings (B or D) instead of preserving the null representation that JSON natively supports.
How to eliminate wrong answers
Option A is wrong because excluding records with missing Phone or Address would result in data loss, violating the migration requirement to preserve all customer data. Option B is wrong because setting missing values to an empty string conflates 'no data' with 'empty data,' which can cause incorrect processing in JSON parsers or CRM logic that expects null for absent values. Option D is wrong because replacing missing values with 'N/A' string introduces a non-standard placeholder that may be treated as valid data, leading to errors in downstream analytics or validation rules.
A data analyst is cleaning a customer dataset. Which two actions are appropriate for handling duplicate records? (Choose TWO)
Exact duplicates can be removed safely.
Why this answer
Removing exact duplicates and standardizing identifiers help resolve duplicates.
A healthcare analytics team is responsible for producing a monthly dashboard for hospital administrators. The dashboard includes key metrics such as patient admission rates, average length of stay, readmission rates, and bed occupancy. For the current month, the data shows a significant increase in average length of stay. The data analyst suspects that this increase is due to a new chronic disease management program that was implemented at the beginning of the month. However, the analyst also notices that the data for the previous month had an error: some discharge dates were incorrectly recorded, causing the average length of stay to be artificially low. The analyst needs to communicate the insights to the administrators, who are concerned about the increase. Which of the following is the best course of action?
This provides accurate data and full context.
Why this answer
The best course of action because it addresses both the data quality issue and the business concern. By correcting the previous month's erroneous discharge dates, the analyst recalculates the true baseline, ensuring the reported increase in average length of stay is accurate. Presenting the corrected data alongside an explanation of the new chronic disease management program provides a complete, transparent narrative that separates the impact of the data error from the program's effect, which is essential for informed decision-making by hospital administrators.
Exam trap
The trap here is that candidates may focus solely on the data correction (Option A) or the program explanation (Option B) without recognizing that both elements must be integrated to provide a complete and honest insight, which is a key principle of communicating data insights in the DA0-001 exam.
How to eliminate wrong answers
Option A is wrong because it only corrects the previous month's data and emphasizes the error, but it fails to mention the new chronic disease management program, which is the suspected cause of the increase; this omission could mislead administrators into thinking the entire increase is due to the data error. Option B is wrong because presenting raw data as-is without correcting the known data error would cause administrators to overestimate the increase, attributing it solely to the new program when part of the apparent rise is due to an artificially low baseline. Option C is wrong because delaying the report ignores the immediate need for insights and does not address the data error; waiting another month could compound the issue and reduce trust in the analytics team's responsiveness.
Refer to the exhibit. The data shown is an example of which data concept?
Structured data conforms to a predefined schema, as shown in the CSV.
Why this answer
The exhibit shows data organized into rows and columns with a fixed schema (e.g., 'Name', 'Age', 'City'), which is the defining characteristic of structured data. Structured data conforms to a predefined data model, typically stored in relational databases or spreadsheets, and can be easily queried using SQL. This tabular format with consistent data types per column is the classic example of structured data.
Exam trap
CompTIA often tests the distinction between structured and semi-structured data, trapping candidates who see any organization (like tags in JSON) and mistakenly label it as structured, when the rigid row-and-column format is the key differentiator.
How to eliminate wrong answers
Option B is wrong because unstructured data lacks a predefined schema or organization, such as raw text, images, or audio files, whereas the exhibit clearly has a tabular structure. Option C is wrong because metadata is 'data about data' (e.g., file size, creation date), not the actual data values shown in the table. Option D is wrong because semi-structured data (e.g., JSON, XML) has some organizational properties (tags, key-value pairs) but does not enforce a rigid row-and-column schema like the exhibit does.
A data pipeline log shows the above error. Which data transformation should be applied during acquisition?
Removing symbols before conversion ensures successful casting.
Why this answer
The error indicates that the pipeline encountered a string with non-numeric characters (e.g., '$1,234.56') when trying to load it into a DECIMAL column. Preprocessing the string to remove non-numeric characters (like currency symbols, commas) before conversion ensures the data is clean and parseable, which is a standard data transformation during acquisition to handle dirty source data.
Exam trap
The trap here is that candidates assume CAST in SQL can handle any string-to-number conversion, but CAST strictly requires a valid numeric string and will throw an error for non-numeric characters, making preprocessing essential.
How to eliminate wrong answers
Option A is wrong because skipping rows that cause errors would result in data loss and is not a proper transformation; it ignores the root cause of the dirty data. Option C is wrong because using CAST(transaction_amount AS DECIMAL(10,2)) in SQL would still fail if the string contains non-numeric characters, as CAST does not automatically strip them. Option D is wrong because changing the target column type to VARCHAR would avoid the conversion error but defeats the purpose of storing numeric data for calculations, leading to data integrity and performance issues.
An e-commerce company uses a star schema for its data warehouse. The fact table 'sales_fact' contains foreign keys to dimension tables: customer_dim, product_dim, time_dim, and store_dim. A business user wants to know the total sales for each product category in the last month. Which join operation is required to retrieve this data?
Inner join returns only matching rows, which is typical in star schema queries.
Why this answer
To retrieve total sales for each product category, you need to join the fact table with the product dimension table to map product keys to categories, and with the time dimension table to filter on the last month. An inner join is correct because it returns only rows where matching keys exist in both tables, which is the standard approach for star-schema queries where all required dimension attributes are present. This ensures that only valid sales transactions with corresponding product and time entries are included in the aggregation.
Exam trap
The trap here is that candidates often confuse the need for a left outer join to 'preserve all fact rows,' but in a well-designed star schema with referential integrity, inner join is sufficient and more performant, and left outer join is only needed when fact rows might lack matching dimension keys (e.g., orphaned records).
How to eliminate wrong answers
Option A is wrong because a self-join on the fact table would match rows within the same table, which is unnecessary here since the required attributes (product category and month) are in dimension tables, not in the fact table itself. Option B is wrong because a cross join between fact and dimension tables would produce a Cartesian product, generating every possible combination of fact rows with dimension rows, leading to massively inflated and incorrect sales totals. Option D is wrong because a left outer join would include fact rows even if there is no matching dimension row (e.g., a product key not in product_dim), which could introduce NULL values for category and potentially skew the aggregation; inner join is the standard for guaranteed referential integrity in a star schema.
A data analyst is preparing features for a machine learning model that uses distance-based algorithms (e.g., K-means, KNN). The dataset contains numerical features with different scales: age (0-100), income (20,000-200,000), and credit score (300-850). Which data transformation technique is most appropriate to ensure all features contribute equally to the distance calculations?
Correct: scales all features to [0,1] so distances are not dominated by large-scale features.
Why this answer
Min-max normalization rescales features to a fixed range (e.g., 0 to 1), making distances computed equally weighted. Standardization is better for algorithms assuming Gaussian distributions.
A sensor records temperature readings in Celsius and a separate sensor records wind speed in meters per second. A data scientist wants to combine these datasets for analysis. Which statement accurately compares these data types?
Celsius has no true zero (interval), while wind speed has a true zero (ratio).
Why this answer
Temperature measured in Celsius has an arbitrary zero point (0°C does not mean 'no heat'), so it is interval data. Wind speed in meters per second has a true zero point (0 m/s means no wind), making it ratio data. Therefore, option D correctly identifies temperature as interval and wind speed as ratio.
Exam trap
The trap here is confusing interval and ratio data by overlooking the significance of a true zero point, leading candidates to incorrectly classify temperature as ratio data.
How to eliminate wrong answers
Option A is wrong because temperature in Celsius is interval data, not ratio data, due to the lack of a true zero point. Option B is wrong because temperature is continuous (can take any value within a range), not discrete; wind speed is also continuous. Option C is wrong because both temperature and wind speed are continuous data types, not discrete.
A healthcare data analyst is presenting findings on patient readmission rates to a group of hospital administrators. The analysis reveals a 15% increase in readmissions over the past quarter for patients aged 65+ from a specific zip code. However, the administrators are skeptical because previous quarterly reports showed no such trend, and they suspect data quality issues. The analyst must communicate this insight effectively while maintaining credibility. Which of the following approaches should the analyst take?
This approach maintains trust and provides context, making the insight more believable.
Why this answer
It demonstrates the core competency of 'Communicating Data Insights' by acknowledging the discrepancy between the current finding and previous reports, which builds trust with skeptical stakeholders. By explaining possible reasons such as changes in data collection methods or patient population, the analyst maintains credibility and invites collaborative investigation into data quality issues, rather than dismissing concerns or hiding details.
Exam trap
The trap here is that candidates may choose Option A, thinking statistical significance alone validates the finding, but the DA0-001 exam emphasizes that effective communication requires acknowledging and addressing stakeholder concerns about data quality, not just presenting numbers.
How to eliminate wrong answers
Option A is wrong because ignoring previous reports undermines credibility and fails to address the administrators' legitimate skepticism about data quality; statistical significance does not automatically validate data integrity. Option B is wrong because presenting data without explanation shifts the burden of interpretation to the audience, which can lead to misinterpretation and erodes trust, especially when stakeholders have already flagged potential issues. Option C is wrong because removing demographic detail to avoid controversy is unethical and violates the principle of transparency in data communication; it also prevents the administrators from understanding the full context of the readmission trend.
A data analyst is preparing a report on regional sales performance. The report will be viewed by regional managers who should only see their own region's data. Which TWO data governance measures are most relevant?
Row-level security limits users to their own region's data.
Why this answer
Row-level security restricts access to specific rows (regions), and a data dictionary ensures consistent metric definitions across regions.
A data analyst is profiling a dataset and finds that the 'email' column contains some NULL values. Which SQL query can be used to count how many rows have a NULL email?
Correct: counts all rows with null email.
Why this answer
COUNT(*) counts all rows; WHERE email IS NULL filters only null rows.
A data analyst runs the query: SELECT AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 60000. What is the purpose of the HAVING clause?
HAVING filters groups based on aggregate conditions.
Why this answer
HAVING filters groups after aggregation, unlike WHERE which filters rows before aggregation.
Which TWO of the following are best practices for designing an accessible data visualization? (Choose 2.)
Provides alternative means to distinguish data.
Why this answer
Using colorblind-friendly palettes and adding text labels/patterns make charts accessible. Relying solely on color or using 3D effects reduces accessibility. Adding animation distracts.
A data analyst is cleaning text data in a SQL database. Which THREE string functions are commonly used to standardize and clean text? (Choose three.)
Replaces occurrences of a substring.
Why this answer
TRIM removes leading/trailing spaces, UPPER/LOWER standardize case, REPLACE substitutes substrings. CONCAT concatenates strings, LENGTH returns length, SUBSTRING extracts part of string.
A financial analyst is integrating data from multiple stock exchanges. One exchange provides trade timestamps in UTC, another in Eastern Time. The analyst needs accurate time synchronization for time-series analysis. What is the best approach?
Converting to a common timezone ensures consistent timestamps for analysis.
Why this answer
(convert to UTC) is the standard. Option A (keep original with offset) adds complexity. Option B (local time) is inconsistent.
Option D (ignore) leads to errors.
A company is designing a data pipeline to process streaming data from social media feeds. Which THREE of the following are characteristics of streaming data? (Select THREE).
Streaming data is unbounded.
Why this answer
Streaming data is inherently unbounded and infinite because social media feeds generate a continuous, never-ending flow of events. Unlike batch data, there is no natural end to the stream; new tweets, posts, or interactions arrive constantly, making the dataset theoretically infinite in size.
Exam trap
The trap here is that candidates confuse processing strategies (like micro-batching) with the inherent nature of streaming data, or they assume streaming data must be stored before processing, which is a batch-oriented mindset.
A data analyst is performing EDA on a dataset with numerical features. Which methods are appropriate for identifying outliers? (Select TWO).
Points with |Z| > 3 are often considered outliers.
Why this answer
IQR method uses Q1 - 1.5*IQR and Q3 + 1.5*IQR to define outliers. Z-score method uses threshold (e.g., |Z| > 3) to identify outliers.
A heat map of store sales by region shows very low correlation between advertising spend and revenue, but a scatter plot of the same data shows a strong positive relationship. What is the most likely cause?
Averaging within bins can reduce variability and hide correlations.
Why this answer
Heat maps often aggregate data into bins (e.g., averages), which can mask the underlying relationship.
A data analyst is testing whether the average sales amount differs between two regions. Which statistical test is most appropriate?
Compares means of two independent groups.
Why this answer
A two-sample t-test compares the means of two independent groups.
A data scientist builds a simple linear regression model to predict house prices based on square footage. The model yields an R-squared value of 0.85. Which statement accurately interprets this result?
Correct interpretation of R-squared.
Why this answer
R-squared of 0.85 means 85% of the variance in house prices is explained by square footage.
Practice DA0-002 by domain
Target a specific domain to shore up weak areas.