Latest [Dec 24, 2025] Workday-Prism-Analytics Exam with Accurate Workday Pro Prism Analytics Exam PDF Questions [Q13-Q29]

NO.13 You have to blend two sources of data. Your matching field is Employee ID, which is a text-type field in Pipeline 1, but is numeric in Pipeline 2. How do you prepare your data for blending?

Add a Manage Fields to change the field type and then Union.

Add a Filter first and then a Manage Fields to change the field type.

Add first a Manage Fields to change the field type and then Join.

Add a Join first and then a Manage Fields to change the field type.

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, blending two data sources typically involves joining them on a common field, such as Employee ID in this case. However, the Employee ID field is text in Pipeline 1 and numeric in Pipeline 2, which means the field types must be aligned before a join can be performed to avoid data mismatches or errors. According to the official Workday Prism Analytics study path documents, the correct approach is to first use a Manage Fields stage to change the field type of Employee ID in one of the pipelines to match the other (e.g., convert the numeric Employee ID in Pipeline 2 to text, as text can safely store numeric values without data loss), and then perform a Join stage to blend the data (option C). Converting from numeric to text is preferred because converting text to numeric risks data loss if the text field contains non- numeric characters.
The other options are not appropriate:
* A. Add a Manage Fields to change the field type and then Union: A Union appends rows vertically and does not blend data based on a matching field like Employee ID; blending typically requires a Join.
* B. Add a Filter first and then a Manage Fields to change the field type: Adding a Filter stage is unnecessary for preparing the field types for a join and does not address the blending requirement.
* D. Add a Join first and then a Manage Fields to change the field type: Performing the Join first will fail or produce incorrect results because the field types (text and numeric) are incompatible for joining; the types must be aligned before the Join.
By using a Manage Fields stage to change the field type first and then performing a Join, the data from both pipelines can be blended accurately on the Employee ID field.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Preparing Data for Joins in Prism Analytics Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Field Type Transformations for Data Blending

NO.14 You are a new Prism customer and you want to ensure the correct set of fields is brought into a derived dataset. When should you apply a Manage Fields stage?

After the dataset is published.

At the end of the Primary Pipeline of a published dataset.

At the beginning of the Primary Pipeline of the derived dataset.

At the beginning of the primary pipeline of the Base Dataset.

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, a Manage Fields stage is used to control the fields in a dataset by renaming, hiding, or changing field types, among other actions. According to the official Workday Prism Analytics study path documents, to ensure the correct set of fields is brought into a derived dataset (DDS), the Manage Fields stage should be applied at the beginning of the Primary Pipeline of the derived dataset (option C).
Placing the Manage Fields stage early in the pipeline-right after the initial import stage (Stage 1)-allows you to define the field structure upfront, ensuring that subsequent transformationstages (e.g., Join, Filter, Calculate Field) operate on the desired set of fields. This approach helps maintain consistency and avoids unnecessary processing of fields that are not needed in later stages.
The other options are not optimal:
* A. After the dataset is published: You cannot add transformation stages like Manage Fields after a dataset is published; transformations must be applied during the dataset’s creation or editing.
* B. At the end of the Primary Pipeline of a published dataset: Similar to option A, you cannot modify a published dataset’s pipeline, and placing Manage Fields at the end would not prevent unnecessary fields from being processed in earlier stages.
* D. At the beginning of the primary pipeline of the Base Dataset: A Base Dataset does not have a transformation pipeline; it is a direct import of a table, so Manage Fields stages can only be applied in a Derived Dataset.
Applying the Manage Fields stage at the beginning of the derived dataset’s Primary Pipeline ensures efficient data preparation and transformation.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Using Manage Fields in Derived Datasets Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Best Practices for Field Management in Pipelines

NO.15 You want to create a Prism calculated field to change the field type to date data using the TO_DATE function.
The field from Workday is numeric data and you will use the Manage Fields stage to prepare the data for use in the function. What will you need to change about the field in the Manage Fields stage?

Output Type

Output Name

Input Type

Input Name

NO.16 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?

A duplicate row will be generated.

The row will be omitted.

Included fields from the imported pipeline will have NULL values.

Included fields from both pipelines will have NULL values.

NO.17 When joining datasets, what items must match?

The field types for the Match Row fields.

The number of rows in each dataset.

The level of detail in each dataset.

The field names for the Match Row fields.

NO.18 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?

Unpivot

Explode

Manage Fields

Group By

NO.19 You want your derived dataset to only show rows that meet the following criteria: Agent ID is not null AND Location is Dallas OR Location is Montreal. How can you achieve this?

By adding a Manage Fields stage.

By using Simple Filter conditions.

By using Advanced Filter conditions.

By creating a Custom Example.

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, filtering a derived dataset to meet specific criteria involving multiple conditions with mixed logical operators (AND, OR) requires careful configuration. The criteria here are: Agent ID is not null AND (Location is Dallas OR Location is Montreal). According to the official Workday Prism Analytics study path documents, this can be achieved by using Advanced Filter conditions (option C).
A Simple Filter in Prism Analytics allows for basic conditions with a single operator (“If All” for AND, “If Any” for OR), but it cannot handle nested logic like AND combined with OR in a single filter. For example, a Simple Filter with “If All” would require all conditions to be true (Agent ID is not null AND Location is Dallas AND Location is Montreal), which is too restrictive. A Simple Filter with “If Any” would include rows where any condition is true (Agent ID is not null OR Location is Dallas OR Location is Montreal), which is too broad. The Advanced Filter, however, allows for complex expressions with nested logic, such as ISNOTNULL(Agent_ID) AND (Location = “Dallas” OR Location = “Montreal”), ensuring the correct rows are included.
The other options are incorrect:
* A. By adding a Manage Fields stage: The Manage Fields stage modifies field properties (e.g., type, visibility) but does not filter rows based on conditions.
* B. By using Simple Filter conditions: As explained, a Simple Filter cannot handle the combination of AND and OR logic required for this criteria.
* D. By creating a Custom Example: Custom Examples are used to provide sample data for testing, not to filter rows in a dataset.
Using Advanced Filter conditions allows for the precise application of the required logic to filter the dataset accurately.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Filtering Data in Derived Datasets Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Using Advanced Filters for Complex Conditions

NO.20 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?

At report run time.

At dataset creation time.

At the calculated field creation time.

At time of publishing.

NO.21 What task or report should you access to view a Prism data source?

Edit Dataset Transformations task

Edit Data Source Security task

View Prism Data Source report

View Dataset Details report

NO.22 You had to change the imported pipeline in a Join stage and your View Dataset Lineage report shows a Stage Alert regarding the disconnected pipeline. How can you fix this and make the alert disappear?

Add a Manage Fields stage and re-attach the pipeline.

Publish the derived dataset.

Change the imported pipeline to a different one.

Delete the disconnected pipeline.

NO.23 You have published a derived dataset to build a Prism data source. For reports using this Prism data source, when is data updated?

At republish of the datasource only.

At reimport into tables and republish of the datasource.

At reimport into tables only.

At report runtime.

NO.24 You apply an Explode stage to your derived dataset that contains information on your worker benefit elections. What happens in the resulting stage?

The number of columns stays the same and the original multi-instance field doesn’t get dropped.

The number of columns exponentially increases and the original multi-instance field gets dropped.

The number of rows stays the same and the original multi-instance field does not get dropped.

The number of rows exponentially increases and the original multi-instance field gets dropped.

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, an Explode stage is used to transform a multi-instance field into multiple rows, creating a single-instance field for each instance. According to the official Workday Prism Analyticsstudy path documents, when an Explode stage is applied to a derived dataset containing worker benefit elections (a multi-instance field, e.g., a list of elected benefits per worker), the following occurs: the number of rows exponentially increases, and the original multi-instance field gets dropped (option D).
For example, if a worker has three benefit elections in a multi-instance field, the Explode stage will create three rows-one for each election-while the original multi-instance field (e.g., “Benefit Elections”) is replaced by a single-instance field containing one election per row. The number of rows increases based on the number of instances in the multi-instance field (e.g., a dataset with 100 workers, each with 3 elections on average, would grow from 100 rows to 300 rows). The term “exponentially” in the question reflects this potential for significant row growth, though the increase is technically linear per record based on the number of instances.
The other options are incorrect:
* A. The number of columns stays the same and the original multi-instance field doesn’t get dropped: The original multi-instance field is dropped and replaced by a single-instance field; the column count may change slightly due to this replacement.
* B. The number of columns exponentially increases and the original multi-instance field gets dropped:
The Explode stage does not increase the number of columns exponentially; it primarily affects rows, with minimal impact on columns.
* C. The number of rows stays the same and the original multi-instance field does not get dropped: The number of rows increases due to the explosion of multi-instance data, and the original field is dropped.
The Explode stage’s behavior of increasing rows and dropping the original multi-instance field aligns with its purpose of normalizing multi-instance data into a row-based structure.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Using the Explode Stage in Derived Datasets Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Handling Multi- Instance Fields with Explode Stages

NO.25 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?

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.

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

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

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.

In Workday Prism Analytics, joining two tables requires that the fields used in the join condition have compatible data types to avoid data mismatches or loss. The Employee Data TBL has an Employee ID field as text, while the Learner Data TBL has an Employee ID field as numeric. According to the official Workday Prism Analytics study path documents, to join these tables without potential data loss, the best approach is to convert the numeric Employee ID in the Learner Data TBL to text, as text fields can safely store numeric values as strings, but converting text to numeric risks data loss if the text field contains non-numeric characters (e.g., leading zeros or special characters).
The correct method is to import the Learner Data TBL into a Derived Dataset (DDS) and use a Manage Fields stage to change the field type of Employee ID from numeric to text (option D). This ensures that the Employee ID field in both tables is text, enabling a safe and accurate join without losing data. The Manage Fields stage in a DDS allows for field type transformations, which is the recommended approach for preparing data for joins in Prism Analytics.
The other options are less suitable:
* 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: Converting text to numeric risks data loss if the text field contains non-numeric values, which could lead to errors or missing records during the join.
* B. Change the field type of Employee ID directly on the Employee Data TBL from text to numeric:
Direct field type changes on tables are not supported in Prism Analytics, and even if possible, this approach risks data loss for the same reason as option A.
* C. Change the field type of Employee ID directly on the Learner Data TBL from Numeric to Text:
Direct field type changes on tables are not supported; field type transformations must be done in a DDS using a Manage Fields stage.
By converting the numeric Employee ID to text in a DDS, the join can be performed safely, preserving all data from both tables.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Preparing Data for Joins in Prism Analytics Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Field Type Transformations Using Manage Fields Stage

NO.26 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?

Add a Manage Fields stage.

Click on the field name and check the stage statistics.

Create a Prism calculated field.

Join on the Worker ID field.

NO.27 A Prism data writer has to create an intermediary Prism calculated field A, used only to achieve a final result in Prism calculated field B and they only need to publish out field B. What should they do?

Mark field A as intermediate calculation.

Add a Manage Fields stage to the DDS and hide field A.

Add a Manage Fields stage to the DDS and hide field B.

Delete field A from their DDS and just leave field B.

NO.28 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?

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

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

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

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

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, classifying workers into pay ranges based on their pay requires creating a new field that evaluates the pay values and assigns them to defined ranges (e.g., “Low,” “Medium,” “High”).
According to the official Workday Prism Analytics study path documents, the recommended approach is to create a derived dataset (DDS) and build a CASE calculated field to classify workers against their pay (option B). The CASE function in a calculated field allows users to define conditional logic (e.g., CASE WHEN pay
< 50000 THEN “Low” WHEN pay < 100000 THEN “Medium” ELSE “High” END), which is ideal for creating pay range classifications. This calculated field is added within a deriveddataset, which can then be published as a Prism data source, making the new field available for reporting and analytics.
The other options are not optimal:
* A. Add the additional field to your raw data before you ingest into Prism: Modifying raw data outside Prism is unnecessary and less flexible, as Prism’s transformation capabilities (like CASE) are designed for such tasks.
* C. Build a CASE calculated field function on the TBL directly to ease later transformation: Calculated fields cannot be created directly on a table (TBL) in Prism Analytics; they must be defined in a derived dataset.
* D. Build an Evaluate Expression calculated field on your final Prism business object to evaluate workers against their pay: Prism Analytics does not use “Prism business objects” for calculated fields, and “Evaluate Expression” is not a standard function; this option is not applicable.
Using a CASE calculated field in a derived dataset provides a flexible and maintainable way to classify workers by pay ranges, ensuring the field is included in the final Prism data source.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Creating Calculated Fields with CASE Functions Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Classifying Data Using Calculated Fields in Derived Datasets

NO.29 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?

The table or dataset where the calculated field was created.

The View Dataset Lineage report.

Any table in the lineage.

Any dataset in the lineage.

Leave a Reply Cancel reply