You are asked to produce a Prism data source, which is going to be used in a matrix report that should display the minimum, maximum, total, average, and the median purchase order amount by location and month. What should you do to achieve the desired result?

• A. Publish your detail data and build the summarizations in the matrix report.
• B. Add two Group By stages to your derived dataset.
• C. Publish your detail data and build the summarizations in the advanced report.
• D. Add a Group By stage to your derived dataset.

You have a number of Workday reports that use a Prism data source. When are the values of the Prism calculated fields in the Workday reports calculated?

• A. At dataset creation time.
• B. At time of publishing.
• C. At report run time.
• D. At the calculated field creation time.

You have two tables. One with employee data from Workday and another with learner data from an external system. Both tables have an Employee ID field.
In the Employee Data TBL, Employee ID is text.

In the Learner Data TBL, Employee ID is numeric.

How can you prepare to join these tables, without the potential loss of data?

• A. Change the field type of Employee ID directly on the Learner Data TBL from Numeric to Text.
• B. Import the Learner Data TBL into a DDS and change the field type of Employee ID from numeric to text using a Manage Fields stage.
• C. Import the Employee Data TBL into a DDS and change the field type of Employee ID from text to numeric using a Manage Fields stage.
• D. Change the field type of Employee ID directly on the Employee Data TBL from text to numeric.

When joining datasets, what items must match?

• A. The level of detail in each dataset.
• B. The number of rows in each dataset.
• C. The field types for the Match Row fields.
• D. The field names for the Match Row fields.

You want to use a custom report containing prompts as a source connection for a table. What must you ensure to make this possible?

• A. The report is built on an indexed data source.
• B. The prompts are marked as required.
• C. The prompts are mapped at the data change task level.
• D. The custom report prompts have default values assigned on the report definition.