986 questions total · 14pages · All types, answers revealed
Which of the following is an example of unstructured data?
Images are unstructured.
Why this answer
Unstructured data has no predefined schema. Images are a classic example of unstructured data.
A data analyst calculates the mean, median, and mode of a dataset. Which of the following best describes how these measures are used in descriptive statistics?
Mean, median, and mode are measures of central tendency.
Why this answer
Descriptive statistics summarize data using measures like mean, median, and mode to describe central tendency.
When creating a data story, what should be the FIRST step?
The key message frames the story and directs the entire process.
Why this answer
The first step in creating a data story is to identify the key message because the entire narrative, data selection, and visualization choices must align with a central insight. Without a clear message, subsequent steps like gathering data or designing layouts risk being unfocused and failing to communicate actionable findings. This ensures the story is driven by the insight, not by the data or tools.
Exam trap
CompTIA often tests the misconception that data gathering or tool selection is the logical starting point, tempting candidates to skip the critical step of defining the core insight first.
How to eliminate wrong answers
Option A is wrong because designing the layout of the report should occur after the key message is defined; layout is a presentation concern, not the foundational step. Option B is wrong because gathering all available data without a guiding message leads to analysis paralysis and irrelevant information; data should be collected with the key message in mind. Option C is wrong because choosing visualization tools depends on the data and the story to be told; selecting tools prematurely can limit the narrative or force inappropriate chart types.
A marketing team wants to compare the growth rates of four product categories over the last quarter. Which chart type would best display this?
Bar charts effectively compare discrete values like growth percentages.
Why this answer
A bar chart is ideal for comparing discrete values across categories, such as the growth rates of four product categories. It allows for easy visual comparison of the heights of the bars. Option A (pie chart) is unsuitable for comparing growth rates as it shows proportions of a whole, not rates.
Option B (stacked bar chart) would show cumulative totals, not individual growth rates. Option C (line chart) is better for trends over time, not for comparing discrete categories.
When communicating uncertainty in a report, which of the following is the most appropriate way to convey the reliability of a survey result showing 75% customer satisfaction?
Provides a confidence interval, clearly expressing uncertainty.
Why this answer
Confidence intervals are standard for communicating uncertainty around a point estimate.
A marketing team wants to analyze customer sentiment from social media posts. Which data acquisition method is most appropriate?
Allows direct access to public posts for sentiment analysis.
Why this answer
Web scraping from public social media APIs allows direct access to public posts for sentiment analysis, which is exactly what the marketing team needs. Option A is wrong because internal databases typically do not contain social media data. Option B is wrong because physical sensors are unrelated to social media sentiment.
Option D is wrong because survey questionnaires are not real-time and do not capture existing social media posts.
An e-commerce company is merging customer data from three legacy systems. Two systems use email as unique identifier, but one system allows multiple customers per email. The third uses phone number. To create a unified customer view, the analyst should first:
Multi-attribute matching handles non-unique identifiers and improves accuracy.
Why this answer
Merging data from systems with different identifier schemas requires a probabilistic matching approach. Using multiple attributes (email, phone, name) with a confidence score allows the analyst to resolve conflicts where email is not unique and phone numbers may be missing or formatted differently, creating a unified customer view without forcing a single key.
Exam trap
The trap here is that candidates assume a single unique identifier (email) can be forced as a primary key, ignoring the real-world data quality issue of non-unique emails, which the question explicitly states.
How to eliminate wrong answers
Option A is wrong because modifying legacy systems is often impractical, costly, and outside the analyst's scope; the question asks what the analyst should do first, not a long-term IT project. Option C is wrong because using email as primary key and ignoring conflicts would lose data integrity when one email maps to multiple customers, violating the goal of a unified view. Option D is wrong because assigning new unique IDs and discarding existing identifiers eliminates the ability to link records back to source systems and loses valuable matching context, making deduplication impossible.
A data governance team is implementing a program to ensure consistent definitions and quality of customer data across the organization. They assign a senior manager to be accountable for the data asset. Which role does this manager fulfill?
Data owner is accountable for a specific data domain.
Why this answer
The data owner is the senior manager accountable for a specific data asset, including its quality, definition, and compliance. In the DA0-001 context, the data owner has ultimate responsibility for the data, not just day-to-day management. This role ensures consistent definitions and quality across the organization, aligning with the governance team's objectives.
Exam trap
The trap here is confusing the data owner's accountability with the data steward's operational duties, leading candidates to pick 'Data steward' because they associate governance with hands-on management rather than executive responsibility.
How to eliminate wrong answers
Option A is wrong because a data analyst focuses on analyzing and interpreting data, not on accountability for data definitions or quality. Option B is wrong because a data custodian is responsible for the technical environment and security of data, not for defining or governing its meaning. Option D is wrong because a data steward handles day-to-day data governance tasks like metadata management and quality monitoring, but does not hold the ultimate accountability that a senior manager does.
A data analyst is preparing a presentation for executive leadership. The analyst wants to highlight the correlation between marketing spend and revenue over the past year. Which visualization type is most appropriate for showing this relationship?
Scatter plots effectively display correlations between two continuous variables.
Why this answer
A scatter plot is the most appropriate visualization for showing the relationship between two continuous variables—marketing spend and revenue—because it plots individual data points on an X-Y axis, allowing the analyst to visually assess correlation, trends, and outliers. This directly supports the goal of highlighting correlation, as the pattern of points (e.g., upward slope) indicates the strength and direction of the relationship.
Exam trap
The trap here is that candidates often confuse a bar chart or histogram with a scatter plot because they think any chart with axes can show relationships, but only a scatter plot directly plots paired continuous data to reveal correlation without aggregation.
How to eliminate wrong answers
Option B (Pie chart) is wrong because pie charts are designed to show parts of a whole (proportions) 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 correlation between two continuous metrics; they would require binning or summarizing the data, losing the granularity needed for correlation analysis. Option D (Histogram) is wrong because histograms display the distribution of a single continuous variable (e.g., frequency of revenue values), not the relationship between two variables.
In SQL, which string function would you use to remove leading and trailing spaces from a column named 'city'?
Correct. TRIM removes both leading and trailing spaces.
Why this answer
TRIM removes leading and trailing spaces (or other specified characters) from a string. TRIM(city) returns the city without extra spaces.
A data analyst is creating a dashboard in Tableau to monitor sales performance. The dashboard will be used by executives to quickly identify trends. Which THREE design principles should the analyst apply?
Makes the dashboard easy to understand at a glance.
Why this answer
Visual hierarchy ensures key metrics stand out; consistent color coding aids interpretation; clear labels prevent confusion. Data-ink ratio is important but not as critical for executive dashboards as clarity; including many interactive filters may clutter.
A sales dashboard shows a map with many overlapping markers in the same city, making it hard to read. What is the best improvement?
Aggregating reduces density and choropleth shows region-level values.
Why this answer
Aggregating sales data by region and using a choropleth map eliminates visual clutter from overlapping markers by shading entire geographic areas based on a metric (e.g., total sales). This approach leverages spatial aggregation to provide a clear, high-level view of regional performance, which is the best practice when individual point markers become unreadable due to density.
Exam trap
The trap here is that candidates may choose tooltips (Option A) thinking interactivity solves the problem, but the question asks for the 'best improvement' to readability, and tooltips do not address the fundamental issue of overlapping markers obscuring the visualization.
How to eliminate wrong answers
Option A is wrong because tooltips only provide details on hover and do not solve the core problem of overlapping markers obscuring data; they add interactivity but do not reduce visual density. Option C is wrong because a bubble chart, while useful for comparing values, is not a map-based visualization and would lose the geographic context that the dashboard intends to convey. Option D is wrong because using different marker colors for each store does not address overlapping markers; it only adds visual differentiation without reducing clutter, and in dense areas, colored markers still overlap and remain unreadable.
Refer to the exhibit. A database administrator notices that queries filtering on both CustomerID and OrderDate are slow. Which single change would most likely improve performance for such queries?
A composite index can satisfy both conditions in one index seek.
Why this answer
A composite index on (CustomerID, OrderDate) allows the database to use a single index to filter on both columns, which is more efficient than using separate indexes and combining results.
A data quality report shows that 95% of records have all required fields completed, but 20% of the completed fields contain values that are outside valid ranges. Which data quality dimension is most affected?
Accuracy is compromised because values outside valid ranges are incorrect.
Why this answer
Accuracy measures how well data reflects real-world values or a defined standard. Here, 20% of completed fields contain values outside valid ranges, meaning the data is present but incorrect, directly degrading accuracy. Completeness (95% filled) is high, but the core issue is that the values themselves are wrong, not missing or late.
Exam trap
The trap here is that candidates see '95% of records have all required fields completed' and immediately think 'Completeness is high, so that dimension is fine,' but then incorrectly assume the 20% out-of-range values also affect Completeness, when in fact Accuracy is the dimension that suffers when present data is invalid.
How to eliminate wrong answers
Option A (Consistency) is wrong because consistency checks for logical coherence across datasets or over time (e.g., same customer ID format in two tables), not whether individual field values fall within valid ranges. Option C (Timeliness) is wrong because timeliness concerns whether data is available when needed or within a required time window, not the correctness of values. Option D (Completeness) is wrong because completeness measures the presence of data (95% of records have all required fields), which is high; the problem is with the quality of the present data, not its absence.
Which chart type is best for showing the number of website visitors at each stage of a conversion funnel, from initial visit to purchase?
Correct. Funnel charts are ideal for conversion funnels.
Why this answer
A funnel chart is specifically designed to visualize the progressive reduction in volume across stages of a linear process, such as a conversion funnel. It clearly shows the number of visitors at each stage (e.g., initial visit, product view, add to cart, purchase) and the drop-off between them, making it the optimal choice for this scenario.
Exam trap
The trap here is that candidates often confuse a funnel chart with a waterfall chart because both show sequential steps, but a waterfall chart is for cumulative changes (additions/subtractions), not for displaying the count at each stage of a funnel.
How to eliminate wrong answers
Option A is wrong because a stacked bar chart is used to compare parts of a whole across categories, not to show the sequential reduction in a funnel; it would obscure the drop-off between stages. Option B is wrong because a treemap displays hierarchical data as nested rectangles based on proportion, which is not suitable for a linear, sequential process like a conversion funnel. Option D is wrong because a waterfall chart is designed to show the cumulative effect of sequential positive and negative values (e.g., financial statements), not the simple count of visitors at each stage of a funnel.
A stock analyst is analyzing monthly sales data for a retail company and observes a consistent pattern of high sales every December. This pattern is most likely an example of which time series component?
Correct: regular pattern within a fixed period.
Why this answer
Seasonality refers to regular, predictable patterns that repeat at fixed intervals (e.g., yearly, monthly). The consistent December peak indicates a seasonal pattern.
A data team is preparing a quarterly business review for the CEO. The report must include both high-level summaries and the ability for the CEO to drill down into specific departments. Which reporting technique best meets this requirement?
Interactive dashboards allow users to start with a summary and click to see underlying details for specific departments.
Why this answer
An interactive dashboard with drill-down capabilities (Option B) is the correct choice because it directly addresses the requirement for both high-level summaries and the ability to explore specific departments. Dashboards allow the CEO to view aggregated KPIs at a glance and then click through to detailed views for each department, providing a seamless, user-driven exploration experience without switching between separate reports or slides.
Exam trap
The trap here is that candidates often choose a static PDF (Option C) or a slide deck (Option A) because they associate 'report' with printed or presentation materials, but the question explicitly requires 'drill-down' capability, which is a hallmark of interactive business intelligence tools, not static documents.
How to eliminate wrong answers
Option A is wrong because a slide deck with one slide per department forces a linear, static presentation; the CEO cannot dynamically drill down from a summary view into a specific department without manually navigating slides, which breaks the requirement for interactive drill-down. Option C is wrong because a static PDF with a summary page and appendices is non-interactive; the CEO would have to jump to appendix pages manually, which is not a true drill-down capability and lacks the real-time filtering or cross-filtering that an interactive dashboard provides. Option D is wrong because a data dump in Excel with filters is a raw data file that requires the CEO to understand the data structure and apply filters manually; it does not offer a curated high-level summary or a guided drill-down path, and it risks overwhelming the user with granular data without pre-built aggregations.
Which THREE are best practices for data profiling during acquisition? (Choose three.)
Ensuring all required fields are populated is essential.
Why this answer
Checking for completeness (Option B) is a best practice during data acquisition because it ensures that all required fields and records are present before further processing. Incomplete data can lead to incorrect analysis or failed transformations, so profiling for missing values or nulls is a fundamental validation step.
Exam trap
The trap here is that candidates confuse 'best practices for acquisition' with 'best practices for transformation,' leading them to select normalization (Option A) as an immediate step rather than a later processing stage.
In simple linear regression, the coefficient of determination R² measures:
Correct interpretation of R².
Why this answer
R² indicates the proportion of variance in the dependent variable explained by the independent variable.
A data analyst is using a recursive CTE to traverse an organizational hierarchy. What is the purpose of the anchor member in the recursive CTE?
The anchor member returns the base result set.
Why this answer
The anchor member initializes the recursion with the base result set.
A data analyst is evaluating data quality issues in a customer database. Which TWO actions are best practices for ensuring data consistency?
Correct: Uniform formats ensure consistency in temporal data.
Why this answer
Standardizing date formats across all tables (Option B) ensures that date values are stored and interpreted uniformly, eliminating inconsistencies that arise from mixed formats (e.g., MM/DD/YYYY vs. DD-MM-YY). This practice directly supports data consistency by enforcing a single representation, which is critical for accurate querying, reporting, and integration across systems.
Exam trap
CompTIA often tests the distinction between data quality dimensions (e.g., consistency vs. accuracy), leading candidates to confuse data profiling (which identifies duplicates) with a direct method for enforcing consistency.
In a regression analysis, the coefficient of determination (R²) is 0.85. How should this value be interpreted?
Correct interpretation of R².
Why this answer
R² represents the proportion of variance in the dependent variable that is explained by the independent variable(s). An R² of 0.85 means the model explains 85% of the variability.
A data analyst creates a report and wants to ensure it tells a compelling story. Which element is most important for data storytelling?
Engages audience and makes findings memorable.
Why this answer
Data storytelling relies on a narrative arc—introducing context, building tension through data insights, and resolving with actionable conclusions—to engage the audience and make the data memorable. Without a narrative, even the most accurate data fails to drive understanding or decision-making. This aligns with the DA0-001 objective of communicating data insights effectively.
Exam trap
The trap here is that candidates often confuse 'data storytelling' with 'data presentation' and assume that including all data (Option C) is thorough, when in fact the exam emphasizes that a compelling story requires filtering and context to avoid overwhelming the audience.
How to eliminate wrong answers
Option A is wrong because using only one chart type ignores the fact that different data relationships (e.g., trends vs. distributions) require different visual encodings; forcing consistency sacrifices clarity. Option B is wrong because avoiding visual elements contradicts the principle that humans process visual information faster than text; data storytelling relies on charts, graphs, and annotations to highlight key patterns. Option C is wrong because including all data without filtering leads to cognitive overload and obscures the main message; effective storytelling requires selective inclusion based on the narrative's focus.
A data analyst is preparing a report on customer satisfaction scores. To comply with GDPR, which THREE actions must be taken? (Select THREE.)
Correct. Aggregates must be safe from re-identification.
Why this answer
GDPR requires anonymization of PII, ensuring aggregate data does not allow re-identification, and respecting data retention policies.
Match each data analysis technique to its primary purpose.
Drag a concept onto its matching description — or click a concept then click the description.
Model relationships between variables
Group similar data points without labels
Analyze data points collected over time
Compare means across multiple groups
Test association between categorical variables
Why these pairings
The correct matches are: Regression with predicting continuous outcomes, Clustering with grouping similar data, Classification with assigning categories, and PCA with reducing dimensionality. Common confusions include swapping regression and clustering definitions.
A data analyst is creating a presentation for executives to explain why customer churn has increased over the last quarter. The analyst wants to present the story in a compelling way. Which narrative structure is most appropriate?
This structure effectively sets the context, presents the problem, and offers a solution.
Why this answer
The Situation-Complication-Resolution structure is ideal for executive presentations because it first establishes the context (situation), then introduces the problem (complication—increased churn), and finally proposes a solution (resolution). This narrative arc aligns with how executives process strategic issues, making the data story compelling and actionable. In contrast, other structures are better suited for technical reports or hypothesis testing, not high-level storytelling.
Exam trap
The CompTIA Data+ exam often tests the distinction between narrative structures for different audiences; the trap here is that candidates mistake 'Background, Analysis, Recommendation' (a common technical report format) as appropriate for executives, when in fact it lacks the persuasive arc needed for strategic decision-making.
How to eliminate wrong answers
Option A is wrong because 'Problem, Hypothesis, Test' is a scientific method structure used for experimental validation, not for presenting a business narrative to executives. Option B is wrong because 'Background, Analysis, Recommendation' is a linear report format that lacks the dramatic tension needed to engage an executive audience on a problem like churn. Option D is wrong because 'Data, Visualization, Conclusion' is a data-centric sequence that prioritizes outputs over storytelling, failing to frame the business impact and resolution in a compelling way.
A data analyst needs to compare the salary distribution across five departments. Which visualization is most appropriate?
Box plots display distribution statistics for each group.
Why this answer
A side-by-side box plot (option B) is the most appropriate visualization for comparing salary distributions across multiple departments because it displays the median, quartiles, and potential outliers for each group simultaneously. This allows the analyst to assess central tendency, spread, and skewness across all five departments in a single, compact chart.
Exam trap
The trap here is that candidates often confuse 'comparing distributions' with 'showing trends' or 'showing relationships,' leading them to incorrectly select a line chart or scatter plot instead of recognizing that a box plot is purpose-built for distribution comparison across groups.
How to eliminate wrong answers
Option A is wrong because a line chart is designed to show trends over a continuous interval (e.g., time series) and is not suitable for comparing distributions of categorical groups like departments. Option C is wrong because a scatter plot visualizes the relationship between two continuous variables, not the distribution of a single variable across categories. Option D is wrong because a stacked bar chart is used to show the composition of parts to a whole across categories, not the distribution (e.g., quartiles, outliers) of a continuous variable like salary.
A data analyst wants to compare the sales revenue of five different product categories for the current month. Which chart type is most suitable for this comparison?
Bar charts compare categories easily.
Why this answer
A bar chart is ideal for comparing discrete categories across a single metric like sales revenue.
An analyst wants to use Python (pandas) to compute the average sales amount per region from a DataFrame 'df' with columns 'region' and 'sales'. Which TWO pandas operations are needed? (Select TWO).
Pivot table with mean aggregation.
Why this answer
To compute average per group, you can use groupby() followed by mean(), or pivot_table() with aggfunc='mean'. merge() combines DataFrames, apply() can be used but is less direct, and fillna() handles missing values.
In a table with columns 'employee_id' and 'manager_id', a data analyst needs to retrieve the hierarchy level of each employee, where the top manager has manager_id NULL. Which SQL feature is best suited?
Recursive CTE can iterate through levels to assign hierarchy depth.
Why this answer
Recursive CTE can traverse hierarchical data to compute levels.
A data analyst is reviewing sales data and wants to find orders where the order total is between $100 and $500, inclusive. Which WHERE clause is correct?
BETWEEN includes both boundary values.
Why this answer
BETWEEN is inclusive of both endpoints.
A sales VP wants a quick summary of last month's revenue change and key drivers. Which report section is most relevant?
Correct. Executive summary gives headline and context.
Why this answer
Executive summaries provide high-level numbers and context for quick decision-making.
A data analyst is building a binary classification model to predict customer churn. The dataset is imbalanced, with only 10% churners. The analyst wants to evaluate model performance with a focus on correctly identifying churners. Which metric is most appropriate?
Recall measures how many actual churners were correctly found, directly addressing the focus.
Why this answer
Recall (sensitivity) is the most appropriate metric because it measures the proportion of actual churners correctly identified by the model. Since the dataset is imbalanced (only 10% churners) and the analyst's focus is on correctly identifying churners, recall directly addresses the cost of missing positive cases (false negatives). Accuracy would be misleading due to class imbalance, while precision and F1-score prioritize different trade-offs.
Exam trap
The trap here is that candidates often default to accuracy as the default metric, failing to recognize that class imbalance renders accuracy misleading, and that the question's explicit focus on 'correctly identifying churners' points directly to recall, not precision or F1-score.
How to eliminate wrong answers
Option B (F1-score) is wrong because it balances precision and recall, but the analyst's primary goal is to maximize identification of churners, not to balance false positives and false negatives; F1-score would penalize a model that achieves high recall at the expense of precision, which may be acceptable in this scenario. Option C (Precision) is wrong because it measures the proportion of predicted churners that are actual churners, focusing on false positives rather than false negatives; the analyst wants to minimize missed churners, not necessarily avoid false alarms. Option D (Accuracy) is wrong because with only 10% churners, a naive model predicting all non-churners would achieve 90% accuracy, masking poor performance on the minority class; accuracy is inappropriate for imbalanced classification problems.
A data analytics team has created a report for stakeholders. The report includes complex statistical terms and raw data tables. Stakeholders are confused and ask for clarification. Which of the following should the team do to improve communication?
Correct. This directly addresses the confusion by making the report accessible.
Why this answer
Effective data communication requires tailoring the message to the audience. By replacing complex statistical terms and raw data tables with clear visualizations and plain language summaries, the team makes insights accessible to stakeholders who may lack technical expertise, directly addressing the confusion.
Exam trap
The trap here is that candidates may think providing more explanation (Option A) or more data (Option B) is always better, but the DA0-001 exam emphasizes that communication must be tailored to the audience's level of understanding, not just the completeness of the information.
How to eliminate wrong answers
Option A is wrong because scheduling a follow-up meeting to explain each term individually is inefficient and does not improve the report itself; stakeholders should be able to understand the report without needing a separate tutorial. Option B is wrong because providing a glossary while keeping the report as is forces stakeholders to constantly cross-reference terms, which does not simplify the communication and still leaves raw data tables that are hard to interpret. Option C is wrong because removing all data and only giving conclusions removes the evidence and context needed for stakeholders to trust and verify the insights, which undermines transparency and data-driven decision-making.
A retail company wants to predict future sales based on historical data. Which modeling approach is most appropriate if the data shows a clear seasonal pattern?
Time series analysis explicitly models seasonal patterns.
Why this answer
Time series analysis is specifically designed to model data points indexed in time order, making it ideal for capturing and forecasting seasonal patterns. Unlike regression models, it accounts for autocorrelation, trends, and seasonality components, which are critical for accurate sales prediction from historical data.
Exam trap
The trap here is that candidates see 'predict future sales' and mistakenly choose linear regression, overlooking that time series methods are required when data has temporal dependencies and seasonality.
How to eliminate wrong answers
Option A is wrong because linear regression assumes independence of observations and cannot model time-dependent structures like seasonality or autocorrelation. Option C is wrong because K-means clustering is an unsupervised learning method used for grouping similar data points, not for forecasting future values. Option D is wrong because logistic regression is used for binary classification problems, not for predicting continuous numeric sales figures.
A data governance team is establishing policies to ensure data quality. They define rules for data accuracy, completeness, and consistency. Which data governance function is primarily responsible for defining and enforcing these rules?
Data quality management is responsible for defining and enforcing quality rules.
Why this answer
Data quality management is the function that sets standards and processes to ensure data is accurate, complete, and consistent. Data stewardship often involves implementing these rules, but the overall responsibility lies with data quality management.
A retail company wants to segment its customers based on purchase history. Which THREE methods are appropriate for customer segmentation?
Segments based on recency, frequency, monetary value.
Why this answer
K-means clustering, hierarchical clustering, and RFM analysis are common segmentation techniques. Linear regression and t-test are not segmentation methods.
An analyst needs to create a report in Power BI that shows year-to-date sales compared to the same period last year, with the ability to drill down from year to quarter. Which DAX function combination is most appropriate for the year-to-date calculation?
These time intelligence functions compute YTD and compare to the same period last year.
Why this answer
TOTALYTD calculates year-to-date values, and SAMEPERIODLASTYEAR shifts the comparison to the prior year. Together they allow YTD vs prior YTD comparison.
The exhibit shows an SQL query executed on an 'orders' table that contains 'order_id', 'customer_id', and 'order_date'. What is the purpose of this query?
The query filters by 2023 date and having count > 5.
Why this answer
The query groups orders by customer_id and filters using a HAVING clause with COUNT(*) > 5, which counts the number of orders per customer. The WHERE clause restricts orders to those placed in 2023, so the result identifies customers who placed more than 5 orders in that year. This matches option D exactly.
Exam trap
CompTIA often tests the distinction between WHERE and HAVING, and the trap here is confusing a count of orders per customer with a count of products or an average, leading candidates to pick option B or C.
How to eliminate wrong answers
Option A is wrong because the WHERE clause filters for order_date in 2023, so the count is not regardless of date. Option B is wrong because the query counts orders per customer, not the average order count per customer. Option C is wrong because the query operates on an 'orders' table with no product-related column; it counts orders per customer, not products.
An analyst is reviewing the above SQL query used to acquire data. What does this query retrieve?
The HAVING clause filters for counts greater than 5.
Why this answer
The SQL query uses a HAVING clause with COUNT(*) > 5 to filter customers who placed more than 5 orders in 2023. The WHERE clause restricts records to the year 2023, and the GROUP BY customer_id aggregates orders per customer. The condition '> 5' explicitly excludes customers with exactly 5 or fewer orders, making option A correct.
Exam trap
The trap here is confusing the comparison operator '>' with '>=', leading candidates to mistakenly include customers with exactly 5 orders when the query explicitly excludes them.
How to eliminate wrong answers
Option B is wrong because 'at least 5 orders' would require the condition COUNT(*) >= 5, not > 5. Option C is wrong because the query returns customer IDs, not the total number of orders per customer; the COUNT is used only for filtering, not as a selected column. Option D is wrong because 'exactly 5 orders' would require COUNT(*) = 5, not > 5.
A data analyst is building a dashboard for executives and wants to ensure the most important metric, total revenue, is immediately visible. Which design principle should the analyst apply?
Correct. Visual hierarchy guides the viewer's eye to the most important metric first.
Why this answer
Visual hierarchy means arranging elements so that the most important information is most prominent, often by placing it in the top-left or center and making it larger.
An analyst is preparing data for an A/B test and wants to ensure valid results. Which TWO of the following should be considered when calculating the required sample size?
Correct: effect size is a key input.
Why this answer
Sample size calculation depends on desired effect size and statistical power, among other factors like significance level.
A data analyst is extracting data from a web page using web scraping techniques. The data will be used for market research. Which TWO of the following are common challenges associated with web scraping?
Many websites prohibit scraping in their terms of service, and legal issues may arise.
Why this answer
Web scraping often involves accessing data that may be protected by copyright, terms of service, or privacy regulations such as GDPR or the Computer Fraud and Abuse Act (CFAA). Even if data is publicly accessible, repurposing it for market research without permission can lead to legal liability or ethical violations, making this a fundamental challenge.
Exam trap
CompTIA Data+ often tests the distinction between API-related challenges (rate limits, authentication) and web-scraping-specific challenges (structure changes, legal/ethical issues), so candidates mistakenly select 'Limited API rate limits' because they confuse web scraping with API consumption.
A dataset contains sales transactions with columns 'order_date', 'amount', and 'region'. The analyst wants to calculate the total sales per region for orders placed in 2023, but only include regions where total sales exceed $10,000. Which SQL clause should be used to filter the aggregated results?
HAVING filters aggregated results after GROUP BY.
Why this answer
The HAVING clause filters groups after aggregation, whereas WHERE filters rows before grouping.
A data analyst wants to compare the means of three different training methods on employee productivity. Which statistical test is most appropriate?
ANOVA compares means across multiple groups.
Why this answer
ANOVA (Analysis of Variance) is used to compare means of three or more groups.
A data analyst wants to retrieve the top 5 highest-paid employees from a table named 'employees' that has columns 'employee_id', 'salary', and 'name'. Which SQL query should they use?
Correct syntax.
Why this answer
ORDER BY salary DESC sorts from highest to lowest, and LIMIT 5 restricts to the first 5 rows.
A data team needs to communicate insights about customer churn to the sales team. The insights include confidence intervals and p-values. The sales team is not familiar with statistics. Which of the following should the data team do?
Correct. This makes the insights accessible and actionable for the sales team.
Why this answer
The sales team lacks statistical background, so presenting confidence intervals and p-values directly would cause confusion. The data team should translate these results into practical business implications—such as 'customers with a 30-day inactivity are 40% more likely to churn'—without using terms like p-value or confidence interval. This aligns with the DA0-001 objective of tailoring communication to the audience's expertise level.
Exam trap
The trap here is that candidates often choose Option C (providing definitions) thinking it balances accuracy and clarity, but the DA0-001 exam emphasizes audience adaptation—definitions still require the audience to learn technical terms, which is less effective than plain-language explanations.
How to eliminate wrong answers
Option B is wrong because assuming the sales team will learn statistical terms over time is unrealistic and risks misinterpretation of critical insights, leading to poor business decisions. Option C is wrong because providing written definitions of technical terms still forces the sales team to process unfamiliar jargon, which can slow understanding and reduce engagement. Option D is wrong because a detailed statistical appendix is excessive for a non-technical audience and may overwhelm them, defeating the purpose of clear communication.
Refer to the exhibit. Which conclusion can be drawn from this data quality report?
Uniqueness is 97%, but validity is only 85%, meaning some emails may be in invalid format.
Why this answer
The data quality report shows that the Email_Address column has a high uniqueness rate (e.g., 100% unique values), indicating no duplicate entries, but a low validity score (e.g., many entries fail format checks like missing '@' or domain). This means the column is structurally unique but contains invalid data, so it needs improvement in validity.
Exam trap
CompTIA often tests the distinction between uniqueness and validity, trapping candidates who assume high uniqueness implies high quality, when in fact validity is a separate dimension that can be poor even with perfect uniqueness.
How to eliminate wrong answers
Option B is wrong because the report indicates low validity, not full consistency; consistency refers to adherence to a standard format, which is violated here. Option C is wrong because the report shows high uniqueness (not low uniqueness), so the claim of 'low uniqueness' is factually incorrect. Option D is wrong because completeness (non-null values) appears high or acceptable; the issue is with validity, not missing data.
A marketing team wants to explore the relationship between advertising spend (in dollars) and resulting revenue. Which chart type is most suitable?
Scatter plot displays relationship between two numerical variables.
Why this answer
Scatter plots reveal correlation and distribution of two continuous variables.
A data analyst at a retail company is building a dashboard for store managers to track sales performance. The data comes from three sources: point-of-sale (POS) systems, inventory, and customer loyalty. The POS table contains columns transaction_id, store_id, date, product_id, quantity, and price. The inventory table has product_id, store_id, stock_level, and reorder_point. The loyalty table has customer_id, transaction_id, and points_earned. The analyst creates a star schema with a sales_fact fact table containing all rows from POS, dimension tables for store, product, date, and customer. To calculate average transaction value, the analyst uses the formula SUM(quantity * price) / COUNT(*). Store managers report that the average transaction value appears too low, especially for stores with multiple registers. The analyst realizes that because each product sold in a transaction creates a separate row in sales_fact, a single transaction with multiple items contributes multiple rows. The current calculation divides by the number of rows rather than the number of distinct transactions. Which of the following is the best course of action to correct the average transaction value metric? (Choose one.)
This correctly computes average transaction value by first summing per transaction.
Why this answer
It first sums sales per transaction (quantity * price) across all rows of the same transaction, then averages those sums across distinct transaction IDs. This directly solves the problem of dividing by the number of rows (which overcounts) because each transaction now contributes exactly one value to the average. Option A (using MEDIAN) is incorrect because median does not produce the average and does not fix the row-counting issue.
Option B is too vague—simply 'aggregating' without specifying the measure and grouping could still produce incorrect results, and it does not clearly describe the correct method of summing per transaction. Option C is unnecessary; the star schema is appropriate, and the error is in the calculation, not the data model.
Refer to the exhibit. Which type of data is the field "region"?
Correct. Region is a descriptive category.
Why this answer
The field 'region' contains categorical labels (e.g., 'North', 'South', 'East', 'West') that represent distinct groups or categories, not numerical measurements. Qualitative data (also called categorical data) describes attributes or characteristics that can be named but not meaningfully ordered or measured on a numeric scale. Since 'region' assigns a name to a geographic area without any inherent numeric value or order, it is a classic example of qualitative data.
Exam trap
The trap here is that candidates may confuse 'region' with a numeric code (e.g., region ID 1, 2, 3) and incorrectly classify it as discrete quantitative data, but the field 'region' as shown contains text labels, making it qualitative.
How to eliminate wrong answers
Option B is wrong because continuous data represents measurements that can take any value within a range (e.g., temperature, time), but 'region' consists of discrete labels with no numeric continuum. Option C is wrong because quantitative data involves numerical values that can be counted or measured (e.g., sales amount, age), whereas 'region' is a non-numeric category. Option D is wrong because discrete data is a subset of quantitative data that takes countable integer values (e.g., number of customers), but 'region' is not numeric at all.
A data analyst wants to show the relationship between advertising spend and sales revenue for 50 stores. Which chart type is most appropriate?
Scatter plots show the relationship between two continuous variables.
Why this answer
A scatter plot is the most appropriate chart for showing the relationship between two continuous variables—advertising spend and sales revenue—across 50 stores. Each point on the plot represents one store, allowing the analyst to visually assess correlation, trends, or outliers. This aligns with the DA0-001 objective of selecting visualizations that best represent bivariate relationships.
Exam trap
The trap here is that candidates often confuse a line chart (which connects points in sequence) with a scatter plot (which treats points as independent observations), leading them to incorrectly choose a line chart when no temporal or ordered dimension exists.
How to eliminate wrong answers
Option A is wrong because a line chart is typically used to display trends over time or ordered categories, not to show the relationship between two independent continuous variables like advertising spend and sales revenue. Option C is wrong because a bar chart compares discrete categories or groups, not the correlation between two continuous metrics across 50 individual stores. Option D is wrong because a pie chart shows proportions of a whole for categorical data, which is irrelevant for analyzing the relationship between two numerical variables.
A data analyst is reviewing a dataset of customer transactions and wants to assess data quality by profiling the 'order_date' column. Which TWO profiling tasks are most appropriate for this date column? (Select TWO).
Null count is a standard profiling check for any column.
Why this answer
Profiling a date column typically includes checking for null values and verifying the data type. Cardinality and pattern analysis are more relevant for categorical or string columns; variance is for numeric data.
An analyst is choosing a chart to show the correlation between two continuous variables. Which TWO chart types could be used? (Select two.)
Bubble charts are scatter plots with a third variable; they also show correlation.
Why this answer
A bubble chart is an extension of a scatter plot that can show the correlation between two continuous variables on the x- and y-axes, while a third variable is represented by the size of the bubbles. For the specific purpose of showing correlation between exactly two continuous variables, the bubble chart is valid because the bubble size is optional and does not interfere with the primary x-y relationship. This makes it a correct choice for visualizing the relationship between two continuous variables.
Exam trap
A common misconception in data visualization is that a histogram can show relationships between two variables, but it only displays the frequency distribution of a single continuous variable. For the Data+ exam, remember that scatter plots and bubble charts are appropriate for showing correlation between two continuous variables.
Which TWO of the following are examples of semi-structured data?
XML uses tags and has flexible schema, semi-structured.
Why this answer
XML and JSON have tags/keys but no rigid schema, making them semi-structured. CSV is structured, relational tables are structured, plain text is unstructured.
A data analyst creates a scatter plot showing the relationship between advertising spend and revenue. The plot shows a strong positive correlation. Which of the following should the analyst include in the report to ensure accurate communication?
This prevents misinterpretation of the relationship.
Why this answer
Correlation does not imply causation. It is important for the analyst to include this caveat to prevent misinterpretation of the relationship. Option B is incorrect because a bar chart is not appropriate for showing the relationship between two continuous variables.
Option C is incorrect because removing outliers without justification can distort the analysis; outliers should be handled transparently. Option D is incorrect because while a trend line could be added, it is not mandatory and the question specifically asks for ensuring accurate communication, which is primarily about the correlation-causation warning.
A data analyst uses a CTE to simplify a complex query. Which keyword is used to define a CTE?
CTEs are defined using the WITH keyword.
Why this answer
The WITH clause introduces a CTE.
An analyst is planning an A/B test to compare two website designs. Which TWO factors should be considered when calculating the required sample size?
Correct.
Why this answer
Statistical power and desired effect size are key inputs for sample size calculations.
Which stage of the data lifecycle involves converting raw data into a usable format, such as cleaning or validating?
Processing includes cleaning and transforming raw data.
Why this answer
Processing is the stage where raw data is transformed into a usable format through cleaning, validation, normalization, or aggregation. This step ensures data quality and consistency before analysis or storage, directly matching the question's description.
Exam trap
The trap here is confusing ingestion (data arrival) with processing (data transformation), as both occur early in the lifecycle but serve distinct purposes.
How to eliminate wrong answers
Option A is wrong because archival refers to moving data to long-term storage for compliance or historical purposes, not cleaning or validating. Option C is wrong because ingestion is the initial capture or import of raw data from sources, not its transformation. Option D is wrong because storage is the persistent retention of data in databases or filesystems, not the conversion into a usable format.
Ingestion is the initial step of bringing data from a source.
Why this answer
Ingestion is the process of bringing data into a system for further processing.
A hospital wants to analyze patient readmission rates. The data contains daily patient visits. What is the level of granularity?
Correct. Each record captures one visit.
Why this answer
The level of granularity refers to the finest detail captured in the dataset. Since the data contains daily patient visits, each record represents a single visit event, not the patient or the day itself. Therefore, 'Visit' is the correct granularity because each row corresponds to one visit occurrence.
Exam trap
The trap here is confusing the subject of analysis (patient readmission rates) with the actual data granularity (each row is a visit), leading candidates to incorrectly select 'Patient' instead of 'Visit'.
How to eliminate wrong answers
Option A is wrong because 'Patient' would be the granularity if the data summarized all visits per patient (e.g., one row per patient with aggregated readmission counts), but here each visit is a separate record. Option C is wrong because 'Day' would be the granularity if the data aggregated all visits per day (e.g., total visits per day), but the data contains individual visit records, not daily summaries. Option D is wrong because 'Hospital' would be the granularity if the data aggregated across the entire hospital (e.g., total readmission rate for the hospital), but the data is at the individual visit level.
A data analyst is cleaning a dataset with missing values in a time series of daily temperatures. The missing values occur sporadically. Which imputation method is most appropriate to maintain the temporal trend?
Correct: uses neighboring values to estimate missing points, preserving trend.
Why this answer
Interpolation estimates missing values by using surrounding data points and is suitable for time series with a trend. Forward-fill carries the last observation forward, which may not capture trend well. Mean imputation ignores order.
A retail company analyzes customer purchase data to improve inventory management. They store daily transaction records in a relational database and monthly aggregate reports in a data warehouse. Which difference between these storage methods best explains why the warehouse is more suitable for trend analysis?
Correct: OLTP supports many writes; OLAP supports complex reads.
Why this answer
OLTP databases are optimized for high-frequency write operations (INSERT/UPDATE/DELETE) and ACID compliance, making them ideal for transaction processing but poor for complex analytical queries. In contrast, a data warehouse is optimized for read-heavy OLAP workloads, using columnar storage, pre-aggregated tables, and indexing strategies that enable fast aggregation and trend analysis over large historical datasets. This architectural difference directly supports the retail company's need to analyze purchase trends over time.
Exam trap
CompTIA often tests the misconception that 'data warehouses only store historical data' (Option D) as the primary reason for trend analysis suitability, but the real differentiator is the workload optimization (OLTP vs. OLAP), not merely the presence of history.
How to eliminate wrong answers
Option A is wrong because a star schema (with fact and dimension tables) is actually typical of data warehouses for analytical queries, while OLTP databases usually use normalized schemas to reduce redundancy and maintain data integrity. Option B is wrong because data warehouses often support ACID or snapshot isolation for consistency, and eventual consistency is more characteristic of NoSQL systems, not traditional data warehouses. Option D is wrong because relational databases can store historical data as well; the key difference is not the presence of history but the optimization for read-heavy analytical queries versus write-heavy transactional processing.
A marketing team conducted a customer satisfaction survey for five different departments (Sales, Support, Billing, Shipping, Returns). The survey asked customers to rate their satisfaction on a scale of 1 (Very Dissatisfied) to 5 (Very Satisfied). The data is ordinal and the team wants to visualize the distribution of responses for each department to quickly see which department has the most 'Very Satisfied' customers and which has the most 'Very Dissatisfied'. They also want to compare the spread of responses across departments. Which chart type should they use?
Stacked bars show the full distribution of ordinal responses, highlighting proportions of top and bottom ratings.
Why this answer
The stacked bar chart, is correct because it displays the distribution of ordinal satisfaction ratings for each department, allowing easy comparison of counts for each rating category. With departments on the x-axis and stacked segments for ratings 1-5, the team can quickly identify which department has the most 'Very Satisfied' (rating 5) and 'Very Dissatisfied' (rating 1). The stacked bars also reveal the spread of responses across departments.
Option C (box plot) is less suitable because it assumes continuous interval data and does not show exact counts of each ordinal category. Option B (line chart) is for trends over a continuous axis, not categorical comparisons of distributions. Option D (scatter plot) is for relationships between two continuous variables, not for comparing response distributions.
An analyst writes a SQL query that uses a window function: SELECT employee_id, salary, LAG(salary, 1) OVER (ORDER BY salary DESC) AS prev_salary FROM employees. What does the LAG function return for the row with the highest salary?
LAG returns NULL if there is no preceding row.
Why this answer
LAG returns the previous row's value in the ordered partition. For the first row (highest salary), there is no previous row, so it returns NULL.
An analyst is sampling a large customer database to estimate the average purchase amount. To ensure that the sample proportionally represents different customer segments (e.g., age groups), which sampling method should be used?
Stratified sampling ensures proportional representation from each stratum.
Why this answer
Stratified sampling divides the population into strata (e.g., age groups) and samples proportionally from each stratum.
A data engineer is designing a system to store raw sensor data from thousands of IoT devices. The data will be used later for various analytics projects, but the schema is not yet defined. Which storage solution is most appropriate?
Data lakes store raw data in any format and allow schema-on-read.
Why this answer
A data lake stores raw data in its native format (e.g., S3, ADLS) without requiring a predefined schema, making it suitable for IoT data.
A company is acquiring social media data via a public API. Which TWO considerations are important for ensuring ethical and legal compliance?
Anonymization protects individual privacy and complies with regulations.
Why this answer
Anonymizing PII before storage is a fundamental data privacy requirement under regulations like GDPR and CCPA. When acquiring data via a public API, the company must ensure that personal identifiers (e.g., names, email addresses, IP addresses) are removed or obfuscated to prevent re-identification, reducing legal liability and ethical risk.
Exam trap
The trap here is that candidates may confuse 'caching for efficiency' (Option D) with ethical compliance, overlooking that indefinite storage violates data minimization principles and platform terms, while 'internal analysis' (Option B) seems harmless but ignores explicit usage restrictions in the API's terms of service.
An OLTP system processes thousands of transactions per second. Which property ensures that a transaction is fully completed or fully rolled back, preventing partial updates?
Atomicity ensures all operations in a transaction complete or none do.
Why this answer
Atomicity guarantees that a transaction is treated as a single unit, completed entirely or not at all.
A data analyst is reviewing a dataset containing house prices. The mean price is $350,000 and the median is $280,000. Which of the following best describes the distribution of house prices?
Correct: Mean > median indicates right skew.
Why this answer
When the mean is greater than the median, the distribution is right-skewed (positively skewed) because higher values pull the mean upward.
A data analyst is creating a report for a marketing campaign. The campaign data includes customer names, email addresses, and purchase history. Which of the following best describes the 'customer name' data type?
Nominal is categorical without order.
Why this answer
Customer names are categorical labels that identify individuals without any inherent order or numerical value. This fits the definition of nominal data, which is used for naming or classifying variables. In data analysis, nominal data can be stored as strings and used for grouping or filtering, but arithmetic operations are meaningless.
Exam trap
CompTIA often tests the distinction between nominal and ordinal data by presenting a label that could be mistaken for having an order (e.g., 'customer name' might be confused with 'rank' or 'tier'), but the trap here is that names are purely categorical with no intrinsic ranking.
How to eliminate wrong answers
Option B is wrong because quantitative data represents numerical measurements or counts (e.g., purchase amount), not text labels like names. Option C is wrong because ordinal data has a meaningful order or rank (e.g., customer satisfaction rating), but customer names have no inherent sequence. Option D is wrong because discrete data consists of countable numerical values (e.g., number of purchases), whereas customer names are non-numeric categories.
Refer to the exhibit. What is the most likely cause of the extraction failure?
Causes connection to hang until timeout.
Why this answer
Connection timeouts with consistent 30-second delays suggest the network firewall is blocking the port, causing the connection to hang until timeout. Option A is wrong because if the server were down, the error would be connection refused immediately. Option C is wrong because a complex query would cause a slow query, not a connection timeout.
Option D is wrong because a locked table would cause a lock wait timeout, not a connection timeout.
A retail company wants to forecast monthly sales for the next 12 months. Sales data shows a clear upward trend and seasonal patterns that repeat yearly. Which time series model is most appropriate?
Holt-Winters includes trend and seasonality components, making it suitable for this data.
Why this answer
The Holt-Winters exponential smoothing model (option C) is the most appropriate because it explicitly captures both trend and seasonality components, which are present in the sales data (upward trend and yearly seasonal patterns). Unlike simple exponential smoothing, Holt-Winters includes additive or multiplicative seasonal terms, making it ideal for data with clear, repeating seasonal cycles over a 12-month horizon.
Exam trap
The trap here is that candidates often choose ARIMA or SARIMA because they are more 'advanced,' but the question specifically describes clear trend and seasonality without requiring stationarity or differencing, making Holt-Winters the most direct and appropriate choice.
How to eliminate wrong answers
Option A (SARIMA) is wrong because while SARIMA can model trend and seasonality, it requires the data to be stationary (differencing) and involves more complex parameter selection (p, d, q, P, D, Q, s); for a straightforward forecasting task with clear trend and seasonality, Holt-Winters is simpler and often more robust. Option B (Simple exponential smoothing) is wrong because it only handles level (no trend or seasonality), so it would fail to capture the upward trend and yearly seasonal patterns in the sales data. Option D (ARIMA) is wrong because it models trend but not seasonality; without seasonal differencing or seasonal AR terms, it cannot account for the repeating yearly patterns in the data.
In multiple linear regression, which TWO assumptions are critical for unbiased coefficient estimates? (Choose two.)
Correct. Linearity is required for unbiasedness because if the relationship is misspecified, OLS estimates will be biased.
Why this answer
For unbiased coefficient estimates in multiple linear regression, the linearity assumption (A) ensures that the model correctly specifies the functional form, and the independence of errors assumption (E) ensures that errors are uncorrelated, both of which are required for ordinary least squares (OLS) estimates to be unbiased. Homoscedasticity (D) is not required for unbiasedness but for efficiency (Gauss-Markov theorem).
Exam trap
The exam often tests the distinction between assumptions for unbiasedness (linearity and independence) versus those for efficiency (homoscedasticity) or inference (normality). Candidates may incorrectly select homoscedasticity as critical for unbiased coefficient estimates.
Refer to the exhibit. A stakeholder complains that the line chart exaggerates the changes in sales. What is the most likely cause?
Starting at a non-zero value exaggerates differences.
Why this answer
Setting beginAtZero to false truncates the y-axis, making small changes appear larger.
Practice DA0-002 by domain
Target a specific domain to shore up weak areas.