Authentic Workday Workday-Prism-Analytics Exam Dumps PDF – Jan-2026 Updated [Q14-Q37]

NO.14 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.15 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.16 When should a Prism configurator leverage advanced filter logic over basic filter logic?

The filter needs to remove NULL values.

The filter needs to use operators such as “equal to” or “not equal to”.

The filter needs to leverage operators such as “greater than or equal to” or “less than or equal to”.

The filter needs a combination of AND/OR operators.

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

Union

Group By

Manage Fields

Filter

NO.21 What is the primary purpose of window functions in Prism?

To provide row-level access control.

To manipulate strings and dates within a query.

To filter rows based on specified conditions.

To perform calculations across a set of rows related to the current row while partitioning the data.

NO.22 When using a window function to calculate averages in Prism, what field type must the function operate on?

Text

Boolean

Numeric

Date

NO.23 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.24 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?

Schema

Source

Naming convention

Size

NO.25 You want to remove data within a Prism data source without deleting any dependent custom reports. What task can you use to do this?

Inactivate Dataset

Delete Dataset

Unpublish Dataset

Delete Published Rows

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 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.28 You explode the Language Skills multi-instance field on your derived dataset and you want to change the business object that the new Language Skills Exploded instance field is mapped to. What steps should you take?

Select from the list of suggested BO values in the Explode stage configuration.

Click on the Related Actions next to the business object in the insight panel.

Add a Manage Fields before the Explode stage and modify the business object.

Add a Manage Fields after the Explode stage and modify the business object.

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, the Explode stage transforms a multi-instance field (e.g., Language Skills) into multiple rows, creating a new single-instance field (e.g., Language Skills Exploded). The resulting field inherits the business object (BO) mapping from the original multi-instance field, but this mapping can be modified if needed. According to the official Workday Prism Analytics study path documents, to change the business object that the new Language Skills Exploded instance field is mapped to, you should add a Manage Fields stage after the Explode stage and modify the business object (option D).
The Manage Fields stage allows you to edit field properties, including the business object mapping, for the exploded field. After the Explode stage creates the new single-instance field, the Manage Fields stage can be used to reassign the business object by selecting a different Workday business object (e.g., changing from a generic object to a specific one like “Language”). This step ensures the field is mapped correctly for downstream reporting or integration with Workday reports.
The other options are incorrect:
* A. Select from the list of suggested BO values in the Explode stage configuration: The Explode stage does not provide an option to modify business object mappings during its configuration; it focuses on exploding the multi-instance field.
* B. Click on the Related Actions next to the business object in the insight panel: The insight panel provides metadata insights but does not allow direct modification of business object mappings for fields.
* C. Add a Manage Fields before the Explode stage and modify the business object: Modifying the business object before the Explode stage affects the original multi-instance field, but the Explode stage will still create the new field with the inherited mapping, so this does not achieve the goal.
Adding a Manage Fields stage after the Explode stage is the correct approach to modify the business object mapping of the new exploded field.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Managing Field Properties After Explode Stages Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Modifying Business Object Mappings in Derived Datasets

NO.29 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.30 You want to configure access to a published Prism data source to use it in reporting and discovery boards.
What action must you take?

Edit the data source security and select a domain.

Share the dataset with appropriate users.

Share the imported Workday report to provide users with access to the published Prism data source.

Schedule the recurring publish process.

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, configuring access to a published Prism data source for use in reporting and discovery boards requires managing its security settings. According to the official Workday Prism Analytics study path documents, the necessary action is to edit the data source security and select a domain (option A).
After a dataset is published as a Prism data source, access is controlled through security domains. By editing the data source security and assigning it to an appropriate security domain (e.g., a domain that grants access to specific user groups like report writers or analysts), you ensure that authorized users can access the data source for reporting and discovery boards. This aligns with Workday’s configurable security framework, ensuring that only users with the appropriate permissions can view or use the data source.
The other options are incorrect:
* B. Share the dataset with appropriate users: Sharing the dataset itself does not grant access to the published Prism data source; access to the data source is controlled through its security settings, not the dataset’s sharing settings.
* C. Share the imported Workday report to provide users with access to the published Prism data source:
Sharing an imported Workday report does not affect access to the Prism data source; the data source’s security must be configured directly.
* D. Schedule the recurring publish process: Scheduling a recurring publish process ensures the data source is updated regularly, but it does not configure access for reporting or discovery boards.
Editing the data source security and selecting a domain is the critical step to enable access for reporting and discovery boards.
References:
Workday Prism Analytics Study Path Documents, Section: Security and Governance in Prism, Topic:
Configuring Access to Prism Data Sources
Workday Prism Analytics Training Guide, Module: Security and Governance in Prism, Subtopic: Managing Data Source Security for Reporting

NO.31 You want to use a custom report containing prompts as a source connection for a table. What must you ensure to make this possible?

The report is built on an indexed data source.

The prompts are mapped at the data change task level.

The custom report prompts have default values assigned on the report definition.

The prompts are marked as required.

NO.32 You want to apply a Filter stage to your derived dataset to show only expense reports submitted in the current month and where the expense report total amount is higher than 2000 USD. What should you do?

Use a simple filter, two conditions, and “If All” operator.

Use a simple filter, two conditions, and “If Any” operator.

Use a simple filter, three conditions, and “If All” operator.

Use a simple filter, three conditions, and “If Any” operator.

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, a Filter stage in a derived dataset is used to include only rows that meet specific criteria. The requirement here is to show expense reports that satisfy two conditions: (1) submitted in the current month, and (2) total amount higher than 2000 USD. According to the official Workday Prism Analytics study path documents, this can be achieved by using a simple filter with two conditions and the “If All” operator (option A).
The first condition would check the submission date, using a function like MONTH() to compare with the current month (e.g., MONTH(submission_date) = MONTH(CURRENT_DATE())). The second condition would compare the total amount (e.g., total_amount > 2000). The “If All” operator ensures that both conditions must be true for a row to be included, which aligns with the requirement that both criteria (current month AND amount > 2000 USD) must be met. A simple filter is sufficient because the logic involves straightforward comparisons without nested conditions.
The other options are incorrect:
* B. Use a simple filter, two conditions, and “If Any” operator: The “If Any” operator would include rows where either condition is true (e.g., submitted in the current month OR amount > 2000 USD), which does not meet the requirement for both conditions to be true.
* C. Use a simple filter, three conditions, and “If All” operator: Only two conditions are needed (submission month and amount), so three conditions are unnecessary.
* D. Use a simple filter, three conditions, and “If Any” operator: This combines the issues of option B (wrong operator) and option C (too many conditions).
Using a simple filter with two conditions and the “If All” operator ensures the dataset includes only the expense reports that meet both criteria.
References:
Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Applying Filters in Derived Datasets Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Configuring Simple Filters with Multiple Conditions

NO.33 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.34 What report can you run to edit and maintain your Prism import and publish schedules?

Scheduled Future Processes

Prism Management Console

Prism Activities Monitor

Prism Usage