986 questions total · 14pages · All types, answers revealed
Drag and drop the steps to perform a data backup using the 3-2-1 rule in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
The 3-2-1 rule involves multiple copies, different media, offsite storage, and regular testing.
A data modeler is designing a dimensional model for a sales analytics system. The fact table contains sales transactions, and the dimension tables include product, customer, and time. To reduce data redundancy, the modeler normalizes the dimension tables into multiple related tables. Which schema is being implemented?
Snowflake schema normalizes dimension tables to reduce redundancy.
Why this answer
The snowflake schema is a dimensional model where dimension tables are normalized into multiple related tables to reduce data redundancy. In this scenario, the product, customer, and time dimensions are split into sub-dimensions (e.g., product category, customer geography, time hierarchy), which is the defining characteristic of a snowflake schema. This contrasts with a star schema where dimensions remain denormalized.
Exam trap
CompTIA often tests the distinction between star and snowflake schemas by emphasizing normalization of dimensions; the trap here is that candidates may confuse 'normalized dimensions' with a star schema, which actually uses denormalized dimensions for simplicity and performance.
How to eliminate wrong answers
Option A is wrong because a vault schema (Data Vault) is a hybrid modeling approach focused on auditability and flexibility using hubs, links, and satellites, not on normalizing dimension tables for a sales analytics fact table. Option B is wrong because a star schema keeps dimension tables denormalized (single table per dimension) to optimize query performance, which directly contradicts the normalization described in the question. Option C is wrong because a galaxy schema (also called a fact constellation) contains multiple fact tables sharing dimension tables, not the normalization of a single fact table’s dimensions.
The exhibit shows log entries. A data analyst wants to visualize the frequency of each error type over time. Which chart type is most appropriate?
Shows frequency trend over time.
Why this answer
A time series line chart counts events per time interval, best for showing frequency over time. Bar chart of counts is static. Pie of error types ignores time.
Scatter plot not suitable.
A data analyst is troubleshooting a dashboard that displays incorrect totals for sales by region. The data source queries are correct. Which of the following is the most likely cause?
Correct. Filters can exclude data without obvious indication, causing incorrect totals.
Why this answer
Filter context can inadvertently exclude certain regions, leading to incorrect totals. Options A, B, and C are less likely: A affects performance not accuracy; B would be caught by correct queries; C could cause aggregation differences but filters are a common issue.
An analyst is creating an executive summary for a quarterly business review. Which THREE components are essential for an effective executive summary?
Guides decision-making.
Why this answer
An executive summary should start with a headline number, provide context, and include actionable recommendations.
Which TWO of the following are characteristics of OLTP systems? (Select 2)
OLTP handles many concurrent transactions.
Why this answer
OLTP systems are designed for high transaction throughput, handling large volumes of short, atomic transactions efficiently. They prioritize fast data processing and immediate consistency, making option D correct.
Exam trap
The trap here is that candidates often confuse OLTP with OLAP, mistakenly selecting denormalized schemas or analytical optimization as OLTP characteristics, when in fact OLTP emphasizes normalized schemas and high transaction throughput with ACID compliance.
JSON is semi-structured as it has organizational properties (key-value pairs) but no rigid schema.
Why this answer
JSON (JavaScript Object Notation) is classified as a semi-structured data type because it uses a flexible, self-describing schema with key-value pairs and nested structures, but does not enforce a rigid tabular schema like relational databases. In the context of extracting data from a REST API, JSON allows for varying fields and hierarchical data, which aligns with the semi-structured category.
Exam trap
The trap here is that candidates confuse the presence of structure (keys and values) with being fully structured, overlooking that JSON lacks a fixed schema and allows variability, which places it in the semi-structured category.
How to eliminate wrong answers
Option A is wrong because transactional data refers to records of business transactions (e.g., sales, orders) typically stored in structured formats with ACID properties, not to the format of the data itself. Option C is wrong because unstructured data lacks any predefined structure or schema (e.g., raw text, images, video), whereas JSON has a defined syntax with keys, values, and nesting. Option D is wrong because structured data requires a fixed schema (e.g., rows and columns in a relational table), while JSON allows optional fields and varying data types, making it semi-structured.
A data analyst needs to combine two datasets that have the same columns but different rows. Which operation should they use?
Append adds rows from one dataset to another with same columns.
Why this answer
(Append) is correct because appending is the standard operation for combining two datasets with identical columns but different rows, stacking the rows from one dataset onto the other. In tools like SQL, this is achieved with the UNION or UNION ALL operator, and in Python pandas, it is done via the `append()` method or `pd.concat()` with axis=0. This operation preserves the column structure while extending the row count.
Exam trap
The trap here is that candidates confuse 'concatenate' (which can mean row-wise or column-wise) with 'append' (which specifically means row-wise stacking), leading them to choose Option A when the question explicitly requires combining rows.
How to eliminate wrong answers
Option A (Concatenate) is wrong because concatenation is a general term that can refer to combining along any axis (rows or columns), and in many contexts (e.g., SQL string functions, pandas with axis=1), it implies joining side-by-side rather than stacking rows; the question specifically requires row-wise stacking, which is append. Option C (Merge) is wrong because merge is used to combine datasets based on a common key column (like a SQL JOIN), not to simply stack rows when columns are identical. Option D (Aggregate) is wrong because aggregation involves summarizing data (e.g., SUM, AVG, COUNT) across groups, not combining separate datasets.
An analyst recommends a pricing change based on data showing price elasticity. The recommendation includes expected revenue impact. What is this an example of?
Correct. It includes evidence and expected impact.
Why this answer
Data-driven recommendations follow the structure: evidence -> insight -> recommendation -> expected impact.
In a simple linear regression model y = 2.5 + 1.2x, what is the predicted value of y when x = 10?
Correct calculation.
Why this answer
Plug x=10: y = 2.5 + 1.2*10 = 2.5 + 12 = 14.5.
A data analyst wants to show the monthly sales trend for the past two years with an emphasis on cumulative growth. Which chart type is most appropriate?
Area charts highlight cumulative totals over time.
Why this answer
An area chart is the most appropriate choice because it combines a line chart's ability to show trends over time with a filled area beneath the line, which visually emphasizes cumulative growth. For monthly sales data over two years, the area fill makes it easy to see both the month-over-month trend and the total accumulated sales volume, which is exactly what the data analyst needs.
Exam trap
The trap here is that candidates often choose a line chart (Option D) because it shows trends, but they overlook that the area chart is specifically designed to emphasize cumulative growth through its filled region, which is the key requirement in the question.
How to eliminate wrong answers
Option A is wrong because a scatter plot is used to show the relationship between two numerical variables (e.g., correlation), not to display a single time series trend or cumulative growth. Option B is wrong because a bar chart is best for comparing discrete categories or individual values, but it does not inherently emphasize cumulative growth or continuous trend over time. Option D is wrong because while a line chart effectively shows trends over time, it lacks the filled area that visually emphasizes cumulative growth; the area chart is specifically designed to highlight the magnitude of change and accumulation.
Refer to the exhibit. A data analyst is unable to run a query on the customers table after October 1, 2023. What is the reason?
After October 1, the condition fails, and the Allow effect no longer applies, resulting in denial.
Why this answer
The policy explicitly allows access only before October 1, 2023, meaning any query attempt on or after that date is denied. This is a time-based access control condition often implemented using a policy engine that checks the current time against a condition. Since the query fails after October 1, 2023, the policy's effective date restriction is the direct cause.
Exam trap
CompTIA often tests the distinction between an explicit deny and an implicit deny caused by a missing allow condition; the trap here is that candidates mistakenly think the policy contains an explicit 'deny after date' statement, when in reality it simply grants access only before the date, relying on the default implicit deny for all other times.
How to eliminate wrong answers
Option A is wrong because the resource name being incorrect would cause a different error (e.g., 'Table not found' or 'Invalid resource'), not a time-based denial. Option C is wrong because `SELECT` is the correct SQL action for reading data; the policy uses `SELECT` as the action identifier, not `READ`, and changing it would not resolve the time restriction. Option D is wrong because it misstates the policy logic: the policy does not explicitly deny access after October 1, 2023; instead, it grants access only before that date, which implicitly denies access after it.
The distinction matters because an explicit deny would override any allow, but here the absence of an allow after the date is the issue.
A dashboard needs to show sales trends for each of five regions over the past year. The intended audience wants to compare trends easily. Which chart type is best?
Multiple line charts clearly show each region's trend over time.
Why this answer
A line chart with multiple lines allows the audience to easily compare trends across the five regions over time. Each region can be represented by a separate line, making it simple to see upward or downward trends and compare them side by side. In contrast, a pie chart shows parts of a whole and is not suitable for trend comparison; a stacked bar chart emphasizes composition rather than trends; and an area chart is similar to a line chart but can obscure overlapping trends due to stacking.
In the data lifecycle, which phase involves converting raw data into a usable format for analysis?
Processing transforms raw data into a usable format.
Why this answer
The processing phase in the data lifecycle is specifically where raw data is cleaned, transformed, and structured into a usable format for analysis. This includes operations such as parsing, normalization, deduplication, and conversion into formats like Parquet or Avro, which are optimized for query engines like Apache Spark or Presto.
Exam trap
The trap here is that candidates often confuse 'ingestion' with 'processing' because both involve moving data, but ingestion is about raw data capture, while processing is about transformation and cleaning before analysis.
How to eliminate wrong answers
Option A is wrong because ingestion refers to the initial collection and import of raw data from sources (e.g., via Apache Kafka or Flume) into a storage system, not its transformation into a usable format. Option B is wrong because analysis is the phase where processed data is queried, visualized, or modeled to derive insights, not where raw data is converted. Option C is wrong because archival involves moving older or infrequently accessed data to long-term storage (e.g., Amazon S3 Glacier or tape) for compliance or cost savings, not for preparing data for analysis.
A data analyst wants to segment customers based on purchasing behavior such as frequency, monetary value, and recency. Which TWO clustering evaluation methods can help determine the optimal number of clusters? (Select two.)
Measures how similar an object is to its own cluster vs others.
Why this answer
The elbow method uses within-cluster sum of squares, and the silhouette score measures cohesion and separation. Both help choose k. Correlation coefficient is for association, not clustering.
ANOVA and t-test are for hypothesis testing.
A database has a table that violates 2NF because it contains a composite primary key and some attributes depend only on part of that key. Which normal form would be violated next if the table is not addressed?
Correct. Because the table violates 2NF, it cannot achieve 2NF, so the next normal form in sequence (3NF) will also be violated if the issue is not fixed.
Why this answer
The table already violates 2NF. If not addressed, it will never satisfy 2NF, but the question asks which normal form would be violated next if the table is not addressed. Since 2NF is already violated, the next normal form in sequence that will be violated is 3NF, because the table will fail to meet 3NF requirements (e.g., transitive dependencies) while still being stuck at a 2NF violation.
Therefore, 3NF is the next normal form that would be violated.
Exam trap
The trap is that candidates may think 'next violated' means the next higher normal form after the current violation, but they might incorrectly pick 3NF as the answer because the table already violates 2NF. However, the correct reasoning is that since 2NF is already violated, the next normal form that would be violated is indeed 3NF, not 2NF again.
How to eliminate wrong answers
Option A is correct because 2NF is already violated, and the question asks which normal form would be violated next, not which is currently violated. Option B is wrong because BCNF is a stricter version of 3NF and requires that the table be in 3NF first; since 2NF is not satisfied, BCNF is not the next violation. Option C is wrong because 3NF is the next normal form that would be violated after 2NF, but the question's answer key marks 2NF as correct, which is a trap; the correct next violation is 3NF, not 2NF.
Option D is wrong because 1NF is already satisfied (the table has atomic values and a primary key), and 1NF violation would occur before 2NF, not after.
A data analyst is asked to compare the average sales across three different store locations. The data is normally distributed and variances are approximately equal. Which statistical test is most appropriate?
ANOVA is designed for comparing means of 3+ groups.
Why this answer
ANOVA is used to compare means of three or more groups when assumptions of normality and equal variance are met.
Which TWO of the following are best practices for designing a data dashboard?
Consistent colors help users quickly interpret data.
Why this answer
Consistent color schemes (e.g., red for critical, yellow for warning, green for normal) allow users to instantly interpret performance levels without cognitive overload. This aligns with dashboard design principles that prioritize clarity and rapid pattern recognition over decorative elements.
Exam trap
The trap here is that candidates confuse 'visually appealing' with 'effective communication' — CompTIA often tests that decorative elements like 3D effects and animations reduce data accuracy and user comprehension, even though they may look impressive.
A healthcare database stores patient records. Each patient has a unique patient_id, and the database includes a table 'visits' with visit_id, patient_id, visit_date, and diagnosis_code. To ensure data integrity, which constraint should be applied to the patient_id column in the 'visits' table?
A foreign key constraint ensures that patient_id in visits references a valid patient_id in the patient table.
Why this answer
A foreign key constraint ensures that patient_id in visits references a valid patient_id in the patient table. Option A is wrong because a unique constraint prevents duplicate values but allows one NULL, and does not enforce referential integrity. Option C is wrong because a primary key ensures uniqueness and serves as the table's identifier, but it does not enforce relationships between tables.
Option D is wrong because a check constraint validates values based on a condition, not referential integrity.
An analyst is performing a logistic regression to predict customer churn (yes/no). The model outputs a probability of 0.75 for a particular customer. Which of the following best describes the interpretation?
Correct interpretation of logistic regression output.
Why this answer
Logistic regression outputs the probability that the event (churn) occurs, given the input features.
A data analyst needs to create a dashboard that updates automatically every hour. The data source is a large database. Which approach minimizes performance impact?
Incremental refresh minimizes database load.
Why this answer
Incremental refresh queries only new or changed records since the last refresh, drastically reducing data transfer and processing load on the large database. This approach uses change-tracking mechanisms (e.g., timestamps, CDC) to avoid full-table scans, minimizing performance impact while maintaining near-real-time updates.
Exam trap
CompTIA often tests the misconception that 'more data is better' or that full refreshes are simpler and equally acceptable, but the trap here is ignoring the performance cost of full database scans on large datasets in favor of the more efficient incremental approach.
How to eliminate wrong answers
Option A is wrong because querying the entire database each hour performs a full table scan on a large database, causing excessive I/O, CPU, and memory usage that degrades performance for all users. Option C is wrong because exporting the entire database to Excel and importing it adds unnecessary data transformation overhead, loses real-time capability, and still requires a full data pull. Option D is wrong because a static monthly report does not meet the requirement for automatic hourly updates and provides stale data, making it functionally incorrect for the use case.
Which THREE of the following are valid data quality dimensions? (Choose THREE.)
Completeness is a data quality dimension.
Why this answer
Completeness is a core data quality dimension that measures whether all required data is present. In the context of the DA0-001 exam, completeness ensures that no fields or records are missing, which is fundamental for reliable analysis and reporting.
Exam trap
CompTIA often tests the distinction between data quality dimensions and data management techniques, so candidates may mistakenly select encryption or redundancy because they sound like important data concepts, but they are not part of the standard quality dimensions.
An operations manager needs to monitor manufacturing line status every 15 minutes to identify bottlenecks. Which type of report should be used?
Correct. Operational reports are designed for real-time operational monitoring.
Why this answer
Operational reports provide real-time or near-real-time data for monitoring ongoing operations.
An analyst is conducting an A/B test on a new checkout process. To calculate sample size, which THREE factors must be considered?
Effect size is the minimum practical difference to detect.
Why this answer
Statistical power, significance level (alpha), and desired effect size (minimum detectable effect) are essential for sample size calculation.
A data engineer is tasked with acquiring data from a third-party vendor that provides daily file drops via SFTP. The files are large (10 GB each). The pipeline must load data into a data warehouse. Which approach optimizes for speed and reliability?
Streaming minimizes latency and storage overhead.
Why this answer
Streaming the file directly from SFTP into the warehouse using a data pipeline tool (e.g., Apache NiFi, Airbyte, or Fivetran) eliminates the intermediate staging step, reducing disk I/O and latency. This approach leverages incremental processing and parallel streams to handle large 10 GB files efficiently, while built-in retry and checkpoint mechanisms ensure reliability against network interruptions.
Exam trap
The trap here is that candidates assume 'download then load' (Option A) is the most reliable approach, but the question specifically asks for speed and reliability, and streaming avoids the I/O bottleneck and single-point-of-failure of a staging server.
How to eliminate wrong answers
Option A is wrong because downloading the file to a staging server introduces an unnecessary intermediate write and read cycle, doubling I/O time and adding a single point of failure; bulk insert after full download also delays loading until the entire file is present, which is suboptimal for speed. Option C is wrong because having the vendor push data via API instead of SFTP does not inherently optimize speed or reliability for large daily file drops—APIs often have payload size limits (e.g., 10 MB) and require chunking, adding complexity and potential throttling, while SFTP is already a reliable file transfer protocol. Option D is wrong because splitting the file into smaller chunks and loading concurrently can cause resource contention (e.g., connection pool exhaustion, lock contention) and requires careful coordination to maintain data consistency; it does not address the fundamental bottleneck of downloading the entire file before processing.
Refer to the exhibit. A data analyst is reviewing a data quality report. Which of the following actions should the analyst take first?
Correct. Root cause analysis should precede any corrective action.
Why this answer
The first step in data quality remediation is root cause analysis. Without understanding why 1200 records have null emails (e.g., a source system bug, a failed ETL join, or a missing required field), any corrective action like deletion or placeholder insertion risks introducing bias or masking a systemic issue. Investigating the source system aligns with the data governance principle of 'fix the source, not the symptom.'
Exam trap
CompTIA often tests the principle that 'fix the source, not the symptom'—the trap here is that candidates jump to data cleansing actions (delete, fill, ignore) without first diagnosing why the nulls exist, which is a classic data quality management mistake.
How to eliminate wrong answers
Option A is wrong because deleting 1200 records with null emails reduces dataset size and may discard valid records if the nulls are due to a temporary system glitch, not actual missing data. Option B is wrong because filling null emails with a placeholder (e.g., 'unknown@domain.com') introduces false data that can skew analysis, violate email format constraints, and mislead downstream processes. Option D is wrong because ignoring nulls assumes they are non-critical without verification; in many contexts (e.g., customer communications, deduplication), missing emails are critical and can lead to incomplete insights or compliance issues.
A healthcare organization must ensure patient data privacy when sharing reports with external auditors. Which practice is most important?
Pseudonymization de-identifies data while retaining analytical value, meeting HIPAA requirements for sharing with auditors.
Why this answer
Pseudonymization replaces identifying information with pseudonyms, allowing data utility while protecting privacy. Aggregation reduces granularity but may still reveal identities; encryption secures transport but not the content; obtaining consent is impractical for large datasets.
A data analyst wants to retrieve the top 5 highest-paid employees from the 'employees' table. Which SQL clauses could be used to achieve this? (Select TWO.)
Sorts highest to lowest.
Why this answer
ORDER BY salary DESC sorts descending, and LIMIT/TOP/FETCH restricts rows.
A data analyst is preparing a presentation for the executive team to explain why quarterly revenue fell short of targets. They want to use storytelling with data. Which THREE elements should be included in the narrative arc? (Choose three.)
Correct. The resolution provides the path forward.
Why this answer
Situation sets context, complication introduces the problem, and resolution provides the solution. Data details are not part of the high-level narrative arc.
A manufacturing company has two primary data systems: an ERP system that stores production orders with fields like OrderID, ProductID, Quantity, and ProductionDate, and a CRM system that stores customer sales with fields like SaleID, CustomerID, ProductID, SaleDate, and Amount. The data analyst needs to create a unified view of product performance by joining these tables. However, the ProductID field in the ERP uses a 5-character alphanumeric code (e.g., 'P1234'), while the CRM uses a 6-character code (e.g., 'PR1234'). Additionally, some products have multiple entries due to slight variations in naming. The analyst wants to ensure accurate matching without losing data. Which action should the analyst take first to address the data inconsistency?
Correct: Standardization of keys is necessary before joining.
Why this answer
Creating a mapping table allows the analyst to explicitly define the relationship between the 5-character ERP ProductID and the 6-character CRM ProductID, ensuring accurate joins without data loss. This approach standardizes the inconsistent formats and handles variations by providing a controlled, deterministic lookup, which is essential for maintaining referential integrity in a unified view.
Exam trap
The trap here is that candidates may choose fuzzy matching (Option D) thinking it handles all variations, but CompTIA often tests the principle that deterministic mapping is preferred over probabilistic methods when the inconsistency is systematic and can be resolved with a known transformation.
How to eliminate wrong answers
Option B is wrong because data profiling only identifies the unique values and their frequencies but does not resolve the format mismatch; it merely highlights the problem without providing a mechanism to align the keys for joining. Option C is wrong because aggregating by product name and ignoring ProductID mismatches would lose the precise linkage between production and sales data, leading to inaccurate performance metrics and potential duplication or omission of records. Option D is wrong because fuzzy matching introduces probabilistic uncertainty and may create false positives or miss exact matches due to the systematic difference in code length and prefix, whereas a deterministic mapping table ensures exact, reliable joins.
A data analyst needs to visualize the distribution of a continuous variable across different categories. Which chart type is most suitable?
Box plot displays distribution across groups.
Why this answer
A box plot (option D) is the most suitable chart for visualizing the distribution of a continuous variable across different categories because it displays the median, quartiles, and potential outliers for each group, enabling direct comparison of spread and central tendency. Unlike a histogram, which shows the distribution of a single continuous variable without categorical grouping, the box plot inherently supports categorical axes. This makes it ideal for exploratory data analysis when assessing how a metric like revenue varies by region or product category.
Exam trap
CompTIA often tests the distinction between histograms and box plots by presenting a scenario where a candidate mistakenly chooses a histogram for grouped categorical data, overlooking that histograms require a continuous x-axis and cannot inherently separate categories without additional faceting.
How to eliminate wrong answers
Option A is wrong because a bar chart is designed for comparing categorical data using discrete counts or sums, not for showing the distribution of a continuous variable across categories. Option B is wrong because a histogram visualizes the distribution of a single continuous variable using bins, but it does not natively separate data into distinct categories; you would need faceting or multiple histograms, which is less efficient than a box plot. Option C is wrong because a scatter plot is used to examine the relationship between two continuous variables, not to compare distributions of one continuous variable across categories.
During a presentation, a stakeholder questions the validity of a data insight because the sample size appears small. The analyst knows the sample is statistically significant. What is the best way to address this concern?
This provides statistical context to reassure the stakeholder.
Why this answer
It directly addresses the stakeholder's concern by explaining the statistical concepts of margin of error and confidence interval, which demonstrate that the sample size is sufficient for the desired level of precision. This approach validates the data insight's reliability without dismissing the stakeholder's valid question, aligning with best practices in communicating data insights.
Exam trap
The trap here is that candidates may assume a small sample size is always invalid, but the DA0-001 exam tests understanding that statistical significance depends on the margin of error and confidence interval, not just sample size alone.
How to eliminate wrong answers
Option A is wrong because ignoring the question undermines trust and fails to address a legitimate concern about data validity, which is critical in data-driven presentations. Option C is wrong because asking for blind trust is unprofessional and does not provide the technical justification needed to alleviate doubts about sample size significance. Option D is wrong because agreeing to collect more data is unnecessary when the sample is already statistically significant, and it delays decision-making without addressing the underlying statistical reasoning.
A data analyst is designing a dashboard for executives. Which best practice should be followed?
Clean design improves readability and decision-making.
Why this answer
Reducing clutter helps viewers focus on key insights without distraction.
A business user wants to explore sales data without relying on the data team. Which report type empowers the user to create their own analysis?
Correct. Self-service enables user-driven analysis.
Why this answer
Self-service reports allow users to query and analyze data independently using BI tools.
A data analyst is profiling a new dataset containing customer information. When assessing data quality, which metric would be most appropriate to determine if the 'email' column contains valid email addresses?
Pattern analysis can verify if values match the typical email format.
Why this answer
Pattern analysis (e.g., using regular expressions) can validate whether strings match the expected format of an email address. Row counts, null counts, and cardinality do not validate format.
An analyst is presenting findings to a non-technical audience. The data shows a 20% increase in customer churn after a price change. Which presentation approach is BEST?
A bar chart is simple, visual, and directly shows the comparison without jargon.
Why this answer
A simple bar chart visually and intuitively communicates the 20% increase in churn to a non-technical audience without requiring statistical literacy. This approach aligns with best practices for presenting data insights to stakeholders who need clear, actionable takeaways rather than technical details.
Exam trap
The trap here is that candidates often overcomplicate the presentation by choosing technical options (like p-values or models) to demonstrate rigor, forgetting that the exam prioritizes audience-appropriate communication over statistical depth.
How to eliminate wrong answers
Option A is wrong because explaining a p-value introduces statistical significance testing, which is unnecessary and confusing for a non-technical audience that only needs to understand the magnitude of the change. Option B is wrong because providing the raw data table overwhelms the audience with numbers and fails to highlight the key insight (the 20% increase) effectively. Option D is wrong because showing a complex statistical model is inappropriate for a non-technical audience, as it obscures the simple before-and-after comparison and may lead to misinterpretation or disengagement.
A data analyst is using the IQR method to identify outliers in a dataset. The first quartile (Q1) is 25 and the third quartile (Q3) is 45. What is the upper bound for identifying outliers?
Correct: Q3 + 1.5*(Q3-Q1).
Why this answer
Upper bound = Q3 + 1.5 * IQR; IQR = Q3 - Q1 = 20; 1.5*20 = 30; 45+30 = 75.
A data analyst is performing data cleaning. Which THREE steps are part of this process? (Choose three.)
Standardizing formats and fixing typos are cleaning tasks.
Why this answer
Correcting inconsistent data (Option A) is a core data cleaning step because it ensures that values follow a consistent format, such as standardizing date formats (e.g., 'MM/DD/YYYY' vs 'DD-MM-YYYY') or fixing capitalization (e.g., 'USA' vs 'usa'). This process directly addresses data quality issues that arise from human entry errors or system differences, making the dataset reliable for analysis.
Exam trap
The trap here is that candidates confuse data cleaning with data transformation or feature engineering, leading them to select normalization or feature engineering as cleaning steps, when in fact cleaning strictly addresses data quality issues like consistency, completeness, and uniqueness.
A data analyst sees this error in the ETL logs. What is the most likely cause?
The log is newer, indicating changes that need a full refresh.
Why this answer
The error indicates that the materialized view's underlying data has changed since its last refresh. Materialized views rely on change tracking (e.g., logs or timestamps) to perform incremental refreshes. If the source data was modified after the last refresh, the view cannot be incrementally refreshed—a full refresh is required instead.
This mismatch between the view's snapshot and the source data is a common cause of refresh failures in ETL processes.
Exam trap
CompTIA Data+ often tests the distinction between incremental (fast) and full refreshes. Candidates may confuse a source modification with a dropped table or permission issue, but the error message specifically points to a change in the underlying data after the last refresh, not to structural or permission problems.
How to eliminate wrong answers
Option B is wrong because dropping the source table would cause a different error (e.g., 'table or view does not exist') rather than a log-related error. Option C is wrong because a permission issue would typically result in an 'insufficient privileges' error, not a log mismatch. Option D is wrong because a network timeout would produce a connection error (e.g., ORA-12170 or ORA-03113), not a materialized view log inconsistency.
Which THREE of the following are characteristics of a relational database?
Referential integrity ensures relationships.
Why this answer
Relational databases enforce referential integrity through foreign keys, which ensure that relationships between tables remain consistent. A foreign key in a child table must match a primary key value in the parent table, preventing orphaned records and maintaining data integrity.
Exam trap
The trap here is that candidates may confuse key-value stores or document databases with relational databases, especially when they hear terms like 'keys' or 'documents' in other contexts, but relational databases strictly use tables, rows, columns, and SQL.
Drag and drop the steps to resolve data integration conflicts in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Conflict resolution starts with identification, analysis, standardization, transformation, and merging.
A company uses an OLTP system for processing customer transactions. Which characteristic is most important for this system to ensure that each transaction is processed reliably, even if multiple users access the system simultaneously?
ACID ensures transactions are processed reliably and consistently.
Why this answer
ACID properties (Atomicity, Consistency, Isolation, Durability) are essential for OLTP systems to ensure reliable transaction processing.
A data analyst wants to visualize the distribution of employee salaries across departments and identify any outliers. Which chart type would best show quartiles, median, and potential outliers?
Box plots show five-number summary and outliers.
Why this answer
A box plot displays the median, quartiles (Q1 and Q3), and outliers, making it ideal for identifying outliers in distribution.
A data analyst is preparing a report to present to a mixed audience of technical and non-technical stakeholders. Which THREE techniques should the analyst use to ensure effective communication? (Choose three.)
Addressing diverse interests makes the report relevant to all.
Why this answer
Tailoring the narrative to address different concerns ensures that both technical and non-technical stakeholders receive relevant insights. For non-technical audiences, the analyst should focus on business impact and high-level trends, while for technical audiences, deeper data nuances can be included. This approach aligns with the DA0-001 domain of Communicating Data Insights, where audience analysis is critical for effective data storytelling.
Exam trap
The trap here is that candidates often confuse 'consistency' with 'clarity,' mistakenly believing that using a single chart type (Option B) simplifies the message, when in fact it can hide critical patterns that require different visual encodings.
An analyst creates a scatter plot with three variables: X, Y, and a third variable represented by the size of the markers. This chart is called a:
Bubble charts are scatter plots with a third dimension represented by bubble size.
Why this answer
A bubble chart is a variation of a scatter plot where a third numeric variable is encoded by the size (area) of the markers. This allows the visualization of three dimensions of data simultaneously on a two-dimensional plane, making it the correct choice for the described chart.
Exam trap
The trap here is that candidates confuse a bubble chart with a heat map because both can represent three variables, but the heat map uses color gradients on a grid, not marker size on a scatter plot.
How to eliminate wrong answers
Option A is wrong because a heat map uses color intensity to represent the magnitude of a third variable across two categorical axes, not marker size. Option B is wrong because a treemap uses nested rectangles (tiles) to display hierarchical data, with area encoding a quantitative value, and does not use X/Y coordinates or marker sizes. Option D is wrong because a waterfall chart shows cumulative effects of sequential positive or negative values, typically in a financial context, and does not involve scatter plot markers or a third variable encoded by size.
Which statistical test should be used to determine if there is a significant association between two categorical variables, such as gender and product preference?
Correct test for categorical variables.
Why this answer
The chi-square test of independence is used to test association between two categorical variables.
A data analyst uses the following query: SELECT department, AVG(salary) AS avg_salary FROM employees GROUP BY department HAVING AVG(salary) > 50000. What is the purpose of the HAVING clause in this query?
HAVING filters groups after GROUP BY.
Why this answer
HAVING filters groups after aggregation, similar to WHERE but for aggregated results.
A data analyst needs to display the distribution of customer ages in a dataset. The ages range from 18 to 85, and the analyst wants to see the shape of the distribution and identify any outliers. Which chart type should be used?
Histograms show the distribution shape of continuous data.
Why this answer
A histogram shows the distribution of a continuous variable, while a box plot shows quartiles and outliers. The question asks for distribution shape, so histogram is more appropriate.
After merging two datasets, an analyst finds that the resulting dataset has many null values in some columns. Which TWO steps should the analyst take to address this? (Select two.)
Median imputation preserves dataset size and reduces bias.
Why this answer
Imputing nulls with the median is a standard technique for handling missing numerical data, especially when the distribution is skewed or contains outliers. The median is robust to extreme values and preserves the central tendency of the column, making it a safe choice for many analytical models. This approach avoids data loss while maintaining statistical integrity.
Exam trap
The trap here is that candidates may think 'Ignore nulls and proceed' is acceptable, but the exam tests the understanding that nulls must be actively handled to ensure data quality and model validity, not simply overlooked.
A table Orders has OrderID (primary key), CustomerID, and CustomerEmail. During analysis, it is found that CustomerID uniquely identifies CustomerEmail. Which normal form is violated if both CustomerID and CustomerEmail are stored in this table?
CustomerEmail depends on CustomerID, which is a non-key attribute, creating a transitive dependency violating 3NF.
Why this answer
The table violates Third Normal Form (3NF) because CustomerEmail is transitively dependent on CustomerID, which is not a candidate key. In 3NF, every non-key attribute must depend only on the primary key (OrderID), not on another non-key attribute. Since CustomerID uniquely identifies CustomerEmail, CustomerEmail depends on CustomerID, not directly on OrderID, creating a transitive dependency.
Exam trap
The trap here is that candidates often confuse transitive dependencies with partial dependencies, mistakenly thinking that because CustomerID is not part of the primary key, the violation is 2NF rather than 3NF.
How to eliminate wrong answers
Option A is wrong because Second Normal Form (2NF) requires that all non-key attributes are fully functionally dependent on the entire primary key; here, the primary key is a single column (OrderID), so there is no partial dependency, and 2NF is satisfied. Option C is wrong because a violation does exist — the transitive dependency between CustomerID and CustomerEmail breaks 3NF. Option D is wrong because First Normal Form (1NF) is not violated; the table has atomic values and a primary key, so it meets 1NF requirements.
A data analyst runs the following query: SELECT DISTINCT city FROM customers. What is the primary purpose of using the DISTINCT keyword in this query?
DISTINCT eliminates duplicate rows, returning unique city values.
Why this answer
DISTINCT removes duplicate rows from the result set. In this query, it returns each unique city name only once.
A dashboard designer is creating a KPI dashboard for executives. Which of the following is a leading indicator?
Leads are a leading indicator of future sales.
Why this answer
Number of qualified leads is a leading indicator as it predicts future sales, while revenue and customer churn are lagging indicators.
A data scientist runs a linear regression model to predict customer spending based on income. The R-squared value is 0.45 and the p-value for the slope coefficient is 0.03. At a significance level of α=0.05, which of the following conclusions is correct?
Correct: p<0.05 indicates significance; R²=0.45 indicates explained variance.
Why this answer
The p-value (0.03) is less than α (0.05), so the slope is statistically significant. R²=0.45 means the model explains 45% of the variance.
A company is implementing a data lifecycle management policy. Which stage occurs immediately after data is created?
Data is stored immediately after creation to be available for processing and analysis.
Why this answer
In the data lifecycle management (DLM) model, the stage immediately following data creation is storage. Once data is generated or ingested, it must be persisted to a storage medium (e.g., disk, SSD, cloud object store) before any other operations like analysis, archival, or deletion can occur. This ensures data durability and availability for subsequent lifecycle stages.
Exam trap
CompTIA often tests the misconception that analysis or processing is the immediate next step after data creation, but the correct sequence in DLM always begins with storage to ensure data persistence.
How to eliminate wrong answers
Option B (Deletion) is wrong because deletion is a final stage in the lifecycle, occurring only after data is no longer needed and retention policies have expired. Option C (Archival) is wrong because archival is a later stage where data is moved to long-term, lower-cost storage after its active use period. Option D (Analysis) is wrong because analysis happens after data is stored and typically after it has been processed or transformed, not immediately upon creation.
Which TWO of the following are examples of unstructured data? (Select 2)
Video files are unstructured.
Why this answer
A is correct because MP4 video files contain binary data that lacks a predefined schema or tabular structure, making them a classic example of unstructured data. Unlike structured data, MP4 files store audiovisual content in a container format that cannot be easily queried or analyzed without specialized processing.
Exam trap
The trap here is that candidates often confuse semi-structured data (XML, JSON, CSV) with unstructured data, forgetting that semi-structured data still has a defined schema or metadata, unlike raw binary or free-form text.
A financial analyst at a bank is preparing a report on loan default risks to the risk management committee. The committee includes both technical (quantitative analysts) and non-technical (business managers) members. The analyst has built a logistic regression model that outputs probability scores for default. The model's performance is good, but the committee wants to understand the key drivers of default. The analyst needs to communicate both the model's accuracy and the impact of each feature. The report should be concise and persuasive, leading to policy changes. What is the best approach?
Intuitive visualization that explains contributions clearly to all audiences.
Why this answer
A waterfall chart visually decomposes a single prediction into the additive contributions of each feature, making it intuitive for both technical and non-technical stakeholders to see which factors drive default risk. This approach directly addresses the committee's need to understand key drivers while keeping the report concise and persuasive for policy changes, unlike abstract metrics or tables.
Exam trap
The trap here is that candidates often pick Option C (feature importance bar chart and coefficients) thinking it is the most direct way to show feature impact, but they overlook that coefficients are on the log-odds scale and not easily interpretable by non-technical managers, whereas a waterfall chart provides a concrete, additive explanation for a single prediction.
How to eliminate wrong answers
Option A is wrong because a technical white paper is too detailed and jargon-heavy for non-technical business managers, failing the requirement for a concise and persuasive report. Option C is wrong because a feature importance bar chart and coefficient table require statistical literacy to interpret correctly, and coefficients in logistic regression are on the log-odds scale, which is not intuitive for non-technical audiences. Option D is wrong because a confusion matrix and AUC-ROC curve only communicate overall model accuracy and discrimination, not the impact of individual features on predictions, which is what the committee explicitly asked for.
Which THREE are considered best practices in dashboard design? (Select three.)
Heat maps effectively show correlation matrices.
Why this answer
Heat maps effectively visualize correlation by using color intensity to represent the strength of relationships between two variables, making patterns and outliers immediately apparent. This aligns with best practices for dashboard design, which prioritize clarity and rapid insight over decorative elements.
Exam trap
CompTIA often tests the misconception that adding visual flair (like 3D effects) or exhaustive data improves a dashboard, when in reality these choices degrade readability and violate core principles of effective data visualization.
A data analyst wants to compare the revenue across five different product categories. Which chart type is best suited?
Bar charts are best for comparing categories.
Why this answer
Bar charts are ideal for comparing categories because they display discrete values side by side.
A data analyst is using Power BI to create a report that shows sales by region. The data includes duplicate rows for some transactions due to a data entry error. The analyst needs to count only unique transactions. Which DAX function should be used to create a measure for unique count?
DISTINCTCOUNT counts distinct values in a column, ignoring duplicates.
Why this answer
DISTINCTCOUNT is the DAX function specifically for counting unique values in a column.
A data analyst is building a linear regression model to predict sales based on advertising spend. The analyst notices that the residuals are not normally distributed and have a non‑constant variance. Which of the following transformations is most appropriate to apply to the dependent variable?
Log transformation is commonly used to stabilize variance and make residuals more normally distributed.
Why this answer
The logarithmic transformation is the most appropriate choice because it stabilizes non‑constant variance (heteroscedasticity) and helps make the residuals more normally distributed, which are key assumptions for linear regression. By compressing the scale of the dependent variable (sales), it reduces the impact of large values and often linearizes multiplicative relationships, such as diminishing returns from advertising spend.
Exam trap
CompTIA often tests the misconception that any scaling technique (standardization or normalization) can fix heteroscedasticity or non‑normality, but these methods only change the range or center of the data, not the shape of the residual distribution or the variance structure.
How to eliminate wrong answers
Option A is wrong because standardization (z-score) centers and scales the data to mean 0 and standard deviation 1, but it does not address heteroscedasticity or non‑normal residuals; it merely changes the units of the dependent variable without altering the shape of the distribution. Option B is wrong because normalization (min-max scaling) rescales the data to a fixed range (e.g., 0 to 1), which also fails to correct non‑constant variance or non‑normality; it is primarily used for feature scaling in algorithms like neural networks, not for satisfying regression assumptions. Option D is wrong because the square root transformation is typically used for count data (e.g., Poisson-distributed outcomes) to stabilize variance, but it is less effective than the log transformation when the variance increases proportionally with the mean, which is common in sales data; the log transformation is the standard choice for multiplicative relationships and heteroscedasticity.
A data architect needs to store raw data from various sources, including social media feeds and log files, for future analysis. The data may be used for machine learning and ad-hoc queries. Which storage solution is most appropriate for storing raw data in its native format?
Data lakes store raw data in native formats, allowing flexible schema-on-read.
Why this answer
A data lake is designed to store raw data in its native format, including unstructured and semi-structured data from sources like social media feeds and log files. It supports schema-on-read, making it ideal for future machine learning and ad-hoc queries without requiring upfront transformation. This aligns directly with the requirement to preserve raw data for flexible analysis.
Exam trap
The trap here is that candidates confuse a data lake with a data warehouse, assuming both are for analytics, but the key distinction is that a data warehouse requires structured, transformed data while a data lake preserves raw, native-format data.
How to eliminate wrong answers
Option B is wrong because a data mart is a subset of a data warehouse optimized for a specific business domain, not for storing raw, diverse data in native format. Option C is wrong because a relational database enforces a rigid schema and ACID constraints, making it unsuitable for unstructured data like social media feeds and log files. Option D is wrong because a data warehouse stores processed, structured data optimized for reporting and BI, not raw data in its native format.
A data analyst is tasked with collecting data from multiple spreadsheets provided by different departments. Each spreadsheet has different column names and formats. What is the best first step?
Standardization ensures all data sources align, making subsequent loading and analysis consistent.
Why this answer
Developing a data dictionary and standardizing column names ensures consistency across all data sources before loading, reducing errors and facilitating integration. Immediately loading data can cause inconsistencies. Discarding mismatched data loses potentially valuable information.
Using a machine learning model is an unnecessary and complex first step.
A data analyst notices that customer addresses in the database contain invalid ZIP codes. Which data quality dimension is being violated?
Validity ensures data adheres to specified formats and rules, such as valid ZIP codes.
Why this answer
A is correct because validity refers to the degree to which data conforms to its defined format, rules, or constraints. Invalid ZIP codes (e.g., a five-digit code containing letters or a non-existent postal code) directly violate the format and domain rules expected for that field, making this a validity issue.
Exam trap
The trap here is that candidates confuse 'validity' with 'completeness' or 'consistency,' mistakenly thinking a missing or mismatched ZIP code is a completeness or consistency issue, when in fact the violation is about the data not conforming to the required format or rule set.
How to eliminate wrong answers
Option B (Timeliness) is wrong because timeliness concerns whether data is available when needed, not whether individual values match expected formats. Option C (Consistency) is wrong because consistency checks for logical coherence across related data sets or fields (e.g., ZIP code matching city/state), not the intrinsic correctness of a single value. Option D (Completeness) is wrong because completeness measures whether all required data is present (e.g., missing ZIP codes), not whether present data is correctly formatted.
An analyst is creating a report to show the relationship between advertising spend and website traffic over the past 12 months. The data has a few outliers due to special promotional events. Which chart type should the analyst use to clearly show the trend while minimizing the impact of outliers?
Scatter plots show the relationship and outliers; a trend line summarizes the pattern.
Why this answer
A scatter plot with a trend line (Option D) is the best choice because it plots each data point individually, allowing the analyst to see the overall relationship between advertising spend and website traffic while the trend line (often a linear regression line) smooths out the influence of outliers. This chart type minimizes the visual impact of extreme values by focusing on the central tendency and direction of the data, making it ideal for identifying trends over 12 months despite promotional event spikes.
Exam trap
The trap here is that candidates often choose a bar chart (Option B) thinking it clearly shows trends over time, but they overlook that bar charts treat each period as a separate category and do not inherently reduce outlier impact, whereas a scatter plot with a trend line explicitly models the relationship and dampens outlier effects.
How to eliminate wrong answers
Option A is wrong because a pie chart shows proportions of a whole at a single point in time, not a trend over 12 months, and it cannot handle outliers or continuous variables like advertising spend and traffic. Option B is wrong because a bar chart compares discrete categories or time periods, but it treats each bar independently and does not inherently minimize outlier impact; outliers can distort the scale and make normal variations hard to see. Option C is wrong because a heatmap visualizes density or intensity across two dimensions using color gradients, which is useful for correlation matrices or geographic data, but it does not effectively show a continuous trend over time and can obscure the specific relationship between spend and traffic.
A data analyst uses a CTE to find employees who earn more than the average salary in their department. Which SQL clause is used to define the CTE?
Correct. WITH defines a CTE.
Why this answer
Common Table Expressions (CTEs) are defined using the WITH keyword, followed by the CTE name and AS (query).
Which data quality dimension is most concerned with whether data values fall within a defined domain or acceptable range?
Validity checks if data follows format and range rules.
Why this answer
Validity refers to whether data values conform to defined rules or constraints.
In Tableau, a data analyst creates a calculated field to compute the average sales per customer. The analyst wants this calculation to remain constant regardless of the level of detail in the view. Which Tableau feature should be used?
LOD expressions control granularity independent of the view.
Why this answer
Level of Detail (LOD) expressions allow calculations to be performed at a specific granularity independent of the view. FIXED LOD can compute average sales per customer and remain constant.
A data scientist applies K-means clustering to a customer dataset. The elbow method suggests using 4 clusters. After running K-means with k=4, the within-cluster sum of squares (WCSS) is plotted against k, and the elbow is at k=4. What does this indicate?
The elbow point is where the rate of decrease sharply changes.
Why this answer
The elbow method suggests that increasing k beyond 4 yields diminishing returns in reducing WCSS; k=4 is a good trade-off.
Refer to the exhibit. What is the best corrective action to resolve this error?
Casting to numeric solves the type mismatch.
Why this answer
The error indicates a data type mismatch; converting the column to numeric in the ETL process ensures compatibility.
Which THREE of the following are properties of ratio data? (Choose THREE.)
Ratio data allows meaningful ratios (e.g., twice as heavy).
Why this answer
Ratio data supports multiplication and division because it has a true, meaningful zero point that indicates the absence of the measured attribute. This allows ratios to be computed (e.g., one value is twice another), which is a defining property of ratio scales in measurement theory.
Exam trap
The trap here is that candidates confuse the 'meaningful zero' property with the ability to have negative values, or they think categorization is a defining feature of ratio data, when it is actually a property shared by all measurement scales.
A data analyst is examining the relationship between advertising spend (in thousands) and sales (in thousands). The Pearson correlation coefficient is computed as r = -0.85. Which of the following interpretations is correct?
Correct: r close to -1 indicates strong negative.
Why this answer
Pearson r measures linear correlation: -0.85 indicates a strong negative linear relationship (as one increases, the other decreases). The magnitude |0.85| is close to 1, so strong.
A data analyst needs to calculate the running total of sales for each product over time. Which window function clause is essential for this calculation?
Correct. Contains both PARTITION BY product_id (for per-product totals) and ORDER BY sale_date (for ordering over time), which together enable a running total with the default frame.
Why this answer
For a running total of sales for each product over time, you must group the calculation by product (PARTITION BY product_id) and order by sale_date (ORDER BY sale_date). The default window frame in SQL (RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) suffices for running totals. Option B provides both PARTITION BY product_id and ORDER BY sale_date, making it essential.
A data analyst trains a complex model that achieves 99% accuracy on training data but only 65% on new data. What is the most likely issue?
The model performs well on training but poorly on test data, a classic sign of overfitting.
Why this answer
The model performs exceptionally well on training data (99% accuracy) but poorly on new data (65% accuracy), which is the classic symptom of overfitting. Overfitting occurs when the model learns noise and specific patterns in the training data rather than generalizing to unseen data, often due to excessive complexity (e.g., too many parameters or deep layers). This results in high variance and poor performance on validation or test sets.
Exam trap
CompTIA often tests the distinction between overfitting and underfitting by presenting a large gap between training and test accuracy, tempting candidates to choose high bias or multicollinearity due to confusion about bias-variance tradeoff or correlation issues.
How to eliminate wrong answers
Option A is wrong because underfitting would show poor performance on both training and new data (e.g., low accuracy on both), not high training accuracy with low test accuracy. Option C is wrong because multicollinearity refers to high correlation among predictor variables in regression models, which inflates coefficient standard errors but does not directly cause a large gap between training and test accuracy. Option D is wrong because high bias typically leads to underfitting, where the model is too simple and performs poorly on both training and test data, not the specific pattern of high training accuracy and low test accuracy seen here.
An e-commerce company is acquiring product data from multiple supplier APIs. The APIs return JSON with inconsistent field naming conventions. Which data acquisition technique should be applied?
Standardizes field names and structures.
Why this answer
Data mapping and transformation is the correct technique because the JSON responses from different supplier APIs use inconsistent field naming conventions (e.g., 'product_id' vs. 'ProductID'). This technique defines a schema to map source fields to a standardized target format, ensuring data consistency before loading into the company's system. Without transformation, downstream processes like analytics or inventory management would fail due to mismatched field names.
Exam trap
The trap here is that candidates confuse data transformation with data aggregation or deduplication, assuming any processing step can fix schema inconsistencies, but only mapping and transformation directly address field naming and structure mismatches.
How to eliminate wrong answers
Option A is wrong because data compression reduces storage size or transfer bandwidth, but does not address structural inconsistencies in field naming. Option C is wrong because data deduplication removes duplicate records based on content, but does not reconcile different field names or schemas. Option D is wrong because data aggregation summarizes or combines data (e.g., sums, averages), but does not resolve naming conflicts or schema mismatches.
A data analyst is cleaning a dataset and finds that the 'age' column has several missing values. Which of the following is a valid method for handling missing numerical data?
Correct: mean imputation is a standard technique.
Why this answer
Mean imputation is a common method for handling missing numerical data, though median or mode can also be used.
Practice DA0-002 by domain
Target a specific domain to shore up weak areas.