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

Comprehensive and Detailed Explanation From Exact Extract:
To import a Workday custom report into the Prism Analytics Data Catalog, specific configurations are required to ensure the report is accessible and usable. According to the official Workday Prism Analytics study path documents, in addition to enabling the report as a web service and enabling it for Prism Analytics, the report must be shared with or owned by the user who is performing the import. This security requirement ensures that only authorized users can access and import the report into the Data Catalog, aligning with Workday's configurable security model. The user must either be the owner of the report or have it shared with them through appropriate security permissions (e.g., via a security group or direct sharing).
The other options are incorrect:
* A. It must be imported via sFTP: Custom reports are imported directly through Workday's web service integration, not via sFTP, which is typically used for file-based data sources.
* B. It must be built as a matrix report: There is no requirement for the report to be a matrix report; Prism Analytics supports various report types, including advanced and simple reports, as long as they are properly configured.
* D. It must be tagged with a Prism Analytics report tag: Tagging is not a mandatory step for importing a report into the Data Catalog, though it may be used for organizational purposes.
Ensuring that the report is shared with or owned by the importing user is a critical step to maintain security and governance during the integration process.
References:
Workday Prism Analytics Study Path Documents, Section: Integrating Prism with Workday Reports, Topic:
Importing Custom Reports into the Data Catalog
Workday Prism Analytics Training Guide, Module: Datasets and Data Sources, Subtopic: Security Requirements for Report Integration

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, an Explode stage is used in a derived dataset to transform a multi-instance field into multiple rows, effectively creating single-instance fields for each instance. According to the official Workday Prism Analytics study path documents, the only field type you can select in the Explode stage is Multi-Instance (option B). A multi-instance field, often sourced from Workday data, contains multiple values for a single record (e.g., a list of certifications for a worker). The Explode stage "explodes" this field into separate rows, one for each instance, while converting the multi-instance fieldinto a single-instance field in the output. For example, if a worker has three certifications in a multi-instance field, the Explode stage would create three rows, each with a single certification value.
The other options are incorrect:
* A. Numeric: Numeric fields are single-instance by nature and cannot be exploded, as they do not contain multiple values.
* C. Single-Instance: Single-instance fields contain one value per record and cannot be used in an Explode stage, which requires a multi-instance field to operate.
* D. Text: While a Text field can be single or multi-instance, the Explode stage specifically requires a Multi-Instance field, not just any Text field.
The requirement for a Multi-Instance field in the Explode stage ensures that the transformation can properly expand the data into multiple rows as intended.
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

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

Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, a matrix report in Workday is designed to display summarized data in a grid format, with built-in capabilities to calculate aggregations like minimum, maximum, total, average, and median. According to the official Workday Prism Analytics study path documents, to produce a Prism data source for a matrix report that needs to display the minimum, maximum, total, average, and median purchase order amount by location and month, you should publish your detail data and build the summarizations in the matrix report (option A).
Publishing the detail data (i.e., the raw purchase order data with fields like location, month, and amount) as a Prism data source allows the matrix report to access the granular data. The matrix report can then apply the required aggregations (MIN, MAX, SUM, AVG, MEDIAN) directly, grouping by location and month as specified in the report configuration. This approach leverages Workday's reporting capabilities, reducing the need for additional transformations in Prism and ensuring flexibility for future reporting needs.
The other options are less efficient:
* B. Add a Group By stage to your derived dataset: A Group By stage in the derived dataset can compute some aggregations (e.g., SUM, AVG), but Prism does not natively support calculating the median in a Group By stage, and it would require multiple stages or calculated fields to compute all metrics, making it less practical than using the matrix report.
* C. Publish your detail data and build the summarizations in the advanced report: While an advanced report can perform some summarizations, it is not as well-suited as a matrix report for displaying multiple aggregations (like median) in a grid format by location and month.
* D. Add two Group By stages to your derived dataset: Using two Group By stages is unnecessary and still does not address the limitation of calculating the median in Prism, making this approach overly complex.
Publishing the detail data and letting the matrix report handle the summarizations is the most efficient and effective way to meet the requirements.
References:
Workday Prism Analytics Study Path Documents, Section: Publishing and Visualizing Data, Topic: Preparing Data for Matrix Reports Workday Prism Analytics Training Guide, Module: Integrating Prism with Workday Reports, Subtopic:
Leveraging Matrix Reports for Aggregations