Workday Prism Analytics Exam Questions Instant Access

Question 1

[Data Prep and Transformation]

You are loading data into a table using the Data Change task. The field type in the source file is Numeric and the table field type is Text. What can you do to load the data?

AUse a different source file, as the field types are incompatible.

BMap the Numeric field to the table Text field.

CChange the field type in the parsing stage from Numeric to Text.

DChange the connection type for the data change task.

Answer : B

Question 2

[Data Prep and Transformation]

Using three different source files, you want to load rows of data into an empty table through a Data Change task. What needs to be the same about the three source files?

ASchema

BSource

CNaming convention

DSize

Answer : A

Question 3

[Data Prep and Transformation]

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?

AUnpivot

BExplode

CManage Fields

DGroup By

Answer : B

Question 4

[Data Prep and Transformation]

You just imported your table on worker compensation into a derived dataset but before adding any transformation you want to make sure you have no NULL values for the Worker ID field. How can you get this insight?

AAdd a Manage Fields stage.

BClick on the field name and check the stage statistics.

CCreate a Prism calculated field.

DJoin on the Worker ID field.

Answer : B

Question 5

[Data Prep and Transformation]

You are adding a Join stage and choose Join type of Left Outer Join, causing Workday to search for a matching row in the imported pipeline. What happens if no matching rows exist?

AA duplicate row will be generated.

BThe row will be omitted.

CIncluded fields from the imported pipeline will have NULL values.

DIncluded fields from both pipelines will have NULL values.

Answer : C

Question 6

[Publishing and Visualizing Data]

A Prism data administrator is ready to create a Prism data source. As data is updated in Prism, the goal is to update the data in the Prism data source concurrently, enabling immediate incremental updates. How should the administrator create the Prism data source?

ACreate a table and select the Enable for Analysis checkbox.

BCreate a table and select Publish.

CPublish a derived dataset with the Prism: Default to Dataset Access Domain.

DSet Data Source Security on a derived dataset and select Publish.

Answer : A

Question 7

[Data Prep and Transformation]

You created a derived dataset that imports data from a table, which will become your Stage 1. What can you add to this dataset?

AAs many transformation stages of any type as your scenario requires.

BAs many transformation stages of any type as long as they are in a particular order.

CUp to five transformation stages.

DUp to two Manage Fields transformation stages.

Answer : A

Workday Pro Prism Analytics Exam Workday Prism Analytics Exam Questions