Identify data tools
5 practice questions under this official exam objective (DA0-002) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Extracting and Appending Missing Months to a Car Sales Report
When a report requires twelve months of car sales data but the table only holds ten, the analyst must retrieve the two missing prior-year months and a
Purpose of a Pivot Table for Large Datasets
This DA0-002 question asks why a data analyst builds a pivot table over a large dataset ahead of a board meeting. The page establishes that the core p
Identifying Delimiter-Based File Formats
CSV files are the standard format for separating data using delimiters like commas or tabs, making them distinct from tag-based formats such as XML an
Which SQL Query Returns Accurate Employee Head Count
This SQL question shows that counting raw rows in the JOBS table double-counts employees who hold multiple jobs, inflating the head count. The page es
Joining Table and API Data Sources with Python
This DA0-002 question asks how to best combine a table data source with a web API data source in Python. The correct approach is to normalize both sou