Latest Workday Prism Analytics Dumps (V8.02) from DumpsBase: Prepare for Your Exam with Real Workday Prism Analytics Exam Questions

1. When joining datasets, what items must match?

2. 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?

3. A Prism data administrator combined data from multiple sources down to a final derived dataset, including current worker data. There is a new requirement to append historical worker data to the dataset in a uniform layout. The historical worker data includes some, but not all, fields that align with the current worker data.

Using current worker data as the primary pipeline, how can the historical worker data points be brought in?

4. 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?

5. 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?

6. 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?

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

8. You have published a derived dataset to build a Prism data source.

For reports using this Prism data source, when is data updated?

9. 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?

10. 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?

11. A report that uses a Prism data source that you created has a brand new requirement that Expense Partner by Location should only see expense reports for workers for the locations they support.

Given that you have the Location Hierarchy (instance) field in your dataset used for publishing, how can you adjust to meet the requirement?

12. A Prism administrator wants to hide a field that contains employee salary information but still allow the Prism data writers to view average salaries for employees by cost center.

What is the reason for hiding this field?

13. 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?

14. You want to delete a Prism data source, but you are unable to complete the dataset unpublish. You have deleted the Report Writer reports.

What else must you delete, if present?

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?