Try 10 Real Questions From CompTIA Data+ (DA0-002 V2) - 700 Questions & Full Rationale Answers
These are unedited questions from the full 700-question set, pulled from across every exam domain. Click a question to reveal the answer and the full rationale for every option, exactly as it appears in the PDF.
A data analyst is combining customer information from a relational database, clickstream events from a web application, and semi-structured support tickets exported in JSON format. The analyst needs to preserve relationships between customer records while also handling flexible, nested fields from the ticketing system. Which solution best supports these requirements?
Show answer & full rationale
A (Correct): Relational structures fit highly related customer data, while semi-structured JSON requires a flexible approach for nested fields.
B: CSV files do not preserve complex relationships or nested structures well.
C: A document database may fit JSON, but it is not automatically the best option for all relational use cases.
D: Image files are not suitable for querying or structured analysis.
A data analyst must distinguish between structured, semi-structured, and unstructured data. Which example best represents semi-structured data?
Show answer & full rationale
A (Correct): JSON commonly represents semi-structured data because fields may vary while still following a recognizable structure.
B: A normalized relational table is structured data, not semi-structured.
C: A scanned handwritten image is generally unstructured data.
D: A paper invoice in a cabinet is not a semi-structured digital data example at all.
A data analyst needs to combine customer data from a CRM export with transaction data from a billing system. The two sources use different customer identifiers, but a cross-reference file exists. Which activity is the analyst performing first?
Show answer & full rationale
A: Dashboard design happens later in the workflow, after the data is combined.
B: Hypothesis testing is part of analysis, not integration.
C: Access control review is a governance activity, unrelated to combining the two sources.
D (Correct): Combining data from multiple systems through mapped identifiers is data integration.
A data professional is profiling a dataset and notices some records have blank values in required fields. What issue has been identified?
Show answer & full rationale
A: The issue described has nothing to do with encryption.
B (Correct): Blank required fields are missing values, a common data quality issue found during profiling.
C: Visualization bias applies to reporting choices, not blank source fields.
D: Container drift is an infrastructure concept unrelated to blank data fields.
A data analyst has completed a churn analysis and must present results to senior executives who want a concise explanation of key drivers and business impact, not technical details. Which approach is most appropriate?
Show answer & full rationale
A: Raw outputs alone are not tailored to the audience and leave the interpretation undone.
B: Excessive technical detail does not serve an executive audience that wants business impact, not methodology.
C (Correct): Executive audiences generally need concise, decision-oriented communication focused on findings and implications.
D: Row-level detail is usually not appropriate for an executive summary.
A data professional wants to summarize the typical value in a skewed income dataset where a few extremely high values are present. Which measure is often more appropriate than the mean?
Show answer & full rationale
A (Correct): The median is less affected by extreme values in skewed distributions, making it a better summary of the typical case than the mean.
B: The range only describes the spread between the smallest and largest values, not a typical value.
C: The maximum is itself one of the extreme values distorting the mean, not a measure of central tendency.
D: A count only describes how many values exist, not what a typical value looks like.
A manager wants to see how daily website traffic changed over a 30-day period. Which visual is the best choice?
Show answer & full rationale
A (Correct): A line chart is ideal for showing movement and trends across a continuous time period.
B: A pie chart shows proportional share of a whole and is not suited for time-based patterns.
C: An icon collage does not clearly show a trend over time.
D: A decorative banner is not an analytical visual at all.
A dashboard uses one color for profit in one chart and the same color for loss in another chart. What is the primary issue?
Show answer & full rationale
A: Color choice is a design issue and has no effect on the underlying calculations.
B: Visual design choices do not encrypt a report.
C (Correct): Colors should be used consistently across a dashboard so viewers can interpret visuals quickly and correctly; reusing the same color for opposite meanings undermines that.
D: The source data is not invalid because of a color choice made during design.
A data steward is documenting where a customer dataset originated, how it was transformed, and where it is used downstream. Which governance concept is being documented?
Show answer & full rationale
A (Correct): Data lineage tracks the origin, movement, and transformation of data over time, exactly what is being documented here.
B: Dashboard theming is a reporting and visual-design concept, unrelated to tracking data's origin and movement.
C: Container orchestration is an infrastructure concept, not a governance documentation practice.
D: Chart interactivity is a reporting feature, unrelated to tracking data origin and transformation.
A company must keep records for a defined number of years to meet legal requirements. Which compliance topic is most directly involved?
Show answer & full rationale
A: Scatter plotting is a visualization method, unrelated to how long records must be kept.
B: BI theming is a reporting and visual-design concept, unrelated to legal recordkeeping requirements.
C (Correct): Retention policies define how long records must be kept to meet legal and regulatory requirements.
D: Parsing is a data transformation task, not a recordkeeping compliance topic.
CompTIA Data+ (DA0-002 V2) - 700 Questions & Full Rationale Answers — $19.99, instant PDF download with full rationale on every answer.
View the practice questions →