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 derived dataset, 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.

Comprehensive and Detailed Explanation From Exact Extract:

In Workday Prism Analytics, calculated fields are defined within datasets, and their expressions dictate the logic used to compute their values. When issues like nil results arise, an administrator needs a centralized view to review and troubleshoot these expressions. According to the official Workday Prism Analytics study path documents, the View Dataset Lineage report is the tool that allows users to review the lineage of datasets, including the expressions of calculated fields, in bulk. This report provides a visual representation of the data lineage, showing the relationships between tables, datasets, and calculated fields, and allows users to drill into the details of each dataset to inspect the expressions of calculated fields across the lineage.

The other options are not as effective for this purpose:

A. The table or dataset where the calculated field was created: While you can review expressions in the specific dataset where a calculated field was created, this approach does not allow for a bulk review across multiple datasets in the lineage.

C. Any table in the lineage: Tables store raw data and do not contain calculated field expressions, which are defined in datasets.

D. Any dataset in the lineage: Reviewing datasets individually does not provide a bulk view of all calculated fields across the lineage, making it less efficient than the View Dataset Lineage report.

The View Dataset Lineage report is the most efficient way to review and troubleshoot calculated field expressions in bulk, enabling the administrator to identify and revise the problematic expressions causing nil results.

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.

Comprehensive and Detailed Explanation From Exact Extract:

In Workday Prism Analytics, a Data Change task is used to load or update data into a table, which can involve importing data from multiple source files. According to the official Workday Prism Analytics study path documents, when loading rows from multiple source files into an empty table, the source files must share the same schema. The schema defines the structure of the data, including the column names, data types, and their order, which ensures that the data from all source files can be consistently mapped and loaded into the target table without errors.

The schema is critical because the Data Change task relies on a predefined table structure to process the incoming data. If the schemas of the source files differ (e.g., different column names or data types), the task will fail due to inconsistencies in data mapping. The other options are not required to be the same:

Source: The source files can originate from different systems or locations (e.g., Workday, external systems, or file uploads) as long as the schema aligns.

Naming convention: The names of the source files do not need to follow a specific convention for the Data Change task to process them.

Size: The size of the source files (e.g., number of rows or file size) can vary, as the task processes the data based on the schema, not the volume.

Thus, the requirement for the source files to have the same schema ensures seamless data loading into the table, maintaining data integrity and consistency during the transformation process.

Comprehensive and Detailed Explanation From Exact Extract:

In Workday Prism Analytics, a published Prism data source (PDS) contains a snapshot of data from a derived dataset at the time of publishing. According to the official Workday Prism Analytics study path documents, for reports using a Prism data source, the data is updated at reimport into tables and republish of the datasource (option B). A derived dataset typically sources data from underlying tables (via import stages), and any updates to the source data require two steps: (1) reimporting the updated data into the tables (e.g., via a Data Change task), and (2) republishing the derived dataset to refresh the Prism data source with the new data. Reports using the PDS will reflect the updated data only after both steps are completed, as the data source is a static snapshot until republished.

The other options are incorrect:

A. At republish of the datasource only: Republishing alone does not update the data if the underlying tables have not been reimported with new data; both steps are necessary.

C. At reimport into tables only: Reimporting into tables updates the source data, but the PDS remains unchanged until the dataset is republished.

D. At report runtime: Reports do not dynamically update the PDS at runtime; they use the data as it exists in the PDS at the time of the last publish.

The combination of reimporting into tables and republishing the data source ensures that reports reflect the most current data.