Absolute Free Workday-Prism-Analytics Exam Practice for Comprehensive Preparation 

A report that uses a Prism data source that you created has a brand new requirement that Expense Partner by Location should only see expense reports for workers for the locations they support. Given that you have the Location Hierarchy (instance) field in your dataset used for publishing, how can you adjust to meet the requirement?

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?  

In a Prism project, you have a dataset containing customer purchase transactions, including the customer ID, purchase amount, and purchase date. You want to analyze the total purchase amount for each customer over the entire period. What transformation stage should you apply to calculate the total purchase amount for each customer? 

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?