Workday Prism Analytics Exam Questions Instant Access

Question 1

[Publishing and Visualizing Data]

A custom report uses your recently published Prism data source, but you noticed a minor error in the published dat

a. You need to delete the published rows to fix it. What happens to your custom report?

AThe report definition remains intact and will work after republishing.

BThe report definition will need to be manually recreated.

CThe report definition will be copied and a new version will appear after republishing.

DThe report definition will need to be edited to reflect changes.

Answer : A

Question 2

[Data Prep and Transformation]

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?

AImport the Employee Data TBL into a DDS and change the field type of Employee ID from text to numeric using a Manage Fields stage.

BChange the field type of Employee ID directly on the Employee Data TBL from text to numeric.

CChange the field type of Employee ID directly on the Learner Data TBL from Numeric to Text.

DImport the Learner Data TBL into a DDS and change the field type of Employee ID from numeric to text using a Manage Fields stage.

Answer : D

Question 3

[Datasets and Data Sources]

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?

ASelect the pencil icon next to the dataset name and Edit Transformations.

BSelect the pencil icon next to the Import stage to update the description.

CSelect Related Actions next to the dataset name and Edit Transformations.

DSelect Add Field from the dataset details to create a description.

Answer : C

Question 4

[Integrating Prism with Workday Reports]

You want to import a Workday custom report into the data catalog. You have already enabled it as a web service and enabled it for Prism Analytics. What other configuration is required?

AIt must be imported via sFTP.

BIt must be built as a matrix report.

CIt must be shared with or owned by the user importing the report.

DIt must be tagged with a Prism Analytics report tag.

Answer : C

Question 5

[Security and Governance in Prism]

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?

ATo protect sensitive data.

BTo hide Prism-calculated fields used for interim processing.

CTo hide unpopulated or sparse data fields.

DTo use computed values instead of base values.

Answer : A

Question 6

[Data Prep and Transformation]

You apply an Explode stage to your derived dataset that contains information on your worker benefit elections. What happens in the resulting stage?

AThe number of columns stays the same and the original multi-instance field doesn't get dropped.

BThe number of columns exponentially increases and the original multi-instance field gets dropped.

CThe number of rows stays the same and the original multi-instance field does not get dropped.

DThe number of rows exponentially increases and the original multi-instance field gets dropped.

Answer : D

Question 7

[Data Prep and Transformation]

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

AMAX

BSUM

CCOUNT

DAVG

Answer : C

Workday Pro Prism Analytics Exam Workday Prism Analytics Exam Questions