986 questions total · 14pages · All types, answers revealed
Drag and drop the steps to create a data visualization dashboard in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Dashboard creation starts with planning, then chart selection, layout design, building, and testing.
A data analyst needs to combine customer data from a MySQL transactional database with product data from a MongoDB document store to create a unified view for reporting. The analyst uses a SQL query that joins the tables after extracting data from both sources. Which database concept is being applied?
Joins combine rows from two or more tables based on a related column.
Why this answer
(Join) because the scenario describes combining data from two different sources—MySQL and MongoDB—into a unified view using a SQL query that joins the tables after extraction. This is a classic example of a cross-source join, where data from disparate databases is merged based on a common key, which is the fundamental purpose of a JOIN operation in SQL.
Exam trap
The trap here is that candidates may confuse a 'view' with a cross-source join, thinking a view can span multiple databases, but a view is limited to a single database and cannot directly reference tables from different database systems like MySQL and MongoDB.
How to eliminate wrong answers
Option A (View) is wrong because a view is a saved SQL query that presents data from one or more tables within the same database, not a mechanism to combine data from different source systems like MySQL and MongoDB. Option C (Stored procedure) is wrong because a stored procedure is a precompiled collection of SQL statements that performs a specific task within a single database, not a concept for joining data across heterogeneous data stores. Option D (Index) is wrong because an index is a data structure that improves the speed of data retrieval operations on a table, not a method for combining data from multiple sources.
Which TWO of the following are commonly used techniques for handling missing data in a dataset? (Select TWO).
Mean imputation replaces missing values with the mean of the column.
Why this answer
Mean imputation is a commonly used technique for handling missing numerical data where the missing value is replaced with the mean of the observed values for that feature. It preserves the sample size and is simple to implement, though it can reduce variance and distort relationships if data is not missing completely at random.
Exam trap
CompTIA often tests the distinction between common imputation methods (mean, median, mode, regression) and data removal techniques, trapping candidates who confuse 'dropping rows' as a primary technique when imputation is more widely recommended for preserving data integrity.
A data analyst is designing a self-service reporting platform for business users. Which TWO practices will help ensure data consistency and trust? (Select TWO.)
Correct. Centralized data ensures consistency.
Why this answer
A single version of truth ensures everyone uses the same data, and a data dictionary provides clear definitions.
A financial analyst needs to show how net income is derived from revenue, costs, and expenses over a period. The chart should highlight the contribution of each component. Which chart type is most appropriate?
Waterfall charts illustrate incremental changes leading to a final total.
Why this answer
A waterfall chart shows how an initial value is affected by a series of positive and negative changes, making it ideal for financial breakdowns.
Which database concept ensures that data in one table corresponds to data in another table, preventing orphan records?
Referential integrity is the constraint that maintains consistency between related tables.
Why this answer
Referential integrity ensures that foreign key values match primary key values in the referenced table.
A data analyst creates a dashboard showing average order value by region. The chart indicates that one region has an unusually high average. Investigation reveals that the region has very few orders, but one large purchase inflates the average. Which data transformation should the analyst apply to improve the visualization?
Median is less sensitive to outliers than mean.
Why this answer
Using the median instead of the mean reduces the influence of extreme values. The median is a robust measure of central tendency that is not skewed by a single large order, thus providing a more accurate representation of typical order values in that region. Option A (logarithmic scaling) could help with visualization of wide ranges but does not change the aggregation; option C (pie chart) is not suitable for comparing average values across regions; option D (removing all outliers) is too drastic and may discard valid data points.
A data analyst creates a dashboard that includes a map showing sales by region. The map uses a continuous color gradient from light yellow to dark blue. Some regions with very high sales appear as dark blue, but many regions with moderate sales appear similar. Which improvement would most enhance the readability?
Discrete bins with distinct colors make it easier to differentiate between ranges, reducing visual ambiguity.
Why this answer
A discrete color scale with distinct bins for sales ranges eliminates the ambiguity caused by a continuous gradient, where moderate sales values blend together. By grouping sales into defined intervals (e.g., $0–$10K, $10K–$50K, etc.), each region is assigned a unique, easily distinguishable color, making it immediately clear which sales bracket a region falls into without requiring precise color differentiation.
Exam trap
The trap here is that candidates may think a diverging color scheme (Option A) is always better for readability, but CompTIA often tests the distinction between continuous vs. discrete scales—the core issue is that a continuous gradient causes perceptual blending in the mid-range, which only a discrete scale with distinct bins can resolve.
How to eliminate wrong answers
Option A is wrong because a diverging color scheme is designed to highlight deviation from a neutral midpoint (e.g., above vs. below average), but the problem here is not about showing positive/negative divergence—it is about distinguishing moderate sales values that appear similar in a continuous gradient. Option B is wrong because increasing the map size does not change the underlying color mapping; it only enlarges the visual elements, so regions with similar moderate sales will still appear indistinguishable. Option C is wrong because adding data labels provides exact numbers but does not improve the readability of the color encoding itself; users would still struggle to visually compare regions at a glance, and labels can clutter the map, especially with many regions.
Which TWO are common pitfalls when communicating data insights?
Manipulating scales can distort the data and mislead the audience.
Why this answer
Using misleading scales on charts (e.g., truncating the y-axis or using non-zero baselines) distorts the visual representation of data, leading to incorrect interpretations. This violates the principle of data integrity in data visualization, as it can exaggerate or minimize trends, making it a common pitfall when communicating data insights.
Exam trap
CompTIA often tests the distinction between best practices and common pitfalls, so the trap here is that candidates may confuse beneficial actions (like explaining assumptions or providing context) with pitfalls, leading them to select those as wrong answers instead of recognizing them as correct practices.
A data analyst is pulling data from a production database for a report. The database contains customer orders with a column 'order_date'. The analyst notices that some orders have dates in the future. Which data quality issue does this represent?
Future orders are not valid per business rules, indicating a data quality issue.
Why this answer
Future order dates violate a business rule that order_date must be in the past or present. This is a classic data integrity issue where the data does not conform to domain-specific constraints, such as 'order_date <= CURRENT_DATE'. The analyst should flag this as a violation of business rules, not a data type or consistency problem.
Exam trap
The trap here is that candidates confuse 'invalid data type' (Option A) with 'invalid data value' — the data is of the correct type but violates a logical business rule, which is a distinct quality issue often tested in DA0-001.
How to eliminate wrong answers
Option A is wrong because the column 'order_date' is of a valid date data type (e.g., DATE or TIMESTAMP), so there is no data type mismatch. Option B is wrong because inconsistent data refers to contradictory values across related columns (e.g., different date formats), not a single column containing future dates. Option C is wrong because missing data would involve NULL or empty values, not dates that are present but invalid according to business logic.
A business user wants to explore sales data by creating custom charts and tables without writing SQL queries. Which type of report capability should the BI team provide?
Self-service tools empower users to explore data on their own.
Why this answer
Self-service reporting allows business users to create their own reports and visualizations using BI tools without technical skills.
Refer to the exhibit. Based on the data profiling results, what is a likely data quality issue?
Correct. Values like 0 and 150 violate reasonable constraints.
Why this answer
The min of 0 and max of 150 are biologically implausible for age. A 0-year-old or 150-year-old customer likely indicates invalid data, affecting validity.
A data analyst is preparing a dataset for a machine learning algorithm that assumes normally distributed features. Which TWO data transformation methods should the analyst consider to achieve this?
Correct. Square root transformation can reduce right skewness and make the distribution more normal.
Why this answer
Log transformation and square root transformation are both methods that can reduce skewness and help make data more normally distributed. Z-score standardization only centers and scales the data but does not change the shape of the distribution. One-hot encoding is for categorical variables, and min-max normalization is for scaling, not normality.
A retail company with 500 stores across North America wants to visualize its sales performance. The dataset includes store ID, region (Northeast, Southeast, Midwest, West), product category (Electronics, Clothing, Home Goods), monthly sales (in dollars), and date (from January 2018 to December 2023). The data has missing values for about 5% of store-month combinations, and a few stores have reported sales that are 10 times higher than the average for their region due to grand opening events. The goal is to create a dashboard that shows monthly sales trends for each region and product category, and allows users to identify which categories are driving growth. Which approach should the analyst take?
Line charts excel at showing trends over time; grouping by region and category allows comparison; outliers should be investigated and annotated, not removed.
Why this answer
A line chart with month on the x-axis and separate lines for each region and product category allows clear visualization of sales trends over time for each combination. This approach also suggests checking for outliers (e.g., grand opening spikes) and annotating them rather than removing them, preserving valuable data. Option A is incorrect: a stacked bar chart with all stores aggregated per month obscures individual category and regional trends, making it hard to identify which categories are driving growth.
Option C is incorrect: removing outlier stores discards legitimate data from grand opening events, which may be important for understanding growth. Option D is incorrect: a scatter plot is not suitable for showing time series trends as it does not connect points sequentially and makes trend identification difficult.
A dataset contains employee salaries ranging from $30,000 to $200,000. An analyst wants to scale the salaries to a range of 0 to 1 for use in a distance-based clustering algorithm. Which method should they use?
Scales to 0-1 using (x - min)/(max - min).
Why this answer
Min-max normalization scales data to a 0-1 range.
In a table 'employee_hierarchy' with columns 'employee_id', 'manager_id', and 'employee_name', an analyst needs to generate a list of all employees under a specific manager, including multiple levels of subordinates. Which SQL construct is most appropriate for querying this hierarchical data efficiently?
Recursive CTEs iterate through levels, ideal for hierarchies.
Why this answer
Recursive CTEs are designed to handle hierarchical data by repeatedly joining a CTE to itself until all levels are included.
A healthcare organization acquires data from multiple hospitals with different patient record systems. The data includes patient IDs but no common identifier across systems. Which technique should be used to link records?
Probabilistic record linkage is designed to link records using non-unique identifiers like name, DOB, and ZIP, making it suitable for this scenario.
Why this answer
(probabilistic linkage) is designed for such situations. Option A (merge without deduplication) creates duplicates and loses connections. Option B (random unique IDs) loses connections because there is no common identifier across systems.
Option C (manual matching) is not scalable.
Which SQL aggregate function would an analyst use to calculate the average value of a numeric column?
AVG computes the average.
Why this answer
AVG calculates the arithmetic mean of a numeric column.
An organization wants to assign responsibility for data quality and metadata management. Which role is primarily accountable for defining data standards and ensuring data quality across a specific domain?
A data steward ensures data quality, standards, and metadata management for a specific domain.
Why this answer
The data steward is the role primarily accountable for defining data standards and ensuring data quality within a specific domain. This aligns with the DAMA-DMBOK framework, where the data steward acts as the business-side owner of data content, establishing rules for data entry, validation, and metadata management to maintain consistency and accuracy.
Exam trap
The trap here is confusing the data steward with the data owner or data custodian, as many candidates mistakenly think the owner handles domain-level quality or that the custodian defines standards, when in fact the steward is the bridge between business requirements and technical enforcement.
How to eliminate wrong answers
Option A is wrong because a data analyst focuses on querying, analyzing, and reporting data, not on defining standards or governing data quality across a domain. Option B is wrong because a data owner is typically a senior executive accountable for data assets at an enterprise level, not for day-to-day domain-specific standards and quality enforcement. Option D is wrong because a data custodian (or data steward in some frameworks) handles technical implementation, storage, and security, but does not define business-level data standards or quality rules.
A data analyst creates a dashboard for executives to monitor quarterly sales. Which best practice ensures the dashboard is effective?
Leverages natural scanning pattern for quick insight.
Why this answer
Placing the most important metric in the top-left corner leverages the natural reading pattern (left-to-right, top-to-bottom) to immediately draw the executive's attention to the key insight. Using simple charts (e.g., bar or line charts) reduces cognitive load, enabling rapid comprehension of quarterly sales trends without distracting details. This aligns with dashboard design principles that prioritize clarity and actionability over data density.
Exam trap
CompTIA often tests the misconception that more data or flashy visuals improve a dashboard, when in fact effective data communication relies on minimalism and strategic placement of the most critical insight.
How to eliminate wrong answers
Option B is wrong because a dark background with bright colors can cause eye strain and reduce readability, especially in well-lit executive meeting rooms; effective dashboards typically use light backgrounds with high-contrast, accessible color schemes. Option C is wrong because including raw data tables in an executive dashboard defeats its purpose—executives need summarized insights, not granular data, which should be available in a separate drill-down report. Option D is wrong because using as many charts as possible leads to clutter and information overload, obscuring the key sales metrics and making the dashboard ineffective for quick decision-making.
A research firm is acquiring data from public government databases via API. The API rate limits at 100 requests per minute. They need to download 10,000 records, but each request returns a maximum of 100 records. What is the most efficient approach to ensure complete acquisition without being blocked?
This approach respects the rate limit, handles failures gracefully, and ensures complete data acquisition.
Why this answer
Pagination with retry logic using exponential backoff allows the firm to send requests in a controlled manner, respecting the rate limit and handling potential failures. Sending all requests in parallel would likely exceed the rate limit and cause blocking. Downloading one record per second is too slow.
Requesting a data dump via email is inefficient and may not be supported.
A data analyst needs to create a visual that shows the distribution of customer ages across different regions. Which chart type is most appropriate?
A stacked bar chart can display the distribution of age groups within each region, making comparisons easy.
Why this answer
A stacked bar chart is most appropriate because it allows the analyst to compare the distribution of customer ages (typically grouped into bins) across multiple regions simultaneously. Each bar represents a region, and the segments within the bar show the proportion or count of each age group, making it easy to see both the overall distribution and regional differences.
Exam trap
The trap here is that candidates often choose a pie chart because they think of 'distribution' as a single whole, forgetting that the question requires comparison across multiple regions, which a pie chart cannot handle.
How to eliminate wrong answers
Option A is wrong because a line chart is designed to show trends over a continuous variable (e.g., time), not the distribution of categorical age groups across regions. Option C is wrong because a scatter plot is used to show the relationship between two continuous variables, not the distribution of a single categorical variable across regions. Option D is wrong because a pie chart can only show the composition of a whole for a single category (e.g., age distribution for one region), but it cannot effectively compare distributions across multiple regions.
During a presentation, a stakeholder questions the validity of a correlation found. What is the best response?
This response is honest and proposes next steps.
Why this answer
It directly addresses the stakeholder's concern about validity by acknowledging the fundamental statistical principle that correlation does not imply causation. It then proposes a constructive next step—further analysis—which aligns with best practices in data communication, where validating insights requires additional testing (e.g., controlled experiments or causal inference methods). This response demonstrates both technical honesty and a commitment to rigorous data-driven decision-making.
Exam trap
The trap here is that candidates often confuse statistical significance (p-value) or sample size with validity of a correlation, overlooking the core principle that correlation does not imply causation, which is a classic pitfall in data interpretation questions.
How to eliminate wrong answers
Option B is wrong because accepting a correlation as true without scrutiny ignores the possibility of spurious correlations, confounding variables, or sampling bias, which undermines data integrity. Option C is wrong because a large sample size reduces sampling error but does not guarantee that a correlation is meaningful or causal; it can still be due to chance or hidden confounders. Option D is wrong because a low p-value indicates statistical significance (i.e., the correlation is unlikely to be due to random chance), but it does not prove practical importance or causation, and significance can be inflated with large samples.
A healthcare organization is building a data warehouse to support population health analytics. The data sources include: (1) an electronic health record (EHR) system with a relational database containing patient demographics, diagnoses, and medications; (2) a claims system that generates CSV files daily; (3) patient-generated health data from mobile apps via a REST API returning JSON. The data engineer needs to design a data acquisition process that runs nightly. The EHR system has a change tracking mechanism that logs changes with timestamps. The claims CSV files are appended daily. The API supports filtering by date. The data warehouse uses a star schema with fact and dimension tables. The engineer must ensure data consistency and minimize load times. Which approach should the engineer take?
This minimizes data transfer and load time while capturing all changes.
Why this answer
It uses incremental extraction for the EHR system (via change tracking) and the API (via date filtering), while performing a full extraction of the claims CSV since it is append-only and small enough to reload nightly. This minimizes load times by avoiding full re-extraction of large, slowly changing datasets, and ensures data consistency by capturing only new or modified records. The star schema in the data warehouse is then populated efficiently from these targeted extracts.
Exam trap
The trap here is that candidates may assume a staging area (Option C) is always required for data consistency, but the question specifically asks for the acquisition approach to minimize load times, and incremental extraction (Option B) directly achieves that without mandating a staging area.
How to eliminate wrong answers
Option A is wrong because performing a full extraction of all data every night would be extremely inefficient, causing unnecessarily long load times and high resource consumption, especially for large relational databases like the EHR system. Option C is wrong because while using a staging area is a best practice for data quality and transformation, it does not address the core requirement of minimizing load times through incremental extraction; the question specifically asks for the acquisition approach, not the ETL pipeline design. Option D is wrong because extracting a full dump of the API data every night ignores the API's built-in date filtering capability, leading to redundant data transfer and longer load times compared to incremental extraction.
In an A/B test, the null hypothesis states that there is no difference between the conversion rates of the control and treatment groups. After collecting data, the p-value is 0.03. Using a significance level α = 0.05, what should the analyst conclude?
Correct conclusion.
Why this answer
Since the p-value (0.03) is less than α (0.05), the null hypothesis is rejected, indicating a statistically significant difference between the groups.
Which of the following data sources is most likely to generate streaming data?
IoT sensors continuously send data, making them a streaming source.
Why this answer
Streaming data is continuously generated from sources like IoT sensors, clickstreams, and social media feeds.
A financial report must be retained for seven years to comply with regulatory requirements. This is an example of which data governance principle?
Data retention refers to policies for how long data is stored.
Why this answer
Data retention policies specify how long data must be kept to meet legal or regulatory obligations.
A data analyst receives a dataset with a column 'salary' that contains values like '45,000', '55,000', and '65,000'. The analyst notices that the values are stored as text. Which data concept should be applied to convert the salary column from text to numeric format for analysis?
Conversion changes data type, e.g., string to integer.
Why this answer
Data type conversion is the correct concept because the salary values are stored as text (string) but need to be converted to a numeric type (e.g., integer or float) for mathematical operations like aggregation or averaging. In tools like Python (pandas `astype(float)`), SQL (`CAST(salary AS INTEGER)`), or Excel (`VALUE()` function), this explicit conversion ensures the data is treated as numbers, not strings. Without conversion, operations like `SUM` or `AVG` would fail or produce incorrect results.
Exam trap
CompTIA often tests the distinction between data transformation (type conversion) and data preparation techniques like imputation or normalization, trapping candidates who confuse 'changing format' with 'filling gaps' or 'scaling values'.
How to eliminate wrong answers
Option A is wrong because data imputation deals with filling missing values (e.g., using mean or median), not changing the data type of existing values. Option C is wrong because data validation checks whether data meets predefined rules (e.g., range or format constraints), but it does not transform text to numeric format. Option D is wrong because data normalization rescales numeric values to a standard range (e.g., 0–1 or z-scores), which assumes the data is already numeric, not converting text to numbers.
A researcher wants to study the effect of a new drug. She collects data directly from clinical trial participants. Later, she compares her findings with historical data from medical journals. Which contrast best describes her data sources?
Primary data is collected firsthand; secondary data is obtained from existing sources.
Why this answer
The researcher is directly collecting data from clinical trial participants (primary data) and then comparing it with historical data from medical journals (secondary data). Primary data is original data collected firsthand for a specific purpose, while secondary data is pre-existing data collected by others for different purposes. This contrast directly maps to the primary vs. secondary data classification in data management.
Exam trap
The trap here is that candidates confuse 'internal vs. external' (Option A) with 'primary vs. secondary' because both involve a contrast between data from the researcher's own work versus outside sources, but the DA0-001 exam specifically tests the distinction based on whether the data was collected firsthand (primary) or reused from existing records (secondary).
How to eliminate wrong answers
Option A is wrong because internal vs. external refers to data originating within or outside an organization, not the method of collection; the clinical trial data is internal to the study but the historical data is external, but the core contrast here is about data origin (firsthand vs. reused), not organizational boundary. Option B is wrong because quantitative vs. qualitative describes data types (numerical vs. categorical/textual), not the source of data; both the clinical trial data and historical journal data could be quantitative or qualitative. Option C is wrong because structured vs. unstructured refers to data format (e.g., tables vs. free text), not the source; both data sources could be structured (e.g., trial results in a database) or unstructured (e.g., narrative journal articles).
Which TWO of the following are best practices when presenting data insights to a non-technical audience?
Actionable insights help the audience make decisions.
Why this answer
Non-technical audiences need clear, actionable insights to make decisions. Presenting recommendations directly from the data ensures the insights are useful and drive business outcomes, which is a core principle of effective data communication.
Exam trap
CompTIA often tests the misconception that technical depth equals credibility, but the DA0-001 exam emphasizes that effective communication means simplifying complexity for the audience, not showcasing every analytical detail.
An analyst needs to combine two datasets from different sources that share a common key but have different levels of granularity. Dataset A has daily sales per store, Dataset B has hourly foot traffic per store. The analyst wants to analyze correlation. Which approach is appropriate?
Aggregating the more granular dataset to match the less granular is the standard approach.
Why this answer
Aggregating Dataset B (hourly foot traffic) to the daily level ensures both datasets share the same granularity before merging on the common key (store and date). This allows a valid correlation analysis between daily sales and daily foot traffic without introducing artificial patterns or data duplication. Merging at mismatched granularities would violate the assumption that each row represents a comparable unit of observation.
Exam trap
CompTIA often tests the misconception that disaggregating (splitting) the coarser dataset is acceptable, but this introduces artificial data and violates the assumption of uniform distribution, whereas aggregation preserves the actual measured values.
How to eliminate wrong answers
Option B is wrong because an outer join without aggregation would produce multiple rows per store-date (one for each hour) when joined with daily sales, inflating the number of rows and creating a many-to-one relationship that distorts correlation calculations. Option C is wrong because disaggregating daily sales by simply dividing by hours (e.g., 24) assumes uniform sales distribution, which is rarely true and introduces artificial hourly values that do not reflect actual sales patterns. Option D is wrong because joining on store and date without aggregation retains hourly granularity from Dataset B, causing each daily sales row to repeat for every hour, leading to duplicate data and invalid statistical analysis.
A data analyst is designing a dashboard for senior executives who need to quickly monitor key business metrics. Which TWO design principles should the analyst follow? (Choose two.)
Focus on critical metrics for quick decision-making.
Why this answer
Senior executives need to monitor key business metrics at a glance, not be overwhelmed with extraneous data. Displaying only the most important KPIs ensures the dashboard is focused and actionable, aligning with the principle of delivering concise, high-level insights for quick decision-making.
Exam trap
CompTIA often tests the misconception that more data and interactivity always improve a dashboard, when in fact, for executive audiences, simplicity and focus on the most important KPIs are paramount.
A data analyst uses Python's pandas library to read a CSV file into a DataFrame. Which function is used to read the file?
This is the correct function to read CSV files into a DataFrame.
Why this answer
pd.read_csv() is the standard pandas function to read a CSV file.
A data analyst is designing a data model for a sales data warehouse. The model should optimize query performance for aggregations by minimizing joins and duplicating data where necessary. Which schema design should the analyst use?
Star schema denormalizes dimensions, minimizing joins and optimizing aggregate queries.
Why this answer
Star schema denormalizes dimensions into a single table, reducing joins and improving query speed for aggregates. Snowflake schema normalizes dimensions increasing joins. Entity-relationship and 3NF are optimized for transactional systems, not analytical queries.
A dashboard designer wants to ensure that the most important metric, such as total revenue, is prominently displayed at the top left. Which dashboard design principle is being applied?
Visual hierarchy emphasizes the most important information first.
Why this answer
Visual hierarchy arranges elements by importance, typically with key metrics at the top or top-left.
A data analyst uses linear regression to model the relationship between advertising spend and sales. The residual plot shows a clear U-shaped pattern. What assumption is violated?
A U-shaped pattern means the relationship is not linear; the model is missing a nonlinear term.
Why this answer
The U-shaped pattern in the residual plot indicates that the relationship between advertising spend and sales is not linear; the model fails to capture the curvature in the data. Linear regression assumes a straight-line relationship between predictors and the response, so a systematic pattern like a U-shape directly violates the linearity assumption. This means the model is misspecified and requires a transformation or a nonlinear modeling approach.
Exam trap
CompTIA often tests the distinction between residual pattern shapes and their corresponding assumptions, so the trap here is that candidates confuse a curved pattern (nonlinearity) with heteroscedasticity or non-normality, leading them to pick B or C instead of D.
How to eliminate wrong answers
Option A is wrong because independence of residuals refers to errors being uncorrelated with each other, often violated in time-series data, but a U-shaped pattern does not imply autocorrelation. Option B is wrong because homoscedasticity means constant variance of residuals across fitted values, which would appear as a funnel or cone shape, not a U-shaped curve. Option C is wrong because normality of residuals concerns the distribution of errors (checked via Q-Q plot or histogram), not the pattern of residuals versus fitted values; a U-shaped pattern does not directly indicate non-normality.
In a sales database, an analyst needs to retrieve all orders where the order amount is between $100 and $500. Which WHERE clause should be used?
BETWEEN filters values within the inclusive range.
Why this answer
The BETWEEN operator is inclusive and is the standard way to filter a range of values.
A BI analyst is creating a report in Power BI and needs to calculate the total sales for the current year compared to the previous year. Which DAX function should be used to calculate the previous year's sales?
SAMEPERIODLASTYEAR returns dates from the previous year for the same period.
Why this answer
SAMEPERIODLASTYEAR returns a set of dates in the previous year for the same period, which is ideal for year-over-year comparisons.
A company requires real-time masking of credit card numbers for customer support agents while allowing full access for accountants. Which technique should be implemented?
Dynamic masking masks data on-the-fly based on user roles, perfect for this requirement.
Why this answer
Dynamic data masking (DDM) applies masking rules at query runtime based on user privileges, allowing accountants full access while customer support agents see only masked credit card numbers. Unlike static masking, DDM does not alter the underlying stored data, making it ideal for real-time, role-based obfuscation without duplicating or transforming the database.
Exam trap
CompTIA often tests the misconception that encryption or tokenization can provide real-time, role-based masking, but these technologies either require decryption (exposing the full value) or introduce latency and storage overhead, making dynamic data masking the only correct choice for this use case.
How to eliminate wrong answers
Option B (Tokenization) is wrong because it replaces sensitive data with a non-sensitive token stored in a separate vault, requiring a detokenization process that adds latency and is not designed for real-time, role-based masking within the same database. Option C (Static data masking) is wrong because it creates a permanent, masked copy of the data in a non-production environment, which cannot provide real-time, on-the-fly masking for live queries. Option D (Data encryption) is wrong because encryption protects data at rest or in transit but does not provide role-based masking at query time; decryption keys grant full access, not partial masking.
A data architect is designing an ETL pipeline to ingest streaming data from IoT sensors. The data must be available for real-time analytics. Which acquisition method is best?
Streaming provides continuous, low-latency data flow.
Why this answer
Real-time streaming via API is the best method because IoT sensors generate continuous data that must be ingested with sub-second latency for real-time analytics. APIs (e.g., REST, WebSocket, or MQTT) enable event-driven ingestion, allowing the ETL pipeline to process each sensor reading as it arrives, which is essential for time-sensitive use cases like anomaly detection or live monitoring.
Exam trap
The trap here is that candidates may confuse 'real-time' with 'frequent batch' and choose hourly polling (Option B), not realizing that real-time analytics requires sub-second latency, not just periodic updates.
How to eliminate wrong answers
Option B is wrong because polling sensors every hour introduces latency of up to 60 minutes, which violates the real-time analytics requirement and can cause data staleness for time-critical decisions. Option C is wrong because manually uploading sensor logs is not automated, introduces human error, and cannot achieve the low-latency ingestion needed for streaming data. Option D is wrong because batch loading daily CSV files imposes a 24-hour delay, making the data unavailable for real-time analytics and contradicting the explicit requirement for immediate data availability.
Refer to the exhibit. A data analyst is reviewing the configuration of an executive dashboard. The dashboard refreshes daily at 6:00 AM. Which of the following best describes a potential issue with this dashboard for executive use?
Executives typically prefer visual summaries (charts) over raw tables for rapid comprehension.
Why this answer
An executive dashboard should provide quick, at-a-glance insights, and a table visualization forces the viewer to read through rows of data rather than immediately grasping trends or outliers. For high-level decision-making, visualizations like line charts, bar charts, or KPI tiles are more effective at conveying key metrics without cognitive overload.
Exam trap
CompTIA often tests the principle that the suitability of a visualization depends on the audience and purpose, and the trap here is assuming that a table is always acceptable because it shows all data, ignoring that executives need rapid, high-level insights rather than granular detail.
How to eliminate wrong answers
Option A is wrong because the question does not provide any information about missing tables or data sources; the exhibit only shows the dashboard configuration, and there is no indication of incomplete data. Option C is wrong because the alert condition for revenue being set too low is not inherently an issue—it depends on business thresholds, and the question does not specify that the alert is misconfigured or causing false alarms. Option D is wrong because a daily refresh at 6:00 AM is a common and reasonable schedule for an executive dashboard, ensuring data is current for morning reviews without being overly frequent or resource-intensive.
A healthcare analytics team is building a predictive model to identify patients at high risk of readmission within 30 days of discharge. The dataset includes 50,000 patient records with 200 features, including demographics, vital signs, lab results, and historical admissions. The target variable is binary (readmitted or not). The team uses a logistic regression model and achieves an AUC of 0.72 on the test set. However, the model's calibration is poor: for patients predicted to have a 70% risk, the actual readmission rate is only 40%. The team wants to improve calibration without significantly reducing discrimination (AUC). The data scientist suggests applying Platt scaling. However, the team lead is concerned that Platt scaling may reduce the model's ability to rank patients correctly. Which of the following is the best course of action?
Platt scaling is designed to improve calibration while maintaining AUC.
Why this answer
Platt scaling is a post-processing technique that fits a logistic regression model on the predicted probabilities from the original model using a held-out validation set. This recalibrates the probabilities without altering the ranking of patients (the AUC remains unchanged), directly addressing the poor calibration while preserving discrimination. Option C correctly describes this procedure.
Exam trap
The trap here is that candidates may think Platt scaling changes the model's ranking (AUC), but in reality it applies a monotonic transformation that preserves rank order, so discrimination is unaffected.
How to eliminate wrong answers
Option A is wrong because discarding patients with predicted risk between 0.3 and 0.7 removes a large portion of the data and does not fix the underlying miscalibration; it merely hides the problem and reduces the model's utility. Option B is wrong because AUC measures only rank ordering, not probability accuracy; for clinical risk models, well-calibrated probabilities are critical for decision-making (e.g., resource allocation). Option D is wrong because random forest models are known to produce poorly calibrated probabilities due to their averaging of decision tree outputs, often requiring their own calibration (e.g., isotonic regression) and do not inherently guarantee better calibration than logistic regression.
A data scientist is performing a hypothesis test with a significance level α=0.05. The p-value obtained is 0.03. What should the scientist conclude?
A p-value less than α leads to rejection of the null hypothesis.
Why this answer
Since 0.03 < 0.05, we reject the null hypothesis, indicating statistically significant evidence against it.
A healthcare analytics team is building a classification model to predict patient readmission within 30 days. The dataset contains 10,000 records with 30 features, including demographics, vital signs, lab results, and medication history. The target variable is imbalanced: 85% no readmission, 15% readmission. The team used logistic regression with default settings and achieved an accuracy of 85%, but the model predicted 'no readmission' for all patients. The lead analyst suspects the model is not learning due to class imbalance. The team has time to implement one corrective action before the next model review. Which action should the team take?
SMOTE generates synthetic samples, balancing the classes and allowing the model to learn from the minority class.
Why this answer
SMOTE (Synthetic Minority Oversampling Technique) directly addresses the class imbalance by generating synthetic samples for the minority class (readmission). This forces the logistic regression model to learn decision boundaries that separate the two classes, rather than defaulting to the majority class prediction. With 85% majority and 15% minority, accuracy alone is misleading, and SMOTE is a proven technique to improve recall for the minority class.
Exam trap
The trap here is that candidates often choose accuracy as a metric (Option C) because it seems intuitive, but in imbalanced datasets, accuracy is misleading and does not reflect model performance for the minority class.
How to eliminate wrong answers
Option A is wrong because removing low-variance features does not address class imbalance; it only reduces noise or redundant features, but the model will still predict the majority class if the imbalance is not handled. Option C is wrong because using accuracy as the evaluation metric is exactly the problem—it will remain high (85%) even if the model predicts all 'no readmission', so it does not monitor improvement for the minority class. Option D is wrong because switching to a random forest model with default settings does not inherently solve class imbalance; random forest can also be biased toward the majority class without techniques like class weighting or resampling.
Which TWO of the following are components of time series data?
Correct: Trend is a long-term direction.
Why this answer
Trend and seasonality are classic components of time series. Mean, median, and variance are statistical measures but not components of time series decomposition.
A logistics company tracks delivery times and customer satisfaction scores. The data analyst finds that delivery times have increased over the past quarter, correlating with a drop in satisfaction. The analyst needs to present this to the operations team, which is interested in root cause analysis. The team wants to identify whether the increase is due to specific regions, routes, or time periods. The analyst has access to granular data including timestamps, route IDs, and region codes. The presentation should lead to actionable insights for process improvement. What visualization should the analyst use as the primary chart?
Clearly visualizes trends and correlation, enabling root cause analysis.
Why this answer
A line chart with dual axes (or separate panels) can clearly show the trend of delivery times and satisfaction scores over the same time period, directly addressing the operations team's need to identify whether the increase is due to specific time periods. This visualization allows the team to correlate changes in delivery times with satisfaction drops over time, supporting root cause analysis by highlighting temporal patterns. The granular timestamp data makes a time-series line chart the most effective primary chart for revealing trends and potential seasonality.
Exam trap
The trap here is that candidates often choose a scatter plot (Option A) because it shows correlation, but the question specifically requires identifying root causes by region, route, or time period, which a scatter plot cannot address without additional dimensions.
How to eliminate wrong answers
Option A is wrong because a scatter plot of delivery time vs. satisfaction shows correlation but does not incorporate time, region, or route dimensions, making it impossible to identify whether increases are due to specific regions, routes, or time periods. Option C is wrong because a histogram of delivery times shows the distribution of delivery times but provides no temporal context or correlation with satisfaction, failing to address the root cause analysis requirement for time-based trends. Option D is wrong because a pie chart showing the proportion of late deliveries is a static snapshot that ignores time trends, regional breakdowns, and route-level granularity, offering no actionable insights for process improvement.
A data analyst is designing a dashboard for a sales team. Which TWO of the following are best practices for dashboard design?
Consistent color coding helps users quickly associate colors with metrics.
Why this answer
Consistent color coding for similar metrics reduces cognitive load and helps users quickly interpret data without re-learning visual cues. In dashboard design, this aligns with Gestalt principles of similarity and proximity, ensuring that revenue metrics, for example, always appear in the same color across charts. This practice is recommended by data visualization experts like Stephen Few and is a standard in tools like Tableau and Power BI.
Exam trap
The trap here is that candidates often confuse 'impressive visuals' with effective communication, or assume that more data equals better insights, when in fact simplicity and consistency are the hallmarks of professional dashboard design.
Which THREE of the following are appropriate ways to handle outliers when communicating data insights?
Documentation provides transparency and context.
Why this answer
Documenting the outlier and its potential impact in the report is a best practice for transparent and ethical data communication. It allows stakeholders to understand the anomaly's influence on the analysis and make informed decisions, rather than hiding or misrepresenting the data.
Exam trap
The trap here is that candidates may think removing outliers is always a standard data cleaning step, but the exam emphasizes that outliers must be investigated and documented rather than automatically deleted, as they can carry significant meaning.
A retail company stores customer purchase history in a relational database. The database contains a table 'transactions' with columns: transaction_id, customer_id, product_id, quantity, price, and transaction_date. A data analyst needs to create a report that shows total revenue per customer for the last quarter. Which data concept describes the relationship between customer_id and total revenue?
Total revenue is calculated from other attributes, making it derived.
Why this answer
Total revenue is calculated by summing (quantity * price) for each customer, making it a derived attribute because it is computed from existing stored data (quantity and price) rather than stored directly. In the context of the 'transactions' table, customer_id is a stored key, but total_revenue is not stored; it is derived via aggregation, which matches the definition of a derived attribute in database design.
Exam trap
CompTIA often tests the confusion between a derived attribute (computed from other attributes) and a foreign key (a referential constraint), leading candidates to incorrectly select 'foreign key' because customer_id appears in multiple tables.
How to eliminate wrong answers
Option A is wrong because a foreign key is a column that references a primary key in another table to enforce referential integrity; customer_id in the transactions table is a foreign key referencing the customers table, but total revenue is not a key—it is a computed value. Option B is wrong because a composite attribute is an attribute that can be divided into smaller sub-parts (e.g., address into street, city, zip); total revenue is a single calculated value, not composed of multiple atomic sub-attributes. Option D is wrong because an atomic attribute is indivisible and stored directly (e.g., price, quantity); total revenue is not stored but derived, so it violates the atomicity principle.
An organization needs to acquire data from a third-party vendor. The data will be used for regulatory reporting. Which of the following should be the primary consideration before acquiring the data?
Regulatory reporting requires adherence to data governance and privacy laws.
Why this answer
When acquiring data for regulatory reporting, legal and compliance requirements must be the primary consideration because the data must adhere to specific laws (e.g., GDPR, HIPAA, SOX) and industry regulations. Failing to ensure compliance can result in legal penalties, fines, or rejection of the report by regulatory bodies. This overrides technical or cost concerns, as non-compliant data is unusable for its intended purpose.
Exam trap
The trap here is that candidates prioritize technical or cost factors (volume, format, price) over the foundational legal and compliance gate, mistakenly assuming any data can be adapted later without verifying regulatory fitness first.
How to eliminate wrong answers
Option B is wrong because the volume of data is a secondary operational concern (e.g., storage, processing bandwidth) but does not address whether the data legally satisfies regulatory mandates. Option C is wrong because data format (e.g., CSV, JSON, XML) is a technical integration detail that can be transformed later, not a primary legal or compliance gate. Option D is wrong because cost is a business negotiation factor; even free data must first meet regulatory requirements to be used for reporting.
A data analyst wants to understand the relationship between advertising spend and sales revenue. The analyst calculates a Pearson correlation coefficient of 0.85. Which of the following is the best interpretation?
r=0.85 indicates strong positive linear relationship.
Why this answer
Pearson r ranges from -1 to +1; 0.85 indicates a strong positive linear relationship, but correlation does not imply causation.
A data analyst wants to retrieve the top 5 highest-paid employees from an 'employees' table, including ties. Which SQL clause should be used?
TOP 5 WITH TIES (SQL Server) includes all rows that tie for the 5th position.
Why this answer
In many SQL dialects, LIMIT can be used to restrict rows. However, to include ties, some databases offer WITH TIES with FETCH FIRST or TOP. Standard SQL: FETCH FIRST 5 ROWS WITH TIES.
TOP 5 alone does not include ties. RANK() with WHERE clause can work but is more complex.
A data analyst is building a dataset from multiple sources and needs to ensure data quality. During the data acquisition phase, which activity is most important to perform?
Profiling assesses data quality and structure before further processing.
Why this answer
Data profiling is the most important activity during the data acquisition phase because it involves examining source data to understand its structure, content, and quality issues before integration. This step identifies missing values, data types, duplicates, and inconsistencies early, preventing downstream errors in analysis. Without profiling, subsequent cleaning and modeling may be based on flawed assumptions about the data.
Exam trap
CompTIA often tests the distinction between data profiling (discovery/assessment) and data cleaning (correction), leading candidates to mistakenly choose cleaning as the first step during acquisition when profiling must come first to identify what needs cleaning.
How to eliminate wrong answers
Option A is wrong because data visualization is a presentation and exploratory analysis technique used after data is acquired and cleaned, not during acquisition. Option B is wrong because data cleaning is a corrective process that typically follows data profiling; performing cleaning without first profiling can waste effort on unknown issues or miss critical quality problems. Option D is wrong because data modeling defines relationships and structures for storage or analysis, which occurs after data is acquired and understood, not during the initial acquisition phase.
A company is analyzing customer feedback sentiment. The dataset is highly imbalanced with 95% positive and 5% negative comments. Which technique should the analyst use to address class imbalance before modeling?
SMOTE generates synthetic minority samples to balance classes.
Why this answer
SMOTE (Synthetic Minority Oversampling Technique) is the correct choice because it generates synthetic samples for the minority class (negative comments) by interpolating between existing minority instances, rather than simply duplicating them. This addresses the 95:5 imbalance without the information loss of undersampling or the overfitting risk of naive oversampling.
Exam trap
The trap here is that candidates often confuse oversampling the minority class with oversampling the majority class, or they incorrectly assume that simply using a different evaluation metric (like accuracy) can fix the imbalance problem without modifying the dataset.
How to eliminate wrong answers
Option A is wrong because accuracy is a misleading metric for imbalanced datasets; a model predicting all comments as positive would achieve 95% accuracy but fail to identify any negative comments. Option B is wrong because undersampling the majority class discards a large amount of potentially useful data, which can lead to loss of important patterns and reduced model performance. Option C is wrong because oversampling the majority class would exacerbate the imbalance, making the model even more biased toward the majority class.
A data analyst is designing a dashboard for a sales team. Which TWO of the following are key performance indicators (KPIs) rather than operational metrics?
Customer retention is a key strategic metric.
Why this answer
Customer retention rate (B) is a key performance indicator (KPI) because it measures the long-term health of customer relationships and directly reflects strategic business goals, such as loyalty and recurring revenue. It is a high-level metric that tracks performance against strategic objectives, unlike operational metrics which focus on day-to-day activities.
Exam trap
The trap here is that candidates often confuse operational metrics (like average time to close a deal) with KPIs because they both appear in sales dashboards, but KPIs must directly measure strategic outcomes rather than process efficiency.
Which TWO of the following are measures of central tendency?
Correct: Median is a measure of central tendency.
Why this answer
Mean, median, and mode are measures of central tendency. Range and standard deviation measure dispersion.
A company's sales report shows revenue of $1.2M, but the calculation method is unclear. What data governance artifact would clarify the definition?
Correct. Data dictionary defines metrics.
Why this answer
A data dictionary provides clear definitions, calculations, and sources for metrics.
In Looker Studio, you have a data source with daily sales and a separate data source with marketing spend. You want to create a chart that shows sales and marketing spend on the same axis, but the two sources are not joined natively. Which feature should you use to combine them?
Blending allows combining multiple data sources in a single chart.
Why this answer
Data blending in Looker Studio allows you to combine data from multiple sources based on a common dimension without requiring a native join.
A data analyst wants to find the top 5 products by total sales amount, but only for products that have been sold more than 50 times. Which SQL query accomplishes this?
Correct use of HAVING, ORDER BY, and LIMIT.
Why this answer
HAVING filters after aggregation, then ORDER BY and LIMIT give the top 5.
Which THREE are challenges in acquiring data from external sources? (Select three.)
External data may have legal restrictions on usage, sharing, or redistribution.
Why this answer
Data format inconsistency occurs when integrating data from different sources. Rate limiting is a common API restriction that limits how much data can be accessed. Licensing restrictions may limit the use or redistribution of acquired data.
Data redundancy is an internal data quality issue, not a challenge specific to acquisition. Unauthorized access is a security concern but not a typical acquisition challenge.
A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?
Blending is used to combine data from multiple sources in Looker Studio.
Why this answer
Blending in Looker Studio allows combining data from different sources based on a common dimension, similar to a left join.
A data analyst needs to sample 10% of customers from each of three regions (North, South, Central) to ensure proportional representation. Which sampling method should be used?
Ensures each region is represented proportionally.
Why this answer
Stratified sampling divides the population into strata (regions) and samples proportionally from each. Simple random sampling would not guarantee proportional representation. Systematic sampling selects every kth element.
Cluster sampling selects entire groups randomly.
Which THREE of the following are examples of descriptive statistics? (Select THREE.)
Correlation coefficient describes the strength of a linear relationship, a descriptive statistic.
Why this answer
The correlation coefficient (A) is a descriptive statistic because it quantifies the strength and direction of a linear relationship between two variables using a single number (ranging from -1 to +1) without making inferences about a larger population. It simply describes the observed data's association, which is the core function of descriptive statistics.
Exam trap
CompTIA often tests the distinction between descriptive and inferential statistics by including p-values and regression coefficients as distractors, exploiting the common misconception that any numerical summary of data is descriptive.
A retail company's data analyst developed a dashboard for store managers to monitor daily sales performance. The dashboard includes numerous metrics such as sales by hour, product category, employee, and customer demographics, along with trend lines and forecast graphs. Despite the comprehensive data, store managers are ignoring the dashboard because they find it cluttered and confusing. They prefer to rely on their intuition and verbal updates from shift leads. The analyst needs to improve communication of data insights to ensure the dashboard is used effectively. Which of the following actions should the analyst take FIRST?
This directly addresses the managers' feedback and makes insights easier to grasp.
Why this answer
The core issue is that the dashboard is cluttered and confusing, which directly undermines its usability. Option B addresses this by simplifying the dashboard to focus on key metrics and using a clear visual hierarchy, which is the foundational step in effective data communication. Without first reducing cognitive load, no amount of training or additional data will make the dashboard useful for time-constrained store managers.
Exam trap
The trap here is that candidates may confuse 'comprehensive data' with 'effective communication,' leading them to choose options that add more information (D) or provide raw data (A), rather than recognizing that clarity and focus are the primary drivers of dashboard adoption.
How to eliminate wrong answers
Option A is wrong because sending raw data in a spreadsheet would exacerbate the problem by overwhelming managers with unstructured, granular data, requiring them to perform their own analysis—the opposite of a dashboard's purpose. Option C is wrong because scheduling a training session to explain all metrics assumes the problem is a lack of understanding, not the dashboard's poor design; training a user to navigate a cluttered interface is inefficient and does not fix the root cause. Option D is wrong because adding more data points would increase clutter and confusion, directly contradicting the user feedback that the dashboard is already too complex.
A data analyst wants to use a Z-score to standardize a dataset. The variable has a mean of 50 and a standard deviation of 10. What is the Z-score for a raw value of 70?
Correct Z-score.
Why this answer
Z = (X - mean) / std = (70 - 50) / 10 = 2.
Which chart type is best for visualizing the correlation between two continuous variables?
Scatter plots are designed to show correlation between two continuous variables.
Why this answer
Scatter plots show the relationship between two continuous variables, making them ideal for visualizing correlation.
A data analyst receives a file with the extension .json. This file contains product information with attributes that vary between records. How should this file be classified?
JSON is a common semi-structured format with tags and nested elements.
Why this answer
A JSON file with varying attributes per record is a classic example of semi-structured data. Unlike strictly structured data (e.g., a relational table with fixed columns), JSON allows each object to have a different set of key-value pairs, making it schema-flexible. This self-describing nature, where metadata is embedded within the data itself, is the defining characteristic of semi-structured formats.
Exam trap
The trap here is that candidates confuse 'structured data' with any data that has a format or organization, forgetting that structured data specifically requires a fixed, predefined schema enforced at write time, unlike JSON's flexible schema-on-read approach.
How to eliminate wrong answers
Option B is wrong because structured data requires a rigid, predefined schema (like a SQL table with fixed columns and data types), which JSON explicitly does not enforce. Option C is wrong because transactional data refers to records of business events (e.g., sales, orders) and is a classification by use case, not by format; a JSON file can contain transactional data, but the question asks how the file itself should be classified based on its structure. Option D is wrong because unstructured data lacks any internal structure or metadata (e.g., raw text, images, audio), whereas JSON has a clear hierarchical structure with keys and values.
A data analyst notices that the sales numbers in a report differ from the numbers in the finance department's spreadsheet. This discrepancy is most likely due to a lack of:
Without a single source of truth, different reports may show conflicting numbers.
Why this answer
A single version of truth means all departments use the same centralized data, avoiding inconsistencies.
A data analyst notices that a dataset of customer ages has several missing values. Which method for handling missing data is most appropriate if the data is missing completely at random and the analyst wants to preserve sample size?
Mean imputation is simple and preserves sample size.
Why this answer
Mean imputation replaces missing values with the mean, preserving sample size, but can bias estimates. However, for MCAR, it is a common simple approach.
A dataset contains a 'salary' column. The analyst wants to identify outliers using the IQR method. If Q1 = 40,000 and Q3 = 70,000, what is the upper threshold for a non-outlier?
Correct calculation: 70,000 + 1.5*30,000 = 115,000.
Why this answer
Upper threshold = Q3 + 1.5 * IQR. IQR = 70,000 - 40,000 = 30,000. So upper = 70,000 + 45,000 = 115,000.
An organization is implementing a data warehouse to support business intelligence reporting. The data warehouse must ensure that transactions are processed reliably. Which property guarantees that each transaction is treated as a single, indivisible unit?
Atomicity ensures a transaction is completed fully or not at all.
Why this answer
Atomicity (option C) is the correct property because it ensures that a transaction is treated as a single, indivisible unit of work. In the context of a data warehouse, this means that either all operations within the transaction are committed successfully, or none are applied, preventing partial updates that could corrupt the data. This is a core component of the ACID (Atomicity, Consistency, Isolation, Durability) model, which is fundamental to reliable transaction processing in databases like SQL Server, Oracle, or PostgreSQL.
Exam trap
The trap here is that candidates often confuse atomicity with consistency, thinking that 'indivisible unit' means the data must be consistent, but consistency is a separate property that ensures data integrity rules are met, not that the transaction is all-or-nothing.
How to eliminate wrong answers
Option A (Consistency) is wrong because consistency ensures that a transaction brings the database from one valid state to another, preserving all defined rules (e.g., constraints, triggers), but it does not guarantee that the transaction is treated as a single unit. Option B (Isolation) is wrong because isolation controls how transaction changes are visible to other concurrent transactions, preventing dirty reads and other anomalies, but it does not address the indivisibility of the transaction itself. Option D (Durability) is wrong because durability guarantees that once a transaction is committed, its changes persist even in the event of a system failure (e.g., via write-ahead logging), but it does not ensure the transaction is atomic.
A data analyst is cleaning a dataset with missing values. Which TWO of the following are acceptable methods for handling missing numerical data?
Correct: Replacing missing with mean is acceptable.
Why this answer
Mean imputation and deletion (listwise) are common methods. Mode imputation is for categorical, and forward-fill is for time series; min-max is normalisation.
The exhibit shows a SQL query result intended for a bar chart of revenue by region. However, the chart shows only the top 10 regions, but the query returns all regions. What is the most likely cause?
Many tools limit categories to avoid clutter unless configured otherwise.
Why this answer
The SQL query itself returns all regions because there is no LIMIT clause. However, the visualization tool has a built-in default limit on the number of categories displayed, such as top 10, which truncates the data in the chart. This is the most likely cause, making Option B correct.
Options A, C, and D are incorrect: the GROUP BY clause is correctly specified, a WHERE clause is not required to get all regions, and the ORDER BY clause may be applied for sorting but the tool's limit overrides the full result set.
A manager in operations needs a real-time dashboard showing production line status, including machine uptime and error counts. Which type of report is most appropriate?
Operational reports deliver real-time status for operations.
Why this answer
Operational reports provide real-time or near-real-time data for monitoring ongoing processes.
A data analyst needs to retrieve all unique job titles from the employees table. Which SQL clause should be used with the SELECT statement?
DISTINCT filters out duplicate rows.
Why this answer
The DISTINCT keyword is used to return only distinct (different) values.
Practice DA0-002 by domain
Target a specific domain to shore up weak areas.