Question 1

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?

Options :

A :

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.

B : Change the field type of Employee ID directly on the Employee Data TBL from text to numeric.

C : Change the field type of Employee ID directly on the Learner Data TBL from Numeric to Text.

D :

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.

Answer: D

Question 2

What report can you run to edit and maintain your Prism import and publish schedules?

Options :

A : Scheduled Future Processes

B : Prism Management Console

C : Prism Activities Monitor

D : Prism Usage

Answer: A

Question 3

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?

Options :

A : Join

B : Union

C : Group By

D : Explode

Answer: C

Question 4

What report can you run to edit and maintain your Prism import and publish schedules?

Options :

A : Scheduled Future Processes

B : Prism Management Console

C : Prism Activities Monitor

D : Prism Usage

Answer: A

Question 5

You have two tables. One with employee data from Workday and another with learner data from anexternal 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?

Options :

A : 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.

B : Change the field type of Employee ID directly on the Employee Data TBL from text to numeric.

C : Change the field type of Employee ID directly on the Learner Data TBL from Numeric to Text.

D : 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.

Answer: D

Free Workday-Prism-Analytics Mock Exam – Practice Online Confidently

Buying Options: