509 questions total · 7pages · All types, answers revealed
Page 7 of 7
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 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
Option A is correct because 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.
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
Option B is correct because 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 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.
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
Option B is correct because 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
Option A is correct because 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 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 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.
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 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 dataset contains a column 'Education Level' with values: 'High School', 'Bachelor', 'Master', 'PhD'. An analyst computes the average by assigning numbers 1-4. Which data concept is being violated?
Assigning numbers and averaging assumes equal intervals, which ordinal data lacks.
Why this answer
The analyst assigned numeric values (1-4) to 'Education Level' categories and computed an average. This treats the ordinal data as if it were interval data, assuming equal spacing between categories (e.g., the difference between 'High School' and 'Bachelor' is the same as between 'Master' and 'PhD'), which is not valid. Ordinal data only preserves order, not magnitude or equal intervals, so calculating a mean is inappropriate.
Exam trap
CompTIA often tests the distinction between ordinal and interval scales by presenting a scenario where a mean is computed on ranked categories, tempting candidates to think the error is about nominal vs. ordinal (Option C) rather than the misuse of arithmetic operations on ordinal data.
How to eliminate wrong answers
Option A is wrong because misclassifying data as structured refers to incorrectly labeling unstructured data (e.g., text) as structured, but the dataset already has a structured column; the violation is about measurement scale, not structure. Option C is wrong because treating nominal data as ordinal would involve imposing an order on unordered categories (e.g., colors), but 'Education Level' already has a natural order, so the error is not about misordering but about assuming equal intervals. Option D is wrong because treating ratio data as interval would ignore a true zero point (e.g., income), but 'Education Level' has no meaningful zero, so the violation is not about ratio vs. interval but about ordinal vs. interval.
You are a data analyst at a retail company. Your team has deployed a new dashboard that displays real-time inventory levels across all warehouses. The dashboard uses a traffic light color scheme (green = sufficient, yellow = low, red = out of stock). After one week, the warehouse managers complain that the dashboard is overwhelming because it shows all 500+ products at once, and they cannot quickly identify which items need immediate attention. They request a way to prioritize items that are red or yellow. Additionally, the dashboard updates every second, causing the screen to flicker constantly, which they find distracting. You need to redesign the dashboard to address these issues. Which course of action should you take?
Filter reduces clutter; slower refresh eliminates flicker.
Why this answer
Option A is correct because it directly addresses both user complaints: adding a filter to show only red/yellow items reduces cognitive overload by hiding the 500+ products that are not critical, and reducing the refresh rate from every second to every 5 minutes eliminates distracting screen flicker while still providing near-real-time inventory updates. This approach balances usability with the need for timely alerts without overwhelming the user.
Exam trap
The trap here is that candidates may think increasing refresh rate improves data accuracy, but the real issue is user distraction and information overload, not data latency.
How to eliminate wrong answers
Option B is wrong because sorting alphabetically does not help prioritize critical items (red/yellow), and increasing the refresh rate to every 2 seconds would worsen the flicker issue. Option C is wrong because removing the color scheme removes the quick visual prioritization that the traffic light system provides, and keeping the 1-second refresh rate does not solve the flicker problem. Option D is wrong because adding more colors would increase visual complexity, not reduce it, and increasing the refresh rate to every 500 milliseconds would make the flicker even more distracting.
A hospital's analytics team has created a dashboard for tracking patient wait times across departments. The dashboard uses a stacked bar chart showing average wait time per department, with each bar segmented by severity level (Low, Medium, High). However, management complains that it is difficult to compare total wait times across departments or identify which department has the highest average wait time. The data itself is accurate and complete. The analyst needs to redesign the visualization to address these concerns. Which course of action should the analyst take?
This allows direct comparison of totals and individual segments across departments.
Why this answer
Option A is correct. A grouped bar chart with bars for each department and separate bars for each severity level side-by-side allows direct comparison of total wait times across departments and easy identification of the department with the highest average wait time. Option B is incorrect because line charts are not suitable for categorical comparisons and would clutter the view with many lines.
Option C is incorrect because a pie chart can only show proportions for a single category (e.g., total wait time per department) and does not convey severity levels. Option D is incorrect because a heat map shows patterns but does not clearly compare total wait times across departments; it is harder to read exact values.
A data analyst is working with a dataset containing customer information. The dataset includes a column 'full_name' which stores first and last names together. To perform analysis on first names separately, which data concept describes the process of splitting 'full_name' into 'first_name' and 'last_name'?
Normalization reduces redundancy and breaks down attributes.
Why this answer
Option C is correct because data normalization is the process of organizing data to reduce redundancy and improve integrity, which includes splitting composite attributes like 'full_name' into atomic values ('first_name', 'last_name'). This aligns with the first normal form (1NF) principle in database design, where each column should contain indivisible values. The data analyst is decomposing a single field into multiple, more granular fields to enable separate analysis.
Exam trap
The trap here is that candidates confuse data normalization with data aggregation or summarization, because both involve restructuring data, but normalization focuses on reducing redundancy and achieving atomicity, not on computing summary statistics.
How to eliminate wrong answers
Option A is wrong because data deduplication refers to identifying and removing duplicate records or entries, not splitting a single column into multiple columns. Option B is wrong because data summarization involves aggregating or condensing data (e.g., calculating averages or totals) to provide a high-level view, not decomposing a field. Option D is wrong because data aggregation combines multiple data points into a single summary value (e.g., sum, count), which is the opposite of splitting a field into more granular components.
An analyst is creating a report that includes multiple charts. To ensure the audience quickly grasps the key insight, which principle of data storytelling should be applied?
A title that summarizes the finding helps the audience understand the message immediately.
Why this answer
Starting with a clear title that summarizes the takeaway guides the audience to the main insight. Using a legend only or placing the chart first does not provide context. Avoiding titles reduces clarity.
Which TWO are valid data acquisition methods? (Select two.)
Web scraping extracts data from websites and is a common acquisition method.
Why this answer
Web scraping and API calls are direct methods to acquire data from external sources. Data profiling and data normalization are data preparation techniques, not acquisition. Data encryption is a security measure.
Which TWO of the following are best practices when creating a data visualization for a presentation to stakeholders?
Interactivity lets stakeholders focus on relevant data.
Why this answer
Option A is correct because interactive filters (e.g., slicers, parameter controls) empower stakeholders to drill down into specific data subsets, ask ad-hoc questions, and uncover insights without overwhelming the initial view. This aligns with the principle of user-driven exploration, which is a best practice for stakeholder presentations where different audience members may have varying interests. Including interactivity also reduces the need for multiple static charts, keeping the presentation concise while still offering depth.
Exam trap
CompTIA often tests the misconception that visual embellishments like 3D effects or consistent chart types are always beneficial, when in fact they can obscure data accuracy and limit communicative effectiveness.
An analyst is creating a data story about the decline in customer satisfaction scores. The data shows that satisfaction dropped after a software update. Which narrative structure best helps the audience understand the cause and effect?
This chronological structure clearly shows the cause and its effect.
Why this answer
Option B is correct because it follows a chronological cause-and-effect narrative, starting with the software update event and then showing satisfaction scores before and after. This structure directly maps to the audience's need to understand the causal relationship, as it highlights the intervention point and the resulting change in the metric. In data storytelling, this is known as the 'before-and-after' or 'change-over-time' narrative, which is most effective for demonstrating impact.
Exam trap
The trap here is that candidates often choose Option A because they think starting with the current state is more engaging, but Cisco tests the understanding that a chronological cause-and-effect narrative is required to clearly demonstrate the impact of a specific event, not just a general trend.
How to eliminate wrong answers
Option A is wrong because starting with current scores and then showing historical trend presents the data in reverse chronological order, which obscures the cause-and-effect relationship and forces the audience to infer the impact of the software update from the end of the story. Option C is wrong because presenting all data points without a story fails to provide context or a narrative arc, leaving the audience to interpret the cause-and-effect on their own, which is inefficient and can lead to misinterpretation. Option D is wrong because a pie chart of satisfaction categories shows a static distribution of current satisfaction levels, not the temporal change before and after the software update, and thus cannot illustrate cause and effect.
Match each data type to its example.
Drag a concept onto its matching description — or click a concept then click the description.
Country of origin (e.g., USA, Canada)
Customer satisfaction rating (1-5)
Temperature in Celsius
Annual income in dollars
Gender (Male, Female, Other)
Why these pairings
These are fundamental data types in statistics.
A hospital's patient records system must process thousands of small transactions per second. Which type of database system is best suited for this workload?
OLTP handles many concurrent short transactions efficiently.
Why this answer
OLTP (Online Transaction Processing) systems are designed to handle a high volume of small, concurrent transactions with low latency and high concurrency. This makes them ideal for a hospital patient records system that must process thousands of small transactions per second, such as patient check-ins, prescription updates, and billing entries.
Exam trap
The trap here is that candidates often confuse OLTP with OLAP, mistakenly thinking that 'processing many transactions' implies analytical processing, when in fact OLTP is the correct choice for high-frequency, small, write-heavy workloads.
How to eliminate wrong answers
Option A is wrong because a data mart is a subset of a data warehouse focused on a specific business line (e.g., cardiology), not designed for high-throughput transactional processing. Option C is wrong because a data warehouse is optimized for complex analytical queries on large historical datasets, not for handling thousands of small, real-time transactions per second. Option D is wrong because OLAP (Online Analytical Processing) is used for multidimensional analysis and reporting, not for high-frequency transactional workloads.
Which TWO data types are considered quantitative? (Select two.)
Correct. Although ordinal, it is a numeric rating and considered quantitative.
Why this answer
Customer satisfaction rating (1-5) is quantitative because it represents numerical values that can be measured and subjected to mathematical operations, such as calculating an average. Temperature in Celsius is also quantitative as it is a continuous numerical measurement on an interval scale, allowing for meaningful arithmetic comparisons. Both options involve numeric data that can be analyzed statistically.
Exam trap
The trap here is that candidates often mistake numeric-looking identifiers (like zip codes or employee IDs) for quantitative data, failing to recognize that they are nominal categorical variables with no mathematical significance.
A data scientist has a dataset with 50 variables and wants to identify clusters of similar observations. Which visualization technique is most suitable for reducing dimensionality to 2D while preserving cluster structure?
PCA reduces dimensions while preserving variance, enabling visualization of clusters.
Why this answer
Option C is correct because PCA (or t-SNE) is designed for dimensionality reduction to visualize clusters. Other options are less effective for high-dimensional data.
An e-commerce company wants to provide real-time personalized product recommendations based on customer browsing behavior. Currently, they have a traditional data warehouse that processes batch updates every night. The marketing team complains that recommendations are outdated within hours because customers see yesterday's data. The data engineer needs to modify the architecture to support near-real-time analytics. The budget is limited, and the existing warehouse infrastructure must be reused as much as possible. Which architectural change would best meet the requirement?
Correct: Streaming enables real-time analytics without replacing the warehouse.
Why this answer
Option C is correct because implementing a streaming data pipeline like Apache Kafka enables the ingestion and processing of customer browsing events in near real-time, feeding a dedicated recommendation engine that can update recommendations within seconds or minutes. This approach reuses the existing data warehouse for historical analytics and batch reporting while adding a lightweight streaming layer for low-latency recommendations, aligning with the limited budget and reuse requirement.
Exam trap
The trap here is that candidates may assume increasing batch frequency (Option D) is sufficient for near-real-time needs, but Cisco tests the understanding that 'near-real-time' typically requires sub-minute latency, which batch processing cannot achieve due to scheduling overhead and resource contention.
How to eliminate wrong answers
Option A is wrong because replacing the warehouse with an in-memory database would discard the existing infrastructure entirely, incurring high migration costs and losing the warehouse's batch processing capabilities for other workloads, which violates the constraint to reuse the existing warehouse. Option B is wrong because adding more nodes to the warehouse cluster only improves the throughput of batch processing, but does not reduce the latency of data freshness—recommendations would still be based on data that is at least hours old, failing the near-real-time requirement. Option D is wrong because increasing batch frequency to every hour still introduces a delay of up to 60 minutes, which is insufficient for real-time personalization; moreover, frequent batch loads can cause resource contention and degrade warehouse performance for other queries.
A data analyst is performing hypothesis testing to compare the mean sales of two store locations. Which TWO conditions must be satisfied to use a two‑sample t‑test? (Select TWO.)
Normality is assumed for the t-test, though it is robust for large samples.
Why this answer
Option C is correct because the two-sample t-test assumes that the data in each group are approximately normally distributed. This is a key parametric assumption; if the sample sizes are large (typically n > 30), the Central Limit Theorem can relax this requirement, but for smaller samples, normality must hold to ensure valid test statistics and p-values.
Exam trap
CompTIA often tests the misconception that equal sample sizes or equal variances are required for a two-sample t-test, but the actual core assumptions are independence and normality (or large sample sizes via CLT).
After presenting a data analysis to stakeholders, they ask for additional details on a specific trend. The analyst needs to provide a follow-up report. What is the best approach?
Allows self-paced review and provides clear context.
Why this answer
Option C is correct because a detailed written report with charts and explanations allows stakeholders to review at their own pace and provides depth. Option A is wrong because creating a new dashboard for every request is inefficient. Option B is wrong because raw data files lack context and interpretation.
Option D is wrong because holding another meeting delays information.
An analyst creates a histogram of customer transaction amounts but observes that the distribution looks bimodal. Upon review, the analyst realizes that two different customer segments (retail and wholesale) were combined. Which action best addresses this?
Separate histograms clearly show each segment's distribution and the reason for bimodality.
Why this answer
Splitting the data into two separate histograms by segment reveals the distinct distributions. Changing bin width may hide or exaggerate features. Combining into one chart with color is possible but may still obscure the bimodal nature if overlapping.
A box plot shows medians but not shape.
Refer to the exhibit. An ETL pipeline failed. What is the most likely root cause?
Timeouts and connection resets are classic signs of network problems.
Why this answer
The exhibit shows an ETL pipeline failure with a timeout error, which is a classic symptom of network connectivity issues. When the pipeline cannot reach the source or target system due to a network interruption, the process hangs until a timeout threshold is exceeded, causing the job to fail. This is the most likely root cause because timeouts are directly associated with network problems, not with data format, authentication, or storage issues.
Exam trap
The trap here is that candidates may confuse a timeout error with a data format mismatch or authentication failure, but Cisco tests the understanding that timeouts are uniquely tied to network connectivity issues, not to data content or access permissions.
How to eliminate wrong answers
Option A is wrong because a data format mismatch would typically result in a parsing or schema validation error, not a timeout. Option B is wrong because an authentication failure would produce a 401 Unauthorized or 403 Forbidden error code, not a timeout. Option C is wrong because insufficient disk space would generate a 'disk full' or 'no space left on device' error, not a timeout.
A retail company has merged with another firm and now needs to create a unified customer data warehouse. The existing systems use different data classification methods: System A stores customer income as a categorical range (e.g., '$0-$50k', '$50k-$100k', '$100k+') while System B stores exact income as a decimal number. A data analyst must combine these into a single table. The goal is to perform statistical analysis that includes calculating average income, but the categorical data from System A loses precision. The analyst proposes converting System B's exact values into the same ranges as System A to ensure consistency. However, the data governance team wants to preserve as much detail as possible. Which course of action should the analyst recommend?
This preserves detail from System B and creates a usable numeric field from System A for analysis.
Why this answer
Option C is correct because imputing the midpoint of each income range converts System A's categorical data into a continuous numeric field, allowing it to be combined with System B's exact decimal values. This approach preserves the granularity of System B's data while enabling statistical calculations like average income across the unified dataset, balancing the data governance team's requirement for detail with the need for consistency.
Exam trap
The trap here is that candidates may choose Option B, thinking consistency requires downgrading all data to the lowest common denominator, but the exam tests the ability to preserve precision while achieving integration through transformation techniques like midpoint imputation.
How to eliminate wrong answers
Option A is wrong because storing both columns separately as independent attributes fails to create a unified customer data warehouse and prevents direct statistical analysis across the combined dataset, such as calculating a single average income. Option B is wrong because converting System B's exact decimal values into the same categorical ranges as System A discards precision unnecessarily, violating the data governance team's goal to preserve as much detail as possible. Option D is wrong because discarding System A's data entirely ignores valuable customer information from the merged firm, leading to data loss and an incomplete unified warehouse.
Drag and drop the steps to normalize a database table from 1NF to 3NF in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Normalization proceeds from 1NF to 2NF to 3NF, then table creation and foreign keys.
A data analyst is tasked with presenting the results of a customer churn analysis to a group of marketing managers. The model identified that customers with low engagement scores are 3 times more likely to churn. The analyst wants to effectively communicate this finding to persuade the managers to focus on engagement. Which of the following is the most compelling way to present this insight?
Revenue impact directly connects to business objectives.
Why this answer
Option A is correct because translating the finding into potential revenue impact resonates with managers' business goals. Option B (bar chart) is factual but less persuasive. Option C (scatter plot) is not compelling.
Option D (table) is less engaging.
A data analyst creates a report showing sales by product category. The analyst notices that one category has a very high sales figure due to a one-time bulk order. Which of the following is the best way to communicate this insight to stakeholders?
Annotation provides context for the anomaly.
Why this answer
Option B is correct because it maintains data integrity while providing necessary context. Adding a note to the chart allows stakeholders to understand the anomaly without distorting the underlying data. This approach aligns with best practices in data communication, where transparency about outliers is critical for accurate interpretation.
Exam trap
The trap here is that candidates may think removing or hiding data (options A and C) simplifies the message, but the exam tests the principle that data communication must be transparent and preserve the full context for decision-making.
How to eliminate wrong answers
Option A is wrong because deleting the bulk order from the dataset introduces bias and misrepresents actual sales performance, violating data integrity principles. Option C is wrong because removing the entire category hides the outlier entirely, preventing stakeholders from understanding its impact on overall trends. Option D is wrong because a pie chart would visually exaggerate the proportion of the bulk order category, potentially misleading stakeholders about normal sales distribution.
You are a data analyst at a logistics company. You have created a dashboard to monitor delivery performance. The dashboard includes a scatter plot showing delivery time (hours) vs. distance (miles) for each delivery, with points colored by delivery region (A, B, C, D, E). Users have reported that the scatter plot is cluttered because there are over 10,000 points, making it hard to see patterns. Additionally, the color legend for the five regions uses similar shades of blue, making it difficult to distinguish which region a point belongs to. You need to improve the scatter plot to reduce overplotting and improve region differentiation. Which approach is most effective?
Alpha blending reveals density; distinct colors improve region identification.
Why this answer
Option C is correct because reducing opacity (alpha blending) mitigates overplotting by making overlapping points more transparent, while switching to a qualitative color palette (e.g., distinct hues like red, green, blue) ensures each of the five regions is easily distinguishable. This directly addresses both user complaints without losing the overall distribution context.
Exam trap
The trap here is that candidates often choose small multiples (Option B) thinking they reduce clutter, but the question specifically asks to improve differentiation and reduce overplotting in a single view, and small multiples fragment the data, making cross-region comparison harder.
How to eliminate wrong answers
Option A is wrong because a hexagonal binning plot aggregates points into hexagons based on density, but it cannot encode a categorical variable like region with color inside a single plot—hexbin typically uses a single color gradient for density, not multiple regions. Option B is wrong because creating five separate scatter plots (small multiples) forces users to mentally compare across separate charts, losing the ability to see relative spatial patterns and interactions between regions in a single view. Option D is wrong because converting to a bubble chart by adding package weight as bubble size does not reduce overplotting (it can worsen it with larger circles) and does not improve region differentiation; it introduces a third continuous variable that is not related to the reported issues.
A data analyst receives a dataset with inconsistent date formats (e.g., "01/02/2023", "2023-01-02", "Jan 2, 2023"). Which data quality dimension is most directly affected?
Inconsistent formats directly impact data consistency.
Why this answer
Consistency refers to the uniformity of data representation. Inconsistent date formats violate consistency, not accuracy, completeness, or timeliness.
A dataset contains salaries ranging from $25,000 to $2,500,000, with most salaries under $100,000. Which chart type best shows the distribution without distortion from extreme values?
Box plots show median, quartiles, and outliers, handling skew well.
Why this answer
Option B is correct because box plots display distribution with outliers clearly separated, unaffected by extreme values in terms of scale. Histograms may compress the bulk of data.
A data analyst is performing data acquisition from multiple source files. Which TWO data profiling tasks should the analyst complete before loading the data into the target system?
Verifying data types ensures consistency and prevents errors during loading.
Why this answer
Identifying missing values and verifying data types are fundamental data profiling tasks that help ensure data quality before acquisition. Building models, creating dashboards, or clustering are not part of profiling.
A small business wants to acquire customer feedback through a short questionnaire emailed after purchase. Which data acquisition method does this represent?
A questionnaire is a classic survey tool for collecting feedback.
Why this answer
The correct answer is C because a survey is a structured data collection method where respondents answer predefined questions, typically via a form or questionnaire. In this scenario, the business is using a short questionnaire emailed after purchase to gather customer feedback, which directly aligns with the definition of a survey as a data acquisition method.
Exam trap
The trap here is that candidates may confuse a survey with a transaction log because both can be automated and delivered electronically, but a transaction log captures system events, not user-provided feedback.
How to eliminate wrong answers
Option A is wrong because a transaction log records system-level events such as database changes, user logins, or API calls, not subjective customer feedback via a questionnaire. Option B is wrong because an interview involves a direct, synchronous conversation between an interviewer and a respondent, often with open-ended questions, whereas the scenario describes an asynchronous, self-administered questionnaire. Option D is wrong because observation involves watching and recording behavior or events without direct interaction, whereas the scenario explicitly involves asking customers for their opinions through a questionnaire.
Refer to the exhibit. A data architect is designing a data dictionary for a relational database. Based on the exhibit, which data concept is being illustrated?
The exhibit specifies field properties like nullable and unique, which are constraints on the data.
Why this answer
The exhibit shows a table definition with column attributes such as NOT NULL, UNIQUE, and PRIMARY KEY, which are data constraints that enforce rules on the data values. Data constraints ensure data integrity by restricting what data can be stored in a column, such as preventing null values or duplicate entries. This directly aligns with the concept of data constraints, making option A correct.
Exam trap
The trap here is that candidates may confuse data constraints with data cardinality, because both involve 'rules' in a database, but cardinality specifically describes the nature of relationships between tables, not the column-level restrictions shown in the exhibit.
How to eliminate wrong answers
Option B is wrong because data aggregation involves summarizing or combining data from multiple rows (e.g., using SUM, AVG), which is not illustrated in the table definition. Option C is wrong because data normalization is a process of organizing data to reduce redundancy and dependency, typically involving splitting tables into related tables, not defining column-level constraints. Option D is wrong because data cardinality refers to the relationship between tables (e.g., one-to-many), not the rules applied to individual columns in a table definition.
Which TWO of the following are true about correlation and causation? (Select TWO).
This is a fundamental concept.
Why this answer
Option C is correct because correlation measures the strength and direction of a linear relationship between two variables, but it does not imply that one variable causes the other. Causation requires controlled experiments with randomization to rule out confounding variables and establish a cause-effect relationship.
Exam trap
CompTIA often tests the classic 'correlation does not imply causation' fallacy, where candidates mistakenly think that a statistically significant correlation automatically proves a causal relationship, ignoring the role of chance and confounding variables.
A data analyst is using a public API to collect historical weather data. The API has a rate limit of 100 requests per minute, but the analyst needs to retrieve 10,000 records as quickly as possible. What strategy should be used?
Pagination allows systematic retrieval; delays ensure compliance with rate limits.
Why this answer
Option C is correct because paginating with appropriate delays respects the API's rate limit of 100 requests per minute while maximizing throughput. By splitting the 10,000 records into pages (e.g., 100 records per page) and sending requests at a rate just under the limit (e.g., one request every 0.6 seconds), the analyst can retrieve all data in approximately 100 minutes without triggering HTTP 429 rate-limit errors.
Exam trap
The trap here is that candidates may assume 'as quickly as possible' means sending requests as fast as possible (Option A) or using multiple keys (Option B), overlooking that rate limits are enforced per key or IP and that proper pagination with delays is the only compliant way to maximize throughput.
How to eliminate wrong answers
Option A is wrong because increasing the request rate beyond 100 requests per minute would violate the API's rate limit, resulting in HTTP 429 (Too Many Requests) responses or temporary IP bans. Option B is wrong because using multiple API keys to circumvent rate limits violates the API's terms of service and could lead to account suspension or revocation of access. Option D is wrong because downloading a precompiled dataset may not be available, may not contain the specific historical weather data needed, or may be outdated, and the question explicitly states the analyst is using a public API to collect data.
Refer to the exhibit. A data analyst is trying to extract data from a SQL Server database but receives the error. Which configuration change should the analyst recommend to the database administrator?
Mixed Mode allows SQL authentication, which matches the login attempt.
Why this answer
The error indicates that the server is configured for Windows authentication only, but the login attempt used SQL authentication. Enabling Mixed Mode authentication allows both Windows and SQL authentication, resolving the issue.
A retail company operates 50 stores across the country. The data analyst has been asked to create a dashboard to visualize monthly sales trends over the past two years and compare the performance of the top 5 stores. The dataset includes store name, date, and daily sales amount. Initial exploration reveals that some stores have missing sales data for certain months due to system outages, and there are occasional extreme values caused by promotional events (e.g., Black Friday sales are 10x normal). The analyst needs to choose an appropriate visualization approach that accurately represents the trends and comparisons while handling these data quality issues. What should the analyst do to best meet the requirements?
Combines trend and comparison effectively; aggregation handles missing data, and tooltips provide context.
Why this answer
Option C is correct because it combines a line chart for overall trend (aggregating all stores) and bar charts for top 5 stores, which allows comparison while handling missing data through aggregation. Tooltips can provide context for outliers. Option A is wrong because using separate line charts for each store becomes cluttered with 50 stores, and excluding outliers may omit valuable information about promotions.
Option B is wrong because filtering out stores with missing data could remove important stores and distort the trend. Option D is wrong because a stacked bar chart with all 50 stores would be difficult to read and doesn't show trends over time effectively.
An analyst is fitting a polynomial regression model and wants to choose the degree that minimizes overfitting. Which technique should the analyst use?
Ridge regression penalizes large coefficients, which is effective for reducing overfitting in polynomial models without removing features.
Why this answer
Ridge regression (L2) adds a penalty proportional to the square of the magnitude of coefficients, which shrinks them toward zero but does not eliminate them. This regularization reduces variance and helps prevent overfitting in polynomial regression by controlling the influence of higher-degree terms, making it the correct technique for minimizing overfitting while retaining all features.
Exam trap
The trap here is that candidates often confuse Lasso (L1) with Ridge (L2), mistakenly thinking Lasso's coefficient elimination is always better for overfitting, when in fact Ridge's smooth shrinkage is more appropriate for polynomial models where all degrees should be retained but controlled.
How to eliminate wrong answers
Option A is wrong because Lasso regression (L1) performs feature selection by shrinking some coefficients exactly to zero, which is more suited for sparse models rather than simply minimizing overfitting in a polynomial context where all degrees may be needed. Option B is wrong because Principal Component Analysis (PCA) is a dimensionality reduction technique that transforms features into uncorrelated components, but it does not directly address overfitting in polynomial regression and can lose interpretability of the polynomial terms. Option C is wrong because stepwise selection is a variable selection method that adds or removes predictors based on statistical criteria (e.g., AIC, p-values), but it can be unstable and does not inherently regularize coefficients to combat overfitting as effectively as ridge regression.
A company is merging two customer databases from different acquisitions. They need to identify duplicate records. Which data profiling technique is most effective?
Fuzzy matching handles variations and is appropriate for deduplication.
Why this answer
Fuzzy matching on name and address is the most effective technique because customer databases from different acquisitions often contain variations in spelling, formatting, and abbreviations (e.g., 'Bob' vs. 'Robert', 'St.' vs. 'Street'). Exact matching would miss these duplicates, while fuzzy matching uses algorithms like Levenshtein distance or Jaro-Winkler to quantify similarity and identify near-matches, ensuring comprehensive deduplication.
Exam trap
The trap here is that candidates assume exact matching or primary keys are sufficient for deduplication, overlooking the real-world data inconsistencies that fuzzy matching is designed to handle.
How to eliminate wrong answers
Option B is wrong because manually comparing all records is impractical and error-prone for large datasets, lacking scalability and consistency. Option C is wrong because exact match on customer names fails to capture duplicates caused by typos, nicknames, or inconsistent formatting (e.g., 'Jon' vs. 'John'). Option D is wrong because primary keys from each database are unique within their own system but cannot identify cross-database duplicates, as the same customer may have different primary keys in each source.
A data analyst is presenting results from a customer segmentation analysis to a non-technical audience. The segmentation was performed using k-means clustering, and the analyst wants to explain the characteristics of each cluster. Which visualization is most appropriate for this audience?
Bar charts are simple, familiar, and effectively compare averages across categories.
Why this answer
A bar chart comparing average values of key metrics per cluster is the most appropriate choice because it directly translates the numerical output of k-means clustering into a simple, intuitive visual that non-technical audiences can easily interpret. Unlike complex multivariate plots, a bar chart focuses on the distinct characteristics of each cluster without requiring knowledge of clustering algorithms or dimensionality reduction. This aligns with the DA0-001 objective of communicating data insights effectively to stakeholders.
Exam trap
The trap here is that candidates may choose a technically sophisticated visualization like a parallel coordinates plot or PCA scatter plot, mistakenly believing it demonstrates deeper analytical skill, when the question specifically tests the ability to tailor visualizations to a non-technical audience's comprehension level.
How to eliminate wrong answers
Option A is wrong because a parallel coordinates plot displays all variables simultaneously, which overwhelms non-technical audiences with overlapping lines and multidimensional complexity, making it unsuitable for clear communication of cluster characteristics. Option B is wrong because a heatmap of the distance matrix between cluster centroids shows abstract mathematical relationships (e.g., Euclidean distances) that are meaningless to a non-technical audience and does not convey the actual metric values defining each cluster. Option D is wrong because a scatter plot with two principal components requires understanding of PCA and dimensionality reduction, which is not intuitive for non-technical stakeholders, and the cluster boundaries may be ambiguous without proper labeling of the original metrics.
Drag and drop the steps to clean a dataset with missing values in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Cleaning starts with identification, then analysis of missingness, strategy selection, application, and documentation.
A data scientist is building a predictive model to forecast monthly sales. The data shows a linear trend with no seasonality. Which regression technique is most appropriate?
Linear regression directly models a linear relationship between independent and dependent variables.
Why this answer
Linear regression is the most appropriate technique because the data shows a linear trend with no seasonality, making a straight-line model the simplest and most effective fit. It directly models the relationship between the independent variable (e.g., time) and the dependent variable (monthly sales) using a linear equation, minimizing the sum of squared residuals.
Exam trap
The trap here is that candidates often confuse 'linear trend' with 'linear in parameters' and incorrectly choose polynomial regression, thinking it adds flexibility, when the question explicitly states no seasonality and a linear trend, making simple linear regression the optimal choice.
How to eliminate wrong answers
Option A is wrong because polynomial regression introduces higher-degree terms (e.g., x², x³) to model curvature, which is unnecessary and risks overfitting when the trend is explicitly linear. Option B is wrong because logistic regression is used for binary classification problems (e.g., predicting yes/no outcomes), not for forecasting continuous numeric values like monthly sales. Option D is wrong because ridge regression is a regularization technique designed to handle multicollinearity or overfitting by adding an L2 penalty, but it is not a distinct regression type for linear trends and would be overkill when a simple linear model suffices.
A data engineer is designing an ETL pipeline to extract sales data from a legacy on-premise database and load it into a cloud data warehouse. The database is slow and queries during business hours affect performance. Which extraction strategy minimizes impact?
CDC minimizes database load by extracting only changed data, reducing performance impact.
Why this answer
Incremental extraction using Change Data Capture (CDC) minimizes impact on the legacy on-premise database by reading only the changed rows (inserts, updates, deletes) from transaction logs or change tables, rather than issuing heavy SELECT queries. This avoids full table scans or frequent queries during business hours, preserving database performance for operational workloads.
Exam trap
The trap here is that candidates confuse 'log shipping' (a high-availability technique) with 'Change Data Capture' (an extraction method), or assume that any periodic query (like hourly SELECT *) is acceptable without considering the cumulative performance impact on a slow legacy database.
How to eliminate wrong answers
Option A is wrong because querying the database with SELECT * every hour performs full table scans on the legacy database, which is slow and would degrade performance during business hours, directly contradicting the goal of minimizing impact. Option C is wrong because full table extraction nightly still requires a complete scan of the entire table, which can be resource-intensive and may not complete within a reasonable window if the database is slow, and it does not capture intra-day changes without additional overhead. Option D is wrong because database log shipping is a disaster recovery technique that continuously copies transaction logs to a standby server, not an extraction strategy for ETL; it does not provide a queryable change stream and would require additional processing to parse logs for CDC.
A retail company has a dashboard that tracks daily sales across all stores. The dashboard is used by the CEO during monthly board meetings. Recently, the CEO complained that the dashboard is confusing and takes too long to interpret. The data analyst is asked to redesign the dashboard to improve usability. The analyst has access to all sales data. The CEO prefers a high-level overview with the ability to drill down into regions if needed. The analyst must decide on a course of action. What should the analyst do first?
Directly addresses the user's frustration and gathers precise requirements.
Why this answer
The correct first step is to interview the CEO to determine key performance indicators and preferred layout. This ensures the dashboard is designed around the specific high-level metrics the CEO needs for monthly board meetings, with the ability to drill down into regions. Starting with stakeholder requirements prevents wasted effort on irrelevant visualizations or formats.
Exam trap
The trap here is that candidates may assume more data or broader input (options A or B) is always better, when in fact the correct approach is to focus on the specific needs of the primary user to reduce confusion and improve usability.
How to eliminate wrong answers
Option A is wrong because revamping with as many visualizations as possible would increase clutter and confusion, directly contradicting the CEO's complaint about the dashboard being confusing and taking too long to interpret. Option B is wrong because surveying all employees is unnecessary; the primary user is the CEO, and the dashboard is for board meetings, not general employee use. Option C is wrong because creating a static PDF report removes interactivity and the ability to drill down into regions, which the CEO explicitly prefers.
Drag and drop the steps to perform a root cause analysis on data quality issues in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Root cause analysis involves defining the problem, gathering data, identifying causes, finding root cause, and acting.
An analyst notices that a dashboard displays conflicting data from two sources. What is the first step in troubleshooting?
Examining transformations and joins helps identify discrepancies between sources.
Why this answer
Option D is correct because the first step in troubleshooting conflicting data from multiple sources is to verify the data transformation steps and join logic. Conflicts often arise from incorrect joins (e.g., using INNER JOIN instead of LEFT JOIN), mismatched keys, or data type conversions that alter values. Checking these steps isolates the root cause before any other action, such as re-running queries or notifying stakeholders.
Exam trap
The trap here is that candidates often jump to re-running queries or notifying stakeholders first, mistaking a symptom (conflicting data) for a root cause, instead of methodically inspecting the transformation and join logic where the discrepancy likely originates.
How to eliminate wrong answers
Option A is wrong because re-running all queries blindly repeats the same potentially flawed logic without diagnosing the source of the conflict; it wastes time and may overwrite intermediate results. Option B is wrong because notifying stakeholders prematurely escalates an unverified issue, causing unnecessary alarm and eroding trust before the analyst has confirmed the error. Option C is wrong because replacing the data source without understanding the conflict ignores the possibility that the transformation logic or join conditions are the actual problem, and it may introduce new inconsistencies.
Based on the exhibit, what is the most likely cause of the import failure?
The date '2024-02-30' is invalid and caused the import to halt.
Why this answer
Option D is correct because the exhibit shows a date field containing '2023-02-30', which is an invalid date (February never has 30 days). This data quality issue causes the import to fail, as the system likely validates date values against calendar rules before inserting them into the target table. The error is not due to file emptiness, non-numeric characters, or corruption, but specifically a semantic data integrity violation.
Exam trap
The trap here is that candidates may overlook semantic data quality issues (like invalid dates) and instead focus on syntactic problems (like file format or non-numeric characters), even though the exhibit clearly shows a date that does not exist in the calendar.
How to eliminate wrong answers
Option A is wrong because the file contains multiple rows of data beyond headers, as evidenced by the visible records in the exhibit. Option B is wrong because the price field shows numeric values (e.g., 19.99, 29.99) without any non-numeric characters that would cause parsing failures. Option C is wrong because the source file is displayed in a standard CSV format with proper delimiters and readable content, indicating it is not corrupted or in an unsupported format.
A healthcare analytics team is analyzing patient readmission rates. They have a dataset with thousands of records including patient age, diagnosis, length of stay, number of prior admissions, and discharge date. The goal is to identify key factors influencing readmission and create a model to predict high-risk patients. The data is imbalanced: only 5% of patients are readmitted within 30 days. The team plans to use logistic regression. What is the most appropriate approach?
Oversampling balances the classes, improving model performance on the minority class.
Why this answer
With imbalanced data, logistic regression can be biased toward the majority class. Oversampling the minority class (e.g., SMOTE) helps the model learn patterns for readmission. Using accuracy as a metric would be misleading.
Removing majority samples discards valuable data. Using data as-is often fails to predict the minority class.
A data engineer is designing a data warehouse for a multinational corporation. The company has sales data from different regions with varying currencies and date formats. To ensure consistency, which data concept should be applied to standardize the data before loading into the warehouse?
Transformation includes standardization of formats.
Why this answer
Data transformation is the correct concept because it involves converting data from source formats (e.g., different currencies and date formats) into a consistent, standardized format before loading into the data warehouse. This process includes applying conversion rules, such as using ISO 8601 for dates and a single base currency (e.g., USD) with exchange rate tables, ensuring uniformity across all regional data. Without transformation, the warehouse would contain incompatible data types, breaking referential integrity and analytical queries.
Exam trap
CompTIA often tests the distinction between data cleansing and data transformation, where candidates mistakenly choose cleansing because they think fixing formats is about 'cleaning' data, but cleansing addresses errors and missing values, not structural conversions like currency or date standardization.
How to eliminate wrong answers
Option A is wrong because data cleansing focuses on detecting and correcting inaccuracies, inconsistencies, or missing values (e.g., removing duplicates or fixing typos), not on converting data types or formats like currencies and dates. Option C is wrong because data profiling is an exploratory process that analyzes source data to understand its structure, quality, and relationships (e.g., checking data types or null percentages), but it does not perform any standardization or conversion. Option D is wrong because data masking is a security technique used to obfuscate sensitive information (e.g., replacing credit card numbers with tokens) for privacy or compliance, and it has no role in standardizing currencies or date formats.
A logistics company is analyzing truck delivery times. Which variable is discrete?
Correct. The number of stops is a count and therefore discrete.
Why this answer
A discrete variable is one that takes on a countable number of distinct values, often integers. The number of stops a truck makes is a count (e.g., 0, 1, 2, 3) and cannot be a fraction, making it a classic discrete variable in data analysis.
Exam trap
The trap here is that candidates confuse 'recorded as an integer' with 'discrete'—for example, thinking distance in whole kilometers is discrete, when the underlying measurement scale is continuous.
How to eliminate wrong answers
Option B is wrong because time taken in hours is a continuous variable—it can be measured to any fractional precision (e.g., 2.5 hours, 3.75 hours). Option C is wrong because fuel consumption in liters is continuous; it can take any value within a range (e.g., 45.3 liters). Option D is wrong because distance traveled is continuous, as it can be measured in fractional units (e.g., 120.7 km).
Page 7 of 7
Practice DA0-001 by domain
Target a specific domain to shore up weak areas.