CompTIA Data+ (V2) (DA0-002) practice questions

Domain coverage 5 domains

• Data Concepts and Environments (17%)
• Data Acquisition and Preparation (23%)
• Data Analysis (30%)
• Visualization and Reporting (20%)
• Data Governance (10%)

Sample questions 10 of 100 shown

1. Q1 Data Concepts and Environments (20%)

   A company has a document containing names of key metrics and the standard calculation criteria for these metrics across the company. Which term describes this document?

   1. Data dictionary
   2. Data explainability report
   3. Data lineage
   4. Data flow diagram

   A data dictionary defines business terms, metrics, data types, and calculation logic. It provides a reference for analysts to understand what each metric means and how it is computed, ensuring consistency across teams.
2. Q2 Data Concepts and Environments (20%)

   Which of the following best describes the approach used to combine files, software, and libraries for use across various operating systems and environments?

   1. Containerization
   2. Code repository
   3. Package manager
   4. Virtual machine

   Containerization packages an application together with its dependencies (libraries, binaries, configuration files) into a single container image that runs consistently across different environments. Containers are lightweight compared to virtual machines.
3. Q3 Data Concepts and Environments (20%)

   A data analyst profiles API records before loading them into a relational reporting table. The record shows nested fields such as customer containing address and items as an array. Which interpretation is best supported?

   1. The record is unstructured because it has no fixed columns
   2. The record contains hierarchical and repeated nested fields
   3. The record has duplicate orders that should be removed
   4. The record is a flat delimited file with embedded separators

   Semi-structured data such as JSON can include fields inside other fields (hierarchical) and arrays of repeated values (nested). The exhibit shows customer with child fields and items as an array, meaning a relational load may need parsing and flattening.
4. Q4 Data Concepts and Environments (20%)

   A data analyst is reviewing how a weekly sales packet is created. The tool run log shows: sign in to sales portal, click Export CSV, open KPI workbook, refresh workbook data, export PDF report, email PDF to managers. Which concept is best illustrated?

   1. Data lakehouse ingestion
   2. Robotic process automation
   3. Natural language processing
   4. Manual ad hoc analysis

   Robotic process automation (RPA) uses software to perform repetitive, rule-based steps that a person would otherwise do. The sequence of signing in, clicking export, refreshing, and emailing represents an automated workflow mimicking user actions.
5. Q5 Data Concepts and Environments (20%)

   A team is deploying a relational database that will support an internal reporting application. The storage requirements include frequent random reads/writes, mounting by one database server, and need for low-level volume, partition, and file system control. Which storage type best fits?

   1. File storage
   2. Object storage
   3. Block storage
   4. Data lake storage

   Block storage is the best fit when a database needs low-level volume-style storage behavior. It presents storage as attachable volumes that the server can format with a file system and use for random read/write workloads, matching database requirements.
6. Q6 Data Concepts and Environments (20%)

   A product team wants to analyze why mobile checkout sessions fail after a new release. An analyst reviews timestamped source data showing session_id, component, event, and status values such as WARN and ERROR. Which interpretation is best supported?

   1. It is log data for event and error analysis
   2. It is a transaction ledger for revenue reporting
   3. It is reference data for product categorization
   4. It is survey data for customer sentiment analysis

   Log data records what systems and applications do over time. The exhibit contains timestamped events tied to a session and component, with status values like WARN and ERROR, supporting analysis of failure sequences and event patterns.
7. Q7 Data Concepts and Environments (20%)

   A retail analytics team maintains a star schema for sales reporting. The business wants quarterly sales to remain tied to the customer segment that was active when each sale occurred, even if a customer's segment changes later. Which dimension-table approach best supports this?

   1. Overwrite the segment in the customer dimension
   2. Use a Type 2 slowly changing dimension
   3. Store only the previous segment in a new column
   4. Remove customer segment from the sales model

   A Type 2 slowly changing dimension (SCD) preserves historical attribute values by adding a new dimension row for each changed version with effective dates. This allows facts to remain associated with the correct historical dimension version.
8. Q8 Data Concepts and Environments (20%)

   A retail analyst is comparing AI tools for automated reporting. Tool A is pretrained on large text corpora and generates SQL explanations and summaries. Tool B is pretrained on text, image, and audio, adaptable for captioning, transcription, and document search. Which interpretation is correct?

   1. Both tools are only LLMs because both can process text
   2. Tool A is a foundation model; Tool B is only RPA
   3. Tool A is an LLM; Tool B is a broader foundation model
   4. Neither tool uses AI unless trained from scratch internally

   An LLM focuses on language tasks like generating and summarizing text. A foundation model is the broader category pretrained on large datasets adaptable to many tasks. Tool A is language-centered (LLM), while Tool B supports multiple data types (broader foundation model).
9. Q9 Data Concepts and Environments (20%)

   Which of the following is used to store and manage structured data using tables with rows and columns, supporting SQL queries?

   1. Non-relational database
   2. Relational database
   3. File storage
   4. Object storage

   A relational database organizes data into tables with rows and columns, enforces schema constraints, and supports Structured Query Language (SQL) for data manipulation and retrieval.
10. Q10 Data Concepts and Environments (20%)

    A retail analytics team needs one repository for raw clickstream logs, product images, and curated sales tables. Data scientists need raw files for experimentation, while BI users need governed SQL reporting with documented lineage. Which repository concept best fits?

    1. Flat file repository
    2. Operational database
    3. Data lakehouse
    4. Data silo

    A data lakehouse combines the flexibility of a data lake for raw diverse data with the managed analytics features of a data warehouse for curated tables and SQL reporting, making it ideal for this mixed workload.

Answer all 100 questions with instant feedback →

Reader reviews 130 ratings

• I was preparing for the DA0-002 exam while juggling a newborn at home. The flexibility of this platform was a lifesaver.

  ★★★★★★ Cooper D.

• Used this DA0-002 prep extensively for three weeks. The progress tracking feature kept me accountable.

  ★★★★★★ Violet W.

• Quick shipping? LOL jk — instant access was great. Started studying DA0-002 questions right after purchase, no delays.

  ★★★★★★ Colton W.

• The DA0-002 questions were tougher than the actual exam, which honestly made me more confident. Great prep tool.

  ★★★★★★ Brandon L.

• Comparing this with other CompTIA practice tests, this one feels the most like the real DA0-002 exam.

  ★★★★★★ Mia R.

• The DA0-002 explanations are detailed and educational. I learned more from reviewing wrong answers than from any book.

  ★★★★★★ Rachel S.

Frequently asked questions

Free study resources

Community-verified analysis of 23 questions from real test-taker discussions — 6 deep analyses and 0 FAQs.

More CompTIA exams