Free Workday Workday-Prism-Analytics Practice Test & Real Exam Questions
You want to convert each instance of a multi-instance field and convert it to a single-instance field. What transformation stage can you use to do this?
Correct Answer: A
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You want to configure access to a published Prism data source to use it in reporting and discovery boards.
What action must you take?
What action must you take?
Correct Answer: D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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?
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
A Prism data administrator combined data from multiple sources down to a final derived dataset, including current worker data. There is a new requirement to append historical worker data to the dataset in a uniform layout. The historical worker data includes some, but not all, fields that align withthe current worker data.
Using current worker data as the primary pipeline, how can the historical worker data points be brought in?
Using current worker data as the primary pipeline, how can the historical worker data points be brought in?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
For a Prism use case, you have two datasets: one contains daily sales data, and the other contains monthly budget allocations. Before performing a join between these datasets, what transformation stage should you apply to the sales data to ensure it matches the granularity of the budget data?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
