986 questions total · 14pages · All types, answers revealed
Page 1 of 14
Page 2A business analyst creates a one-time report to analyze customer churn for a special project. Which report type is being used?
Ad hoc reports are designed for a specific, one-time need.
Why this answer
A one-time, custom query for a specific purpose is an ad hoc report.
A healthcare provider needs to integrate patient data from multiple clinics into a single data warehouse. Which process is used to extract, transform, and load the data?
ETL extracts data, transforms it, and loads it into the warehouse, suitable for structured integration.
Why this answer
ETL (Extract, Transform, Load) is the correct process because the healthcare provider must first extract data from multiple source clinics, then transform it (e.g., standardize formats, clean duplicates, apply business rules) before loading it into the target data warehouse. This ensures data quality and consistency, which is critical for clinical analytics and reporting.
Exam trap
The trap here is confusing ETL with ELT, where candidates assume ELT is always better due to modern big data tools, but the question explicitly describes a traditional data warehouse integration requiring pre-load transformations.
How to eliminate wrong answers
Option A is wrong because ELT (Extract, Load, Transform) loads raw data into the target system first and transforms it later, which is less suitable for a data warehouse requiring pre-integrated, clean data from multiple sources; it is more common in big data environments like Hadoop. Option C is wrong because OLAP (Online Analytical Processing) is a category of database systems optimized for complex queries and multidimensional analysis, not a data integration process. Option D is wrong because OLTP (Online Transaction Processing) is designed for high-volume transactional operations (e.g., recording patient visits), not for extracting, transforming, and loading data into a warehouse.
An analyst runs an A/B test with 1000 users per group and observes a conversion rate of 5% in the control and 6% in the treatment. The p-value is 0.12. What should the analyst conclude?
Correct interpretation.
Why this answer
Since p-value > 0.05, we fail to reject the null hypothesis; the observed difference is not statistically significant.
Refer to the exhibit. Before running the code, the original salary column had 50 missing values. The median was calculated as 52000. After imputation, which of the following statements is true?
Since missing values are replaced by the median, the median of the dataset does not change.
Why this answer
Imputing missing values with the median (52000) replaces only the 50 missing entries with that value, leaving all original non-missing values unchanged. Since the median is a positional statistic, adding values equal to the current median does not shift the middle position of the sorted data, so the median remains unchanged. This is why option C is correct.
Exam trap
CompTIA often tests the misconception that imputing with the median will change the median itself, when in fact adding values equal to the current median leaves the median unchanged because it is a rank-based statistic.
How to eliminate wrong answers
Option A is wrong because imputing with the median does not significantly change the mean; the mean may shift slightly toward the median but not decrease significantly unless the missing values were extremely high. Option B is wrong because adding values exactly at the median reduces variance (since imputed values are all equal to the median), so the standard deviation decreases, not increases. Option D is wrong because the minimum value is unaffected—imputation only adds values at the median, which is far above the minimum, so the minimum remains the same.
An analyst is using Python pandas and has a DataFrame 'sales' with columns 'date', 'product', 'revenue'. They need to create a pivot table showing total revenue per product per month. Which pandas function is most appropriate?
pivot_table creates a matrix with products as rows and months as columns.
Why this answer
pivot_table is specifically designed to reshape data and aggregate values based on index and columns.
In A/B testing, the null hypothesis typically states that:
Correct definition of null hypothesis.
Why this answer
The null hypothesis (H0) is a statement of no effect or no difference between groups.
A data analyst needs to identify the top 3 most frequent product categories from a sales table. Which SQL techniques can be used to achieve this? (Choose two.)
Using window function DENSE_RANK() with QUALIFY (or in a subquery) returns top 3 categories including ties.
Why this answer
Both GROUP BY with ORDER BY and LIMIT, and using a window function like DENSE_RANK() to rank categories by count and filter top 3, are valid. HAVING is for filtering groups after aggregation, but without ORDER BY and LIMIT, it doesn't give top 3. A subquery with COUNT(*)>3 would get categories with count >3, not top 3.
LEFT JOIN is irrelevant.
A data analyst wants to show the relative proportions of defects by type in a manufacturing process. There are 6 defect types. Which chart is most appropriate?
Pie chart effectively shows each defect type's share of total.
Why this answer
A pie chart is standard for showing parts of a whole, especially with few categories. Bar chart is also possible but not the best for proportions. Scatter and line charts are not for proportions.
A retail company wants to analyze customer purchase patterns over time. The data is stored in a relational database with tables for Customers, Orders, and Products. Which database concept should be used to ensure that each order references a valid customer?
A foreign key links tables by referencing a primary key in another table, maintaining referential integrity.
Why this answer
A foreign key constraint enforces referential integrity by ensuring that every value in the 'customer_id' column of the Orders table matches a valid primary key value in the Customers table. This prevents orphaned records and guarantees that each order references an existing customer.
Exam trap
CompTIA often tests the distinction between a primary key (which enforces uniqueness within a table) and a foreign key (which enforces relationships between tables), leading candidates to mistakenly choose primary key when the question asks about cross-table validation.
How to eliminate wrong answers
Option A is wrong because a view is a virtual table based on a query and does not enforce any constraints between tables. Option B is wrong because an index speeds up data retrieval but does not enforce referential integrity or validate relationships. Option C is wrong because a primary key uniquely identifies rows within its own table and cannot enforce relationships between different tables.
An analyst wants to show the trend of monthly sales over the past two years. Which chart type is most appropriate?
Line charts clearly display trends over time.
Why this answer
A line chart is best for showing trends over time.
A healthcare organization is subject to strict data privacy regulations requiring the classification of all data assets. The data governance team has identified three data sensitivity levels: Public, Internal, and Restricted. They have a new data pipeline importing patient health records from multiple clinics. The records include patient names, diagnoses, treatment codes, and insurance information. The team must ensure that the classification is applied correctly and that restricted data (e.g., diagnoses) is not exposed to unauthorized personnel. However, the pipeline uses automated tagging based on metadata rules, and some fields are misclassified. What is the most effective immediate action to improve classification accuracy?
Correct: DLP can reclassify based on actual content, improving accuracy.
Why this answer
Implementing DLP tools with content inspection can automatically detect sensitive patterns (e.g., diagnosis codes) and enforce correct classification, directly addressing misclassification from incomplete metadata rules. Option A (encrypting all data) is a security measure but does not fix classification accuracy. Option B (manual review) is not scalable for a pipeline.
Option C (expanding metadata rules) may help but is less effective since metadata can still miss patterns that DLP content inspection can catch.
Which TWO of the following are benefits of database normalization to 3NF? (Select 2)
Normalization eliminates duplicate data.
Why this answer
Normalization to 3NF eliminates transitive dependencies, which directly reduces data redundancy by ensuring each non-key attribute depends only on the primary key. This reduction in redundancy also increases data integrity because updates, inserts, and deletes are less likely to create inconsistencies or anomalies. In a relational database, 3NF achieves this without sacrificing the ability to reconstruct the original data via joins.
Exam trap
The trap here is that candidates confuse normalization with denormalization, assuming that reducing redundancy always improves query performance, when in fact normalization often increases join complexity and can slow down read queries.
Which TWO of the following are effective techniques for presenting data to a non-technical audience?
Callouts draw attention to key findings.
Why this answer
Highlighting key insights with callouts directly addresses the needs of a non-technical audience by drawing attention to the most important findings without requiring them to interpret complex data. This technique aligns with best practices for data storytelling, where visual emphasis on critical points improves comprehension and retention for stakeholders who may not have a technical background.
Exam trap
CompTIA often tests the misconception that non-technical audiences need more data (tables, statistics) to understand insights, when in fact they need less—focusing on simplicity, visual emphasis, and clear language—so candidates mistakenly choose options A, B, or D thinking they are thorough.
A data analyst wants to visualize the number of website visitors by traffic source (e.g., organic, paid social, email) and also show the proportion of each source within the total. Which chart type is best?
Stacked bar charts show both category totals and subcategory proportions.
Why this answer
A stacked bar chart is best because it allows the data analyst to display both the absolute number of visitors per traffic source and the proportional contribution of each source to the total across categories (e.g., time periods). Each bar represents the total visitors, and segments within the bar show the breakdown by source, making it easy to compare both individual source counts and their relative shares.
Exam trap
The trap here is that candidates often choose a pie chart because it shows proportions, but fail to recognize that the question requires displaying both absolute visitor counts and proportions, which a pie chart cannot do for multiple categories or time periods.
How to eliminate wrong answers
Option B (Histogram) is wrong because histograms display the distribution of a single continuous variable by binning data into intervals, not categorical comparisons of traffic sources. Option C (Pie chart) is wrong because while it shows proportions of a whole, it cannot effectively display absolute visitor counts for multiple categories or allow easy comparison across different time periods. Option D (Line chart) is wrong because line charts are designed to show trends over continuous time intervals, not categorical breakdowns of proportions within a total.
An analyst computed the mean, median, and mode of a dataset and found they are all equal. Which of the following best describes the distribution?
Symmetric distributions have equal mean, median, and mode.
Why this answer
When mean, median, and mode are equal, the distribution is symmetric and unimodal, often resembling a normal distribution.
An analyst needs to present quarterly sales data to the board. The CEO wants to see both overall trend and breakdown by region. Which dashboard layout is most effective?
This layout clearly shows the overall trend and regional contributions in a cohesive way.
Why this answer
It simultaneously satisfies the CEO's dual requirement: a line chart clearly shows the overall quarterly sales trend, while a stacked area chart breaks down total sales by region, allowing the board to see both the aggregate performance and the contribution of each region over time. This combination leverages the strengths of each chart type—line for trend clarity and stacked area for part-to-whole relationships—without overloading the viewer with data.
Exam trap
The trap here is that candidates often choose a single line chart (Option A) thinking it shows both trend and breakdown, but they overlook that multiple overlapping lines make it hard to see the aggregate trend, which is the CEO's primary need.
How to eliminate wrong answers
Option A is wrong because a single line chart with all regions would create visual clutter and make it difficult to discern the overall trend from the regional lines, especially if regions have overlapping values; it fails to provide a clear aggregate view. Option B is wrong because a KPI card with total sales only shows a single number, which cannot convey the quarterly trend or regional breakdown required by the CEO. Option D is wrong because a table with all quarterly figures forces the board to manually parse numbers to identify trends and regional contributions, which is inefficient for a high-level presentation and violates the principle of data visualization for quick insight.
A time series of monthly sales data exhibits a clear upward trend over several years, with consistent peaks each December. Which components are present in this series?
Correct identification.
Why this answer
The upward trend is a trend component, and the consistent December peaks indicate seasonality.
A dataset contains a feature with values ranging from 10 to 1000. The analyst applies min-max normalization to scale the feature between 0 and 1. What is the normalized value of 520?
Calculation yields 0.515.
Why this answer
Min-max normalization formula: (x - min) / (max - min) = (520 - 10) / (1000 - 10) = 510 / 990 = 0.515.
A data analyst needs to count the number of orders placed by each customer, but only for customers who have placed more than 5 orders. Which SQL clause should be used to filter the aggregated results?
Correct. HAVING filters aggregated results.
Why this answer
HAVING is used to filter groups after aggregation. The query would use GROUP BY customer_id, then HAVING COUNT(*) > 5.
A government agency's data analyst is commissioned to produce a report on public transportation usage trends. The report will be read by policymakers, transit planners, and the general public. The data includes ridership numbers, delay rates, and demographic breakdowns. The analyst needs to ensure the report is accessible and persuasive, especially to non-technical readers. The goal is to advocate for increased funding in underserved areas. The report must be data-driven but also tell a compelling story. What strategy should the analyst prioritize?
Makes data relatable and persuasive, driving home the need for funding.
Why this answer
It directly addresses the need to make data accessible and persuasive to non-technical readers by weaving a narrative around a specific, relatable impact (delayed trains on low-income commuters). This approach aligns with the goal of advocating for increased funding in underserved areas, as it humanizes the data and creates a compelling story that policymakers and the public can understand and act upon, without requiring technical expertise.
Exam trap
The trap here is that candidates often choose Option C (complex statistical analysis) because they equate 'data-driven' with technical rigor, failing to recognize that the exam's focus on 'communicating data insights' prioritizes accessibility and persuasion over statistical complexity for non-technical stakeholders.
How to eliminate wrong answers
Option A is wrong because providing raw data only in appendices fails to make the report accessible or persuasive; it buries the key insights and requires readers to perform their own analysis, which is ineffective for non-technical audiences. Option C is wrong because using complex statistical analysis (e.g., p-values, regression coefficients) would alienate non-technical readers like the general public and many policymakers, making the report inaccessible and undermining its persuasive power. Option D is wrong because focusing solely on ridership numbers without context (e.g., demographic breakdowns, delay rates) provides no narrative or actionable insight, failing to tell a compelling story or advocate for specific funding needs.
A company uses a dashboard to monitor server uptime. The data is collected every minute, but the dashboard only refreshes every hour. Users see gaps in the line chart. What is the most likely cause, and how should it be fixed?
Refreshing every minute eliminates gaps because data is fetched in near real-time.
Why this answer
The gaps occur because the dashboard aggregates data over one-hour intervals, while data is collected every minute. When the dashboard refreshes, it only shows the latest one-hour snapshot, so data between refreshes is missing. Increasing the dashboard refresh rate to match data collection frequency ensures continuous display.
Interpolation (option A) would artificially fill gaps, masking the issue rather than fixing it; the correct solution is to align refresh rates.
A data analyst is creating a dashboard for a retail company. The dashboard should provide insights into sales performance across multiple dimensions. Which TWO chart types are best suited for showing the contribution of each product category to total sales?
Pie charts effectively show each category's proportion of the total.
Why this answer
A pie chart is ideal for showing the contribution of each product category to total sales because it visually represents parts of a whole, making it easy to compare proportions at a glance. The stacked bar chart also effectively shows category contributions within a total, allowing for both absolute and relative comparisons across different time periods or segments. Both chart types directly address the need to visualize proportional breakdowns of a single aggregate metric.
Exam trap
The trap here is that candidates often choose a line chart (Option D) for any sales data because they associate sales with trends, overlooking that the question specifically asks for contribution to total sales, not change over time.
Which chart type is best for comparing the distribution of a continuous variable across different categories?
Box plots effectively compare distributions across categories.
Why this answer
Box plots provide a summary of distribution including median, quartiles, and outliers, making them ideal for comparing distributions across groups.
A data analyst wants to show the distribution of customer ages for a retail store. The ages are continuous and the analyst needs to visualize the frequency of different age ranges. Which chart type is most appropriate?
Histograms display frequency distributions of continuous variables.
Why this answer
A histogram is used to display the distribution of a continuous variable by grouping data into bins.
A data analyst discovers an anomaly in a dataset. Which two actions should be taken before reporting? (Choose TWO.)
This confirms the anomaly is not due to data collection issues.
Why this answer
Before reporting an anomaly, the data analyst must verify the data source and extraction process to ensure the anomaly is not due to a pipeline error, such as a misconfigured ETL job or a corrupted data feed. This step confirms data integrity and prevents false alarms based on extraction artifacts rather than genuine data issues.
Exam trap
The trap here is that candidates may confuse 'immediate reporting' with proactive communication, but CompTIA Data+ expects the understanding that data validation must precede any stakeholder notification to maintain data credibility.
A data analyst needs to combine customer data from two tables: Customers (CustomerID, Name) and Orders (OrderID, CustomerID, Amount). Only customers who have placed at least one order should be included. Which JOIN type should be used?
INNER JOIN returns only matching rows, which are customers with orders.
Why this answer
An INNER JOIN returns only rows where there is a match in both tables. Since the requirement is to include only customers who have placed at least one order, the INNER JOIN on CustomerID will filter out any customer without a matching order record, exactly meeting the condition.
Exam trap
The trap here is that candidates often choose LEFT JOIN thinking it 'includes all customers' without realizing it also includes customers with no orders, which fails the explicit condition of 'only customers who have placed at least one order'.
How to eliminate wrong answers
Option B (LEFT JOIN) is wrong because it would include all customers, even those with no orders, with NULL values for order columns, which violates the 'only customers who have placed at least one order' requirement. Option C (FULL OUTER JOIN) is wrong because it would include customers without orders and orders without customers, both of which are not needed. Option D (RIGHT JOIN) is wrong because it would include all orders, potentially including orders with no matching customer, and still would not restrict customers to only those with orders.
A large retail company is integrating customer data from two separate CRM systems into a new data warehouse. System A stores customer IDs as integers (e.g., 12345), while System B stores them as alphanumeric strings (e.g., 'CUST-12345-X'). Additionally, some customers exist in both systems but with slight name variations (e.g., 'John Smith' vs 'Jon Smith'). The data warehouse requires a unified customer table with a single unique identifier for each customer. The analyst needs to design the data acquisition process. Which of the following is the most appropriate first step?
Profiling provides the necessary insights to plan transformations, handle inconsistencies, and design the matching strategy.
Why this answer
Data profiling is the foundational first step in any data integration project. It systematically assesses source data types, formats, completeness, and quality issues (e.g., integer vs. alphanumeric IDs, name variations) before designing transformation logic. Without profiling, subsequent steps like fuzzy matching or ID standardization risk being built on incorrect assumptions about the data.
Exam trap
The trap here is that candidates often jump to a technical solution (fuzzy matching or ID standardization) without recognizing that data profiling is the prerequisite step that validates source assumptions and prevents costly rework.
How to eliminate wrong answers
Option A is wrong because exact name matches cannot resolve the known name variations (e.g., 'John Smith' vs 'Jon Smith'), leading to missed linkages and duplicate customers. Option B is wrong because loading all data into a staging table before profiling risks propagating unknown data quality issues (e.g., inconsistent ID formats, nulls) into the staging area, making fuzzy matching less reliable and harder to tune. Option D is wrong because standardizing IDs to a common format (e.g., UUIDs) without first profiling the source data ignores the need to understand existing relationships and quality issues, and may break referential integrity if applied prematurely.
A data analyst needs to show the cumulative revenue over time, with emphasis on the total magnitude. Which chart type is most appropriate?
Area charts are ideal for cumulative trends over time.
Why this answer
Area charts display cumulative values over time, filling the area under the line to emphasize magnitude.
An analyst is comparing the average sales of two different store locations using a t-test. The p-value obtained is 0.03, and the significance level is 0.05. What should the analyst conclude?
Correct interpretation.
Why this answer
Since p-value (0.03) < α (0.05), we reject the null hypothesis, indicating a statistically significant difference in mean sales between the two locations.
A data analyst is working with a dataset that includes customer names, email addresses, and purchase history. The analyst wants to ensure that each customer is uniquely identified. Which TWO database concepts should be used to enforce uniqueness and link related data?
A foreign key links purchase history to customers, maintaining relationships.
Why this answer
A primary key uniquely identifies each row in a table, ensuring no duplicate customer records. A foreign key links related data across tables by referencing the primary key of another table, enforcing referential integrity. Together, they guarantee uniqueness and enable relational joins between customer and purchase history tables.
Exam trap
The trap here is that candidates often confuse normalization with a constraint or think an index enforces uniqueness, when only primary and foreign keys provide the required referential integrity and unique identification.
A data analyst creates a line chart showing monthly sales over the past year. The chart uses a y-axis starting at $100,000 instead of zero. What is the most likely misinterpretation a viewer might have?
A non-zero baseline exaggerates differences, which can mislead viewers about the magnitude of change.
Why this answer
Starting the y-axis at $100,000 instead of zero truncates the baseline, which visually exaggerates the relative differences between monthly sales values. This is a common data visualization pitfall that can mislead viewers into perceiving small fluctuations as significant trends, violating the principle of using a zero baseline for bar and line charts to accurately represent proportional change.
Exam trap
The trap here is that candidates may think a truncated y-axis only affects bar charts or that it reverses trends, but CompTIA often tests the specific misinterpretation that small changes appear exaggerated due to the loss of a zero baseline, not that the direction of the trend is flipped.
How to eliminate wrong answers
Option B is wrong because a truncated y-axis does not inherently reverse the direction of a trend; it only amplifies the visual magnitude of changes, so sales that are actually increasing would still appear to increase, just more dramatically. Option C is wrong because the chart is not correctly scaled for accurate proportional interpretation; starting the y-axis at a non-zero value is a deliberate distortion that can mislead viewers, and best practices for data visualization recommend a zero baseline for line charts showing magnitude. Option D is wrong because a truncated y-axis does not reverse the direction of a trend; if sales are actually decreasing, they would still appear to decrease, but the visual drop would be exaggerated, not inverted.
A data analyst is preparing to run an A/B test comparing two email subject lines. Which TWO of the following should the analyst define before the test begins?
Needed to frame the test and interpret results.
Why this answer
Before A/B testing, define null and alternative hypotheses, and determine sample size needed for desired statistical power and effect size.
In a dataset of employee salaries, the analyst notices one value that is significantly higher than the rest. Using the IQR method, which values are typically considered outliers?
Standard IQR outlier definition.
Why this answer
Outliers are values less than Q1 - 1.5*IQR or greater than Q3 + 1.5*IQR.
A retailer wants to test if a new website layout increases the average time spent on the site. They split traffic: control group (old layout) and treatment group (new layout). Which statistical test is most appropriate to compare the average time spent between the two groups?
Compares means of two independent groups.
Why this answer
A t-test is used to compare means of two independent groups.
A data analyst is performing a hypothesis test with a significance level of 0.05. The p-value obtained is 0.03. What should the analyst conclude?
p < alpha indicates statistically significant result.
Why this answer
Since the p-value (0.03) is less than the significance level (0.05), the result is statistically significant. This means the observed data provides sufficient evidence to reject the null hypothesis in favor of the alternative hypothesis. The analyst should conclude that there is a statistically significant effect or difference.
Exam trap
The trap here is that candidates often confuse 'fail to reject' with 'accept' the null hypothesis, or they mistakenly think a p-value less than α means the null hypothesis is proven false with certainty, rather than just providing sufficient evidence to reject it.
How to eliminate wrong answers
Option B is wrong because failing to reject the null hypothesis occurs only when the p-value is greater than or equal to the significance level (p ≥ 0.05), not when it is smaller. Option C is wrong because hypothesis testing never 'accepts' the null hypothesis; we either reject it or fail to reject it, as acceptance implies proof of truth, which is not a valid statistical conclusion. Option D is wrong because practical significance is a separate consideration from statistical significance; a statistically significant result (p < 0.05) does not automatically imply practical importance, and the question only asks about the hypothesis test conclusion.
A data analyst wants to sample a large dataset of customer transactions. Which TWO sampling methods are probability-based and ensure every element has a known chance of being selected? (Select TWO.)
Every element has an equal chance.
Why this answer
Simple random sampling and stratified sampling are probability-based methods where each element has a known probability. Systematic sampling is also probability-based but the question asks for TWO; convenience sampling is non-probability, and cluster sampling is probability-based but the question likely expects the two most common.
A data analyst needs to visualize the relationship between advertising spend and sales revenue for 50 products. Which chart type is most appropriate?
Scatter plots show correlation between two variables.
Why this answer
A scatter plot is the most appropriate chart type for visualizing the relationship between two continuous variables—advertising spend and sales revenue—across 50 products. It allows the data analyst to assess correlation, trends, and potential outliers by plotting each product as a point on a Cartesian plane, with advertising spend on the x-axis and sales revenue on the y-axis.
Exam trap
The trap here is that candidates often confuse a bar chart or histogram with a scatter plot when the question involves two numeric variables, but a bar chart is designed for categorical comparisons and a histogram for single-variable distributions, not for bivariate relationships.
How to eliminate wrong answers
Option A is wrong because a histogram is used to display the distribution of a single continuous variable by grouping data into bins, not to show the relationship between two variables. Option B is wrong because a bar chart compares categorical data or discrete values, not the continuous relationship between two numeric variables like advertising spend and sales revenue. Option C is wrong because a pie chart shows proportions of a whole for categorical data, making it unsuitable for visualizing the correlation between two continuous variables.
A data analyst runs an A/B test on a new website layout. The test yields a p-value of 0.04 with the null hypothesis being no difference in conversion rates. The significance threshold is α=0.05. Which of the following is the correct conclusion?
Correct interpretation: statistically significant difference exists.
Why this answer
Since p-value (0.04) < α (0.05), we reject the null hypothesis and conclude there is a statistically significant difference. However, statistical significance does not guarantee practical significance.
An analyst needs to retrieve the year from an order_date column (datetime type). Which function should be used in SQL?
EXTRACT is the standard SQL function for date parts.
Why this answer
EXTRACT(YEAR FROM order_date) is the standard SQL function to get the year part.
Which TWO of the following are common assumptions of linear regression?
Correct. Independence of observations is a key assumption of linear regression; violations can lead to biased standard errors.
Why this answer
Linear regression relies on several assumptions for valid OLS estimation. Two fundamental assumptions are independence of observations (option A), meaning the residuals are independent, and linearity of the relationship (option C), meaning the model correctly specifies a linear relationship between predictors and outcome. While homoscedasticity (equal variance of residuals) is also an important assumption, it is not listed as one of the two most common assumptions in this context.
Options B and D are incorrect: no multicollinearity applies only to multiple regression, and normality of the dependent variable is not required; rather, normality of residuals is needed for hypothesis testing.
Exam trap
Candidates often confuse homoscedasticity as an assumption that must be strictly satisfied, but it is actually a requirement for efficiency of OLS estimators. However, in many definitions, independence and linearity are considered the primary assumptions.
A business intelligence analyst is designing a dashboard for executives. The dashboard includes revenue, profit margin, and customer satisfaction score. To maximize the data-ink ratio, the analyst should:
Minimal non-data ink increases the data-ink ratio.
Why this answer
Maximizing data-ink ratio means removing non-data ink (chartjunk) and redundant labels, focusing on the data itself.
A data analyst needs to combine two datasets: one contains customer information (customer_id, name, address) and the other contains order information (order_id, customer_id, order_date). The analyst wants to include all customers, even those who have not placed orders. Which type of join should be used?
LEFT JOIN includes all customers, with order data where available.
Why this answer
A LEFT JOIN returns all rows from the left table (customers) and the matching rows from the right table (orders). If a customer has no orders, the order columns will contain NULLs. This satisfies the requirement to include all customers, even those without orders.
Exam trap
The trap here is that candidates often confuse LEFT JOIN with INNER JOIN, assuming all customers must have orders, or they pick FULL OUTER JOIN thinking it includes all customers, but it also includes unmatched orders, which is not required.
How to eliminate wrong answers
Option A is wrong because a FULL OUTER JOIN returns all rows from both tables, which would include unmatched orders (if any) — unnecessary for this requirement. Option B is wrong because an INNER JOIN returns only rows with matching keys in both tables, excluding customers who have never placed an order. Option D is wrong because a RIGHT JOIN returns all rows from the right table (orders) and only matching rows from the left table (customers), which would exclude customers without orders.
A data analyst is creating a data story about sales performance. Which THREE elements are essential for effective data storytelling? (Choose THREE.)
Provides structure and guides the audience.
Why this answer
A clear narrative with a beginning, middle, and end is the structural backbone of effective data storytelling. It guides the audience through the data insights in a logical, engaging sequence, transforming raw numbers into a compelling story that drives understanding and retention.
Exam trap
CompTIA often tests the distinction between supporting elements (like raw data tables or chart variety) and the core structural components (narrative, context, call to action) that define effective data storytelling.
Refer to the exhibit. What does the query return?
HAVING COUNT(*) > 5 ensures only customers with more than 5 orders are included.
Why this answer
The query uses a HAVING clause with COUNT(*) > 5, which filters groups (by customer ID) to only those with more than 5 orders. The GROUP BY customer ID ensures the count is per customer, so the result is customers who have placed more than 5 orders. Option C is correct because the condition is strictly greater than 5, not at least 5.
Exam trap
CompTIA often tests the distinction between 'at least' (>=) and 'more than' (>) in HAVING clauses, and candidates may misread the condition as including exactly 5 orders.
How to eliminate wrong answers
Option A is wrong because the query does not return all orders; it returns aggregated results (counts) per customer, not individual order rows. Option B is wrong because the condition is COUNT(*) > 5, not COUNT(*) >= 5; 'at least 5' would include exactly 5, which is excluded by the strict greater-than operator. Option D is wrong because the HAVING clause filters out customers with 5 or fewer orders; the query does not return all customers who have placed orders, only those exceeding the threshold.
Match each data quality dimension to its description.
Drag a concept onto its matching description — or click a concept then click the description.
Degree to which data correctly reflects real-world values
Extent to which all required data is present
Absence of contradictions across data sources
Data is up-to-date and available when needed
No duplicate records exist within the dataset
Why these pairings
The correct matches are: Accuracy - data correctly reflects real-world values; Completeness - all required data is present; Consistency - data values are the same across systems; Timeliness - data is available when needed. Common confusions include mixing timeliness with accuracy and consistency with completeness.
A data analyst is performing a chi-square test of independence on a 2x2 contingency table. The p-value is 0.04. At α=0.05, which THREE of the following statements are correct?
Correct: Significant association exists.
Why this answer
Since p < α, reject the null hypothesis, meaning there is an association. The test does not measure strength (Cramer's V does) and does not identify specific categories.
A dataset contains height measurements in centimeters and inches. An analyst wants to apply k-means clustering. Which data transformation should be applied before clustering?
Normalization ensures equal weight from all features.
Why this answer
Min-max normalization scales features to a range, often [0,1], which is appropriate for distance-based algorithms like k-means.
A data analyst is testing whether a new website layout increases conversion rate. The p-value from the test is 0.03. Using a significance level of 0.05, what is the correct conclusion?
Correct interpretation.
Why this answer
Since p-value (0.03) < α (0.05), we reject the null hypothesis and conclude there is a statistically significant difference.
A data analyst notices that a column labeled 'Income' contains values like '$50,000' and '$75,000', but also 'High' and 'Low'. What data concept issue is occurring?
Income should be quantitative, but text labels are qualitative.
Why this answer
The 'Income' column contains both numeric values (e.g., '$50,000', '$75,000') which are quantitative data, and categorical labels ('High', 'Low') which are qualitative data. Mixing these two distinct data types in a single column violates data consistency principles and prevents proper statistical analysis or machine learning processing. This is a classic example of mixing quantitative and qualitative data.
Exam trap
CompTIA often tests the distinction between data type categories (quantitative vs. qualitative) versus subtypes (discrete/continuous or nominal/ordinal), so candidates mistakenly pick a subtype option when the core issue is the fundamental type mismatch.
How to eliminate wrong answers
Option B is wrong because discrete and continuous data are both subtypes of quantitative data (e.g., number of children vs. height), but the issue here is mixing numbers with text labels, not distinguishing between countable and measurable values. Option C is wrong because nominal and ordinal data are both categorical (qualitative) subtypes (e.g., colors vs. rankings), but the column includes actual numeric income values, not just ordered categories. Option D is wrong because structured data refers to organized formats like tables (which this column is part of), while unstructured data refers to free-form text or media; the problem is not about format but about inconsistent data types within a structured field.
A company is designing a dashboard for real-time monitoring. Which THREE considerations are most critical?
Thresholds trigger notifications when metrics go out of range, enabling prompt action.
Why this answer
Alert thresholds (B) are critical for real-time monitoring because they define the conditions that trigger notifications when metrics exceed or fall below acceptable ranges. Without thresholds, the dashboard cannot proactively alert operators to anomalies, defeating the purpose of real-time oversight. This directly supports the domain of communicating data insights by ensuring actionable alerts are delivered promptly.
Exam trap
CompTIA often tests the misconception that aesthetic or exploratory features (like color palettes or drill-downs) are as critical as operational necessities (like thresholds and refresh frequency), leading candidates to overlook the core requirements for real-time monitoring.
An analyst needs to display the number of website visitors per age group (e.g., 18-25, 26-35, 36-45). Which chart type is most appropriate?
Histograms are designed for binned continuous data.
Why this answer
A histogram displays the distribution of a continuous variable (age) across bins (age groups).
A company needs to store user session data for a web application. Each session has a unique session ID, and the data must be retrieved very quickly by session ID. The data does not require complex relationships or transactions. Which type of NoSQL database is most appropriate?
Key-value stores provide high-performance lookups by key.
Why this answer
A key-value store like Redis is the most appropriate choice because it is optimized for extremely fast lookups by a unique key (session ID) and does not require complex relationships or transactions. Redis stores data in memory, providing sub-millisecond retrieval times ideal for session management, and supports built-in expiration (TTL) to automatically clean up stale sessions.
Exam trap
The trap here is that candidates often choose a document store like MongoDB because they associate 'session data' with JSON objects, overlooking that key-value stores are purpose-built for the exact use case of fast, simple key-based retrieval without the overhead of document querying.
How to eliminate wrong answers
Option B (Wide-column store, e.g., Cassandra) is wrong because it is designed for high-volume, distributed writes and complex query patterns over column families, not for simple, low-latency key-based lookups; its eventual consistency model and overhead for single-key reads make it overkill for session storage. Option C (Document store, e.g., MongoDB) is wrong because it stores semi-structured JSON-like documents with rich querying capabilities, which adds unnecessary complexity and latency for simple session data that only needs key-based retrieval. Option D (Graph database, e.g., Neo4j) is wrong because it is purpose-built for traversing relationships between entities (nodes and edges), which is irrelevant for session data that has no relational structure.
A data analyst needs to present findings about customer churn to business stakeholders. The analysis identified that churn is highest among customers who have called customer support more than three times in the last month. Which of the following is the best way to communicate this insight?
A bar chart effectively shows the relationship between a categorical variable (call count bins) and churn rate.
Why this answer
A bar chart directly compares churn rates across discrete categories of support call counts (e.g., 0, 1, 2, 3, 4+ calls), making it easy for stakeholders to see the spike at 'more than three calls'. This aligns with the insight that churn is highest among customers with >3 support calls, and a bar chart is the standard visualization for comparing a continuous metric (churn rate) across categorical bins.
Exam trap
The trap here is that candidates may choose a scatter plot (Option A) because they think it shows 'relationship', but they fail to recognize that a scatter plot is inappropriate for a binary dependent variable and discrete independent variable, whereas a bar chart is the correct choice for comparing rates across categories.
How to eliminate wrong answers
Option A is wrong because a scatter plot is used to show the relationship between two continuous variables, but here the independent variable (number of support calls) is discrete and the dependent variable (churn) is binary, so a scatter plot would produce overlapping points and fail to clearly communicate the categorical threshold of 'more than three calls'. Option B is wrong because a pie chart only shows the overall proportion of churned vs. retained customers, which does not convey the relationship between support call frequency and churn, missing the key insight entirely. Option D is wrong because a table of raw churn data by customer ID presents unaggregated, granular data that obscures the pattern and is not suitable for a high-level stakeholder presentation; it would require the audience to manually compute churn rates per call count.
A marketing team needs to store customer feedback from social media posts, including text, images, and emojis. Which data concept is most appropriate for this storage?
NoSQL document databases store unstructured data such as text, images, and emojis without a fixed schema.
Why this answer
Customer feedback from social media includes text, images, and emojis, which lack a predefined schema and are best stored as unstructured data. NoSQL document databases (e.g., MongoDB) store such data in flexible JSON-like documents, allowing each record to have varying fields and data types without requiring a fixed schema.
Exam trap
CompTIA often tests the misconception that 'unstructured data' cannot be stored in any database, when in fact NoSQL document databases are purpose-built for it, while relational databases require rigid schemas that fail with variable content.
How to eliminate wrong answers
Option B is wrong because structured data in a relational database requires a fixed schema with predefined columns and data types, which cannot efficiently handle variable-length text, images, and emojis without complex workarounds like BLOBs. Option C is wrong because relational databases are designed for structured data; storing unstructured data in them forces schema rigidity and poor performance for heterogeneous content. Option D is wrong because XML databases are semi-structured and impose hierarchical markup, which is unnecessary overhead for social media posts that are naturally schema-less and better served by document stores.
In Power BI, a data analyst needs to create a measure that calculates total sales for the current year. Which DAX function should be used?
TOTALYTD calculates year-to-date total.
Why this answer
TOTALYTD is a time intelligence function that calculates a running total for the year-to-date.
Which TWO of the following data quality dimensions are most directly affected by duplicate records?
Correct: Duplicates violate uniqueness.
Why this answer
Duplicates harm accuracy (incorrect counts) and uniqueness (duplicate entries). Completeness, consistency, timeliness are less directly affected.
A data engineer is designing a data pipeline for a retail company. The source system is an OLTP database that records sales transactions. The target is a data warehouse used for reporting. The engineer is evaluating whether to use ETL or ELT. Which three factors would favor using ELT over ETL? (Select THREE)
ELT loads raw data, allowing analysts to explore it before transformation.
Why this answer
ELT loads raw data into the warehouse first, allowing business analysts to perform ad-hoc exploration directly on the source data without pre-transformation. This flexibility is a key advantage of ELT over ETL, where transformations are applied before loading.
Exam trap
The trap here is that candidates often confuse the direction of data flow, mistakenly thinking that ELT requires transformations before loading, when in fact ELT defers transformations until after data is in the warehouse.
A company uses a NoSQL document database to store product catalogs. Each product document includes fields like product_id, name, category, and price. The operations team frequently queries by product_id and by category. Which type of NoSQL database is being used, and what should be created to optimize queries by category?
Document databases support secondary indexes on any field, which speeds up queries.
Why this answer
The question explicitly states a document database is used, and the operations team frequently queries by category. In a document database like MongoDB, creating an index on the category field optimizes these queries by allowing the database to quickly locate documents without scanning every document in the collection. This is the standard approach for improving query performance on non-primary-key fields in document stores.
Exam trap
CompTIA Data+ may test the misconception that all NoSQL databases support secondary indexes similarly. The trap here is that document databases natively support secondary indexes, while key-value and wide-column stores require different optimization strategies.
How to eliminate wrong answers
Option A is wrong because a key-value store does not support secondary indexes on fields like category; it only allows lookups by the primary key (product_id), making it unsuitable for the described query pattern. Option B is wrong because a graph database is designed for relationship-heavy data (e.g., social networks), not for product catalogs with simple field queries, and creating relationships between products does not optimize category-based lookups. Option D is wrong because a wide-column store organizes data by column families, not by documents, and creating a column family for category would not provide the index-based optimization needed for document-style queries.
A data scientist is analyzing a dataset with 100 variables and 5,000 records. The dataset has several missing values and a few extreme outliers. The goal is to build a regression model to predict a continuous target. Which combination of preprocessing steps is most likely to improve model performance?
Median imputation is robust, robust scaling handles outliers, log transform handles skewness.
Why this answer
Imputing missing values with the median is robust to outliers, robust scaling handles extreme values by using median and IQR, and log transformation reduces skewness in predictors. This combination preserves data integrity and stabilizes variance, which is critical for regression models on a dataset with 100 variables and 5,000 records.
Exam trap
CompTIA often tests the misconception that mean imputation and standard scaling are universally safe, but the trap here is that outliers and skewness require robust methods like median imputation and robust scaling to avoid distorting the model.
How to eliminate wrong answers
Option B is wrong because imputing with the mean is sensitive to outliers, which can distort the distribution and negatively affect PCA, and PCA may discard important variance related to the target. Option C is wrong because dropping all rows with missing values reduces the already limited 5,000 records, potentially losing significant information and introducing bias, and min-max scaling is not robust to outliers. Option D is wrong because removing outliers using Z-score assumes a normal distribution, which may not hold with skewed variables, and standard scaling is also sensitive to outliers, leading to poor model performance.
In a dataset with variables on different scales (e.g., age in years and income in dollars), which preprocessing step is necessary before applying k-means clustering?
Normalization ensures each feature contributes equally to distance calculations.
Why this answer
K-means clustering relies on Euclidean distance to measure similarity between data points. When variables like age (in years) and income (in dollars) are on different scales, the variable with larger numeric values (income) will dominate the distance calculation, skewing the clustering results. Normalization (scaling), such as min-max scaling or z-score standardization, rescales all features to a comparable range (e.g., [0,1] or mean=0, variance=1), ensuring each feature contributes equally to the distance computation.
Exam trap
The trap here is that candidates may confuse normalization with other preprocessing steps like feature selection or dimensionality reduction, thinking that removing irrelevant features or reducing dimensions will automatically fix scale differences, but k-means specifically requires scaling to ensure equal feature influence in distance calculations.
How to eliminate wrong answers
Option A is wrong because feature selection is about choosing a subset of relevant features to reduce noise or improve model performance, but it does not address the issue of differing scales among features, which is required before k-means. Option B is wrong because dimensionality reduction (e.g., PCA) reduces the number of features, but it does not inherently scale the data; scaling is typically performed before dimensionality reduction, not as a substitute for it. Option D is wrong because one-hot encoding is used to convert categorical variables into numerical format, not to handle numerical variables on different scales; applying one-hot encoding to already numerical features would be incorrect and does not solve the scaling problem.
A data analyst at a retail company is building a multiple linear regression model to forecast weekly sales. The dataset contains 50 predictor variables, including store size, promotional spend, holiday indicators, and many others. After training the model, the analyst observes an R-squared of 0.99 on the training set but only 0.55 on the holdout test set. Which action should the analyst take first to address this discrepancy?
Regularization and feature selection reduce overfitting by penalizing large coefficients and removing redundant predictors.
Why this answer
The high R-squared of 0.99 on training data versus 0.55 on test data is a classic sign of overfitting, where the model has learned noise and specific patterns in the training set that do not generalize. Removing highly correlated predictors reduces multicollinearity and model complexity, while regularization (Ridge or Lasso) penalizes large coefficients, shrinking them to prevent overfitting. This is the most direct first step to improve generalization.
Exam trap
The trap here is that candidates may think a high R-squared is always good, or they may confuse overfitting with underfitting and choose to add more complexity (Option D) or more data (Option B), rather than recognizing the need to reduce model complexity and apply regularization.
How to eliminate wrong answers
Option B is wrong because adding more predictor variables would increase the training R-squared but worsen overfitting, making the test set performance even lower. Option C is wrong because k-fold cross-validation with a different random seed does not address the fundamental overfitting issue; it only provides a different estimate of test error but does not change the model's tendency to overfit. Option D is wrong because increasing the number of hidden layers (a neural network technique) is irrelevant for a multiple linear regression model and would introduce unnecessary complexity, likely exacerbating overfitting.
A marketing analyst needs to combine customer data from a CRM database with social media engagement data from a third-party API. Which data acquisition method is most appropriate?
API integration provides structured, real-time access to third-party data, which is ideal for social media engagement data.
Why this answer
API integration is the most appropriate method because it allows the analyst to programmatically retrieve structured social media engagement data directly from the third-party service's RESTful or GraphQL API endpoints. This approach ensures real-time or near-real-time data synchronization, supports authentication (e.g., OAuth 2.0), and returns data in standardized formats like JSON or XML, which can be directly ingested into the CRM system without manual intervention.
Exam trap
The trap here is that candidates may confuse web scraping with API integration, assuming both can retrieve web data, but the question specifically requires combining structured data from a third-party API, where web scraping would be unreliable, unauthorized, and technically inappropriate for programmatic data acquisition.
How to eliminate wrong answers
Option A is wrong because web scraping is used to extract unstructured data from HTML pages, which is inefficient, brittle, and often violates the third-party API's terms of service; it is not designed for reliable, authenticated access to structured social media metrics. Option B is wrong because manual data entry is error-prone, time-consuming, and impractical for large volumes of social media engagement data, and it lacks any automated validation or consistency checks. Option D is wrong because batch file upload assumes the data is already exported into a file (e.g., CSV) and delivered manually, which introduces latency and requires the third-party to support file exports, whereas the API provides direct, on-demand access to live data.
Which THREE are best practices for acquiring data via web scraping? (Select exactly 3)
Legal and ethical best practice.
Why this answer
Options B, C, and E are correct because best practices for web scraping include respecting robots.txt (ethical and legal compliance), identifying yourself with a user-agent (transparency), and limiting request rate (avoid overloading servers). Option A is incorrect because using multiple IP addresses is often used to circumvent blocking, which can violate terms of service and is not a recommended best practice. Option D is incorrect because scraping all data without regard to terms is unethical and potentially illegal.
A data analyst is creating a report on customer satisfaction scores across different regions. The analyst wants to highlight regions that are significantly below average. Which of the following statistical methods is most appropriate for identifying these outliers?
Correct. IQR-based box plots are a standard method for identifying statistical outliers.
Why this answer
A box plot with interquartile range (IQR) is the most appropriate method because it explicitly identifies outliers as data points falling below Q1 - 1.5*IQR or above Q3 + 1.5*IQR. This directly addresses the analyst's goal of highlighting regions significantly below average, as the IQR method is a standard statistical technique for detecting extreme values in a distribution.
Exam trap
The trap here is that candidates may choose a bar chart with an average line (Option A) because it visually shows deviations, but it lacks a formal statistical criterion to define 'significantly below average,' which the IQR-based box plot provides.
How to eliminate wrong answers
Option A is wrong because a bar chart with an average line only shows the mean and individual region values, but does not provide a statistical threshold to determine which regions are significantly below average; it merely visualizes deviations without identifying outliers. Option B is wrong because a pie chart of satisfaction categories shows proportions of categorical data, not numerical scores across regions, and cannot identify outliers or deviations from the mean. Option D is wrong because a scatter plot of satisfaction vs. region treats region as a categorical variable on one axis, which does not produce a meaningful distribution for outlier detection; it would simply plot points per region without any statistical measure of dispersion or outlier boundaries.
During data profiling, an analyst wants to identify the number of distinct values in a column. Which SQL function should be used?
Returns distinct count.
Why this answer
COUNT(DISTINCT column) returns the number of unique non-null values.
Which TWO of the following are characteristics of structured data? (Choose TWO.)
Tabular storage is a hallmark of structured data like relational databases.
Why this answer
Structured data is organized into rows and columns, typically within relational databases or spreadsheets, where each column represents a specific attribute and each row represents a record. This tabular format enables efficient querying, sorting, and indexing using languages like SQL. The rigid row-and-column structure ensures data consistency and supports ACID (Atomicity, Consistency, Isolation, Durability) properties.
Exam trap
The trap here is that candidates often confuse semi-structured data (which uses tags or labels) with structured data, or they incorrectly assume structured data can lack a schema, when in fact a predefined schema is its defining requirement.
Which of the following is a characteristic of a NoSQL document database like MongoDB?
Document databases store data in flexible documents.
Why this answer
Document databases store data in flexible, JSON-like documents, allowing schema variability.
A data analyst is writing a query to rank products by total sales amount within each category. They want ties to have the same rank and no gaps in the ranking sequence. Which window function should they use?
Correct. DENSE_RANK() gives same rank to ties and no gaps.
Why this answer
DENSE_RANK() assigns the same rank to ties and does not skip subsequent ranks. RANK() also assigns same rank to ties but skips numbers, creating gaps.
Which THREE of the following are appropriate methods to handle outliers in a dataset?
Transformation can reduce the impact of outliers.
Why this answer
Log transformation compresses the scale of data, reducing the impact of extreme values and making the distribution more symmetric. This is a standard technique for handling skewed data where outliers are present, as it preserves the relative order of observations while mitigating outlier influence.
Exam trap
The trap here is that candidates may confuse data preprocessing techniques like binning or imputation with outlier handling methods, but binning is for discretization and mean imputation is not robust for outliers, while the correct methods (transformation, removal, capping) directly address outlier impact.
A marketing team wants to collect data on competitor pricing for similar products. Which data source is most appropriate?
Web scraping can collect competitor pricing from public websites.
Why this answer
External public web scraping is the most appropriate data source because competitor pricing is publicly available on websites, and web scraping allows automated extraction of this structured or unstructured data. This approach directly addresses the need for external competitive intelligence without relying on internal or customer-reported data.
Exam trap
The trap here is that candidates may confuse internal data sources (ERP, sales) with external data needs, or mistakenly think customer surveys can provide accurate, unbiased competitor pricing data.
How to eliminate wrong answers
Option A is wrong because customer surveys collect subjective opinions and self-reported data, not objective, real-time competitor pricing from external sources. Option B is wrong because an internal ERP system contains only the company's own operational and financial data, not competitor pricing information. Option D is wrong because internal sales data reflects the company's own transactions and pricing, not competitor pricing.
An analyst is preparing data for a clustering algorithm that uses Euclidean distance. Which TWO data preprocessing techniques should be applied to ensure all features contribute equally?
Scales features to [0,1] range.
Why this answer
Min-max normalization and Z-score standardization both scale features to comparable ranges, preventing features with larger scales from dominating distance calculations.
An analyst calculates a Pearson correlation coefficient of -0.8 between advertising spend and customer churn rate. Which interpretation is correct?
Negative correlation: one goes up, other down.
Why this answer
Negative correlation means as one variable increases, the other decreases; strength is high (close to -1).
An analyst needs to aggregate sales data by region and product, then sort the results by total sales in descending order. Which SQL clauses are required? (Select THREE).
Required to define groups for aggregation.
Why this answer
GROUP BY is needed to aggregate, ORDER BY to sort, and DESC for descending order. SUM is an aggregate function but not a clause.
In Tableau, which of the following is used to create a calculated field that aggregates data at a different level of detail than the view?
LOD expressions enable computations at different granularities.
Why this answer
LOD (Level of Detail) expressions allow you to compute aggregates at a granularity different from the view.
A data analyst is creating a dashboard to monitor e-commerce performance. The dashboard will be used by both executives (strategic view) and operations managers (detailed view). The analyst plans to use interactive filters. Which THREE design principles or features are most important to apply for effective dashboard design?
Correct. Reduces confusion and improves readability.
Why this answer
Visual hierarchy ensures executives see key metrics first. Consistent color coding helps users quickly associate colors with categories. Interactive filters allow different users to drill down to their required level of detail.
Data-ink ratio is important but less critical for multi-user dashboards. Annotations are useful for storytelling but not a core design principle for interactive dashboards.
Page 1 of 14
Page 2Practice DA0-002 by domain
Target a specific domain to shore up weak areas.