nerdexam
IBM

COG-612 · Question #10

The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country. IBM COG-612 Exam What will the report show if the author creates a…

The correct answer is A. Only reps who generated total revenue greater than 500,000. See the full explanation below for the reasoning.

Question

The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country. IBM COG-612 Exam What will the report show if the author creates a detail filter for Revenue>500,000 and applies the filter AFTER auto aggregation?

Exhibit

COG-612 question #10 exhibit

Options

  • AOnly reps who generated total revenue greater than 500,000.
  • BOnly cities that generated total revenue greater than 500,000.
  • COnly countries that generated total revenue greater than 500,000.
  • DOnly reps who had individual sales transactions of greater than 500,000.

How the community answered

(40 responses)
  • A
    78% (31)
  • B
    13% (5)
  • C
    8% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full COG-612 Practice