nerdexam
CompTIA

DA0-001 · Question #484

Given the following tables: Referencing Table A, which of the following functions would be the most appropriate to summarize total items sold in Table B across the two channels?

The correct answer is D. Aggregate. Aggregate functions are used to summarize data, such as calculating the total quantity sold by channel and item.

Data Analysis

Question

Given the following tables:

Referencing Table A, which of the following functions would be the most appropriate to summarize total items sold in Table B across the two channels?

Exhibits

DA0-001 question #484 exhibit 1
DA0-001 question #484 exhibit 2

Options

  • ABinning
  • BLookup
  • CSystem
  • DAggregate

How the community answered

(38 responses)
  • B
    3% (1)
  • C
    5% (2)
  • D
    92% (35)

Explanation

Aggregate functions are used to summarize data, such as calculating the total quantity sold by channel and item.

Topics

#Aggregation#Data summarization#Data functions

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice