DA0-001 · Question #319
DA0-001 Question #319: Real Exam Question with Answer & Explanation
The correct answer is A: Aggregation. To summarize the number of people in Chicago in 2022 from a dataset, the analyst must first filter the data to include only records for Chicago and the year 2022, then apply aggregation to count the people within that filtered subset. These two steps allow for targeted summarizat
Question
An analyst needs to summarize the number of people in Chicago in 2022 using the following set of data: Which of the following steps should the analyst use to provide results? (Choose two.)
Options
- AAggregation
- BSorting
- CFiltering
- DIndexing
- ECleaning
- FReplacing
Explanation
To summarize the number of people in Chicago in 2022 from a dataset, the analyst must first filter the data to include only records for Chicago and the year 2022, then apply aggregation to count the people within that filtered subset. These two steps allow for targeted summarization.
Common mistakes.
- B. Sorting arranges data but does not summarize or select specific subsets for analysis.
- D. Indexing improves data retrieval speed but does not summarize or filter the data content itself.
- E. Cleaning addresses data quality issues but is not a direct step for summarizing specific counts based on location and year.
- F. Replacing modifies data values but is not a step for summarizing or filtering based on the given criteria.
Concept tested. Data preparation - Filtering and Aggregation
Reference. https://learn.microsoft.com/power-bi/fundamentals/service-basic-concepts#explore-your-data
Topics
Community Discussion
No community discussion yet for this question.