最新的 Reporting and Analytics Workday-Prism-Analytics 免費考試真題:

1. You are asked to produce a Prism data source, which is going to be used in a matrix report that should display the minimum, maximum, total, average, and the median purchase order amount by location and month. What should you do to achieve the desired result?

A) Add a Group By stage to your derived dataset.
B) Publish your detail data and build the summarizations in the matrix report.
C) Publish your detail data and build the summarizations in the advanced report.
D) Add two Group By stages to your derived dataset.

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

A) To hide Prism-calculated fields used for interim processing.
B) To use computed values instead of base values.
C) To hide unpopulated or sparse data fields.
D) To protect sensitive data.

3. You have two tables. One with employee data from Workday and another with learner data from an external system. Both tables have an Employee ID field.
In the Employee Data TBL, Employee ID is text.

In the Learner Data TBL, Employee ID is numeric.

How can you prepare to join these tables, without the potential loss of data?

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.
B) Change the field type of Employee ID directly on the Employee Data TBL from text to numeric.
C) Import the Learner Data TBL into a DDS and change the field type of Employee ID from numeric to text using a Manage Fields stage.
D) Change the field type of Employee ID directly on the Learner Data TBL from Numeric to Text.

4. While viewing your lineage, you realize you have forgotten to add a description to some of your derived datasets. From the lineage, you double-click on a dataset to view the dataset details. What is the next step to add the missing descriptions?

A) Select the pencil icon next to the Import stage to update the description.
B) Select Add Field from the dataset details to create a description.
C) Select Related Actions next to the dataset name and Edit Transformations.
D) Select the pencil icon next to the dataset name and Edit Transformations.

5. What window function returns the number of rows within a window?

A) AVG
B) COUNT
C) MAX
D) SUM

問題與答案：