Online Access Free Workday-Prism-Analytics Practice Test

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?

• A.Click on the field name and check the stage statistics.
• B.Join on the Worker ID field.
• C.Add a Manage Fields stage.
• D.Create a Prism calculated field.

A Prism data writer needs to create a new Prism calculated field on a derived dataset using the CASE function. When creating a calculated field, what symbol do you use to view a list of fields that you can select from in the dataset?

• A.{
• B.#
• C.[
• D.(

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?

• A.At the beginning of the primary pipeline of the Base Dataset.
• B.At the beginning of the Primary Pipeline of the derived dataset.
• C.After the dataset is published.
• D.At the end of the Primary Pipeline of a published dataset.

You want to configure access to a published Prism data source to use it in reporting and discovery boards.
What action must you take?

• A.Schedule the recurring publish process.
• B.Share the dataset with appropriate users.
• C.Share the imported Workday report to provide users with access to the published Prism data source.
• D.Edit the data source security and select a domain.

What is the primary purpose of window functions in Prism?

• A.To manipulate strings and dates within a query.
• B.To filter rows based on specified conditions.
• C.To perform calculations across a set of rows related to the current row while partitioning the data.
• D.To provide row-level access control.