CompTIA Data+ (DA0-002) Practice Exam

What the CompTIA Data+ (DA0-002) exam covers

• Data Concepts and Environments153 questions
• Data Acquisition and Preparation169 questions
• Data Analysis184 questions
• Visualization and Reporting153 questions
• Data Governance108 questions

Free CompTIA Data+ (DA0-002) sample questions

A sample of 10 questions with answers and explanations. Sign up free to practice all 767.

1. Question 1Data Concepts and Environments

   Which describes structured data?

   • AData organised into a predefined schema of rows and columnsCorrect
   • BData held as free text, images or audio with no fixed schema
   • CData that carries tags describing itself but no rigid schema
   • DData that has been aggregated and is no longer at record level
   ✓ Correct answer: A

   Relational tables and spreadsheets are the everyday examples, and the fixed schema is what allows a query language to address a column by name. It is the easiest form to analyse and the least common by volume in most organisations. Free text and media are unstructured, tagged formats are semi-structured, and aggregation describes a summary rather than a category.

   Why the other options are wrong

   • BFree text, images and audio with no schema is unstructured data.
   • CData carrying self describing tags is semi-structured instead.
   • DAggregated data is a summary rather than a structural category.
2. Question 2Data Concepts and Environments

   Which describes a single source of truth?

   • AOne governed dataset that every report and team agrees to useCorrect
   • BOne database server hosting all of the organisation's data
   • COne person authorised to approve every analytical request
   • DOne report format that every department is required to adopt
   ✓ Correct answer: A

   The point is agreement rather than physical consolidation: two teams quoting different revenue figures is a definition problem, and a governed shared dataset with documented measures is what resolves it. A single server, a single approver and a single report format address quite different concerns.

   Why the other options are wrong

   • BOne server hosting everything is a physical rather than definitional matter.
   • COne person approving every request is an approval bottleneck.
   • DOne required report format is a presentation standard instead.
3. Question 3Data Acquisition and Preparation

   Which describes primary data collection?

   • AGathering data first hand for the specific question being investigatedCorrect
   • BReusing data that was collected earlier for a different purpose
   • CPurchasing a prepared dataset from a commercial data supplier
   • DDownloading a published dataset from a government website
   ✓ Correct answer: A

   Collecting it yourself means the instrument, the sample and the definitions all match the question, which is why the results are more directly usable, at a cost in time and money. Reusing earlier data, purchasing a dataset and downloading a published one are all forms of secondary collection.

   Why the other options are wrong

   • BReusing data collected earlier for another purpose is secondary data.
   • CPurchasing a prepared dataset from a supplier is also secondary data.
   • DDownloading a published government dataset is secondary data too.
4. Question 4Data Acquisition and Preparation

   Which describes the value of comparing a new extract against the previous one?

   • ASudden changes in row counts, ranges or missing rates reveal a source problemCorrect
   • BThe comparison replaces the need to profile the new extract at all
   • CThe comparison guarantees that the new extract contains no errors
   • DThe comparison determines which chart type suits the data best
   ✓ Correct answer: A

   A source system change usually announces itself as a shift in one of those three rather than as a failure, and comparing against last month's profile catches it before the numbers reach a report. It supplements rather than replaces profiling, guarantees nothing and says nothing about chart choice.

   Why the other options are wrong

   • BThe comparison supplements rather than replaces profiling the new extract.
   • CNo comparison guarantees that an extract contains no errors at all.
   • DWhich chart type suits the data is a presentation question.
5. Question 5Data Acquisition and Preparation

   Which describes a parameter in a saved query or report?

   • AA value supplied when the query runs so the same logic serves several casesCorrect
   • BA fixed value written into the query that never changes
   • CA column returned by the query alongside the results
   • DA permission determining who is allowed to run the query
   ✓ Correct answer: A

   One parameterised query serving twelve regions is far easier to maintain than twelve near identical copies, and it is also the correct defence against building a query by pasting user input into it. Hard coded values, returned columns and permissions are three separate concepts.

   Why the other options are wrong

   • BA fixed value written into the query is a hard coded literal.
   • CA column returned alongside the results is part of the output.
   • DA permission determining who may run it is an access control.
6. Question 6Data Analysis

   Which describes an underpowered study?

   • AIt is too small to detect the effect it is looking for, so a real effect may be missedCorrect
   • BIt uses more observations than are necessary to reach a conclusion
   • CIt reaches a conclusion that contradicts the researcher's expectation
   • DIt is analysed with software that lacks the required functions
   ✓ Correct answer: A

   Concluding that there is no effect when the study could never have found one is a common and costly outcome, which is why the sample size is calculated from the effect worth detecting before the work begins. Over sampling, contradicted expectations and software limitations are different problems.

   Why the other options are wrong

   • BUsing more observations than necessary makes a study overpowered.
   • CA conclusion contradicting expectation may be entirely correct.
   • DSoftware lacking required functions is a tooling problem instead.
7. Question 7Data Analysis

   Which describes an index in time series reporting?

   • AValues expressed relative to a chosen base period set to one hundredCorrect
   • BA sorted list of the periods in which measurements were taken
   • CA database structure that speeds up retrieval of the series
   • DThe identifier assigned to each row of the time series table
   ✓ Correct answer: A

   Rebasing lets series measured in different units be compared on one chart, and it makes proportional change easy to read. The choice of base period matters, since a low base flatters everything that follows. Sorted period lists, database indexes and row identifiers are three other things.

   Why the other options are wrong

   • BA sorted list of measurement periods is simply an ordered series.
   • CA structure speeding up retrieval is a database index instead.
   • DAn identifier assigned to each row is a row key.
8. Question 8Visualization and Reporting

   Which describes the appropriate baseline for a bar chart axis?

   • AZero, because bar length is read as proportional to the valueCorrect
   • BThe minimum value present, to maximise the visible differences
   • CThe average of the values, so differences appear on both sides
   • DWhatever value makes the intended message clearest
   ✓ Correct answer: A

   A truncated baseline makes a three per cent difference look like a doubling, which is the single most common way a chart misleads without stating anything false. Line charts, which encode change rather than magnitude, may reasonably start elsewhere. Message driven axis choice is exactly what to avoid.

   Why the other options are wrong

   • BStarting at the minimum exaggerates the differences considerably.
   • CStarting at the average distorts the proportional reading of length.
   • DChoosing the baseline to suit the message is how charts mislead.
9. Question 9Visualization and ReportingSelect all that apply

   Which TWO risks accompany emailing reports as attachments? (Choose TWO)

   • ARecipients forward stale copies that no longer match the live figuresCorrect
   • BSensitive figures leave the controlled platform and cannot be recalledCorrect
   • CThe underlying dataset is modified each time the report is sent
   • DThe report can no longer be produced on a schedule
   ✓ Correct answer: A, B

   Both follow from the attachment becoming an independent artefact the moment it is sent, outside every access control and refresh mechanism the platform provides. A link to the live report avoids both. The dataset is unchanged and scheduling continues to work exactly as before.

   Why the other options are wrong

   • CThe underlying dataset is not modified by sending the report.
   • DThe report continues to be produced on its schedule regardless.
10. Question 10Data Governance

    Which describes special category or sensitive personal data?

    • ACategories such as health, biometrics or beliefs that carry additional protectionCorrect
    • BAny personal data belonging to a senior member of staff
    • CPersonal data that happens to be stored in an encrypted column
    • DPersonal data that was collected more than five years ago
    ✓ Correct answer: A

    Health, biometric, genetic, racial, religious, political and sexual orientation data are singled out because misuse causes disproportionate harm, and processing them usually needs a stronger lawful basis. Seniority, encryption and age of collection have no bearing on whether data falls into these categories.

    Why the other options are wrong

    • BData about a senior member of staff is ordinary personal data.
    • CBeing stored encrypted is a control rather than a category of data.
    • DHow long ago the data was collected does not change its category.

Who this CompTIA Data+ (DA0-002) practice exam is for

This practice set is for anyone preparing for the CompTIA Data+ (DA0-002) exam - from first-time candidates building a foundation to experienced Data practitioners doing a final review before test day. If you learn best by working through realistic questions and reading why each answer is right or wrong, it is built for you.

How to use this CompTIA Data+ (DA0-002) practice exam

1. Start with the free sample questions above to gauge your current baseline.
2. Read the full explanation on every question, including why each wrong option is wrong.
3. Track your weak domains and focus your study where you are losing the most marks.
4. Once you are scoring consistently well, take a timed, full-length mock exam.
5. Use your readiness score to decide when you are ready to book the real CompTIA Data+ (DA0-002) exam.

Related Data resources

• CompTIA Data+ (DA0-002) study guideKey concepts
• Data practice examsAll Data
• Certification pathWhere this fits
• Certification exam guides & tipsBlog
• Plans & pricingFree & paid
• Databricks Certified Data Analyst Associate practice examRelated
• MongoDB Associate Developer practice examRelated
• Databricks Certified Data Engineer Associate practice examRelated

CompTIA Data+ (DA0-002) practice exam FAQ