Workday Pro Prism Analytics - Workday-Prism-Analytics 模擬練習
What report can you run to edit and maintain your Prism import and publish schedules?
正解: A
解説: (PassTest メンバーにのみ表示されます)
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?
Using current worker data as the primary pipeline, how can the historical worker data points be brought in?
正解: B
解説: (PassTest メンバーにのみ表示されます)
The final derived dataset in a Prism pipeline is complete and ready to publish. What should be done prior to publishing?
正解: A
解説: (PassTest メンバーにのみ表示されます)
You want to create a Prism calculated field to change the field type to date data using the TO_DATE function.
The field from Workday is numeric data and you will use the Manage Fields stage to prepare the data for use in the function. What will you need to change about the field in the Manage Fields stage?
The field from Workday is numeric data and you will use the Manage Fields stage to prepare the data for use in the function. What will you need to change about the field in the Manage Fields stage?
正解: C
解説: (PassTest メンバーにのみ表示されます)
A Prism data writer has two pipelines of data that need to be joined together:
* The primary pipeline includes point of sale data by sales agent.
* The secondary pipeline includes performance rating by sales agent.
The requirement is to keep all of the point of sale data from the primary pipeline and blend in performance rating data for the agents from the secondary pipeline where it exists. What Join type should be used to blend the data together?
* The primary pipeline includes point of sale data by sales agent.
* The secondary pipeline includes performance rating by sales agent.
The requirement is to keep all of the point of sale data from the primary pipeline and blend in performance rating data for the agents from the secondary pipeline where it exists. What Join type should be used to blend the data together?
正解: B
解説: (PassTest メンバーにのみ表示されます)
What window function returns the number of rows within a window?
正解: B
解説: (PassTest メンバーにのみ表示されます)