986 questions total · 14pages · All types, answers revealed
Refer to the exhibit. What data quality issue is indicated?
The use of 'N/A' in a numeric field indicates lack of standardization.
Why this answer
The error shows that a non-numeric value 'N/A' is present in a numeric column, indicating non-standardized data entry. Duplication, inconsistency, or outliers are not directly shown.
A company needs to store raw, unprocessed data from IoT sensors for future machine learning experiments. The data is in various formats and schemas are not yet defined. Which storage solution is most appropriate?
A data lake stores raw data in its native format and supports schema-on-read, making it ideal for storing unstructured and semi-structured data for future analysis.
Why this answer
A data lake is the correct choice because it stores raw, unprocessed data in its native format (structured, semi-structured, or unstructured) without requiring a predefined schema. This aligns perfectly with the need to ingest IoT sensor data in various formats for future machine learning experiments, where schemas are not yet defined. Unlike data warehouses or data marts, a data lake supports schema-on-read, allowing the data to be transformed and queried later as needed.
Exam trap
CompTIA often tests the misconception that 'raw data' belongs in a data warehouse because it is 'data,' but the trap is that data warehouses require structured, processed data with a fixed schema, while a data lake is specifically designed for raw, schema-less data storage.
How to eliminate wrong answers
Option B is wrong because a data mart is a subset of a data warehouse designed for a specific business line or department, requiring pre-defined schemas and processed data, not raw unprocessed data. Option C is wrong because a data warehouse stores structured, cleaned, and transformed data optimized for business intelligence and reporting, not raw data in various formats. Option D is wrong because an operational database (e.g., OLTP system) is designed for real-time transaction processing with strict schemas and ACID compliance, not for storing large volumes of raw, schema-less IoT data for future analytics.
A data governance team is defining roles and responsibilities for data management. Which TWO of the following are common data governance roles? (Select TWO).
Data steward manages data quality and standards.
Why this answer
Data owner and data steward are standard roles in data governance, responsible for data ownership and stewardship respectively.
In a dataset of customer orders, you need to count the number of distinct customers who have placed orders. Which SQL aggregate function should you use?
Correctly counts unique customer IDs.
Why this answer
COUNT(DISTINCT column) counts the number of unique non-null values in a column. COUNT(*) counts all rows including duplicates, COUNT(column) counts non-null values including duplicates. DISTINCT alone is not an aggregate function.
A data analyst needs to identify the most frequently occurring value in a dataset. Which measure of central tendency should they use?
Mode is the most frequently occurring value.
Why this answer
The mode is the measure of central tendency that identifies the most frequently occurring value in a dataset. Unlike the mean or median, the mode directly counts the frequency of each distinct value and returns the value with the highest count, making it the correct choice for this specific requirement.
Exam trap
The trap here is that candidates often confuse 'most frequently occurring' with 'average' or 'middle value' and incorrectly choose mean or median, especially when the dataset is numeric and they assume central tendency always refers to mean.
How to eliminate wrong answers
Option B (Standard deviation) is wrong because it measures the dispersion or spread of data points around the mean, not the frequency of occurrence of any single value. Option C (Median) is wrong because it identifies the middle value when the dataset is sorted, which does not indicate which value appears most often. Option D (Mean) is wrong because it calculates the arithmetic average of all values, which can be skewed by outliers and does not reflect frequency of occurrence.
Which TWO chart types are best suited for visualizing the distribution of a single continuous variable? (Select two.)
Box plot summarizes distribution with median, quartiles, and outliers.
Why this answer
Histogram shows frequency bins; box plot shows quartiles and outliers.
A data analyst is performing a chi-square test of independence on a contingency table of customer satisfaction (satisfied vs. dissatisfied) and product type (A, B, C). The test yields a p-value of 0.04 with α = 0.05. What is the correct conclusion?
Correct: reject null, conclude association.
Why this answer
Since p-value < α, we reject the null hypothesis of independence, meaning there is a significant association between satisfaction and product type.
A company wants to share a dataset with external partners via an API. Which API type is typically used for web services and uses XML or JSON for messaging?
REST APIs use JSON/XML and are widely used for web services.
A dashboard designer needs to ensure that color choices are accessible to users with color vision deficiencies. Which practice should be followed?
Using patterns or text alongside color ensures accessibility.
Why this answer
Combining color with patterns or labels ensures that information is conveyed even to users with color vision deficiencies. Option A is incorrect as rainbow palettes rely solely on hue differentiation, which is problematic for color-blind users. Option B is incorrect because converting to grayscale loses the emphasis that color can provide for all users.
Option C is incorrect because red-green color schemes are particularly difficult for those with red-green color blindness (the most common type).
A company wants to segment its customers into distinct groups based on purchasing behavior. Which algorithm is best suited for this task?
K-means clustering groups similar customers together based on features.
Why this answer
K-means clustering is an unsupervised learning algorithm that partitions data into K distinct clusters based on feature similarity, making it ideal for segmenting customers by purchasing behavior without predefined labels. It groups customers who exhibit similar purchasing patterns, enabling the company to identify natural segments for targeted marketing.
Exam trap
The trap here is that candidates often confuse supervised learning algorithms (like decision trees or logistic regression) with unsupervised clustering, mistakenly thinking that any algorithm that 'groups' data can be used for segmentation without recognizing the need for unlabeled data.
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 training data to predict outcomes, not for discovering unknown groupings in unlabeled data. Option B is wrong because logistic regression is a supervised classification algorithm for binary or multinomial outcomes, relying on labeled target variables, and cannot perform unsupervised clustering. Option D is wrong because linear regression is a supervised regression algorithm that models the relationship between a dependent variable and one or more independent variables, and it is not designed to segment data into distinct groups without predefined categories.
A data analyst is designing a dashboard for executives to monitor company performance. Which THREE practices should the analyst follow to ensure effective storytelling with data? (Select three.)
Annotations highlight important points in the story.
Why this answer
Effective data storytelling includes a narrative arc, choosing the right chart, and annotating key events.
A company runs an A/B test to compare a new website layout (treatment) against the current layout (control). The conversion rate for the control is 5% and for the treatment is 5.5%. The p-value is 0.06 at α=0.05. Which THREE of the following conclusions are valid?
Correct: Fail to reject null.
Why this answer
The p-value > α, so fail to reject the null; the difference is not statistically significant. However, the observed lift is 0.5% (absolute). Sample size might be insufficient; statistical power could be low.
A dataset contains a column 'birthdate' in 'YYYY-MM-DD' format. The analyst needs to calculate the average age of customers as of today. Which combination of functions is most appropriate?
DATEDIFF with year returns the number of year boundaries crossed, which is a common approximation of age.
Why this answer
DATEDIFF(year, birthdate, GETDATE()) returns the number of year boundaries crossed between the two dates, which is the standard SQL method for calculating age. The other options subtract year components, which gives only an estimate that ignores the month and day, leading to inaccuracies.
A data analyst is working with a sales table that contains columns: sale_id, product_id, sale_date, and amount. They need to calculate a 7-day moving average of sales amount for each product, ordered by sale_date. Which window function syntax should they use?
Correct. This computes the average of the current and previous 6 rows per product.
Why this answer
A moving average requires averaging over a frame of rows. Using AVG() with an ORDER BY in the OVER clause and a frame specification (ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) calculates the 7-day moving average.
A data analyst notices that two departments report different revenue totals for the same period. Which data governance issue is most likely?
Correct. Without a centralized reporting layer, different sources can produce different numbers.
Why this answer
Lack of a single version of truth means data sources are not reconciled, leading to discrepancies.
Which TWO are best practices for data storytelling?
Leading with the key insight captures attention and provides clear direction.
Why this answer
Starting with the conclusion is a best practice for data storytelling because it immediately communicates the key insight to the audience, allowing them to understand the takeaway before diving into supporting details. This approach aligns with the inverted pyramid structure used in data communication, where the most critical finding is presented first to capture attention and provide context for the subsequent data. It ensures that even if the audience does not follow every detail, they still grasp the primary message.
Exam trap
CompTIA often tests the misconception that data storytelling should prioritize completeness or technical complexity over audience comprehension, leading candidates to select options like 'include all data points' or 'use complex jargon' instead of focusing on clarity and narrative flow.
A retail company has a data warehouse that integrates sales data from multiple sources including online transactions, in-store POS, and third-party marketplaces. The data team recently updated the ETL pipeline to add a new data source: mobile app purchases. After the update, the daily sales report shows a 15% increase in total sales compared to the previous day, which is unexpected because the mobile app is new and only contributed 2% of sales in tests. The report is created by a SQL script that aggregates sales by date and runs every morning. The data team needs to identify the cause of the discrepancy. Which of the following should the team do first?
Correct. A date filter error is a common cause of sudden large increases and should be checked first.
Why this answer
The correct first step because an unexpected 15% increase in total sales, especially when the new mobile app source accounts for only 2% in tests, suggests a data integrity issue rather than a real sales surge. The most common cause is a date filter error in the SQL script, such as including future dates or applying an incorrect date range, which would inflate the daily total. Verifying the date filter is a quick, low-effort check that can confirm the data source before investigating more complex issues like double-counting (Option D).
Options B and C are premature: comparing raw transaction counts is a secondary step after confirming the date filter, and assuming the increase is real (C) ignores the most likely data problem.
An analyst is presenting findings to stakeholders. Which TWO techniques effectively communicate uncertainty in data? (Choose TWO.)
Provides a range within which the true value likely falls.
Why this answer
Confidence intervals provide a range of values that likely contain the true population parameter, offering a clear measure of uncertainty around a point estimate. This technique is fundamental in inferential statistics and directly communicates the precision of the data, helping stakeholders understand the reliability of the findings.
Exam trap
CompTIA often tests the distinction between measures of central tendency (point estimates) and measures of variability (confidence intervals, error bars), trapping candidates who think stating exact numbers or removing outliers is a valid way to handle uncertainty.
Which of the following data types best describes a JSON file containing customer orders with varying fields per record?
JSON uses tags/elements to organize data but allows flexibility, making it semi-structured.
Why this answer
JSON is a semi-structured data format because it allows flexible schema where fields can vary between records.
A data analyst needs to present the correlation between advertising spend and website traffic. Which chart type is most appropriate?
Scatter plots reveal relationships between two variables.
Why this answer
A scatter plot is the most appropriate chart type for visualizing the correlation between two continuous variables, such as advertising spend and website traffic. It displays individual data points on a Cartesian plane, allowing the analyst to assess the strength, direction, and form of the relationship (e.g., linear, non-linear, or no correlation). This aligns with the DA0-001 objective of selecting the correct visualization for bivariate analysis.
Exam trap
The trap here is that candidates often choose a line chart because they mistakenly think 'correlation' implies a trend over time, but the DA0-001 exam specifically tests that scatter plots are the standard for bivariate correlation analysis without a temporal component.
How to eliminate wrong answers
Option A is wrong because a bar chart is used to compare categorical data or discrete values, not to show the relationship between two continuous variables; it would obscure the correlation pattern. Option B is wrong because a line chart is best for displaying trends over time or sequential data, not for revealing the correlation between two independent continuous variables; it implies a temporal order that may not exist. Option C is wrong because a pie chart is designed to show proportions of a whole for categorical data, making it completely unsuitable for visualizing the correlation between two numeric variables.
A company wants to show the number of products sold across different categories: Electronics, Clothing, Home Goods, and Books. Which chart type is most appropriate?
Bar chart effectively compares categories.
Why this answer
Bar chart is ideal for comparing categorical data across distinct groups.
A data analyst at a marketing firm is creating a weekly performance report for the marketing team. The report includes metrics like click-through rates, conversion rates, and cost per acquisition. The team prefers a quick overview of the week's performance to identify trends and make decisions in their Monday morning meeting. The meeting is only 30 minutes, and the team has limited time to review data. The analyst wants to provide a report that is concise and actionable. What format should the analyst use?
Concise and quickly readable in a short meeting.
Why this answer
A one-page executive summary with key metrics highlighted provides the marketing team with a concise, actionable overview that can be quickly reviewed in a 30-minute meeting. This format aligns with the requirement for a quick overview to identify trends and make decisions without overwhelming the team with excessive detail or requiring interactive exploration.
Exam trap
The trap here is that candidates often confuse 'interactive' with 'efficient,' choosing a live dashboard (Option B) because it seems modern and flexible, but they overlook the specific constraint of a 30-minute meeting where pre-digested, static summaries are more actionable than tools requiring active exploration.
How to eliminate wrong answers
Option B is wrong because a live dashboard with interactive filters, while powerful for ad-hoc analysis, requires time to explore and manipulate, which is not suitable for a quick 30-minute meeting where the team needs a pre-digested overview. Option C is wrong because a detailed spreadsheet with all data presents raw, unsummarized information that would take too long to parse and interpret, defeating the goal of conciseness and quick trend identification. Option D is wrong because a 20-slide presentation is too lengthy and detailed for a 30-minute meeting, likely leading to information overload and insufficient time for discussion and decision-making.
A data analyst is creating a dashboard for a sales team. Which TWO actions adhere to dashboard design best practices?
Consistent color coding helps users quickly interpret charts and maintain visual coherence, which is a best practice.
Why this answer
Using consistent color coding and placing the most important metric prominently are best practices. Using many bright colors and 3D effects are not.
A data team is using web scraping to collect competitor pricing data. The target website has anti-scraping measures like CAPTCHAs and rate limiting. Which approach is most effective?
Mimics human behavior and avoids detection.
Why this answer
Using rotating proxies and respectful delays helps evade anti-scraping mechanisms like CAPTCHAs and rate limiting by distributing requests across multiple IPs and mimicking human browsing behavior. Option A is incorrect because using a single IP address makes it easy for the website to block all requests from that IP. Option B is incorrect because disregarding robots.txt may violate the website's terms of service and could lead to legal action or IP bans.
Option D is incorrect because increasing request frequency would trigger rate limiting and increase the likelihood of being blocked.
A data analyst creates a bubble chart showing country GDP (x-axis), life expectancy (y-axis), and population (bubble size). However, large bubbles overlap and obscure many data points. Which corrective action should the analyst take?
Transparency allows seeing through overlapping bubbles.
Why this answer
Setting bubble opacity to 70% allows overlapping bubbles to become semi-transparent, so data points underneath remain visible. This technique preserves the original data representation (GDP, life expectancy, and population) without altering the chart's scale or removing data. It is a standard visualization practice for handling overplotting in dense scatter plots and bubble charts.
Exam trap
The trap here is that candidates often choose to reduce bubble sizes uniformly (Option C) thinking it solves overlap, but this distorts the proportional encoding of population, whereas opacity preserves the original data relationships while improving visibility.
How to eliminate wrong answers
Option A is wrong because increasing the canvas size does not resolve the fundamental issue of overlapping bubbles; it only spreads them out slightly, and large bubbles will still obscure others if their sizes are disproportionate. Option C is wrong because uniformly reducing all bubble sizes changes the visual encoding of population, potentially making small populations invisible and distorting the data's relative comparison. Option D is wrong because removing outlier countries with large populations eliminates valid data points, which introduces bias and violates the principle of representing the full dataset; the goal is to visualize all data, not discard it.
Which of the following best describes a data mart?
Data marts are subsets of data warehouses.
Why this answer
A data mart is a subject-specific subset of a data warehouse, focused on a particular department or function.
Which THREE elements should be included in a data insight report to ensure it is actionable? (Choose three.)
Confidence helps stakeholders assess reliability.
Why this answer
An actionable data insight report must include the level of confidence or statistical significance to allow decision-makers to assess the reliability of the findings. Without this, stakeholders cannot determine whether the observed patterns are likely to be real or due to random chance, which is critical for making data-driven decisions.
Exam trap
CompTIA often tests the distinction between technical artifacts (like source code or raw data) and actionable business insights, so candidates mistakenly include all supporting materials instead of focusing on elements that directly drive decision-making.
A dataset contains features with vastly different scales (e.g., age 0-100 and income 0-1,000,000). Which data transformation should be applied before using a K-nearest neighbors algorithm?
Min-max scales features to a fixed range (0-1), suitable for distance-based methods.
Why this answer
Distance-based algorithms like KNN require features on similar scales; min-max normalization is appropriate.
A data analyst is preparing a dataset for analysis and needs to ensure data quality. Which TWO of the following are dimensions of data quality?
Correct: consistency ensures data is uniform across sources.
Why this answer
Accuracy and consistency are recognized dimensions of data quality in CompTIA Data+.
A data analyst wants to test if the proportion of customers who prefer Product A over Product B is different from 50%. She surveys 200 customers and finds that 120 prefer Product A. Which statistical test should she use?
Correct for testing a single proportion against a hypothesized value.
Why this answer
A one-sample z-test for proportions compares a sample proportion to a hypothesized population proportion. Here, the null is p=0.5. A chi-square test for goodness-of-fit could also be used, but the z-test is standard for a single proportion.
Which of the following is an example of semi-structured data?
JSON uses key-value pairs with flexible schema, typical of semi-structured data.
Why this answer
Semi-structured data has tags or markers to separate data elements, like JSON or XML.
A company uses a data warehouse for reporting. They need to extract data from multiple sources, load it into a staging area, and then transform it before moving to the warehouse. This process is known as:
ETL extracts, transforms in a staging area, then loads into warehouse.
Why this answer
The process described—extracting data from multiple sources, loading it into a staging area, and then transforming it before moving to the warehouse—is the classic definition of ETL (Extract, Transform, Load). In ETL, transformation occurs after extraction but before loading into the target system, which is exactly what the staging area is used for. This contrasts with ELT, where transformation happens after loading into the warehouse.
Exam trap
The trap here is that candidates confuse the order of operations in ETL versus ELT, assuming that because modern cloud warehouses support ELT, the described staging-area process must be ELT, when in fact the staging area is a hallmark of traditional ETL.
How to eliminate wrong answers
Option A is wrong because ELT (Extract, Load, Transform) loads raw data into the target system first and transforms it later, which is the opposite of the described sequence where transformation occurs before moving to the warehouse. Option C is wrong because data replication refers to copying data from one system to another for redundancy or availability, not a multi-stage pipeline with transformation. Option D is wrong because data ingestion is a broad term covering the initial import of data into a system, but it does not specifically include the staging and transformation steps described in the question.
Which THREE characteristics describe unstructured data? (Select three.)
Correct. Unstructured data includes multimedia and free text.
Why this answer
Unstructured data lacks a predefined data model and is typically composed of non-tabular formats such as text, images, audio, and video. Unlike structured data, it cannot be directly stored in relational databases without transformation. This characteristic is fundamental to distinguishing unstructured data from structured or semi-structured types.
Exam trap
The trap here is that candidates may confuse 'unstructured' with 'semi-structured' (e.g., JSON or XML) and incorrectly assume that SQL can process all non-tabular data, or they may forget that schema-on-read is a defining trait of unstructured data in modern big data architectures.
Refer to the exhibit. A data analyst is creating a report that includes customer transaction data from 6 years ago. According to the policy, what should the analyst do?
The policy specifies 5 years retention; data older than that should be removed.
Why this answer
The data retention policy specifies that customer transaction data must be retained for only 5 years. Since the data is from 6 years ago, it exceeds the retention period and must be excluded from the report to comply with data governance and regulatory requirements. Including or modifying such data would violate policy and potentially expose the organization to legal or compliance risks.
Exam trap
The trap here is that candidates may assume data can be retained or modified (e.g., anonymized) if it is valuable for analysis, but the policy strictly prohibits using data beyond its retention period, regardless of its potential value or transformation.
How to eliminate wrong answers
Option A is wrong because anonymizing the data does not address the policy violation; the data has already exceeded the retention period and should not be used at all, regardless of anonymization. Option B is wrong because flagging the data for review implies it might still be used after evaluation, but the policy is clear that data beyond the retention period must be excluded, not reviewed for potential inclusion. Option D is wrong because including the data for its analytical value directly violates the retention policy, which prioritizes compliance over data utility.
Which of the following is a key performance indicator (KPI) tied to a strategic objective, as opposed to a metric?
CSAT can be a KPI if tied to strategic objective of improving customer experience.
Why this answer
A key performance indicator (KPI) is a measurable value that demonstrates how effectively a company is achieving a key strategic objective. Here, 'Customer satisfaction score (CSAT) as a strategic goal' explicitly ties the metric to a strategic objective (e.g., improving customer loyalty), whereas a plain metric like 'average handle time' is an operational measure without a direct strategic link. In data visualization, KPIs are often displayed on dashboards with targets and thresholds to track progress toward high-level business goals.
Exam trap
The trap here is that candidates confuse any measurable value (metric) with a key performance indicator (KPI), failing to recognize that a KPI must be explicitly tied to a strategic objective, not just any operational or technical measurement.
How to eliminate wrong answers
Option A is wrong because average handle time is an operational metric that measures efficiency in a call center, not a KPI tied to a strategic objective; it lacks a direct connection to a broader business goal. Option C is wrong because number of daily logins is a vanity metric that tracks user activity but does not inherently reflect progress toward a strategic objective like revenue growth or customer retention. Option D is wrong because server uptime percentage is a technical metric for system reliability, not a KPI linked to a strategic objective unless explicitly framed as part of a service-level agreement (SLA) goal tied to business continuity.
A retail company wants to predict sales based on advertising spend and season. Which data modeling technique should the analyst use?
Multiple linear regression handles two or more predictors and predicts a continuous outcome.
Why this answer
Multiple linear regression is the correct technique because the analyst needs to model a continuous outcome (sales) based on two or more predictor variables: advertising spend (continuous) and season (categorical, typically encoded as dummy variables). This allows the model to capture the independent effect of each predictor on sales, which simple linear regression cannot do because it only handles one predictor.
Exam trap
The trap here is that candidates often confuse simple linear regression with multiple linear regression, thinking that 'linear regression' alone suffices, but the exam specifically tests whether you recognize that multiple predictors require multiple regression.
How to eliminate wrong answers
Option A is wrong because simple linear regression can only model the relationship between one independent variable and the dependent variable, but here we have two predictors (advertising spend and season). Option C is wrong because logistic regression is used for binary or categorical outcome variables (e.g., yes/no), not for continuous outcomes like sales. Option D is wrong because K-means clustering is an unsupervised learning technique used to group similar data points, not to predict a continuous target variable.
A healthcare organization maintains a database of patient records. The database has a table 'patients' with columns: patient_id (primary key), first_name, last_name, date_of_birth, gender, and last_visit_date. A data analyst is tasked with creating a report that lists all patients who have not visited in the last two years. The analyst writes a query: SELECT * FROM patients WHERE last_visit_date < DATEADD(year, -2, GETDATE()); However, the query returns zero rows, even though the analyst knows there are patients who have not visited for over two years. Upon inspection, the analyst discovers that the last_visit_date column contains NULL values for patients who have never visited. Which modification to the query should the analyst make to include patients with NULL last_visit_date?
Includes NULLs in the result.
Why this answer
The original query uses a WHERE clause that compares last_visit_date to a computed date, but NULL comparisons in SQL always yield UNKNOWN, so rows with NULL last_visit_date are excluded. Adding OR last_visit_date IS NULL explicitly includes those rows, ensuring patients who have never visited are listed in the report.
Exam trap
The trap here is that candidates often forget that NULL comparisons in SQL do not return TRUE, leading them to incorrectly think the original query already handles NULLs, and they may choose Option C (COALESCE) as a workaround instead of the simpler and correct IS NULL check.
How to eliminate wrong answers
Option A is wrong because removing the WHERE clause entirely would return all rows, including those with recent visits, which fails to filter for patients who have not visited in two years. Option C is wrong because COALESCE(last_visit_date, '1900-01-01') would replace NULL with a very old date, making the comparison work, but it is not the standard or most efficient approach; the correct method is to use IS NULL to handle NULLs directly. Option D is wrong because AND last_visit_date IS NOT NULL would explicitly exclude rows with NULL last_visit_date, which is the opposite of what is needed.
A data team is preparing data for a clustering analysis. Which THREE of the following steps are commonly part of data cleaning?
Deduplication is cleaning.
Why this answer
Data cleaning includes handling missing values, outlier treatment, and deduplication.
Match each data analysis tool to its primary function.
Drag a concept onto its matching description — or click a concept then click the description.
Query and manipulate structured data in databases
General-purpose language for data analysis and modeling
Statistical computing and graphics
Interactive data visualization and dashboards
Spreadsheet for data manipulation and basic analysis
Why these pairings
Excel is for spreadsheets, SQL for databases, Python for programming/ML, and Tableau for visualization. Common confusions include assigning predictive modeling to Excel or dashboard creation to SQL.
A financial analyst wants to create a dashboard that shows the monthly profit and loss, highlighting how each component (revenue, cost of goods sold, operating expenses) contributes to the final net profit. Which chart type is most appropriate?
Waterfall charts illustrate the step-by-step progression from starting to ending value, perfect for financial breakdowns.
Why this answer
A waterfall chart effectively shows how each incremental positive or negative value contributes to a final total, making it ideal for profit/loss breakdowns.
In Power BI, an analyst wants to create a measure that calculates the total sales for the current year up to the latest date in the data. Which DAX function should be used?
Correct. TOTALYTD computes the year-to-date total.
Why this answer
TOTALYTD is a time intelligence function that sums values for the year up to the last date in the filter context (or specified end date).
A data analyst needs to retrieve all unique job titles from an employees table. Which SQL keyword should be used in the SELECT clause?
Correct. DISTINCT filters out duplicate rows.
Why this answer
DISTINCT removes duplicate rows from the result set, returning only unique values. In this case, SELECT DISTINCT job_title would return each job title only once.
A data analyst uses a Common Table Expression (CTE) to query hierarchical employee data (manager_id references employee_id). Which THREE statements about recursive CTEs are correct? (Select THREE).
The anchor member is the non-recursive initial query.
Why this answer
Recursive CTEs require the WITH RECURSIVE clause (or WITH in some DBMS that imply recursion). The UNION ALL is typical to combine anchor and recursive members. Anchor member is the starting set; recursive member references the CTE itself.
The anchor member is defined before the recursive member.
A healthcare organization collects patient questionnaire data via paper forms at clinics. The forms are scanned and sent to a central office, where staff manually enter data into an electronic system. This process is slow and error-prone. The organization wants to reduce manual entry errors and speed up data availability. Which method should they adopt?
OCR automates data extraction from scanned forms, reducing errors and increasing speed.
Why this answer
Optical Character Recognition (OCR) can convert scanned images to text automatically, reducing manual entry errors and speeding up the process. Requiring patients to fill out online forms may not be feasible for all patients, especially those without internet access. Continuing manual entry with double-checking is still slow and labor-intensive.
Sending to an external company introduces additional cost and potential privacy concerns.
A data scientist is performing K-means clustering on customer data. She plots the within-cluster sum of squares (WCSS) for different values of k and observes an 'elbow' at k=4. What does this indicate?
The elbow point indicates a good trade-off between cluster compactness and number of clusters.
Why this answer
The elbow method suggests that adding more clusters beyond k=4 yields diminishing returns, so k=4 is a suitable number of clusters.
Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?
Correct. KPIs are a subset of metrics that are critical to strategic success.
Why this answer
KPIs are tied to strategic objectives and measure progress toward goals, while metrics can be any operational measurement that may not be directly linked to strategy.
An analyst has a dataset with monthly sales figures for the past five years. They want to highlight the cumulative effect of sales over time and show the total contribution of each month stacked on top of previous months. Which chart type is most suitable?
Correct. An area chart, especially stacked, shows cumulative trends over time.
Why this answer
An area chart is the most suitable choice because it fills the space between the line and the baseline with color, visually emphasizing the cumulative total over time. This allows the analyst to see both the trend of monthly sales and the stacked contribution of each month to the overall cumulative effect, which is exactly what the question requires.
Exam trap
The trap here is that candidates often confuse a stacked bar chart with an area chart, thinking that stacking bars shows cumulative effect, but the area chart's continuous fill better represents the cumulative flow over time, which is the key requirement in the question.
How to eliminate wrong answers
Option A is wrong because a line chart only shows the trend of individual data points over time without any visual stacking or cumulative effect, so it cannot highlight the total contribution of each month stacked on top of previous months. Option B is wrong because a stacked bar chart shows parts of a whole at discrete time points but does not inherently emphasize the cumulative effect over time as a continuous flow, and it is less effective for showing the progression of cumulative totals across many months. Option D is wrong because a waterfall chart is designed to show incremental changes (additions and subtractions) from a starting value to an ending value, not to display a continuous cumulative stack of monthly contributions over a five-year period.
An e-commerce company wants to integrate product pricing data from competitor websites to adjust its own prices dynamically. They plan to scrape pricing pages every hour. However, the competitors' websites have anti-scraping measures such as IP blocking and CAPTCHAs. The company's legal team also advises caution regarding terms of service. Which data acquisition strategy is both effective and compliant?
An API agreement is legal, compliant, and provides structured data access.
Why this answer
Negotiating with competitors to obtain pricing data via API agreements is the most compliant approach, as it avoids violating terms of service and ensures reliable data access. Using rotating proxies and automation to bypass anti-scraping measures may be effective but could violate laws or terms of service. Manual recording is too slow and not dynamic.
Using a public data aggregator may not provide the specific competitor data needed and could be costly.
Which TWO of the following are characteristics of a data lake?
Data lakes store data as-is without transformation.
Why this answer
A data lake retains raw data in its native format, meaning data is ingested without transformation or schema enforcement. This allows storage of structured, semi-structured, and unstructured data as-is, preserving fidelity for future analytics. Unlike a data warehouse, a data lake does not require upfront schema definition, enabling flexible exploration and machine learning workloads.
Exam trap
The trap here is that candidates confuse data lakes with data warehouses, assuming all enterprise data stores enforce ACID and schema-on-write, when in fact data lakes prioritize raw storage and schema flexibility.
Which TWO of the following are characteristics of structured data? (Choose TWO.)
Schema defines structure.
Why this answer
Structured data is defined by having a predefined schema, which specifies the data types, constraints, and relationships for each field. This schema ensures consistency and allows for efficient querying and validation. Option A is correct because a defined schema is a fundamental characteristic of structured data, as seen in relational database tables where each column has a specific data type and constraints.
Exam trap
The trap here is that candidates often confuse structured data with semi-structured data (e.g., JSON or XML) and incorrectly assume that structured data cannot be queried with SQL or that it requires NoSQL databases.
A data analyst is evaluating a multiple regression model with three predictors. The R² value is 0.85. Which of the following is the best interpretation of R²?
Correct: R² measures explained variance.
Why this answer
R² represents the proportion of variance in the dependent variable explained by the independent variables. 0.85 means 85% of the variance is explained.
Refer to the exhibit. Which data concept does this exhibit best represent?
The exhibit is a JSON schema that validates the structure of JSON data.
Why this answer
The exhibit shows a structured data format with key-value pairs, arrays, and nested objects enclosed in curly braces, which is the standard syntax for JSON (JavaScript Object Notation). A JSON schema defines the structure, data types, and validation rules for JSON data, making it the best fit for the exhibit. The presence of fields like "name", "age", and "address" with specific types (e.g., string, integer) confirms this is a schema definition, not a generic data representation.
Exam trap
CompTIA often tests the distinction between a JSON schema (a structural definition with type constraints) and a raw JSON object (just data), leading candidates to mistake the schema for a simple data dictionary or ERD.
How to eliminate wrong answers
Option A is wrong because an entity relationship diagram (ERD) uses graphical symbols like rectangles and diamonds to represent entities and their relationships, not structured text with curly braces and key-value pairs. Option C is wrong because a data quality rule defines constraints like uniqueness or completeness (e.g., 'age must be > 0'), but the exhibit shows a structural blueprint with data types, not validation rules. Option D is wrong because a data dictionary is a tabular or textual catalog of data elements with definitions, not a machine-readable schema with nested objects and arrays.
A financial institution wants to analyze transaction networks to detect fraud rings. Which database type is best suited for this analysis?
Graph databases excel at traversing relationships, perfect for network analysis.
Why this answer
A graph database is designed to store and traverse relationships between entities, making it ideal for analyzing transaction networks where connections between accounts, merchants, and transactions reveal fraud rings. Its native graph model (nodes and edges) allows efficient pattern matching and pathfinding queries, such as detecting circular transactions or shared attributes, which are common in fraud detection.
Exam trap
CompTIA often tests the misconception that any NoSQL database can handle relationship-heavy workloads, but the trap here is that only graph databases are purpose-built for deep relationship traversal and pattern matching, while other NoSQL types sacrifice relationship performance for scalability or flexibility.
How to eliminate wrong answers
Option A is wrong because wide-column stores (e.g., Cassandra, HBase) are optimized for high-volume, low-latency reads/writes on sparse data with flexible schemas, but they lack native relationship traversal capabilities, making multi-hop queries across transaction networks slow and complex. Option C is wrong because key-value stores (e.g., Redis, DynamoDB) provide fast lookups by primary key but cannot efficiently model or query the interconnected relationships between transactions and entities, requiring application-level joins that degrade performance. Option D is wrong because document stores (e.g., MongoDB, Couchbase) store semi-structured data as JSON-like documents and support indexing, but they do not have built-in graph traversal algorithms, so analyzing fraud rings would require expensive recursive queries or external graph processing.
A data analyst is troubleshooting a report that shows unusually high sales for a specific product. Upon investigation, the analyst finds that the product was returned by several customers, but the returns were recorded in a separate system and not reflected in the sales data. Which data integration concept was likely missing?
Reconciliation ensures data matches across sources.
Why this answer
The core issue is that the sales data and returns data are inconsistent because they were not cross-verified. Data reconciliation is the process of comparing datasets to ensure they are in agreement and identifying discrepancies, such as returns not being reflected in sales figures. Without reconciliation, the analyst would not detect that the high sales number is inflated by unrecorded returns.
Exam trap
The trap here is that candidates confuse the data movement process (ETL) with the data validation process (reconciliation), assuming that simply extracting and loading data will automatically ensure consistency between separate systems.
How to eliminate wrong answers
Option A is wrong because ETL (Extract, Transform, Load) is a process for moving and transforming data from source to target systems, but it does not inherently include a step to compare or verify data consistency between separate systems; the missing concept here is not about data movement but about data agreement. Option C is wrong because data profiling focuses on examining data quality, structure, and content (e.g., nulls, duplicates, data types), not on cross-system consistency checks; the problem is not about the quality of the sales data itself but about its mismatch with returns data. Option D is wrong because data governance refers to the overall management of data availability, usability, integrity, and security through policies and standards, not a specific technical process for reconciling discrepancies between two systems.
A business needs to store large volumes of raw data in its native format for future analytics. Which storage architecture is most appropriate?
Data lakes store raw data in its native format without transformation.
Why this answer
A data lake is designed to store large volumes of raw data in its native format (structured, semi-structured, or unstructured) without requiring a predefined schema. This makes it ideal for future analytics where the data schema may not yet be known, as it supports schema-on-read rather than schema-on-write.
Exam trap
The trap here is that candidates confuse a data warehouse with a data lake, assuming both are for analytics, but the key differentiator is that a data warehouse requires schema-on-write and processed data, while a data lake stores raw data in native format.
How to eliminate wrong answers
Option A is wrong because a relational database enforces a strict schema-on-write and is optimized for transactional processing (OLTP), not for storing raw, unprocessed data at scale. Option C is wrong because an operational data store (ODS) is used for integrating data from multiple operational systems for near-real-time reporting, not for storing raw data in native format for future analytics. Option D is wrong because a data warehouse stores cleansed, transformed, and structured data optimized for query performance and business intelligence, not raw data in its native format.
A data analyst is using pandas in Python to merge two DataFrames: sales (columns: sale_id, product_id, amount) and products (columns: product_id, product_name). Which pandas function should they use to combine these DataFrames on the 'product_id' column?
Correct. merge() is designed for database-style joins.
Why this answer
The pandas merge function is used to combine DataFrames on common columns. The syntax is pd.merge(sales, products, on='product_id').
You are a data analyst for an e-commerce company. Your team has built a dashboard to monitor daily sales performance across five regions: North, South, East, West, and Central. The dashboard includes a bar chart showing total sales per region, a line chart showing daily sales trend over the past 30 days, and a pie chart showing sales distribution by product category (Clothing, Electronics, Home, Books, Sports). Recently, stakeholders have complained that the pie chart is hard to interpret because the Sports category has very small sales and is barely visible. Also, the bar chart uses a rainbow color scheme that makes it difficult to compare bar heights because the colors are not ordered by magnitude. The line chart is fine. You need to redesign the dashboard to address these issues. Which combination of changes is most appropriate?
Grouping small categories improves pie readability; sequential colors ordered by magnitude helps bar comparison.
Why this answer
Grouping small categories into an 'Other' slice directly addresses the pie chart's readability issue by consolidating negligible values, and using a sequential color scheme ordered by sales for the bar chart improves the ability to compare bar heights by encoding magnitude through color intensity. This combination follows best practices for data visualization: avoid cluttering with tiny slices and use ordered, perceptually uniform colors to facilitate accurate comparisons.
Exam trap
CompTIA often tests the misconception that simply highlighting or separating a small slice (exploding or 3D) fixes pie chart readability, when in fact it does not address the fundamental issue of angle comparison for tiny values.
How to eliminate wrong answers
Option A is wrong because replacing the pie chart with a stacked bar chart does not solve the problem of a barely visible category; it may still compress small values into thin segments, and a categorical color scheme for the bar chart does not order colors by magnitude, leaving the comparison of bar heights difficult. Option B is wrong because exploding the Sports slice in the pie chart only draws attention to it without improving the overall readability of the pie chart for small slices, and a monochromatic color scheme for the bar chart lacks the ordered intensity needed to compare bar heights effectively. Option C is wrong because a 3D pie chart distorts proportions and makes interpretation even harder, and a diverging color scheme is designed for data with a meaningful midpoint (e.g., positive/negative values), not for ordering bars by magnitude.
A market research firm collects survey responses where customers rate satisfaction on a scale of 'Very Unsatisfied', 'Unsatisfied', 'Neutral', 'Satisfied', 'Very Satisfied'. What type of data is being collected?
The satisfaction scale has a clear order but unequal intervals, fitting ordinal data definition.
Why this answer
The data is ordinal because the satisfaction levels have a clear, ordered ranking from 'Very Unsatisfied' to 'Very Satisfied', but the intervals between categories are not necessarily equal. This type of categorical data preserves the order without assuming a consistent numerical difference between each level.
Exam trap
The trap here is that candidates mistakenly treat ordered categorical data as interval data because they assume the numeric labels (e.g., 1 to 5) imply equal spacing, but the exam expects you to recognize that the underlying measurement scale lacks guaranteed equal intervals.
How to eliminate wrong answers
Option A is wrong because interval data requires equal, measurable intervals between values (e.g., temperature in Celsius), but the satisfaction scale does not guarantee equal psychological distance between categories. Option C is wrong because ratio data requires a true, meaningful zero point (e.g., income, height), and 'Very Unsatisfied' does not represent an absolute absence of satisfaction. Option D is wrong because nominal data is unordered categorical data (e.g., colors, gender), but the satisfaction scale has a natural order that must be preserved.
A database designer wants to improve query performance on a large table that is frequently filtered by multiple columns. Which TWO types of indexes could be beneficial? (Select TWO).
Composite indexes on multiple columns can speed up queries filtering by those columns.
Why this answer
Composite indexes cover multiple columns, and B-tree indexes are general-purpose and support range queries, both useful for filtering on multiple columns.
Which TWO of the following are dimensional modeling techniques commonly used in data warehouses?
Snowflake schema is a dimensional modeling technique where dimensions are normalized.
Why this answer
The snowflake schema is a dimensional modeling technique where dimension tables are normalized into multiple related tables, reducing data redundancy. This structure is commonly used in data warehouses to improve query performance and maintainability for complex analytical queries.
Exam trap
The trap here is that candidates may confuse general data modeling concepts (like ERDs) or data visualization tools (like scatter plots and histograms) with specific dimensional modeling techniques used in data warehouses.
A data scientist trains a regression model and observes high variance with low bias. Which technique is most appropriate to reduce variance?
Ridge adds penalty to coefficients, reducing overfitting and variance.
Why this answer
Ridge regularization (L2) reduces variance by adding a penalty term proportional to the square of the coefficients, which shrinks them toward zero without eliminating them. This directly addresses high variance (overfitting) by constraining the model's complexity, while low bias indicates the model fits the training data well. The regularization parameter λ controls the trade-off between bias and variance.
Exam trap
CompTIA often tests the misconception that reducing variance requires removing features or simplifying the model, but Ridge regularization is the correct technique because it penalizes coefficient magnitude without discarding predictors.
How to eliminate wrong answers
Option B is wrong because increasing polynomial features adds higher-order terms, which increases model complexity and typically increases variance, not reduces it. Option C is wrong because using a smaller training set reduces the amount of data available for learning, which generally increases variance due to less stable coefficient estimates. Option D is wrong because removing correlated features can reduce multicollinearity but does not directly penalize coefficient magnitudes; it may even increase variance if important predictors are dropped.
A data analyst is communicating insights about a sales forecast to stakeholders. Which three of the following should the analyst include to build trust and clarity? (Select THREE.)
Correct. Confidence intervals quantify uncertainty.
Why this answer
Confidence intervals are correct because they quantify the uncertainty around the forecast, providing a range within which the true value is expected to fall with a certain probability (e.g., 95%). This directly builds trust by showing stakeholders that the analyst acknowledges variability and does not present a single point estimate as absolute truth.
Exam trap
CompTIA often tests the distinction between transparency and information overload, so the trap here is that candidates think sharing raw data (Option B) is always good practice, but in stakeholder communication, raw data without context or summary statistics can confuse rather than clarify.
A data analyst frequently receives ad hoc requests for the same type of analysis. Which TWO approaches could reduce the number of ad hoc requests?
A scheduled report can proactively deliver the needed information.
Why this answer
Building self-service capabilities and iterating on feedback to improve scheduled reports can address recurring needs and reduce ad hoc requests.
An executive dashboard must display high-level KPIs such as current revenue, profit margin, and customer count. Which visualization type is most appropriate for each KPI?
KPI cards provide an immediate, straightforward view of a key metric.
Why this answer
KPI cards (or tiles) are designed to display a single key metric, such as revenue, profit margin, or customer count, along with its variance (e.g., change over time or vs. target), making them ideal for executive dashboards where quick comprehension of high-level KPIs is critical. Pie charts are poor for showing individual values and cannot display variance; sparklines show trends but not the current value prominently; gauge charts are less precise for exact numbers. Therefore, KPI cards are the most appropriate choice.
A data analyst is creating a self-service reporting environment. Which data governance practice ensures users see only data relevant to their department?
Correct. Row-level security filters data per user.
Why this answer
Row-level security restricts data access based on user roles, ensuring users only see authorized data.
An analyst is creating a report in Power BI and needs to calculate year-to-date total sales compared to the same period last year. Which TWO DAX functions should be used? (Choose two.)
Correct. SAMEPERIODLASTYEAR shifts dates back one year.
Why this answer
TOTALYTD computes year-to-date, and SAMEPERIODLASTYEAR shifts context to the prior year. CALCULATE modifies filter context, often used with time intelligence.
A data scientist is building a machine learning model to predict customer churn. The dataset includes both numerical features (age, income) and categorical features (gender, marital status). Which data concept describes the process of converting categorical features into numerical values that can be used by the algorithm?
Encoding converts categories to numbers, e.g., one-hot encoding.
Why this answer
Encoding is the correct data concept because it transforms categorical features (like gender and marital status) into numerical representations (e.g., one-hot encoding, label encoding) that machine learning algorithms can process. Unlike feature scaling or dimensionality reduction, encoding directly addresses the incompatibility of non-numeric data with mathematical model operations.
Exam trap
CompTIA often tests the distinction between encoding and feature scaling, where candidates mistakenly think scaling applies to categorical data, but scaling only adjusts numeric ranges and cannot convert text labels to numbers.
How to eliminate wrong answers
Option A is wrong because data sampling refers to selecting a subset of data for training/testing, not converting categorical data to numeric. Option C is wrong because feature scaling normalizes numerical ranges (e.g., via min-max scaling or z-score standardization) and does not handle categorical-to-numeric conversion. Option D is wrong because dimensionality reduction (e.g., PCA, t-SNE) reduces the number of features, but it assumes all input features are already numeric and does not address the encoding of categorical variables.
An analyst needs to communicate a data insight about a sudden drop in website traffic. Which communication method should be used first?
Allows real-time discussion and clarification.
Why this answer
A sudden drop in website traffic is a critical, time-sensitive insight that requires immediate discussion and validation. A live meeting allows the analyst to present the data, answer questions, and collaboratively determine the root cause (e.g., a server outage, SEO penalty, or broken tracking code) before taking action. This aligns with the DA0-001 domain of Communicating Data Insights, where urgency and context demand interactive, real-time communication.
Exam trap
The trap here is that candidates may choose Option D (email with data dump) because they think providing all data is thorough, but the exam tests the understanding that raw data without context or a narrative fails to communicate insights effectively, especially for urgent issues.
How to eliminate wrong answers
Option A is wrong because updating a dashboard without notification assumes stakeholders will notice the change and interpret it correctly, which is unreliable for urgent insights and violates the principle of proactive communication. Option B is wrong because posting on a company wiki is a passive, asynchronous method that delays awareness and lacks the immediacy needed for a sudden drop in traffic. Option D is wrong because sending an email with a data dump overwhelms recipients with raw data without analysis or context, failing to communicate the insight effectively and potentially causing confusion or delayed action.
A logistic regression model predicts customer churn (0=no churn, 1=churn). The model outputs probabilities. Which THREE of the following statements about logistic regression are correct?
Correct: The sigmoid function ensures output in [0,1].
Why this answer
Logistic regression outputs probabilities; it uses the logistic function (sigmoid) to map linear combination to [0,1]. The coefficients represent log-odds changes. R² is for linear regression; pseudo-R² is used but not standard R².
A data analyst is performing data profiling on a customer table. Which metric would best help identify missing values in the 'phone' column?
Null count shows number of records with missing phone values.
Why this answer
Null count directly measures missing values.
A DBA wants to improve query performance on a large table that is frequently filtered on two columns: department_id and hire_date. The table has millions of rows. Which index strategy would be most effective?
Composite index on both columns in the filter order can be used for both conditions.
Why this answer
A composite B-tree index on (department_id, hire_date) is most effective because it allows the database to satisfy equality and range predicates on both columns in a single index scan. B-tree indexes are optimized for high-cardinality columns and support efficient multi-column filtering when the leading column matches the query's equality condition, followed by the range condition on hire_date.
Exam trap
The trap here is that candidates often assume two separate single-column indexes are equivalent to a composite index, but they fail to realize that the database cannot efficiently combine them for range predicates without a costly index merge operation.
How to eliminate wrong answers
Option B is wrong because bitmap indexes are designed for low-cardinality columns (e.g., gender or status) and perform poorly with high-cardinality columns like hire_date, leading to excessive bitmap merge overhead and poor query performance. Option C is wrong because a hash index on department_id only supports equality lookups, not range queries on hire_date, and cannot be used for filtering on both columns simultaneously. Option D is wrong because two separate B-tree indexes would force the optimizer to choose one index and then filter the other column via a table access (or perform an expensive index merge), which is less efficient than a single composite index that can directly satisfy both predicates.
A data analyst is performing a chi-square test for independence between two categorical variables. Which THREE of the following are necessary conditions for the test to be valid?
Correct condition.
Why this answer
The chi-square test requires expected frequencies ≥5, random sampling, and independence of observations.
A retail company wants to analyze monthly sales data over the past three years to identify long-term trends. Which component of time series analysis is most relevant for this goal?
Trend shows the overall long-term direction of the time series.
Why this answer
The trend component represents the long-term direction of the data, which is exactly what the company wants to identify.
When the analyst runs the query, it fails. What is the most likely reason?
Aliases are not recognized in WHERE due to order of execution.
Why this answer
The alias 'TotalValue' is defined in the SELECT clause but is referenced in the WHERE clause. In SQL, column aliases cannot be used in the WHERE clause because the WHERE clause is evaluated before the SELECT clause, so the alias does not yet exist at that point in the query execution order. This causes a syntax or 'unknown column' error.
Exam trap
CompTIA often tests the SQL query execution order, specifically that column aliases cannot be used in the WHERE clause, leading candidates to mistakenly think the alias is available everywhere in the query.
How to eliminate wrong answers
Option B is wrong because a misspelled table name would cause a 'table not found' error, not the alias-related failure described. Option C is wrong because Price and Quantity are typically numeric types (e.g., DECIMAL, INT), and multiplication is valid between compatible numeric types; if they were incompatible, the error would be about implicit conversion, not alias usage. Option D is wrong because 'Price * Quantity' is a valid arithmetic expression in SQL, and the multiplication operator works on numeric columns.
A company is planning an A/B test to compare two website designs. Which THREE of the following must be determined before the test begins to ensure valid results? (Select three.)
Helps determine sample size.
Why this answer
Sample size (based on power and effect size), significance level (α), and desired effect size are all pre-specified to design the test. The p-value is an outcome, not a pre-test parameter. The hypothesis is defined beforehand, but which one is false? Actually null and alternative hypotheses should be pre-specified, but the phrasing 'which one is true' is not determined before; the test determines that.
So correct are: determine minimum sample size, determine significance level, and determine desired effect size.
Practice DA0-002 by domain
Target a specific domain to shore up weak areas.