A data engineer is designing an ETL process to load data from a source system into a data warehouse. The source data contains duplicate records and inconsistent date formats. The engineer wants to ensure the data is clean before loading. Which ETL step should be performed first?

Transform the data to remove duplicates and standardize dates

Validate the data in the source system

Load the data into the warehouse

Extract the data from the source system

A data pipeline ingests data from an external vendor. The vendor's data format sometimes changes without notice. To ensure the pipeline does not fail silently, what should the data engineer implement?

A data cleansing step that removes any invalid rows

Schema validation that checks the data types and required fields before processing

A manual review of the data every time it is received

Which of the following is an example of an external data source that might be integrated into a company's data warehouse?

A company's human resources system

A social media API providing public sentiment data

A customer relationship management (CRM) system

What is the primary goal of data blending?

To store data in a data warehouse

To create a unified dataset from multiple sources for analysis

CompTIAData+

Domain 2Objective 1

Use Data Acquisition Methods DA0-001 Practice Questions (Page 1)

Part of the Data acquisition and preparation domain, which accounts for 22% of the DA0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 3–4 from this objective — we provide 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

10concepts

22%of the exam

Questions 1–5

1expert · easy
A data engineer is designing an ETL process to load data from a source system into a data warehouse. The source data contains duplicate records and inconsistent date formats. The engineer wants to ensure the data is clean before loading. Which ETL step should be performed first?
Select an answer first
2application · medium
A data pipeline ingests data from an external vendor. The vendor's data format sometimes changes without notice. To ensure the pipeline does not fail silently, what should the data engineer implement?
Select an answer first
3foundation · easy
Which of the following is an example of an external data source that might be integrated into a company's data warehouse?
Select an answer first
4foundation · easy
In an ETL process, which step involves converting data from its source format into a format that is suitable for the target system?
Select an answer first
5foundation · easy
What is the primary goal of data blending?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DA0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DA0-001” is a trademark of its owner, used for identification only.