Courseiva

CCNA Dap Data Concepts Questions

50 of 200 questions · Page 3/3 · Dap Data Concepts topic · Answers revealed

151
Multi-Selecthard

Which TWO of the following are primary benefits of implementing a data governance program?

Select 2 answers
A.Faster data processing speed
B.Increased data volume
C.Improved data quality and consistency
D.Lower storage costs
E.Reduced data redundancy
AnswersC, E

Governance establishes standards, ownership and controls across the data lifecycle, which directly raises data quality and consistency. These are the primary benefits cited, as governance enforces uniform definitions and validation rather than merely storing or visualising data.

Why this answer

Option C is correct because a core purpose of data governance is establishing policies, standards, and stewardship roles that enforce data quality dimensions such as accuracy, completeness, and consistency across systems. Option E is correct because governance defines authoritative data sources, master data management, and ownership rules that eliminate duplicate and conflicting copies of data across the enterprise. The remaining options do not belong: A (faster data processing speed) is an infrastructure or query-optimization outcome, B (increased data volume) is a byproduct of data accumulation rather than a governance benefit, and D (lower storage costs) is a cost-optimization result typically achieved through tiering, deduplication, or archiving rather than governance itself.

Exam trap

The trap here is that candidates may confuse data governance with data management or data engineering tasks, mistakenly thinking it directly improves performance or reduces costs, when its core value is in quality, consistency, and compliance.

152
MCQeasy

Refer to the exhibit. Which data quality dimension is compromised by the missing value for Charlie's salary?

A.Uniqueness
B.Completeness
C.Timeliness
D.Accuracy
AnswerB

Charlie's salary field is absent entirely, so the record lacks a required attribute. Completeness measures whether all expected values are present, and the missing value directly violates it, satisfying the stem's data quality dimension question.

Why this answer

Completeness measures whether all required data is present. Charlie's missing salary value means the record is incomplete, directly violating this dimension. In data quality frameworks, completeness is assessed by the proportion of non-null values in a field, and a null salary here fails that check.

Exam trap

CompTIA often tests the distinction between 'missing' (completeness) and 'wrong' (accuracy), leading candidates to confuse a null value with an incorrect value.

How to eliminate wrong answers

Option A is wrong because uniqueness refers to the absence of duplicate records or values, not missing data; a missing salary does not create a duplicate. Option C is wrong because timeliness concerns whether data is up-to-date or available when needed, not whether a value is present or absent. Option D is wrong because accuracy measures correctness of values against a reference source; a missing value is not an inaccurate value—it is an absent one.

153
Multi-Selectmedium

Which THREE of the following are common characteristics of unstructured data?

Select 3 answers
A.Easily queried using SQL
B.Often stored in NoSQL databases or data lakes
C.Can include text, images, and video
D.Stored in relational tables
E.Lacks a predefined schema
AnswersB, C, E

NoSQL databases and data lakes both accept data without a predefined relational schema, so they accommodate raw text, media and logs. This satisfies the stem's requirement by naming the storage platforms that handle schema-less content, unlike warehouses requiring structure before loading.

Why this answer

Option B is correct because unstructured data, such as documents, media files, and logs, is commonly stored in NoSQL databases (e.g., MongoDB, Cassandra) or data lakes (e.g., Amazon S3, Azure Data Lake) that do not require a fixed relational schema. Option C is correct because unstructured data encompasses heterogeneous formats including free text, images, audio, and video, which cannot be easily decomposed into rows and columns. Option E is correct because unstructured data by definition lacks a predefined schema, meaning there is no fixed data model or rigid structure enforced at write time.

Option A is incorrect because SQL querying relies on structured, tabular schemas, which unstructured data does not provide. Option D is incorrect because relational tables are the storage model for structured data, not unstructured data.

Exam trap

The trap here is confusing 'unstructured' with 'semi-structured' or assuming that any data stored in a database must be queryable via SQL; candidates often pick 'Easily queried using SQL' because they conflate storage with query capability.

154
MCQhard

An organization has multiple systems that store customer information inconsistently. To create a single authoritative view of customer data, they implement a process that identifies and merges duplicate records. This is an example of which data management discipline?

A.Data governance
B.Data warehousing
C.Data quality
D.Master Data Management (MDM)
AnswerD

Master Data Management creates the single authoritative golden record by matching and merging duplicates across systems, exactly the discipline described. It governs the organisation's core customer entities, unlike data quality or integration, which address different concerns.

Why this answer

Master Data Management (MDM) is the discipline focused on creating and maintaining a single, authoritative, consistent view of core business entities such as customers, products, and suppliers. Identifying and merging duplicate records to produce a trusted golden record is a core MDM activity. The scenario describes exactly this consolidation of inconsistent customer data across systems.

Exam trap

DA0-002 often tests the overlap between data governance, data quality, and MDM, causing candidates to choose governance or quality when the scenario specifically requires creating a single authoritative master record.

How to eliminate wrong answers

Option A is wrong because data governance defines policies, standards, and stewardship for data, but does not itself perform record matching and merging to create a golden record. Option B is wrong because data warehousing is about consolidating data for analytics and reporting, not about establishing an authoritative operational master record. Option C is wrong because data quality focuses on accuracy, completeness, and consistency of data, but the specific goal of a single authoritative customer view through deduplication and merging is MDM.

155
MCQmedium

A table named Orders has columns OrderID, CustomerID, OrderDate, and TotalAmount. Which column should be the primary key to uniquely identify each order?

A.OrderDate
B.OrderID
C.TotalAmount
D.CustomerID
AnswerB

OrderID is a surrogate identifier assigned one distinct value per order row, so it guarantees uniqueness and rejects nulls, satisfying the requirement to identify each order individually. CustomerID repeats across a customer's orders, OrderDate collides on same-day purchases, and TotalAmount duplicates readily, so none can enforce entity integrity as the primary key.

Why this answer

The OrderID column is the correct choice for the primary key because it contains unique values for each order, ensuring that each row can be uniquely identified. A primary key must be unique, non-null, and stable; OrderID satisfies all these requirements, whereas the other columns do not guarantee uniqueness or are subject to change.

Exam trap

The trap here is that candidates may confuse a column that is frequently used for filtering or grouping (like CustomerID or OrderDate) with one that guarantees uniqueness, overlooking the fundamental primary key requirement of uniqueness and non-nullability.

How to eliminate wrong answers

Option A is wrong because OrderDate is not unique; multiple orders can occur on the same date, and it can also be null, violating primary key constraints. Option C is wrong because TotalAmount can have duplicate values (e.g., two orders with the same total) and is not inherently unique or stable. Option D is wrong because CustomerID is not unique per order; a single customer can place many orders, so it cannot uniquely identify each order row.

156
Multi-Selecteasy

Which TWO of the following are examples of data transformation? (Choose TWO.)

Select 2 answers
A.Normalizing data to eliminate redundancy
B.Creating a backup of the database
C.Converting string dates to date format
D.Generating summary statistics
E.Removing duplicate records
AnswersA, C

Normalization is a transformation.

Why this answer

Data normalization is a transformation process that reorganizes data to reduce redundancy and improve integrity, typically by decomposing tables into smaller, related tables (e.g., achieving 3NF in relational databases). This changes the structure and representation of the data, which is a core example of data transformation.

Exam trap

CompTIA often tests the distinction between data transformation (changing format/structure) and data cleansing (removing errors/duplicates) or data analysis (generating summaries), leading candidates to mistakenly select removal of duplicates or summary statistics as transformations.

157
MCQmedium

A data analyst is working with a dataset that contains customer names and addresses. Some records have missing state codes. Which data quality issue is this?

A.Duplication
B.Incompleteness
C.Outliers
D.Inconsistency
AnswerB

Incompleteness captures missing values within otherwise present records, which matches the absent state codes precisely. Unlike inaccuracy, which concerns incorrect values, or duplication, incompleteness addresses the null entries the analyst must resolve before geographic analysis. This satisfies the stem's constraint of records lacking required state data.

Why this answer

Incompleteness is the correct answer because missing state codes in customer address records represent a lack of required data. This is a classic example of incomplete data, where fields that should contain values are left null or blank, reducing the dataset's usability for analysis.

Exam trap

The trap here is that candidates may confuse incompleteness with inconsistency, but incompleteness is about missing data (nulls), while inconsistency is about contradictory data across records.

How to eliminate wrong answers

Option A is wrong because duplication refers to duplicate records (e.g., same customer appearing multiple times), not missing values. Option C is wrong because outliers are data points that deviate significantly from the norm (e.g., an unusually high age), not absent data. Option D is wrong because inconsistency involves contradictory or conflicting data (e.g., same customer with different state codes in different records), not missing values.

158
MCQhard

A company is designing a data lake to store raw sensor data from IoT devices. The data arrives as JSON objects with varying schemas. Which storage approach is most appropriate?

A.Ingest into a relational database with a predefined schema
B.Store each JSON object as a separate file in a compressed columnar format
C.Convert all JSON to Avro with a fixed schema before storing
D.Store raw JSON files in a distributed file system and apply schema-on-read
AnswerD

Schema-on-read defers parsing until query time, so each JSON object's varying structure is interpreted individually rather than forced into a fixed table. This directly satisfies the stem's requirement to store raw sensor data whose schemas differ across IoT devices, avoiding ingestion-time transformation failures.

Why this answer

A data lake is designed to store raw data in its native format, and IoT sensor data with varying schemas is best handled by storing raw JSON files in a distributed file system (e.g., HDFS or Amazon S3). This approach leverages schema-on-read, where the schema is applied at query time rather than at write time, allowing flexibility for heterogeneous JSON objects without data loss or transformation overhead.

Exam trap

The trap here is that candidates confuse 'schema-on-read' with 'schema-on-write' and assume that converting to a structured format like Avro or columnar storage is always better for performance, ignoring the requirement to store raw, varying-schema data as-is.

How to eliminate wrong answers

Option A is wrong because relational databases require a predefined schema and enforce ACID constraints, which cannot accommodate JSON objects with varying schemas without costly schema migrations or data loss. Option B is wrong because storing each JSON object as a separate file in a compressed columnar format (e.g., Parquet or ORC) is inefficient for small, variable-schema records; columnar formats are optimized for analytical queries on large, homogeneous datasets, not for raw ingestion of many small, schema-varying JSON objects. Option C is wrong because converting all JSON to Avro with a fixed schema before storing defeats the purpose of a data lake, which is to preserve raw data; Avro requires a predefined schema at write time, and forcing a fixed schema on varying JSON objects would either lose data or require complex schema evolution management.

159
MCQmedium

A data analyst needs to combine rows from two tables based on a related column, but only wants rows that have matching values in both tables. Which join type should the analyst use?

A.RIGHT JOIN
B.INNER JOIN
C.FULL OUTER JOIN
D.LEFT JOIN
AnswerB

An INNER JOIN returns only rows where the join key exists in both tables, discarding unmatched rows from either side. This directly satisfies the requirement for rows with matching values in both tables, unlike outer joins that retain unmatched rows.

Why this answer

An INNER JOIN returns only the rows where the join key exists in both tables, which is exactly what the analyst needs when they want matched records only. Rows with no counterpart in either table are excluded from the result set. This is the default and most common join type in SQL.

Exam trap

DA0-002 often tests the difference between INNER JOIN (matches only) and OUTER JOINs (include unmatched rows with NULLs), so candidates who default to LEFT JOIN for 'combining tables' pick the wrong answer.

How to eliminate wrong answers

Option A is wrong because a RIGHT JOIN returns all rows from the right table plus matching rows from the left, including unmatched right-side rows with NULLs — it does not restrict to matches only. Option C is wrong because a FULL OUTER JOIN returns all rows from both tables, filling unmatched sides with NULLs, which is the opposite of 'matching values in both tables.' Option D is wrong because a LEFT JOIN returns all rows from the left table plus matches from the right, again including unmatched left-side rows.

160
MCQmedium

A data engineer needs to store logs from web servers that have varying fields. The logs are in JSON format. Which data type describes this JSON data?

A.Binary data
B.Structured data
C.Semi-structured data
D.Unstructured data
AnswerC

JSON logs have no fixed schema, yet carry tags and hierarchy, which defines semi-structured data. Unlike structured data in rigid relational tables, it permits varying fields per record while remaining machine-parseable, matching the web server logs described.

Why this answer

JSON data with varying fields is classified as semi-structured data because it has organizational properties (key-value pairs, nested structures) but does not conform to a rigid schema like a relational table. The logs from web servers may have different fields per record, which is a hallmark of semi-structured data, as it allows flexibility while still being self-describing.

Exam trap

The trap here is that candidates confuse 'structured' with any data that has a format, but JSON's lack of a fixed schema and varying fields disqualifies it from being structured data, which requires a rigid, predefined schema like a relational database table.

How to eliminate wrong answers

Option A is wrong because binary data refers to raw bytes or encoded formats (e.g., images, executables) that lack any inherent structure or human-readable format, whereas JSON is text-based and has explicit key-value organization. Option B is wrong because structured data requires a fixed schema with predefined fields and data types (e.g., rows in a SQL table), but JSON logs with varying fields violate this strict schema requirement. Option D is wrong because unstructured data has no predefined format or organization (e.g., plain text, video files), while JSON has a defined syntax with keys, values, and nesting, providing a clear structure.

161
MCQmedium

A data analyst needs to combine customer information from a CRM table and order information from an orders table, returning only customers who have placed at least one order. Which type of join should the analyst use?

A.RIGHT JOIN
B.INNER JOIN
C.FULL OUTER JOIN
D.LEFT JOIN
AnswerB

An INNER JOIN returns only rows where the join key matches in both tables, so customers without orders are excluded and only customers with at least one order remain. A LEFT JOIN would retain unmatched customers, contradicting the stated requirement.

Why this answer

An INNER JOIN between the CRM table and the orders table returns only rows where there is a match in both tables based on the join key (e.g., customer ID). This satisfies the requirement to return only customers who have placed at least one order, because any customer without an order in the orders table will be excluded from the result set.

Exam trap

The CompTIA Data+ exam often tests the misconception that a LEFT JOIN will include only customers with orders because it 'joins' the tables, but the trap is that a LEFT JOIN preserves all rows from the left table, including those with no matches, so it does not filter out customers without orders.

How to eliminate wrong answers

Option A (RIGHT JOIN) is wrong because it returns all rows from the orders table and matching rows from the CRM table, which could include orders without a matching customer (if referential integrity is not enforced) and would not limit results to only customers with orders. Option C (FULL OUTER JOIN) is wrong because it returns all rows from both tables, including customers without orders and orders without customers, which violates the requirement to return only customers who have placed at least one order. Option D (LEFT JOIN) is wrong because it returns all rows from the CRM table and matching rows from the orders table, which would include customers with zero orders (where the orders columns are NULL), failing to filter out customers without orders.

162
Multi-Selecthard

A data governance committee is defining metadata standards for a new data lake. They need to distinguish between technical metadata and business metadata to ensure proper data management. Which two of the following are examples of technical metadata? (Choose two.)

Select 2 answers
A.Data type of a column (e.g., VARCHAR, INTEGER)
B.Business definition of a 'customer'
C.Data quality threshold for completeness
D.Data owner responsible for a dataset
E.Number of rows in a table
AnswersA, E

Technical metadata describes the structure and format of data, such as data types, lengths, and constraints. The data type of a column directly defines how data is stored and processed, making it essential for schema management, ETL development, and query optimization. This is a classic example of technical metadata used by data engineers and database administrators.

Why this answer

Technical metadata describes the structure, format, and operational characteristics of data, such as data types and row counts. Business metadata provides semantic context, definitions, ownership, and quality rules. The data type of a column and the number of rows in a table are technical metadata, while business definitions, data owners, and quality thresholds are business metadata.

Exam trap

The trap here is conflating business governance roles and definitions with technical metadata, which strictly concerns the physical and structural attributes of data systems.

163
MCQhard

A database table has columns: OrderID (primary key), ProductID, CustomerID, CustomerName, OrderDate, ProductName. All products are purchased only by the customer who placed the order. Which normal form violation exists if CustomerName depends on CustomerID?

A.Boyce-Codd normal form (BCNF)
B.Third normal form (3NF)
C.Second normal form (2NF)
D.First normal form (1NF)
AnswerB

CustomerName depends on CustomerID, which is not a candidate key, creating a transitive dependency and violating 3NF.

Why this answer

The table violates Third Normal Form (3NF) because CustomerName depends on CustomerID, which is not a candidate key (the primary key is OrderID). 3NF requires that every non-key attribute be non-transitively dependent on the primary key; here, CustomerName is transitively dependent on OrderID via CustomerID. Since CustomerID is a non-key attribute (it is not part of the primary key), this transitive dependency breaks 3NF.

Exam trap

The trap here is that candidates often confuse transitive dependencies (3NF violation) with partial dependencies (2NF violation) or think that any dependency on a non-key attribute automatically violates BCNF, but the specific scenario of CustomerName depending on CustomerID is a textbook transitive dependency that breaks 3NF first.

How to eliminate wrong answers

Option A is wrong because Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF that requires every determinant to be a candidate key; while this table also violates BCNF, the question asks which normal form violation exists, and the dependency described is a classic 3NF violation (transitive dependency), not a BCNF-specific one. Option C is wrong because Second Normal Form (2NF) is violated only when a non-key attribute depends on a proper subset of a composite primary key; here the primary key is a single column (OrderID), so no partial dependency exists, and 2NF is satisfied. Option D is wrong because First Normal Form (1NF) is violated only if there are repeating groups or non-atomic values; the table as described has atomic columns and no repeating groups, so 1NF is satisfied.

164
MCQhard

A data modeler is designing a dimensional model for a sales analytics system. The fact table contains sales transactions, and the dimension tables include product, customer, and time. To reduce data redundancy, the modeler normalizes the dimension tables into multiple related tables. Which schema is being implemented?

A.Vault schema
B.Star schema
C.Galaxy schema
D.Snowflake schema
AnswerD

Normalising dimensions into multiple related tables produces a snowflake schema: each dimension is decomposed into its own hierarchy of linked tables rather than one flat denormalised table. This directly satisfies the stated goal of reducing redundancy in the product, customer and time dimensions.

Why this answer

The snowflake schema is a dimensional model where dimension tables are normalized into multiple related tables to reduce data redundancy. In this scenario, the product, customer, and time dimensions are split into sub-dimensions (e.g., product category, customer geography, time hierarchy), which is the defining characteristic of a snowflake schema. This contrasts with a star schema where dimensions remain denormalized.

Exam trap

CompTIA often tests the distinction between star and snowflake schemas by emphasizing normalization of dimensions; the trap here is that candidates may confuse 'normalized dimensions' with a star schema, which actually uses denormalized dimensions for simplicity and performance.

How to eliminate wrong answers

Option A is wrong because a vault schema (Data Vault) is a hybrid modeling approach focused on auditability and flexibility using hubs, links, and satellites, not on normalizing dimension tables for a sales analytics fact table. Option B is wrong because a star schema keeps dimension tables denormalized (single table per dimension) to optimize query performance, which directly contradicts the normalization described in the question. Option C is wrong because a galaxy schema (also called a fact constellation) contains multiple fact tables sharing dimension tables, not the normalization of a single fact table’s dimensions.

165
Multi-Selecthard

A data analyst is preparing a dataset for analysis and needs to address data quality issues. The dataset contains missing values, outliers, and inconsistent formats. Which two techniques are appropriate for handling missing values? (Choose two.)

Select 2 answers
A.Mean imputation
B.Winsorizing
C.Listwise deletion
D.One-hot encoding
E.Z-score normalization
AnswersA, C

Mean imputation replaces missing numerical values with the mean of the observed values. It is a simple method that preserves the overall mean of the variable, though it can reduce variance. It is appropriate when missingness is random and the variable is numeric, making it a valid technique for this scenario.

Why this answer

The correct answers are Mean imputation and Listwise deletion because both directly address missing values. Mean imputation fills gaps with a central tendency measure, while listwise deletion removes incomplete records. The other techniques are for scaling, encoding, or outlier handling, not for missing data.

Exam trap

The trap here is confusing data preprocessing techniques; for example, assuming that normalization or encoding also handles missing values, when they do not.

166
MCQmedium

A logistics company stores shipment records in a relational database. The ShipmentID column uniquely identifies every shipment, and the CarrierName column stores the name of the carrier that moved each shipment, such as "Northwind Freight" or "Acme Logistics". Analysts frequently group shipments by carrier to compare on-time performance. Which statement correctly describes the relationship between these two columns in this table?

A.CarrierName is a candidate key because analysts group by it frequently
B.ShipmentID and CarrierName together form a composite primary key
C.ShipmentID is the primary key of the table, and CarrierName is a non-key descriptive attribute
D.ShipmentID is a foreign key that references CarrierName as its parent key
AnswerC

ShipmentID uniquely identifies each row, so it qualifies as the primary key and enforces entity integrity. CarrierName holds descriptive text about the carrier and repeats across many shipments, so it is a non-key attribute rather than an identifier. This structure supports grouping shipments by carrier for on-time performance comparisons.

Why this answer

Because ShipmentID uniquely identifies each shipment row, it serves as the primary key, while CarrierName simply describes an attribute of the shipment that can repeat and supports grouping. A foreign key must point to a unique parent key in another table, a candidate key must be unique, and a composite key is unnecessary when a single column already guarantees uniqueness. The described schema therefore fits the primary key plus descriptive attribute model.

Exam trap

The trap here is confusing a frequently grouped, repeating column with a key, when key status depends on uniqueness rather than on how often the column is used in queries.

167
Multi-Selecteasy

Which TWO of the following are characteristics of OLTP systems? (Select 2)

Select 2 answers
A.Typically uses a denormalized schema
B.Optimized for complex analytical queries
C.Stores historical data for trend analysis
D.Designed for high transaction throughput
E.Supports ACID transactions
AnswersD, E

OLTP handles many concurrent transactions.

Why this answer

OLTP systems are designed for high transaction throughput, handling large volumes of short, atomic transactions efficiently. They prioritize fast data processing and immediate consistency, making option D correct.

Exam trap

The trap here is that candidates often confuse OLTP with OLAP, mistakenly selecting denormalized schemas or analytical optimization as OLTP characteristics, when in fact OLTP emphasizes normalized schemas and high transaction throughput with ACID compliance.

168
MCQmedium

A company has a large data warehouse running on Snowflake. They receive daily CSV files from multiple sources and load them directly into the warehouse, then run SQL transformations to clean and aggregate the data. Which data integration approach does this describe?

A.ELT
B.Data streaming
C.ETL
D.CDC
AnswerA

ELT fits because raw CSV files load straight into Snowflake before any cleansing, letting the warehouse's own compute run the SQL transformations. This satisfies the stem's constraint of loading directly, then transforming in place — the defining reversal of extract-load-transform order versus ETL, where transformation precedes loading.

Why this answer

This describes ELT (Extract, Load, Transform) because the raw CSV files are first loaded directly into Snowflake, and then SQL transformations are applied within the warehouse. Unlike ETL, where data is transformed before loading, ELT leverages Snowflake's compute power to perform transformations after ingestion, which is efficient for large-scale batch processing.

Exam trap

The trap here is that candidates confuse ELT with ETL because both involve transformations, but the key distinction is the order of loading versus transforming; CompTIA often tests this by describing the sequence of operations to see if you recognize that loading raw data first is the hallmark of ELT.

How to eliminate wrong answers

Option B is wrong because data streaming involves continuous, real-time ingestion (e.g., using Kafka or Kinesis), not daily batch CSV file loads. Option C is wrong because ETL would transform the data before loading into Snowflake, but the question states raw CSV files are loaded directly and then transformed afterward. Option D is wrong because CDC (Change Data Capture) captures incremental changes from source databases (e.g., via Debezium or Oracle GoldenGate), not daily full-file CSV imports.

169
MCQeasy

A data engineer needs to extract data from a REST API and load it into a data warehouse. The data is received in JSON format. Which data type best describes JSON?

A.Transactional
B.Semi-structured
C.Unstructured
D.Structured
AnswerB

JSON is semi-structured: it encodes hierarchical key-value pairs and arrays without a fixed relational schema, yet retains tags and nesting that allow parsing. This distinguishes it from fully unstructured text and from rigidly structured tabular formats.

Why this answer

JSON (JavaScript Object Notation) is classified as a semi-structured data type because it uses a flexible, self-describing schema with key-value pairs and nested structures, but does not enforce a rigid tabular schema like relational databases. In the context of extracting data from a REST API, JSON allows for varying fields and hierarchical data, which aligns with the semi-structured category.

Exam trap

The trap here is that candidates confuse the presence of structure (keys and values) with being fully structured, overlooking that JSON lacks a fixed schema and allows variability, which places it in the semi-structured category.

How to eliminate wrong answers

Option A is wrong because transactional data refers to records of business transactions (e.g., sales, orders) typically stored in structured formats with ACID properties, not to the format of the data itself. Option C is wrong because unstructured data lacks any predefined structure or schema (e.g., raw text, images, video), whereas JSON has a defined syntax with keys, values, and nesting. Option D is wrong because structured data requires a fixed schema (e.g., rows and columns in a relational table), while JSON allows optional fields and varying data types, making it semi-structured.

170
MCQhard

In the data lifecycle, which phase involves converting raw data into a usable format for analysis?

A.Ingestion
B.Analysis
C.Archival
D.Processing
AnswerD

Processing transforms raw data into a usable, analysis-ready format through cleaning, validation, aggregation and enrichment. It sits between collection and analysis in the lifecycle, directly matching the stem's conversion of raw data into usable form.

Why this answer

The processing phase in the data lifecycle is specifically where raw data is cleaned, transformed, and structured into a usable format for analysis. This includes operations such as parsing, normalization, deduplication, and conversion into formats like Parquet or Avro, which are optimized for query engines like Apache Spark or Presto.

Exam trap

The trap here is that candidates often confuse 'ingestion' with 'processing' because both involve moving data, but ingestion is about raw data capture, while processing is about transformation and cleaning before analysis.

How to eliminate wrong answers

Option A is wrong because ingestion refers to the initial collection and import of raw data from sources (e.g., via Apache Kafka or Flume) into a storage system, not its transformation into a usable format. Option B is wrong because analysis is the phase where processed data is queried, visualized, or modeled to derive insights, not where raw data is converted. Option C is wrong because archival involves moving older or infrequently accessed data to long-term storage (e.g., Amazon S3 Glacier or tape) for compliance or cost savings, not for preparing data for analysis.

171
MCQeasy

A healthcare database stores patient records. Each patient has a unique patient_id, and the database includes a table 'visits' with visit_id, patient_id, visit_date, and diagnosis_code. To ensure data integrity, which constraint should be applied to the patient_id column in the 'visits' table?

A.Unique constraint
B.Foreign key
C.Primary key
D.Check constraint
AnswerB

A foreign key on patient_id in the visits table references the primary key in the patients table, ensuring every visit maps to an existing patient. This enforces referential integrity, preventing orphan visit records, which is the integrity requirement stated in the stem.

Why this answer

A foreign key constraint on patient_id in the visits table enforces referential integrity by ensuring every patient_id value in visits matches an existing patient_id in the patients table. This prevents orphaned visit records and maintains consistency between the two tables.

Exam trap

DA0-002 often tests the confusion between primary key, unique, and foreign key constraints, where candidates incorrectly apply uniqueness to a column that should allow duplicates but reference another table.

How to eliminate wrong answers

Option A is wrong because a unique constraint would prevent duplicate patient_id values in the visits table, which is incorrect since a patient can have multiple visits. Option C is wrong because a primary key on patient_id in visits would also enforce uniqueness and not-null, which is inappropriate for a foreign key column that can repeat. Option D is wrong because a check constraint validates values against a condition (e.g., range), not referential integrity with another table.

172
MCQhard

A data architect is designing a system for a subscription streaming service. The service must record every play, pause, and skip event from millions of concurrent viewers with very low write latency, and it must later support analytical queries over months of event history. The architect wants a single storage layer that handles both needs without a separate transformation pipeline. Which data architecture should the architect choose?

A.A message queue that retains events for a fixed retention period and serves analytical queries directly
B.A traditional data warehouse that ingests events only through nightly ETL batches
C.A lakehouse that combines open table formats with ACID transactions and query engines over the same storage
D.A data lake that stores raw event files and requires a separate batch job to load them into a warehouse
AnswerC

A lakehouse uses open table formats such as Delta Lake or Apache Iceberg to add ACID transactions and schema enforcement directly on object storage, so streaming writes and analytical reads share one layer. It removes the need for a separate transformation pipeline while supporting low-latency ingestion and historical queries over the same data.

Why this answer

A lakehouse unifies streaming ingestion and analytical querying on one storage layer by adding ACID transactions and schema management to open table formats on object storage. This satisfies the requirement for low-latency event writes plus months of queryable history without a separate transformation pipeline.

Exam trap

The trap here is treating a message queue as a storage layer for long-term analytics, when its retention limits mean historical queries still require another system.

173
Multi-Selectmedium

Which THREE of the following are characteristics of a relational database?

Select 3 answers
A.Enforces referential integrity through foreign keys
B.Stores data in key-value pairs
C.Supports NoSQL document storage
D.Uses Structured Query Language (SQL) for data manipulation
E.Data is organized into tables with rows and columns
AnswersA, D, E

Referential integrity ensures relationships.

Why this answer

Relational databases enforce referential integrity through foreign keys, which ensure that relationships between tables remain consistent. A foreign key in a child table must match a primary key value in the parent table, preventing orphaned records and maintaining data integrity.

Exam trap

The trap here is that candidates may confuse key-value stores or document databases with relational databases, especially when they hear terms like 'keys' or 'documents' in other contexts, but relational databases strictly use tables, rows, columns, and SQL.

174
MCQmedium

A company uses an OLTP system for processing customer transactions. Which characteristic is most important for this system to ensure that each transaction is processed reliably, even if multiple users access the system simultaneously?

A.It uses a columnar storage format
B.It stores data in a denormalized schema
C.It supports complex analytical queries
D.It follows ACID properties
AnswerD

ACID properties guarantee atomicity, consistency, isolation and durability, so concurrent OLTP transactions commit reliably without partial writes or interference. Isolation specifically handles simultaneous users, while durability ensures committed transactions survive failure, matching the stem's reliability requirement.

Why this answer

ACID properties (Atomicity, Consistency, Isolation, Durability) are the foundational guarantees that ensure each transaction in an OLTP system is processed reliably, even when multiple users access the system concurrently. Atomicity ensures all-or-nothing execution, Consistency preserves database invariants, Isolation prevents concurrent transactions from interfering with each other, and Durability guarantees committed transactions survive failures. These properties directly address the requirement for reliable transaction processing under simultaneous access.

Exam trap

The trap here is confusing OLTP with OLAP characteristics: candidates might pick columnar storage or complex analytical queries because they associate databases with analytics, but the question specifically asks for reliability under concurrent access, which points to ACID properties.

How to eliminate wrong answers

Option A is wrong because columnar storage is optimized for analytical workloads (OLAP) that scan large volumes of data, not for high-concurrency transactional processing; it typically degrades write performance and does not provide transactional guarantees. Option B is wrong because a denormalized schema is used in data warehousing to reduce joins and improve read performance for analytics, but it can introduce data redundancy and update anomalies that undermine transactional consistency. Option C is wrong because supporting complex analytical queries is a characteristic of OLAP systems, not OLTP; OLTP systems prioritize fast, simple transactions and would suffer performance degradation if burdened with complex analytical queries.

175
MCQhard

A table Orders has OrderID (primary key), CustomerID, and CustomerEmail. During analysis, it is found that CustomerID uniquely identifies CustomerEmail. Which normal form is violated if both CustomerID and CustomerEmail are stored in this table?

A.Second normal form (2NF)
B.Third normal form (3NF)
C.No violation
D.First normal form (1NF)
AnswerB

CustomerEmail depends on CustomerID, which is a non-key attribute, creating a transitive dependency violating 3NF.

Why this answer

The table violates Third Normal Form (3NF) because CustomerEmail is transitively dependent on CustomerID, which is not a candidate key. In 3NF, every non-key attribute must depend only on the primary key (OrderID), not on another non-key attribute. Since CustomerID uniquely identifies CustomerEmail, CustomerEmail depends on CustomerID, not directly on OrderID, creating a transitive dependency.

Exam trap

The trap here is that candidates often confuse transitive dependencies with partial dependencies, mistakenly thinking that because CustomerID is not part of the primary key, the violation is 2NF rather than 3NF.

How to eliminate wrong answers

Option A is wrong because Second Normal Form (2NF) requires that all non-key attributes are fully functionally dependent on the entire primary key; here, the primary key is a single column (OrderID), so there is no partial dependency, and 2NF is satisfied. Option C is wrong because a violation does exist — the transitive dependency between CustomerID and CustomerEmail breaks 3NF. Option D is wrong because First Normal Form (1NF) is not violated; the table has atomic values and a primary key, so it meets 1NF requirements.

176
Multi-Selectmedium

Which TWO of the following are examples of unstructured data? (Select 2)

Select 2 answers
A.MP4 video
B.CSV file
C.XML file
D.JPEG image
E.JSON document
AnswersA, D

Video files are unstructured.

Why this answer

A is correct because MP4 video files contain binary data that lacks a predefined schema or tabular structure, making them a classic example of unstructured data. Unlike structured data, MP4 files store audiovisual content in a container format that cannot be easily queried or analyzed without specialized processing.

Exam trap

The trap here is that candidates often confuse semi-structured data (XML, JSON, CSV) with unstructured data, forgetting that semi-structured data still has a defined schema or metadata, unlike raw binary or free-form text.

177
MCQeasy

A data architect needs to store raw data from various sources, including social media feeds and log files, for future analysis. The data may be used for machine learning and ad-hoc queries. Which storage solution is most appropriate for storing raw data in its native format?

A.Data lake
B.Data mart
C.Relational database
D.Data warehouse
AnswerA

A data lake stores raw data in its native format without schema enforcement, accommodating social media feeds and log files. This satisfies the requirement for future machine learning and ad-hoc queries, unlike warehouses that demand predefined structure.

Why this answer

A data lake is designed to store raw data in its native format, including unstructured and semi-structured data from sources like social media feeds and log files. It supports schema-on-read, making it ideal for future machine learning and ad-hoc queries without requiring upfront transformation. This aligns directly with the requirement to preserve raw data for flexible analysis.

Exam trap

The trap here is that candidates confuse a data lake with a data warehouse, assuming both are for analytics, but the key distinction is that a data warehouse requires structured, transformed data while a data lake preserves raw, native-format data.

How to eliminate wrong answers

Option B is wrong because a data mart is a subset of a data warehouse optimized for a specific business domain, not for storing raw, diverse data in native format. Option C is wrong because a relational database enforces a rigid schema and ACID constraints, making it unsuitable for unstructured data like social media feeds and log files. Option D is wrong because a data warehouse stores processed, structured data optimized for reporting and BI, not raw data in its native format.

178
Multi-Selecthard

A national retailer is consolidating data from 40 regional stores into a central analytics platform. Each region uses different codes for the same product categories, and store managers report sales in local currencies. Before loading the data, the integration team must resolve these inconsistencies. Which two activities are appropriate steps to standardize the data? (Choose two.)

Select 2 answers
A.Convert all monetary values to a single reporting currency using a defined exchange rate table.
B.Build a mapping table that translates each region's product category codes into a single enterprise code set.
C.Delete records from regions whose currency differs from the headquarters currency.
D.Store each region's data in a separate database and report from each database independently.
E.Allow each region to keep its own category codes and currencies, and resolve differences during reporting.
AnswersA, B

Converting local currency amounts to one reporting currency using a governed exchange rate table makes financial figures directly comparable across regions. The rate table documents which rate applies to which period, preserving auditability. This standardization step addresses the unit inconsistency in monetary values and is essential before aggregating sales at the enterprise level.

Why this answer

Standardizing inconsistent data requires resolving both the category code mismatch and the currency unit mismatch. A crosswalk mapping table unifies product categories under one enterprise code set, while conversion using a governed exchange rate table unifies monetary values into one reporting currency. Deleting records, isolating databases, or deferring translation to report time all leave the inconsistencies unresolved or shift the burden downstream.

Exam trap

The trap here is thinking that consolidation only means moving data into one place, when it also requires resolving semantic and unit mismatches during transformation.

179
MCQeasy

A data analyst notices that customer addresses in the database contain invalid ZIP codes. Which data quality dimension is being violated?

A.Validity
B.Timeliness
C.Consistency
D.Completeness
AnswerA

Validity checks whether values conform to defined formats and permissible ranges. A ZIP code that does not match the required pattern breaches that rule, so the dimension violated is validity rather than accuracy, completeness or consistency.

Why this answer

A is correct because validity refers to the degree to which data conforms to its defined format, rules, or constraints. Invalid ZIP codes (e.g., a five-digit code containing letters or a non-existent postal code) directly violate the format and domain rules expected for that field, making this a validity issue.

Exam trap

The trap here is that candidates confuse 'validity' with 'completeness' or 'consistency,' mistakenly thinking a missing or mismatched ZIP code is a completeness or consistency issue, when in fact the violation is about the data not conforming to the required format or rule set.

How to eliminate wrong answers

Option B (Timeliness) is wrong because timeliness concerns whether data is available when needed, not whether individual values match expected formats. Option C (Consistency) is wrong because consistency checks for logical coherence across related data sets or fields (e.g., ZIP code matching city/state), not the intrinsic correctness of a single value. Option D (Completeness) is wrong because completeness measures whether all required data is present (e.g., missing ZIP codes), not whether present data is correctly formatted.

180
Multi-Selecthard

A retail analytics team is building a data catalog and must document the metadata for a new sales fact table. The team needs to record structural metadata that describes how the data is organized. Which two items qualify as structural metadata for this table? (Choose two.)

Select 2 answers
A.The name of the business owner accountable for the sales data
B.The primary key constraint that enforces uniqueness on the sales transaction identifier
C.The list of columns in the table with each column's declared data type
D.The timestamp recording when the table was last refreshed from the source system
E.A free-text business definition explaining what a completed sale means to the merchandising team
AnswersB, C

A primary key constraint defines how rows are uniquely identified and how the table's structure enforces integrity, which is structural metadata. It tells consumers which column or columns distinguish records and informs join planning and validation. Ownership and load timestamps describe governance and operations, not the table's internal organization, so the constraint is the structural element.

Why this answer

Structural metadata describes how data is organized: the columns and their data types, plus constraints such as primary keys that define row identity. Ownership, refresh timestamps, and business definitions describe accountability, operational state, and semantics respectively, which fall under administrative, operational, or descriptive categories. Documenting the column list with types and the primary key constraint therefore satisfies the structural requirement for the catalog.

Exam trap

The trap here is treating any catalog entry as structural metadata, when ownership, freshness, and business definitions describe governance, operations, and semantics rather than the table's organization.

181
Multi-Selecthard

Which THREE of the following are properties of ratio data? (Choose THREE.)

Select 3 answers
A.Data can be categorized into groups
B.Allows negative values
C.Supports multiplication and division
D.Intervals between values are equal
E.Has a meaningful zero point
AnswersC, D, E

Ratio data allows meaningful ratios (e.g., twice as heavy).

Why this answer

Ratio data supports multiplication and division because it has a true, meaningful zero point that indicates the absence of the measured attribute. This allows ratios to be computed (e.g., one value is twice another), which is a defining property of ratio scales in measurement theory.

Exam trap

The trap here is that candidates confuse the 'meaningful zero' property with the ability to have negative values, or they think categorization is a defining feature of ratio data, when it is actually a property shared by all measurement scales.

182
MCQhard

A dataset contains a column 'Education Level' with values: 'High School', 'Bachelor', 'Master', 'PhD'. An analyst computes the average by assigning numbers 1-4. Which data concept is being violated?

A.Misclassifying data as structured
B.Treating ordinal data as interval
C.Treating nominal data as ordinal
D.Treating ratio data as interval
AnswerB

Education levels are ordinal: order matters but gaps between categories are not equal, so distances between 1 and 2 versus 3 and 4 are meaningless. Averaging the numeric codes treats those ranks as interval data with equal spacing, producing a statistically invalid mean.

Why this answer

The analyst assigned numeric values (1-4) to 'Education Level' categories and computed an average. This treats the ordinal data as if it were interval data, assuming equal spacing between categories (e.g., the difference between 'High School' and 'Bachelor' is the same as between 'Master' and 'PhD'), which is not valid. Ordinal data only preserves order, not magnitude or equal intervals, so calculating a mean is inappropriate.

Exam trap

CompTIA often tests the distinction between ordinal and interval scales by presenting a scenario where a mean is computed on ranked categories, tempting candidates to think the error is about nominal vs. ordinal (Option C) rather than the misuse of arithmetic operations on ordinal data.

How to eliminate wrong answers

Option A is wrong because misclassifying data as structured refers to incorrectly labeling unstructured data (e.g., text) as structured, but the dataset already has a structured column; the violation is about measurement scale, not structure. Option C is wrong because treating nominal data as ordinal would involve imposing an order on unordered categories (e.g., colors), but 'Education Level' already has a natural order, so the error is not about misordering but about assuming equal intervals. Option D is wrong because treating ratio data as interval would ignore a true zero point (e.g., income), but 'Education Level' has no meaningful zero, so the violation is not about ratio vs. interval but about ordinal vs. interval.

183
Multi-Selectmedium

A data architect is designing a system to handle a workload that requires strong consistency and complex multi-table joins for financial reporting. Which two characteristics should the architect prioritize when selecting the database technology? (Choose two.)

Select 2 answers
A.Denormalized wide-column storage to optimize write throughput
B.A schema-less document model to accommodate evolving report formats
C.A relational schema with well-defined foreign key relationships
D.ACID compliance to guarantee transaction integrity
E.Eventual consistency to maximize availability during network partitions
AnswersC, D

A relational schema with foreign keys enforces referential integrity and supports the complex multi-table joins required for financial reporting. Well-defined relationships allow the query optimizer to execute joins efficiently and ensure that related records remain consistent. This characteristic aligns directly with both the strong consistency and complex join requirements in the scenario.

Why this answer

Financial reporting demands strong consistency and the ability to join data across multiple related tables. ACID compliance guarantees that transactions complete reliably without partial updates, and a relational schema with foreign keys enforces the relationships that make complex joins both possible and efficient. Together these characteristics satisfy the core requirements, while eventual consistency, wide-column storage, and document models each sacrifice one or both of these needs.

Exam trap

The trap here is assuming that any modern database can handle financial reporting, when the combination of strong consistency and complex joins specifically points to ACID-compliant relational systems.

184
MCQmedium

A database administrator is designing a normalized database to reduce data redundancy. They have a table with columns: OrderID, ProductID, ProductName, and Quantity. The table is currently in 1NF. To move to 2NF, which issue must be resolved?

A.The table has repeating groups
B.ProductName depends only on ProductID, causing a partial dependency
C.Quantity depends on both OrderID and ProductID
D.The table has a transitive dependency
AnswerB

ProductName depends only on ProductID, not on the full composite key (OrderID, ProductID), which is a partial dependency violating 2NF. Resolving it means moving ProductName into a separate Products table keyed by ProductID, leaving Quantity and OrderID in the order line table.

Why this answer

To move from 1NF to 2NF, the table must have no partial dependencies. A partial dependency occurs when a non-key attribute depends on only part of a composite primary key. Here, the composite key is (OrderID, ProductID).

ProductName depends only on ProductID, not on the full key, so it is a partial dependency. Option A (repeating groups) is a violation of 1NF, not 2NF, and the table is already in 1NF. Option C is incorrect because Quantity depends on both OrderID and ProductID (it is fully functionally dependent on the composite key).

Option D is incorrect because a transitive dependency (where a non-key attribute depends on another non-key attribute) is a 3NF issue, not 2NF. Therefore, the correct answer is B.

Exam trap

CompTIA Data+ often tests the distinction between partial dependencies (2NF) and transitive dependencies (3NF), so candidates mistakenly choose a transitive dependency when the real issue is a partial dependency on a composite key.

How to eliminate wrong answers

Option A is wrong because repeating groups are a 1NF violation, and the table is already stated to be in 1NF, so this issue is already resolved. Option C is wrong because Quantity depending on both OrderID and ProductID is a full functional dependency on the composite key, which is acceptable and does not violate 2NF. Option D is wrong because a transitive dependency (where a non-key column depends on another non-key column) is a 3NF violation, not a 2NF issue.

185
Multi-Selecthard

A data analyst is designing a database for a retail application. Which TWO of the following are valid reasons to use a NoSQL document database like MongoDB instead of a relational database? (Select 2)

Select 2 answers
A.The application requires high-speed transactional consistency
B.The data structure evolves frequently
C.The data is hierarchical, such as orders with line items
D.The data has a fixed schema with many relationships
E.The application needs complex joins across multiple tables
AnswersB, C

Document stores allow schema flexibility.

Why this answer

NoSQL document databases like MongoDB are schema-flexible, allowing the data structure to evolve over time without requiring migrations or downtime. This is ideal for agile development where application requirements change frequently, as documents can have varying fields without breaking existing records.

Exam trap

The trap here is that candidates often assume NoSQL databases are always faster or more consistent, but the exam tests the specific trade-offs: document databases excel at flexible schemas and hierarchical data, not at transactional consistency or complex joins.

186
MCQmedium

A data analyst is profiling a dataset of customer records and discovers that 12% of the rows have missing values in the "postal_code" column, while the "customer_id" column is fully populated. The analyst needs to document this finding for a data quality report. Which data quality dimension does the missing postal code values primarily violate?

A.Uniqueness
B.Completeness
C.Accuracy
D.Consistency
AnswerB

Completeness measures the extent to which required data is present without missing values. With 12% of postal codes absent, the column fails to fully represent all customer records, directly violating completeness. Documenting this gap helps downstream processes assess whether imputation or source correction is needed before analysis.

Why this answer

Completeness assesses whether all required values are present. The postal_code column has 12% missing entries, meaning the dataset does not fully capture that attribute for all customers, which is the defining characteristic of a completeness violation. Accuracy, consistency, and uniqueness address correctness, agreement, and duplication respectively, none of which describe absent values.

Exam trap

The trap here is conflating missing values with incorrect values, which leads to selecting accuracy instead of recognizing that absence of data is a completeness issue.

187
MCQeasy

A hospital's patient records system must process thousands of small transactions per second. Which type of database system is best suited for this workload?

A.Data mart
B.OLTP
C.Data warehouse
D.OLAP
AnswerB

OLTP systems are optimised for high volumes of small, concurrent read/write transactions with strong consistency and row-level locking, matching the hospital's thousands-per-second small transaction requirement. OLAP instead suits large analytical queries, so it cannot meet this throughput pattern.

Why this answer

OLTP (Online Transaction Processing) systems are designed to handle a high volume of small, concurrent transactions with low latency and high concurrency. This makes them ideal for a hospital patient records system that must process thousands of small transactions per second, such as patient check-ins, prescription updates, and billing entries.

Exam trap

The trap here is that candidates often confuse OLTP with OLAP, mistakenly thinking that 'processing many transactions' implies analytical processing, when in fact OLTP is the correct choice for high-frequency, small, write-heavy workloads.

How to eliminate wrong answers

Option A is wrong because a data mart is a subset of a data warehouse focused on a specific business line (e.g., cardiology), not designed for high-throughput transactional processing. Option C is wrong because a data warehouse is optimized for complex analytical queries on large historical datasets, not for handling thousands of small, real-time transactions per second. Option D is wrong because OLAP (Online Analytical Processing) is used for multidimensional analysis and reporting, not for high-frequency transactional workloads.

188
MCQmedium

A hospital's analytics team is designing a new repository for electronic health records. The records include patient demographics, lab results, and physician notes, and the schema must remain flexible because new lab test types are added frequently. The team needs to enforce relationships between patients, encounters, and lab orders while keeping the ability to evolve the schema. Which data model best fits these requirements?

A.Relational model
B.Document model
C.Key-value model
D.Graph model
AnswerA

The relational model stores data in tables with primary and foreign keys, which directly enforces the patient-to-encounter-to-lab-order relationships the team requires. Schema evolution is supported through migrations such as adding new tables or columns for new lab test types. This combination of strong referential integrity and structured change management matches the hospital's need to keep records consistent while the schema grows.

Why this answer

The requirement to enforce relationships between patients, encounters, and lab orders points to a model with primary and foreign keys, which is the relational model. It also supports schema evolution through controlled migrations when new lab test types appear. Key-value, graph, and document models offer flexibility or traversal but do not natively enforce the structured relationships clinical records demand.

Exam trap

The trap here is focusing only on schema flexibility and choosing a document store, while overlooking the explicit requirement to enforce relationships between entities.

189
MCQeasy

An e-commerce company wants to provide real-time personalized product recommendations based on customer browsing behavior. Currently, they have a traditional data warehouse that processes batch updates every night. The marketing team complains that recommendations are outdated within hours because customers see yesterday's data. The data engineer needs to modify the architecture to support near-real-time analytics. The budget is limited, and the existing warehouse infrastructure must be reused as much as possible. Which architectural change would best meet the requirement?

A.Replace the warehouse with an in-memory database for real-time processing.
B.Add more nodes to the warehouse cluster to speed up batch processing.
C.Implement a streaming data pipeline (e.g., Apache Kafka) that feeds a real-time recommendation engine.
D.Increase the frequency of batch load from nightly to every hour.
AnswerC

Kafka ingests events continuously and pushes them to the recommendation engine within seconds, eliminating the nightly batch latency that made recommendations stale. It satisfies the near-real-time requirement while the existing warehouse remains in place, keeping costs within the limited budget.

Why this answer

Implementing a streaming data pipeline like Apache Kafka enables the ingestion and processing of customer browsing events in near real-time, feeding a dedicated recommendation engine that can update recommendations within seconds or minutes. This approach reuses the existing data warehouse for historical analytics and batch reporting while adding a lightweight streaming layer for low-latency recommendations, aligning with the limited budget and reuse requirement.

Exam trap

The trap here is that candidates may assume increasing batch frequency (Option D) is sufficient for near-real-time needs, but the Data+ exam tests the understanding that 'near-real-time' typically requires sub-minute latency, which batch processing cannot achieve due to scheduling overhead and resource contention.

How to eliminate wrong answers

Option A is wrong because replacing the warehouse with an in-memory database would discard the existing infrastructure entirely, incurring high migration costs and losing the warehouse's batch processing capabilities for other workloads, which violates the constraint to reuse the existing warehouse. Option B is wrong because adding more nodes to the warehouse cluster only improves the throughput of batch processing, but does not reduce the latency of data freshness—recommendations would still be based on data that is at least hours old, failing the near-real-time requirement. Option D is wrong because increasing batch frequency to every hour still introduces a delay of up to 60 minutes, which is insufficient for real-time personalization; moreover, frequent batch loads can cause resource contention and degrade warehouse performance for other queries.

190
MCQhard

A data analyst is working with a relational database that contains a table of customer orders. To optimize query performance for a report that filters by order date and customer ID, the analyst wants to create an index. Which type of index would be most effective for queries that filter on both columns?

A.B-tree index on order_date
B.Hash index on customer_id
C.Composite index on (order_date, customer_id)
D.Clustered index on order_id
AnswerC

A composite index stores the two key columns together in a defined order, so the database can satisfy the combined order_date and customer_id filter from a single index structure rather than intersecting separate single-column indexes or scanning the table.

Why this answer

A composite B-tree index on (order_date, customer_id) allows the database to efficiently satisfy equality and range predicates on both columns in a single index scan. B-tree indexes support ordered traversal and range lookups, making them ideal for date-based filtering combined with an equality filter on customer_id. This index structure minimizes the number of rows scanned by leveraging the index's leading column for the date range and the second column for the customer ID match.

Exam trap

The trap here is that candidates often choose a single-column index (A or B) thinking it will be sufficient, not realizing that a composite index is required to avoid a 'filter' step that scans many rows after the index lookup.

How to eliminate wrong answers

Option A is wrong because a single-column B-tree index on order_date can only efficiently filter by date; any additional filter on customer_id would require a separate lookup or a full scan of the date-matched rows, leading to poor performance. Option B is wrong because a hash index on customer_id only supports equality lookups and cannot handle range queries on order_date, making it unsuitable for date-range filtering. Option D is wrong because a clustered index on order_id physically reorders the table by order_id, which does not help with filtering on order_date or customer_id and may even degrade performance for these queries due to unnecessary key lookups.

191
MCQmedium

An organization uses a data warehouse for analytics. The data team wants to load data from source systems into the warehouse. They choose to load raw data first and then perform transformations within the warehouse. Which approach are they using?

A.ELT
B.Data lake
C.Data mart
D.ETL
AnswerA

ELT extracts raw source data, loads it into the warehouse unchanged, then transforms it using the warehouse's own compute. This matches the described sequence exactly, distinguishing it from ETL, where transformation occurs in a staging area before loading.

Why this answer

ELT (Extract, Load, Transform) is correct because the raw data is extracted from source systems and loaded directly into the data warehouse before any transformation occurs. Transformations are then performed inside the warehouse using its own compute engine (e.g., SQL, dbt, or Snowflake virtual warehouses). This is the defining characteristic of the ELT pattern, which leverages modern cloud warehouse scalability.

Exam trap

DA0-002 often tests the order of operations — candidates confuse ETL and ELT by assuming transformation always happens before loading, but the phrase 'load raw data first, then transform' is the explicit ELT signal.

How to eliminate wrong answers

Option B is wrong because a data lake is a storage repository for raw structured, semi-structured, and unstructured data — it describes where data lives, not the load-then-transform sequence described. Option C is wrong because a data mart is a subset of a warehouse focused on a specific business line or department, not a data integration methodology. Option D is wrong because ETL transforms data in a separate staging or transformation engine before loading it into the warehouse, which is the reverse order of the scenario described.

192
MCQmedium

A data analyst receives a dataset with inconsistent date formats (e.g., "01/02/2023", "2023-01-02", "Jan 2, 2023"). Which data quality dimension is most directly affected?

A.Accuracy
B.Consistency
C.Completeness
D.Timeliness
AnswerB

Consistency measures whether values conform to the same format and units across a dataset. Mixed representations of the same date attribute violate that uniformity, whereas accuracy concerns correctness of values and completeness concerns missing data.

Why this answer

Consistency refers to the uniformity of data representation. Inconsistent date formats violate consistency, not accuracy, completeness, or timeliness.

193
MCQmedium

An e-commerce company stores product descriptions that contain accented characters and emoji in customer reviews. The database currently fails to store these characters correctly, replacing them with question marks. Which action should the data engineer take to resolve this issue?

A.Increase the maximum length of the VARCHAR column
B.Convert the column to a BLOB data type to store raw bytes
C.Set the column's character set to UTF-8 and ensure the connection uses UTF-8 encoding
D.Change the column data type from VARCHAR to CHAR
AnswerC

Accented characters and emoji require Unicode support. Changing the column character set to UTF-8 and aligning the client connection encoding ensures that multibyte characters are transmitted and stored without loss. When the connection or column uses a limited encoding such as Latin-1, characters outside that set are replaced with question marks, which exactly matches the symptom described.

Why this answer

The symptom of accented characters and emoji becoming question marks is a classic encoding problem. Unicode character sets such as UTF-8 can represent virtually all characters, while legacy encodings cannot. Aligning both the column character set and the client connection encoding to UTF-8 ensures end-to-end representation and storage of multibyte characters without corruption.

Exam trap

The trap here is focusing on the length or type of the column when the actual problem is that the character encoding cannot represent the characters being stored.

194
Multi-Selecthard

A data governance team is establishing policies. Which three activities are part of data governance? (Select THREE.)

Select 3 answers
A.Data quality management
B.Data ownership assignment
C.Data indexing
D.Data steward designation
E.Data normalization
AnswersA, B, D

Ensuring data quality is a core governance function.

Why this answer

Data quality management is a core activity of data governance because it ensures that data meets defined standards for accuracy, completeness, consistency, and timeliness. Governance policies mandate monitoring and remediation processes to maintain data quality across the organization.

Exam trap

CompTIA Data+ often tests the distinction between data governance (policies, roles, quality) and data management (technical implementation like indexing and normalization), leading candidates to confuse operational tasks with governance activities.

195
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.

196
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.

197
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.

198
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.

199
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.

200
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).

← PreviousPage 3 of 3 · 200 questions total

Ready to test yourself?

Try a timed practice session using only Dap Data Concepts questions.