Courseiva

CompTIA Data+ (DA0-002) (DA0-002) — Questions 976–1004

1004 questions total · 14 pages · All types, answers revealed

Page 13

Page 14 of 14

976
MCQmedium

A large online retailer stores customer orders in a PostgreSQL database. Each order has a unique order ID, and the database is normalized to 3NF. Which type of data is this?

A.Semi-structured data
B.Structured data
C.Unstructured data
D.Metadata
AnswerB

Records held in fixed relational tables with defined columns, primary keys and 3NF constraints are structured data. Order IDs and their attributes fit neatly into rows and columns, so they are queryable with standard SQL.

Why this answer

The data is structured because it resides in a normalized PostgreSQL database with a unique order ID and conforms to a fixed schema (3NF). Structured data is organized into rows and columns with defined data types, enabling efficient SQL querying and ACID compliance. PostgreSQL's relational model enforces this structure through tables, constraints, and indexes.

Exam trap

The trap here is that candidates confuse 'structured data' with 'metadata' or assume that any database containing JSON fields is semi-structured, but the question specifies a normalized 3NF schema, which inherently means structured data regardless of any JSON columns.

How to eliminate wrong answers

Option A is wrong because semi-structured data (e.g., JSON, XML) does not require a fixed schema and is typically stored in NoSQL databases or as JSONB in PostgreSQL, not in a normalized 3NF relational schema. Option C is wrong because unstructured data (e.g., images, videos, free text) lacks a predefined data model and cannot be directly stored in normalized relational tables without transformation. Option D is wrong because metadata is data about data (e.g., table schemas, column descriptions), not the actual customer order records themselves.

977
MCQmedium

A business analyst wants to show the relationship between advertising spend (independent variable) and sales revenue (dependent variable) for 12 different regions. Each region will be represented by a point. Which chart type is most appropriate?

A.Line chart
B.Bar chart
C.Scatter plot
D.Histogram
AnswerC

A scatter plot places each region as a point on two axes, advertising spend against sales revenue, revealing correlation, clusters and outliers. It is the standard chart for showing the relationship between two continuous variables.

Why this answer

A scatter plot is the most appropriate chart type because it directly visualizes the relationship between two continuous variables—advertising spend (independent) and sales revenue (dependent)—by plotting each of the 12 regions as a point. This allows the analyst to assess correlation, trends, and outliers, which is the core purpose of scatter plots in data visualization.

Exam trap

The trap here is that candidates often confuse scatter plots with line charts, mistakenly thinking a line connecting points is needed to show a relationship, but the exam tests the understanding that scatter plots are the standard for bivariate continuous data without an inherent sequence.

How to eliminate wrong answers

Option A is wrong because a line chart is typically used to show trends over time or sequential data, not the relationship between two independent continuous variables across distinct regions. Option B is wrong because a bar chart compares categorical data or discrete values, not the continuous relationship between two numeric variables. Option D is wrong because a histogram displays the distribution of a single continuous variable by grouping data into bins, not the relationship between two variables.

978
MCQmedium

A company is merging two customer databases from different acquisitions. They need to identify duplicate records. Which data profiling technique is most effective?

A.Fuzzy matching on name and address
B.Manually compare all records
C.Exact match on customer names
D.Use primary keys from each database
AnswerA

Fuzzy matching tolerates the typos, abbreviations and formatting variations that plague merged customer records, so near-identical names and addresses still score as matches. Exact matching would miss these, and the technique directly satisfies the requirement to identify duplicate records across the two acquisitions.

Why this answer

Fuzzy matching on name and address is the most effective technique because customer databases from different acquisitions often contain variations in spelling, formatting, and abbreviations (e.g., 'Bob' vs. 'Robert', 'St.' vs. 'Street'). Exact matching would miss these duplicates, while fuzzy matching uses algorithms like Levenshtein distance or Jaro-Winkler to quantify similarity and identify near-matches, ensuring comprehensive deduplication.

Exam trap

The trap here is that candidates assume exact matching or primary keys are sufficient for deduplication, overlooking the real-world data inconsistencies that fuzzy matching is designed to handle.

How to eliminate wrong answers

Option B is wrong because manually comparing all records is impractical and error-prone for large datasets, lacking scalability and consistency. Option C is wrong because exact match on customer names fails to capture duplicates caused by typos, nicknames, or inconsistent formatting (e.g., 'Jon' vs. 'John'). Option D is wrong because primary keys from each database are unique within their own system but cannot identify cross-database duplicates, as the same customer may have different primary keys in each source.

979
MCQeasy

A marketing analyst receives a dataset containing customer ages recorded as whole numbers (for example, 25, 42, 67). The analyst wants to classify the measurement scale of the age field. Which measurement scale applies?

A.Ordinal
B.Interval
C.Ratio
D.Nominal
AnswerC

Age measured in years has a true zero point (birth) and equal intervals between values, enabling meaningful ratios and arithmetic. These properties define the ratio scale. The analyst can compute averages, differences, and ratios such as one customer being twice as old as another, making ratio the correct classification.

Why this answer

Age in years possesses a true zero, equal intervals between consecutive values, and supports meaningful arithmetic and ratios. These are the defining properties of the ratio scale. Nominal and ordinal scales lack the numeric structure required, while interval scales lack a true zero, so ratio is the appropriate classification.

Exam trap

The trap here is confusing interval and ratio scales by overlooking the presence of a true zero, which is what elevates age from interval to ratio.

980
MCQeasy

A data analyst at a healthcare clinic is preparing a patient records dataset for analysis. The analyst discovers that the 'date_of_birth' column contains values stored as text strings in the format 'MM/DD/YYYY', but the analytics tool requires a date data type for age calculations. Which data transformation technique should the analyst apply?

A.Data aggregation
B.Data imputation
C.Data normalization
D.Data type conversion
AnswerD

Converting the text strings to a date data type allows the analytics tool to perform date arithmetic such as calculating age. This transformation changes the representation of the data to match the required format, enabling correct calculations and comparisons. It is the appropriate step when data is stored in an incompatible type.

Why this answer

The dataset stores dates as text, which prevents date arithmetic. Converting the column to a date data type is the correct transformation because it changes the underlying representation to one that supports date functions. This enables accurate age calculations and other temporal operations required by the analytics tool.

Exam trap

The trap here is confusing data type conversion with normalization or aggregation, which address different data preparation needs.

981
Drag & Dropmedium

Drag and drop the steps to clean a dataset with missing values in the correct order.

Drag or tap steps into the slots.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4

Why this order

Cleaning starts with identification, then analysis of missingness, strategy selection, application, and documentation.

982
MCQmedium

A data scientist is building a predictive model to forecast monthly sales. The data shows a linear trend with no seasonality. Which regression technique is most appropriate?

A.Polynomial regression
B.Logistic regression
C.Linear regression
D.Ridge regression
AnswerC

Linear regression models a straight-line relationship between predictors and a continuous target, matching data with a linear trend and no seasonality. Seasonal techniques such as SARIMA or decomposition would add unnecessary parameters, while tree ensembles forgo the interpretable linear fit the pattern warrants.

Why this answer

Linear regression is the most appropriate technique because the data shows a linear trend with no seasonality, making a straight-line model the simplest and most effective fit. It directly models the relationship between the independent variable (e.g., time) and the dependent variable (monthly sales) using a linear equation, minimizing the sum of squared residuals.

Exam trap

The trap here is that candidates often confuse 'linear trend' with 'linear in parameters' and incorrectly choose polynomial regression, thinking it adds flexibility, when the question explicitly states no seasonality and a linear trend, making simple linear regression the optimal choice.

How to eliminate wrong answers

Option A is wrong because polynomial regression introduces higher-degree terms (e.g., x², x³) to model curvature, which is unnecessary and risks overfitting when the trend is explicitly linear. Option B is wrong because logistic regression is used for binary classification problems (e.g., predicting yes/no outcomes), not for forecasting continuous numeric values like monthly sales. Option D is wrong because ridge regression is a regularization technique designed to handle multicollinearity or overfitting by adding an L2 penalty, but it is not a distinct regression type for linear trends and would be overkill when a simple linear model suffices.

983
MCQmedium

A data engineer is designing an ETL pipeline to extract sales data from a legacy on-premise database and load it into a cloud data warehouse. The database is slow and queries during business hours affect performance. Which extraction strategy minimizes impact?

A.Query the database with SELECT * every hour
B.Incremental extraction using Change Data Capture (CDC)
C.Full table extraction nightly
D.Use a database log shipping
AnswerB

Incremental extraction using Change Data Capture reads only changed rows from the transaction log, avoiding full-table scans that degrade the legacy database during business hours. This directly satisfies the stem's constraint of minimising performance impact on a slow on-premise source, while reducing data volume transferred to the cloud warehouse.

Why this answer

Incremental extraction using Change Data Capture (CDC) minimizes impact on the legacy on-premise database by reading only the changed rows (inserts, updates, deletes) from transaction logs or change tables, rather than issuing heavy SELECT queries. This avoids full table scans or frequent queries during business hours, preserving database performance for operational workloads.

Exam trap

The trap here is that candidates confuse 'log shipping' (a high-availability technique) with 'Change Data Capture' (an extraction method), or assume that any periodic query (like hourly SELECT *) is acceptable without considering the cumulative performance impact on a slow legacy database.

How to eliminate wrong answers

Option A is wrong because querying the database with SELECT * every hour performs full table scans on the legacy database, which is slow and would degrade performance during business hours, directly contradicting the goal of minimizing impact. Option C is wrong because full table extraction nightly still requires a complete scan of the entire table, which can be resource-intensive and may not complete within a reasonable window if the database is slow, and it does not capture intra-day changes without additional overhead. Option D is wrong because database log shipping is a disaster recovery technique that continuously copies transaction logs to a standby server, not an extraction strategy for ETL; it does not provide a queryable change stream and would require additional processing to parse logs for CDC.

984
MCQeasy

A retail company has a dashboard that tracks daily sales across all stores. The dashboard is used by the CEO during monthly board meetings. Recently, the CEO complained that the dashboard is confusing and takes too long to interpret. The data analyst is asked to redesign the dashboard to improve usability. The analyst has access to all sales data. The CEO prefers a high-level overview with the ability to drill down into regions if needed. The analyst must decide on a course of action. What should the analyst do first?

A.Revamp the dashboard with as many visualizations as possible.
B.Conduct a survey of all employees to understand their needs.
C.Create a static PDF report instead of a dashboard.
D.Interview the CEO to determine key performance indicators and preferred layout.
AnswerD

Interviewing the CEO first establishes which KPIs and layout the board actually needs, grounding the redesign in user requirements before any technical work. Building charts or queries beforehand risks misalignment with the executive audience's stated preference for a high-level overview with drill-down.

Why this answer

The correct first step is to interview the CEO to determine key performance indicators and preferred layout. This ensures the dashboard is designed around the specific high-level metrics the CEO needs for monthly board meetings, with the ability to drill down into regions. Starting with stakeholder requirements prevents wasted effort on irrelevant visualizations or formats.

Exam trap

The trap here is that candidates may assume more data or broader input (options A or B) is always better, when in fact the correct approach is to focus on the specific needs of the primary user to reduce confusion and improve usability.

How to eliminate wrong answers

Option A is wrong because revamping with as many visualizations as possible would increase clutter and confusion, directly contradicting the CEO's complaint about the dashboard being confusing and taking too long to interpret. Option B is wrong because surveying all employees is unnecessary; the primary user is the CEO, and the dashboard is for board meetings, not general employee use. Option C is wrong because creating a static PDF report removes interactivity and the ability to drill down into regions, which the CEO explicitly prefers.

985
MCQmedium

In a logistic regression model predicting customer churn (1 = churn, 0 = not churn), the coefficient for 'contract length' is -0.5. Which of the following is the correct interpretation?

A.For each unit increase in contract length, the log-odds of churn decrease by 0.5.
B.Longer contract length increases the odds of churn.
C.The probability of churn decreases by 50% for each unit increase in contract length.
D.Contract length is not a significant predictor.
AnswerA

In logistic regression the coefficient operates on the log-odds scale, so a -0.5 coefficient means each one-unit rise in contract length lowers the log-odds of churn by 0.5, holding other predictors constant. This directly satisfies the stem's request for the correct interpretation of that coefficient.

Why this answer

In logistic regression, the coefficient represents the change in log-odds of the outcome for a one-unit increase in the predictor, holding other variables constant. A coefficient of -0.5 means that for each unit increase in contract length, the log-odds of churn decrease by 0.5. This is the correct interpretation of the model's output.

Exam trap

DA0-002 often tests the confusion between log-odds and probability, or between odds and probability, leading candidates to incorrectly interpret coefficients as direct probability changes.

How to eliminate wrong answers

Option B is wrong because a negative coefficient indicates a decrease in log-odds, not an increase. Option C is wrong because it misinterprets the coefficient as a direct probability change; the change in probability is not constant and depends on the current probability. Option D is wrong because the coefficient value does not determine significance; significance is assessed via p-values or confidence intervals, which are not provided.

986
MCQmedium

A data analyst is performing exploratory data analysis on a dataset containing house prices. They want to identify outliers in the 'price' column using the IQR method. The first quartile (Q1) is $200,000, the third quartile (Q3) is $350,000, and the IQR is $150,000. What is the upper bound for identifying outliers?

A.$500,000
B.$575,000
C.$425,000
D.$650,000
AnswerB

The IQR method flags outliers above Q3 + 1.5 × IQR. With Q3 at $350,000 and IQR at $150,000, the calculation gives $350,000 + $225,000 = $575,000, satisfying the stem's requirement for the upper bound. Values exceeding this threshold are treated as outliers.

Why this answer

The IQR method defines the upper bound as Q3 + 1.5 × IQR. With Q3 = $350,000 and IQR = $150,000, the calculation is $350,000 + (1.5 × $150,000) = $350,000 + $225,000 = $575,000. Any price above $575,000 is considered an outlier.

Exam trap

The trap is misremembering the multiplier as 1.0 or 2.0 instead of the standard 1.5, or confusing the upper fence formula with Q3 + IQR.

How to eliminate wrong answers

Option A is wrong because $500,000 results from adding only 1.0 × IQR to Q3, which is not the standard IQR outlier threshold. Option C is wrong because $425,000 is Q3 + 0.5 × IQR, an incorrect multiplier. Option D is wrong because $650,000 is Q3 + 2.0 × IQR, which corresponds to a more extreme threshold not used in the standard Tukey IQR method.

987
Drag & Dropmedium

Drag and drop the steps to perform a root cause analysis on data quality issues in the correct order.

Drag or tap steps into the slots.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4

Why this order

Root cause analysis involves defining the problem, gathering data, identifying causes, finding root cause, and acting.

988
MCQhard

An analyst notices that a dashboard displays conflicting data from two sources. What is the first step in troubleshooting?

A.Re-run all queries
B.Notify stakeholders of potential error
C.Replace the data source with the one believed to be correct
D.Check data transformation steps and join logic
AnswerD

Conflicting values usually originate upstream of the visualisation layer, so transformation logic and join keys are inspected first. Mismatched join types, duplicate rows or incorrect aggregations in the pipeline produce divergent figures; verifying these steps isolates whether the discrepancy is a data-preparation fault.

Why this answer

The first step in troubleshooting conflicting data from multiple sources is to verify the data transformation steps and join logic. Conflicts often arise from incorrect joins (e.g., using INNER JOIN instead of LEFT JOIN), mismatched keys, or data type conversions that alter values. Checking these steps isolates the root cause before any other action, such as re-running queries or notifying stakeholders.

Exam trap

The trap here is that candidates often jump to re-running queries or notifying stakeholders first, mistaking a symptom (conflicting data) for a root cause, instead of methodically inspecting the transformation and join logic where the discrepancy likely originates.

How to eliminate wrong answers

Option A is wrong because re-running all queries blindly repeats the same potentially flawed logic without diagnosing the source of the conflict; it wastes time and may overwrite intermediate results. Option B is wrong because notifying stakeholders prematurely escalates an unverified issue, causing unnecessary alarm and eroding trust before the analyst has confirmed the error. Option C is wrong because replacing the data source without understanding the conflict ignores the possibility that the transformation logic or join conditions are the actual problem, and it may introduce new inconsistencies.

989
MCQmedium

A data analyst needs to share a weekly sales report with the marketing team. The report includes aggregated data from the data warehouse. To simplify access, the analyst creates a virtual table that encapsulates the complex query. Which database object should the analyst create?

A.Trigger
B.View
C.Stored procedure
D.Index
AnswerB

A view is a stored query that presents a virtual table, letting the marketing team select from it without rewriting the underlying aggregation. It satisfies the requirement for simplified, reusable access to the data warehouse's complex query results.

Why this answer

A view is a virtual table that encapsulates a complex query, allowing users to access aggregated data without needing to understand the underlying SQL. In this scenario, the analyst creates a view to simplify access to the weekly sales report, as it presents pre-defined, aggregated data from the data warehouse as if it were a table.

Exam trap

The trap here is that candidates may confuse a view with a stored procedure, thinking both can encapsulate logic, but only a view behaves as a virtual table that can be directly queried with SELECT, while a stored procedure requires explicit execution and does not return a result set in the same way.

How to eliminate wrong answers

Option A is wrong because a trigger is a procedural code that automatically executes in response to certain events (e.g., INSERT, UPDATE, DELETE) on a table, not a virtual table for simplifying query access. Option C is wrong because a stored procedure is a set of precompiled SQL statements that can accept parameters and perform operations, but it does not act as a virtual table that can be queried directly with SELECT statements. Option D is wrong because an index is a database structure that improves the speed of data retrieval operations on a table, but it is not a virtual table or a query encapsulation object.

990
MCQhard

Based on the exhibit, what is the most likely cause of the import failure?

A.The file is empty or contains only headers.
B.The price field includes non-numeric characters that cannot be parsed.
C.The source file is corrupted or in an unsupported format.
D.A data quality issue: the date field contains an invalid date.
AnswerD

An invalid date value in the source field prevents the import from parsing correctly, so the load fails at the data quality stage. The exhibit's error points to a malformed date rather than a schema mismatch or connectivity fault, making the invalid date the specific cause.

Why this answer

The exhibit shows a date field containing '2023-02-30', which is an invalid date (February never has 30 days). This data quality issue causes the import to fail, as the system likely validates date values against calendar rules before inserting them into the target table. The error is not due to file emptiness, non-numeric characters, or corruption, but specifically a semantic data integrity violation.

Exam trap

The trap here is that candidates may overlook semantic data quality issues (like invalid dates) and instead focus on syntactic problems (like file format or non-numeric characters), even though the exhibit clearly shows a date that does not exist in the calendar.

How to eliminate wrong answers

Option A is wrong because the file contains multiple rows of data beyond headers, as evidenced by the visible records in the exhibit. Option B is wrong because the price field shows numeric values (e.g., 19.99, 29.99) without any non-numeric characters that would cause parsing failures. Option C is wrong because the source file is displayed in a standard CSV format with proper delimiters and readable content, indicating it is not corrupted or in an unsupported format.

991
Multi-Selectmedium

A data analyst is designing a dashboard for executives. Which TWO practices improve dashboard effectiveness? (Select two.)

Select 2 answers
A.Including clear labels and titles for all charts
B.Adding decorative images to make the dashboard visually appealing
C.Displaying data with high precision (e.g., 4 decimal places)
D.Using consistent color coding for similar metrics across charts
E.Using many different colors to highlight every data point
AnswersA, D

Clear labels and titles state what each chart measures, its units and dimensions, so executives interpret values without guessing. This satisfies the effectiveness goal by removing ambiguity that would otherwise cause misreading of the displayed metrics.

Why this answer

Option A is correct because clear labels and titles for all charts give executives immediate context for what each visual represents, eliminating ambiguity and reducing the cognitive effort needed to interpret the data, which is essential for fast executive decision-making. Option D is correct because consistent color coding for similar metrics across charts lets viewers track the same measure (e.g., revenue always in blue) across multiple visuals without re-learning the legend each time, improving comparability and reducing misinterpretation. Option B is not appropriate because decorative images add visual clutter and consume dashboard space without conveying analytical value, distracting from the data.

Option C is incorrect because displaying data with high precision such as 4 decimal places creates unnecessary detail that obscures trends and slows comprehension at the executive level, where rounded or aggregated values are more useful. Option E is incorrect because using many different colors to highlight every data point destroys visual hierarchy and makes it impossible to distinguish meaningful patterns or exceptions.

Exam trap

DA0-002 often tests the difference between aesthetics and effectiveness — candidates who equate 'visually appealing' with 'effective' pick decorative images or many colors, missing that clarity and consistency drive comprehension.

992
MCQeasy

A data analyst has built a dashboard tracking daily website sessions. The product owner wants to know which acquisition channel contributed the largest share of sessions over the past quarter, and how those shares shifted month by month. Which chart type is MOST appropriate?

A.A stacked bar chart with one bar per month and segments for each acquisition channel.
B.A line chart with one line per acquisition channel plotting sessions against time.
C.A waterfall chart starting from total quarterly sessions and subtracting each channel's contribution.
D.A scatter plot of sessions against channel with each point representing one day.
AnswerA

Stacked bars show both the total per month and each channel's contribution as a segment, so the reader can see share composition and how it changes across the quarter. When comparing shares across months, a 100% stacked variant makes the proportion comparison even cleaner. This directly answers both parts of the product owner's question.

Why this answer

The question combines a part-to-whole comparison with a time progression, which is precisely what a stacked bar chart handles: each monthly bar totals the sessions while its segments show each channel's contribution, and a 100% stacked form isolates share. Line charts emphasize absolute trends, scatter plots require two continuous variables, and waterfalls imply sequential deductions that do not exist here.

Exam trap

The trap here is choosing a line chart because the data spans time, overlooking that the question asks about share of a whole rather than absolute trend.

993
MCQmedium

A data analyst needs to show the relationship between advertising spend (in dollars) and monthly sales revenue (in dollars) for the past 12 months. Which chart type is most appropriate?

A.Scatter plot
B.Line chart
C.Bar chart
D.Pie chart
AnswerA

A scatter plot pairs advertising spend against sales revenue as two continuous numeric variables, exposing correlation, trend and outliers across the 12 months. This satisfies the requirement to show the relationship between the two dollar-denominated measures.

Why this answer

A scatter plot is the most appropriate chart to show the relationship between two numerical variables, such as advertising spend and sales revenue. It plots each pair of values as a point, allowing the analyst to visually assess correlation, trends, and outliers. Line charts are better for time series, bar charts for categorical comparisons, and pie charts for proportions.

Exam trap

DA0-002 often tests chart selection; candidates may choose line chart because data is over 12 months, but the goal is to show relationship, not trend over time.

How to eliminate wrong answers

Option B is wrong because a line chart is used to show trends over time, not the relationship between two variables. Option C is wrong because a bar chart compares categorical data or shows distributions, not correlations between two numerical variables. Option D is wrong because a pie chart shows parts of a whole, not relationships between two continuous variables.

994
MCQmedium

A data analyst discovers that the sales data for the current quarter shows a 15% increase in revenue. However, the analyst notes that the data does not include returns from the last week due to a system lag. How should the analyst communicate this uncertainty?

A.Delay the report until returns are processed.
B.Report the 15% increase as final, because the returns are insignificant.
C.Include a caveat that returns from the last week are missing and revenue may be overstated.
D.State that the revenue increase is exactly 15% and provide a confidence interval.
AnswerC

Stating that last week's returns are absent and revenue may therefore be overstated gives stakeholders the specific limitation affecting the 15% figure. This satisfies the stem's uncertainty requirement by disclosing the missing data rather than presenting the increase as definitive.

Why this answer

The analyst must be transparent about the data's limitations. Since the missing returns could reduce the reported revenue increase, the correct action is to explicitly state that returns from the last week are not included and that the 15% figure may be overstated. This maintains data integrity and allows stakeholders to make informed decisions.

Exam trap

DA0-002 often tests the importance of data quality and the need to disclose limitations rather than presenting incomplete data as final.

How to eliminate wrong answers

Option A is wrong because delaying the report may not be necessary if the uncertainty is clearly communicated; stakeholders may still need the preliminary data. Option B is wrong because assuming the returns are insignificant is an unsupported assumption; even small returns could affect the percentage. Option D is wrong because stating the increase is exactly 15% contradicts the known data gap, and a confidence interval cannot be accurately calculated without the missing data.

995
MCQeasy

Which database index type is most commonly used for exact-match lookups and range queries in a B-tree structure?

A.B-tree index
B.Hash index
C.Clustered index
D.Bitmap index
AnswerA

A B-tree index stores keys in sorted order across balanced nodes, so exact-match lookups traverse a single root-to-leaf path in logarithmic time, while range queries exploit the sorted leaf chain to scan contiguous values. This satisfies both the equality and range requirements stated in the stem.

Why this answer

A B-tree index is the correct answer because it maintains sorted data in a balanced tree structure, enabling both exact-match lookups (via equality searches) and efficient range queries (via ordered traversal of leaf nodes). This dual capability makes it the standard index type in relational databases like MySQL, PostgreSQL, and Oracle for general-purpose querying.

Exam trap

The trap here is that candidates often confuse 'clustered index' as a separate index type, but it is actually a physical implementation of a B-tree where the leaf nodes contain the full row data, not a different algorithmic structure.

How to eliminate wrong answers

Option B (Hash index) is wrong because hash indexes use a hash function to map keys to bucket locations, which is extremely fast for exact-match lookups but does not support range queries (e.g., BETWEEN, >, <) since the hash order does not preserve key order. Option C (Clustered index) is wrong because while a clustered index physically reorders table data based on the index key and can support range queries, it is not a distinct index type but rather a storage organization; the underlying structure is still a B-tree, and the question asks for the index type most commonly used for both operations, which is the B-tree itself. Option D (Bitmap index) is wrong because bitmap indexes store bitmaps for each distinct key value and are optimized for low-cardinality columns and complex boolean queries, not for efficient range scans or exact-match lookups in high-cardinality scenarios.

996
Multi-Selectmedium

A data analyst is preparing a dataset for analysis and needs to handle outliers. Which TWO of the following are common methods for treating outliers?

Select 2 answers
A.Removal
B.Capping
C.Normalization
D.Imputation
E.Standardization
AnswersA, B

Removal deletes or filters out records whose values fall beyond a defined threshold, such as three standard deviations or the interquartile range fence. This satisfies the need to treat outliers by eliminating their distortion, though it reduces sample size and risks discarding legitimate extreme observations.

Why this answer

Removal (A) is a common outlier treatment because it deletes the extreme data points from the dataset, which is appropriate when outliers are errors or when their influence must be eliminated before analysis. Capping (B), also called winsorizing, is a common treatment that replaces extreme values with a defined threshold, such as the 1st/99th percentile or a value at a set number of standard deviations, preserving the record while limiting the outlier's effect. Normalization (C) is a scaling technique that rescales values to a fixed range like 0–1; it does not identify or treat outliers, so it is not a treatment method.

Imputation (D) fills in missing values rather than addressing extreme values, so it is not an outlier treatment. Standardization (E) transforms data to have mean 0 and standard deviation 1, which is also a scaling method and does not by itself treat outliers.

Exam trap

The trap is confusing data scaling techniques (normalization, standardization) with outlier treatment methods; candidates must distinguish between transforming the scale and actually handling extreme values.

997
Multi-Selecteasy

A data analyst is using pandas to clean a DataFrame that contains missing values in the 'age' and 'income' columns. Which THREE pandas methods are appropriate for handling missing data? (Select THREE).

Select 3 answers
A.dropna()
B.pivot_table()
C.merge()
D.apply() with a custom function
E.fillna()
AnswersA, D, E

The `dropna()` method removes rows or columns containing null values, directly satisfying the requirement to handle missing entries in the 'age' and 'income' columns. It suits scenarios where incomplete records should be excluded entirely, though it risks discarding otherwise valid data when nulls are sparse across the DataFrame.

Why this answer

Common pandas methods for missing data include dropna (remove rows with NaN), fillna (replace NaN with a value), and apply with a custom function. Merge is for combining DataFrames; pivot_table is for reshaping.

998
MCQmedium

A data analyst must build a monthly dashboard for the executive team. The dashboard will be viewed on large screens in the boardroom and must display the current month's revenue, profit margin, and customer acquisition cost at a glance. Which design approach best ensures the dashboard is immediately understandable?

A.Include detailed data tables with conditional formatting to show the exact values for each KPI and supporting calculations.
B.Create a separate tab for each KPI with interactive filters so executives can drill into the data themselves.
C.Use a single color palette with consistent meaning and place the three KPIs as large, clearly labeled tiles at the top of the dashboard.
D.Use a variety of chart types, such as pie charts and 3D bar charts, to make the dashboard visually engaging and modern.
AnswerC

Using a consistent color palette and large, labeled KPI tiles aligns with dashboard design best practices for executive audiences. It reduces cognitive load, ensures the most important metrics are immediately visible, and avoids ambiguity. The boardroom setting demands quick comprehension, so prioritizing key numbers at the top with clear labels is optimal.

Why this answer

The correct approach is to use consistent colors and prominent KPI tiles because executive dashboards should prioritize immediate comprehension of key metrics. Large, labeled tiles at the top ensure that revenue, profit margin, and customer acquisition cost are seen first without requiring interaction. This design reduces cognitive load and supports quick decision-making in a boardroom setting.

Exam trap

The trap here is assuming that more detail or interactivity always improves an executive dashboard, when actually simplicity and at-a-glance clarity are paramount.

999
MCQmedium

A healthcare analytics team is analyzing patient readmission rates. They have a dataset with thousands of records including patient age, diagnosis, length of stay, number of prior admissions, and discharge date. The goal is to identify key factors influencing readmission and create a model to predict high-risk patients. The data is imbalanced: only 5% of patients are readmitted within 30 days. The team plans to use logistic regression. What is the most appropriate approach?

A.Use the dataset as is because logistic regression handles imbalance
B.Remove most of the non-readmitted patients to balance the dataset
C.Use accuracy as the evaluation metric
D.Apply oversampling techniques like SMOTE to the training set
AnswerD

With only 5% readmissions, logistic regression would bias toward the majority class. SMOTE synthesises minority-class examples in the training set, balancing class distribution so the model learns readmission patterns rather than predicting 'no readmission' constantly.

Why this answer

With imbalanced data, logistic regression can be biased toward the majority class. Oversampling the minority class (e.g., SMOTE) helps the model learn patterns for readmission. Using accuracy as a metric would be misleading.

Removing majority samples discards valuable data. Using data as-is often fails to predict the minority class.

1000
Multi-Selecthard

An e-commerce company wants to analyze sales performance across product categories. The dataset includes transaction amounts and a column 'category' with values (Electronics, Clothing, Home). The analyst decides to use stratified sampling to ensure proportional representation. Which THREE steps are required to implement this? (Select THREE).

Select 3 answers
A.Calculate the proportion of each category in the population
B.Take a random sample from each stratum with size proportional to its population proportion
C.Divide the dataset into three strata based on category
D.Select every 10th transaction from the entire dataset
E.Combine all categories into a single group and perform simple random sampling
AnswersA, B, C

Stratified sampling requires knowing each stratum's share of the population to allocate sample sizes proportionally. Calculating the proportion of each category establishes those weights, which the subsequent per-stratum sampling step uses to preserve the dataset's category distribution.

Why this answer

Stratified sampling requires first partitioning the population into homogeneous subgroups, so option C is correct: dividing the dataset into three strata based on the 'category' column (Electronics, Clothing, Home) creates the strata. Next, option A is correct because the analyst must calculate each category's proportion of the total population to determine how many samples each stratum should contribute for proportional representation. Option B is also correct because, after determining stratum sizes, a random sample must be drawn from each stratum with size proportional to its population proportion, which is the defining allocation step of proportional stratified sampling.

Option D is incorrect because selecting every 10th transaction describes systematic sampling, not stratified sampling, and it ignores the category strata. Option E is incorrect because merging all categories into one group and performing simple random sampling removes the stratification and does not guarantee proportional representation across categories.

1001
MCQhard

A data engineer is designing a data warehouse for a multinational corporation. The company has sales data from different regions with varying currencies and date formats. To ensure consistency, which data concept should be applied to standardize the data before loading into the warehouse?

A.Data cleansing
B.Data transformation
C.Data profiling
D.Data masking
AnswerB

Data transformation converts source values into a consistent format, normalising currencies and date formats during ETL before loading. This satisfies the stem's standardisation constraint by ensuring multinational sales records are comparable and queryable within the warehouse.

Why this answer

Data transformation is the correct concept because it involves converting data from source formats (e.g., different currencies and date formats) into a consistent, standardized format before loading into the data warehouse. This process includes applying conversion rules, such as using ISO 8601 for dates and a single base currency (e.g., USD) with exchange rate tables, ensuring uniformity across all regional data. Without transformation, the warehouse would contain incompatible data types, breaking referential integrity and analytical queries.

Exam trap

CompTIA often tests the distinction between data cleansing and data transformation, where candidates mistakenly choose cleansing because they think fixing formats is about 'cleaning' data, but cleansing addresses errors and missing values, not structural conversions like currency or date standardization.

How to eliminate wrong answers

Option A is wrong because data cleansing focuses on detecting and correcting inaccuracies, inconsistencies, or missing values (e.g., removing duplicates or fixing typos), not on converting data types or formats like currencies and dates. Option C is wrong because data profiling is an exploratory process that analyzes source data to understand its structure, quality, and relationships (e.g., checking data types or null percentages), but it does not perform any standardization or conversion. Option D is wrong because data masking is a security technique used to obfuscate sensitive information (e.g., replacing credit card numbers with tokens) for privacy or compliance, and it has no role in standardizing currencies or date formats.

1002
MCQhard

A logistics company is analyzing truck delivery times. Which variable is discrete?

A.Number of stops
B.Time taken in hours
C.Fuel consumption in liters
D.Distance traveled
AnswerA

Number of stops is discrete because it takes countable whole-number values with gaps between them; a truck cannot make 3.5 stops. Delivery time, by contrast, is continuous, so it can assume any value within a range.

Why this answer

A discrete variable is one that takes on a countable number of distinct values, often integers. The number of stops a truck makes is a count (e.g., 0, 1, 2, 3) and cannot be a fraction, making it a classic discrete variable in data analysis.

Exam trap

The trap here is that candidates confuse 'recorded as an integer' with 'discrete'—for example, thinking distance in whole kilometers is discrete, when the underlying measurement scale is continuous.

How to eliminate wrong answers

Option B is wrong because time taken in hours is a continuous variable—it can be measured to any fractional precision (e.g., 2.5 hours, 3.75 hours). Option C is wrong because fuel consumption in liters is continuous; it can take any value within a range (e.g., 45.3 liters). Option D is wrong because distance traveled is continuous, as it can be measured in fractional units (e.g., 120.7 km).

1003
MCQmedium

A data analyst at a regional bank is asked to share a de-identified customer churn dataset with an external marketing consultancy. Before releasing the data, the analyst must confirm that all direct identifiers such as names, account numbers, and Social Security numbers have been removed. Which data governance concept does this action primarily address?

A.Data minimization
B.Data retention
C.Data lineage
D.De-identification
AnswerD

De-identification is the process of removing or obscuring direct identifiers so that individuals cannot be readily identified from the dataset. Removing names, account numbers, and Social Security numbers before sharing with the consultancy is exactly this process, making it the concept that directly matches the analyst's action in the scenario.

Why this answer

De-identification focuses on removing or obscuring direct identifiers so that individuals are no longer readily identifiable. Stripping names, account numbers, and Social Security numbers from the churn dataset before sharing it with an external consultancy is a textbook example of this practice, making it the governance concept that directly matches the described action.

Exam trap

The trap here is confusing de-identification with data minimization, since both reduce privacy risk but only one specifically involves removing identifiers from data that is being shared.

1004
MCQeasy

A data analyst at a logistics company receives a shipment-tracking table in which the carrier identifier column contains values such as 'FEDX', 'FedEx', 'fed ex', and 'FX'. The analyst needs to consolidate these into a single carrier value before building a delivery-performance dashboard. Which data preparation step should the analyst perform?

A.One-hot encode the carrier column into binary indicator fields.
B.Standardize and normalize the categorical values through data cleansing.
C.Impute the missing carrier values using the column mean.
D.Apply min-max normalization to rescale the carrier column.
AnswerB

These entries are the same carrier recorded inconsistently, so the analyst should cleanse the column by trimming whitespace, unifying case, and mapping known aliases to one canonical value. Consolidating variants into a single label prevents the dashboard from splitting one carrier's shipments across four bogus categories, which would distort on-time rates and volume comparisons.

Why this answer

The carrier column suffers from inconsistent representation of the same entity, a classic data cleansing issue. Trimming whitespace, normalizing case, and mapping aliases to a canonical label collapses the variants into one category. Numeric rescaling, missing-value imputation, and one-hot encoding all address different problems and would leave the duplicated carrier categories intact in the delivery dashboard.

Exam trap

The trap here is reaching for a transformation like one-hot encoding or normalization because the column looks messy, when the actual defect is inconsistent labels that only cleansing and standardization can merge.

Page 13

Page 14 of 14