A SaaS company provides a public API. The data team wants to build a dashboard showing API usage trends, including request volume, latency, and error rates by endpoint. The API gateway already logs all requests. The team must decide between querying the API gateway logs directly or building a separate analytics pipeline. Which approach is the most appropriate?

Ask customers to report their own API usage.

Build a separate pipeline that calls the API's own endpoints to generate usage metrics.

Query the API gateway logs directly using a log analytics tool.

Use web scraping to extract usage data from the API's documentation page.

A data engineer must load a 500 GB CSV file into a data warehouse daily. The file is delivered via SFTP. The engineer notices that the load takes too long and wants to reduce the time. The warehouse supports both CSV and Parquet formats. Which approach is the most effective?

Compress the CSV file with ZIP before loading.

Load the CSV file directly without any transformation.

Split the CSV into smaller files and load them sequentially.

Convert the CSV to Parquet before loading, then load the Parquet file.

A security analyst is investigating a suspected brute-force attack on a web application. The analyst needs to identify the source IP addresses that generated the most failed login attempts over the past 24 hours. Which data source should the analyst query?

The data warehouse's sales fact table.

The web server's access and error logs.

The company's employee directory.

The customer relationship management (CRM) database.

What is the primary purpose of web scraping?

To extract data from websites in an automated way

To create a backup of a website's content

To secure a website against cyber attacks

To improve the search engine ranking of a website

Which file format is commonly used for storing structured tabular data and is easily opened in spreadsheet applications?

JSON (JavaScript Object Notation)

XML (eXtensible Markup Language)

CompTIAData+

Domain 1Objective 2

Identify Data Sources DA0-001 Practice Questions (Page 4)

Part of the Data concepts and environments domain, which accounts for 20% of the DA0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–12 in this domain), expect 1–2 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

6concepts

20%of the exam

Questions 16–20

16expert · hard
A SaaS company provides a public API. The data team wants to build a dashboard showing API usage trends, including request volume, latency, and error rates by endpoint. The API gateway already logs all requests. The team must decide between querying the API gateway logs directly or building a separate analytics pipeline. Which approach is the most appropriate?
Select an answer first
17expert · hard
A data engineer must load a 500 GB CSV file into a data warehouse daily. The file is delivered via SFTP. The engineer notices that the load takes too long and wants to reduce the time. The warehouse supports both CSV and Parquet formats. Which approach is the most effective?
Select an answer first
18application · easy
A security analyst is investigating a suspected brute-force attack on a web application. The analyst needs to identify the source IP addresses that generated the most failed login attempts over the past 24 hours. Which data source should the analyst query?
Select an answer first
19foundation · easy
What is the primary purpose of web scraping?
Select an answer first
20foundation · easy
Which file format is commonly used for storing structured tabular data and is easily opened in spreadsheet applications?
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.