nerdexam
CompTIA

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.

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

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    93% (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.

AAggregating

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.

BTransposing

Transposing involves rotating data from rows to columns or vice-versa, which is not about reordering records within the existing row/column structure.

CSortingCorrect

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.

DConsolidating

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

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

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice