Free Workday Workday-Prism-Analytics Exam Questions (page: 2)

[Data Prep and Transformation]
When joining datasets, what items must match?

  1. The field types for the Match Row fields.
  2. The number of rows in each dataset.
  3. The level of detail in each dataset.
  4. The field names for the Match Row fields.

Answer(s): A



[Data Prep and Transformation]
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?

  1. Add a Manage Fields stage.
  2. Click on the field name and check the stage statistics.
  3. Create a Prism calculated field.
  4. Join on the Worker ID field.

Answer(s): B



[Data Prep and Transformation]
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 withthe current worker data.
Using current worker data as the primary pipeline, how can the historical worker data points be brought in?

  1. Add a Join stage with a Right Outer Join.
  2. Add a Union stage.
  3. Add a Join stage with a Left Outer Join.
  4. Add a Join stage with an Inner Join.

Answer(s): B



[Integrating Prism with Workday Reports]
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?

  1. At report run time.
  2. At dataset creation time.
  3. At the calculated field creation time.
  4. At time of publishing.

Answer(s): D



[Data Prep and Transformation]
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?

  1. Mark field A as intermediate calculation.
  2. Add a Manage Fields stage to the DDS and hide field A.
  3. Add a Manage Fields stage to the DDS and hide field B.
  4. Delete field A from their DDS and just leave field B.

Answer(s): B



[Datasets and Data Sources]
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?

  1. The table or dataset where the calculated field was created.
  2. The View Dataset Lineage report.
  3. Any table in the lineage.
  4. Any dataset in the lineage.

Answer(s): B



[Data Prep and Transformation]
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?

  1. Schema
  2. Source
  3. Naming convention
  4. Size

Answer(s): A



[Publishing and Visualizing Data]
You have published a derived dataset to build a Prism data source. For reports using this Prism data source, when is data updated?

  1. At republish of the datasource only.
  2. At reimport into tables and republish of the datasource.
  3. At reimport into tables only.
  4. At report runtime.

Answer(s): B






Post your Comments and Discuss Workday Workday-Prism-Analytics exam prep with other Community members:

Workday-Prism-Analytics Exam Discussions & Posts