DA0-001 Question #244: Real Exam Question with Answer & Explanation

The correct answer is C: Sorting. To change the order of a list from one criteria (alphabetical name) to another (transaction date), the data manipulation technique of sorting is required. Sorting rearranges data based on the values in one or more specified columns.

Data Analysis

Question

A data analyst has received a list of customer names in alphabetical order that needs to instead be put in order by transaction date. Which of the following data manipulation techniques should the analyst use?

Options

AAggregating
BTransposing
CSorting
DConsolidating

Explanation

To change the order of a list from one criteria (alphabetical name) to another (transaction date), the data manipulation technique of sorting is required. Sorting rearranges data based on the values in one or more specified columns.

Common mistakes.

A. Aggregating involves combining data from multiple rows into a single summary row, such as calculating sums or averages, which does not change the order of existing records.
B. Transposing involves rotating data from rows to columns or vice-versa, which is not about reordering records within the existing row/column structure.
D. Consolidating involves combining data from multiple sources into a single dataset, which is a broader data integration task rather than a specific reordering technique.

Concept tested. Data manipulation - sorting

Reference. https://learn.microsoft.com/en-us/power-bi/fundamentals/service-sort-report-by-column

Topics

#Data manipulation#Sorting data#Data ordering#Data preparation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice Browse All DA0-001 Questions