Question 1

[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 2

[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 3

[Data Prep and Transformation]

The Prism use case is to classify workers based on their pay. You must create a field that evaluates worker pay and returns a value that represents various pay ranges. How would you add this field for inclusion on the Prism data source?

AAdd the additional field to your raw data before you ingest into Prism.

BCreate a derived dataset and build a CASE calculated field to classify workers against their pay.

CBuild a CASE calculated field function on the TBL directly to ease later transformation.

DBuild an Evaluate Expression calculated field on your final Prism business object to evaluate workers against their pay.

Answer : B

Question 4

[Integrating Prism with Workday Reports]

Why should you include Workday instance field types in the Workday report that you use to import data into Prism?

AThe final Prism datasource can support drilling into Workday objects.

BPerformance is improved in the final Prism datasource when published.

CUnions are more easily performed with instance field types.

DJoins are more easily performed with instance field types.

Answer : A

Question 5

[Datasets and Data Sources]

A Prism data administrator notices that several of the Prism calculated fields on their lineage are producing nil results, so they need to revise the expressions for all of the affected calculated fields. Where can they review the expressions in bulk?

AThe table or dataset where the calculated field was created.

BThe View Dataset Lineage report.

CAny table in the lineage.

DAny dataset in the lineage.

Answer : B

Free Practice Questions for Workday Prism Analytics Exam

Question 1

Question 2

Question 3

Question 4

Question 5