DA0-002 Data Concepts and Environments Practice Test 8 — 15 Questions

Question 1

A retail company analyzes customer purchase data to improve inventory management. They store daily transaction records in a relational database and monthly aggregate reports in a data warehouse. Which difference between these storage methods best explains why the warehouse is more suitable for trend analysis?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The database is optimized for write-heavy OLTP, while the warehouse is optimized for read-heavy OLAP.. OLTP databases are optimized for high-frequency write operations (INSERT/UPDATE/DELETE) and ACID compliance, making them ideal for transaction processing but poor for complex analytical queries. In contrast, a data warehouse is optimized for read-heavy OLAP workloads, using columnar storage, pre-aggregated tables, and indexing strategies that enable fast aggregation and trend analysis over large historical datasets. This architectural difference directly supports the retail company's need to analyze purchase trends over time.

Answer

The database uses a star schema while the warehouse uses a normalized schema.

Answer

The database enforces ACID transactions, while the warehouse uses eventual consistency.

Answer

The database stores only current data, while the warehouse stores historical data.

Question 2

A data analyst is evaluating data quality issues in a customer database. Which TWO actions are best practices for ensuring data consistency?

Accepted Answer

Standardizing date formats across all tables. Standardizing date formats across all tables (Option B) ensures that date values are stored and interpreted uniformly, eliminating inconsistencies that arise from mixed formats (e.g., MM/DD/YYYY vs. DD-MM-YY). This practice directly supports data consistency by enforcing a single representation, which is critical for accurate querying, reporting, and integration across systems.

Answer

Allowing null values for foreign keys

Answer

Enabling cascading updates on primary keys

Answer

Using data profiling to identify duplicate records

Question 3

An organization is implementing a data lake to store raw data from various sources. Which THREE characteristics are typically associated with a data lake compared to a data warehouse?

Accepted Answer

Supports batch and real-time processing. Data lakes are designed to ingest and process data in both batch and real-time streaming modes, unlike data warehouses which primarily handle batch ETL workloads. This flexibility is enabled by technologies like Apache Kafka for streaming and Apache Spark for batch processing, allowing the data lake to support diverse ingestion patterns without pre-schematization.

Answer

Supports only structured data

Answer

Requires data transformation before loading

Question 4

A manufacturing company has two primary data systems: an ERP system that stores production orders with fields like OrderID, ProductID, Quantity, and ProductionDate, and a CRM system that stores customer sales with fields like SaleID, CustomerID, ProductID, SaleDate, and Amount. The data analyst needs to create a unified view of product performance by joining these tables. However, the ProductID field in the ERP uses a 5-character alphanumeric code (e.g., 'P1234'), while the CRM uses a 6-character code (e.g., 'PR1234'). Additionally, some products have multiple entries due to slight variations in naming. The analyst wants to ensure accurate matching without losing data. Which action should the analyst take first to address the data inconsistency?

Accepted Answer

Create a mapping table that standardizes ProductID formats between ERP and CRM.. Creating a mapping table allows the analyst to explicitly define the relationship between the 5-character ERP ProductID and the 6-character CRM ProductID, ensuring accurate joins without data loss. This approach standardizes the inconsistent formats and handles variations by providing a controlled, deterministic lookup, which is essential for maintaining referential integrity in a unified view.

Answer

Perform data profiling to identify all unique ProductID values and their frequencies.

Answer

Aggregate data by product name and ignore ProductID mismatches.

Answer

Use a fuzzy matching algorithm to join on similar ProductID strings.

Question 5

A large financial institution is implementing a data governance framework to comply with new regulations requiring strict control over sensitive customer data. The data governance committee has identified several domains, including customer master data, transaction data, and risk assessment data. They need to decide on a master data management (MDM) approach that ensures a single, authoritative source of customer information across all systems. However, the current environment has multiple legacy systems with conflicting customer records. The committee is concerned about downtime and business disruption during the transition. Which MDM approach best balances data consistency with minimal operational impact?

Accepted Answer

Registry MDM, which creates a virtual view by linking records without moving data.. Registry MDM is correct because it creates a virtual, unified view of customer data by linking records from multiple legacy systems via a registry index, without physically moving or consolidating data. This approach ensures a single authoritative source of customer information while avoiding downtime and business disruption, as the underlying systems remain unchanged and operational during the transition.

Answer

Centralized MDM, which replaces all systems with one central master system.

Answer

Consolidation MDM, which merges all customer data into a single physical hub.

Answer

Coexistence MDM, which maintains multiple masters with synchronization.

Question 6

A data analyst at a marketing agency is working with a dataset containing customer demographics, purchase history, and social media engagement metrics. The agency wants to perform sentiment analysis on unstructured social media comments to identify brand perception. The dataset also includes structured fields like age, income, and purchase amounts. The analyst needs to choose a storage and processing platform that can handle both structured and unstructured data efficiently without requiring extensive schema definition upfront. Which platform should the analyst recommend?

Accepted Answer

Data lake. A data lake is the correct choice because it can store both structured data (e.g., age, income, purchase amounts) and unstructured data (e.g., social media comments) in its native format without requiring a predefined schema. This flexibility allows the analyst to ingest raw social media text for sentiment analysis and later apply schema-on-read for structured queries, avoiding the upfront schema definition needed by other platforms.

Answer

Relational database (RDBMS)

Answer

Data warehouse

Answer

NoSQL document database

Question 7

A telecommunications company is experiencing issues with its customer satisfaction survey data. The data is collected from multiple channels: phone, email, and web forms. Each channel uses a different scale for ratings: phone uses 1-10, email uses 1-5, and web uses 1-7. Additionally, some survey responses contain missing values for demographic fields. The data analyst needs to calculate an overall satisfaction score that is comparable across all channels. The company's leadership wants a single metric that minimizes distortion from the different scales. Which approach should the analyst use to standardize the ratings?

Accepted Answer

Normalize each rating to a 0-100 scale using min-max normalization.. Min-max normalization rescales each rating to a common 0-100 range using the formula (x - min) / (max - min) * 100. This preserves the relative distribution of responses within each channel while eliminating the effect of different scale lengths, making the scores directly comparable. It minimizes distortion better than simple multiplication or binary conversion, as it accounts for the full range of each original scale.

Answer

Calculate the average rating separately for each channel and then compare the averages.

Answer

Convert all ratings to a binary metric of satisfied (above midpoint) or unsatisfied.

Answer

Convert all ratings to a 1-10 scale by multiplying email ratings by 2 and web by 1.43.

Question 8

A healthcare organization is subject to strict data privacy regulations requiring the classification of all data assets. The data governance team has identified three data sensitivity levels: Public, Internal, and Restricted. They have a new data pipeline importing patient health records from multiple clinics. The records include patient names, diagnoses, treatment codes, and insurance information. The team must ensure that the classification is applied correctly and that restricted data (e.g., diagnoses) is not exposed to unauthorized personnel. However, the pipeline uses automated tagging based on metadata rules, and some fields are misclassified. What is the most effective immediate action to improve classification accuracy?

Accepted Answer

Implement data loss prevention (DLP) tools that inspect content and enforce classification rules.. Implementing DLP tools with content inspection can automatically detect sensitive patterns (e.g., diagnosis codes) and enforce correct classification, directly addressing misclassification from incomplete metadata rules. Option A (encrypting all data) is a security measure but does not fix classification accuracy. Option B (manual review) is not scalable for a pipeline. Option C (expanding metadata rules) may help but is less effective since metadata can still miss patterns that DLP content inspection can catch.

Answer

Encrypt all data at rest and in transit regardless of classification.

Answer

Require manual review and reclassification of all incoming records.

Answer

Expand the metadata rule set to include more keywords and patterns.

Question 9

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?

Accepted Answer

Implement a streaming data pipeline (e.g., Apache Kafka) that feeds a real-time recommendation engine.. 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.

Answer

Replace the warehouse with an in-memory database for real-time processing.

Answer

Add more nodes to the warehouse cluster to speed up batch processing.

Answer

Increase the frequency of batch load from nightly to every hour.

Question 10

A data analyst is comparing characteristics of structured and unstructured data. Which TWO of the following are characteristics of structured data? (Choose two.)

Accepted Answer

Data is stored in predefined schemas. Structured data is organized into predefined schemas, such as tables with rows and columns, which enforce a consistent data format and relationships. This rigid structure allows structured data to be easily queried using SQL, as SQL is designed to operate on relational database management systems (RDBMS) that rely on these schemas. Option C is correct because a predefined schema is a defining characteristic of structured data, enabling efficient storage, retrieval, and integrity constraints.

Answer

Data is typically stored as raw text

Answer

Data lacks a fixed format

Answer

Data often requires NoSQL databases for storage

Question 11

Refer to the exhibit. A data architect is designing a data dictionary for a relational database. Based on the exhibit, which data concept is being illustrated?

Accepted Answer

Data constraints. The exhibit shows a table definition with column attributes such as NOT NULL, UNIQUE, and PRIMARY KEY, which are data constraints that enforce rules on the data values. Data constraints ensure data integrity by restricting what data can be stored in a column, such as preventing null values or duplicate entries. This directly aligns with the concept of data constraints, making option A correct.

Answer

Data aggregation

Answer

Data normalization

Answer

Data cardinality

Question 12

A retail company is merging customer data from three separate systems: an e-commerce platform, a point-of-sale (POS) system, and a loyalty program. The e-commerce platform stores customer names in "FirstName LastName" format, the POS system stores names as "LastName, FirstName", and the loyalty program stores names in separate "first_name" and "last_name" fields. The data analyst needs to create a unified customer master table. After initial merging, there are 20% more records than expected, including duplicates with slight name variations (e.g., "John Smith" vs "John A. Smith"). To ensure accurate consolidation, which data concept should the analyst prioritize applying first?

Accepted Answer

Data standardization. Data standardization is the correct first step because it resolves the inconsistent name formats (e.g., 'FirstName LastName', 'LastName, FirstName', and separate fields) into a single, consistent representation. By applying a standardized format (e.g., 'FirstName LastName'), the analyst can then accurately identify and merge duplicates like 'John Smith' and 'John A. Smith' using fuzzy matching or exact matching on the standardized values. This ensures the unified customer master table has the correct number of records without the 20% inflation caused by formatting variations.

Answer

Data profiling

Answer

Data indexing

Answer

Data encryption

Question 13

Which of the following data types is characterized by a flexible schema and is commonly represented using JSON or XML?

Accepted Answer

Semi-structured data. JSON and XML are examples of semi-structured data, which has a flexible schema unlike structured data (fixed schema) or unstructured data (no schema).

Answer

Unstructured data

Answer

Structured data

Answer

Relational data

Question 14

An organization needs to store raw data from IoT sensors in its native format for future analysis. Which storage solution is best suited for this purpose?

Accepted Answer

Data lake. A data lake is designed to store raw data in its native format, including unstructured and semi-structured data from IoT sensors, without requiring a predefined schema. This allows the organization to preserve the original data for future analysis, unlike traditional databases that enforce structure upon ingestion.

Answer

Relational database

Answer

Data mart

Answer

Data warehouse

Question 15

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?

Accepted Answer

INNER JOIN. INNER JOIN returns only rows with matching values in both tables, which matches the requirement.

Answer

RIGHT JOIN

Answer

FULL OUTER JOIN

Answer

LEFT JOIN