DA0-001 · Question #244
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…
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.
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
How the community answered
(30 responses)- A3% (1)
- B3% (1)
- C93% (28)
Why each option
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.
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.
Transposing involves rotating data from rows to columns or vice-versa, which is not about reordering records within the existing row/column structure.
Sorting is the appropriate data manipulation technique to reorder a list of data based on a new criterion, such as changing from alphabetical order by name to chronological order by transaction date. This technique rearranges the entire dataset according to the specified key.
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
Source: https://learn.microsoft.com/en-us/power-bi/fundamentals/service-sort-report-by-column
Topics
Community Discussion
No community discussion yet for this question.