nerdexam
IBM

P2020-300 · Question #51

P2020-300 Question #51: Real Exam Question with Answer & Explanation

Sign in or unlock P2020-300 to reveal the answer and full explanation for question #51. The question stem and answer options stay visible for context.

Question

Click the Exhibit button. Referring to the exhibit, yourmodel has two calculations ?"Revenue"and"Commission"- partitioned byPayeeID, ProductGroup, Product, and Month. What must you create to produce the summary report that shows revenue and commission by ProductGroup and Month?

Exhibit

P2020-300 question #51 exhibit

Options

  • Aa Data Store that joins both calculations and select ProductGroup and Month as detail columns
  • BAggregate Transformations in Presenter partitioned by ProductGroup and Month
  • Cadditional calculations to sum the results partitioned by ProductGroup and Month
  • DCalculated Rows in Presenter that sum both values by ProductGroup and Month

Unlock P2020-300 to see the answer

You've previewed enough free P2020-300 questions. Unlock P2020-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full P2020-300 Practice