Workday Prism Analytics 시험 - Workday실제시험문제와 답 - 50문항

Question No : 1

You have to blend two sources of data. Your matching field is Employee ID, which is a text-type field in Pipeline 1, but is numeric in Pipeline 2.
How do you prepare your data for blending?

A.Add a Manage Fields to change the field type and then Union.
B.Add a Filter first and then a Manage Fields to change the field type.
C.Add first a Manage Fields to change the field type and then Join.
D.Add a Join first and then a Manage Fields to change the field type.

정답:

Question No : 2

You want to delete a Prism data source, but you are unable to complete the dataset unpublish. You have deleted the Report Writer reports.
What else must you delete, if present?

A.Upstream tables
B.Published rows
C.Discovery board visualizations
D.Upstream datasets

정답:

Question No : 3

The Prism use case is to classify workers based on their pay. You must create a field that evaluates worker pay and returns a value that represents various pay ranges.
How would you add this field for inclusion on the Prism data source?

A.Add the additional field to your raw data before you ingest into Prism.
B.Create a derived dataset and build a CASE calculated field to classify workers against their pay.
C.Build a CASE calculated field function on the TBL directly to ease later transformation.
D.Build an Evaluate Expression calculated field on your final Prism business object to evaluate workers against their pay.

정답:

Question No : 4

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 protect sensitive data.
B.To hide Prism-calculated fields used for interim processing.
C.To hide unpopulated or sparse data fields.
D.To use computed values instead of base values.

정답:

Question No : 5

A report that uses a Prism data source that you created has a brand new requirement that Expense Partner by Location should only see expense reports for workers for the locations they support.
Given that you have the Location Hierarchy (instance) field in your dataset used for publishing, how can you adjust to meet the requirement?

A.Run the Edit Data Source Security task to update the Securing Entities and then republish the PD
B.Run the Edit Data Source Security task to update row-level security and then republish the PD
C.Run the Edit Data Source Security task to update row-level security.
D.Run the Edit Data Source Security task to update the Securing Entities.

정답:

Question No : 6

You explode the Language Skills multi-instance field on your derived dataset and you want to change the business object that the new Language Skills Exploded instance field is mapped to.
What steps should you take?

A.Select from the list of suggested BO values in the Explode stage configuration.
B.Click on the Related Actions next to the business object in the insight panel.
C.Add a Manage Fields before the Explode stage and modify the business object.
D.Add a Manage Fields after the Explode stage and modify the business object.

정답:

Question No : 7

You want your derived dataset to only show rows that meet the following criteria: Agent ID is not null AND Location is Dallas OR Location is Montreal.
How can you achieve this?

A.By adding a Manage Fields stage.
B.By using Simple Filter conditions.
C.By using Advanced Filter conditions.
D.By creating a Custom Example.

정답:

Question No : 8

You have published a derived dataset to build a Prism data source.
For reports using this Prism data source, when is data updated?

A.At republish of the datasource only.
B.At reimport into tables and republish of the datasource.
C.At reimport into tables only.
D.At report runtime.

정답:

Question No : 9

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?

A.Schema
B.Source
C.Naming convention
D.Size

정답:

Question No : 10

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?

A.The table or dataset where the calculated field was created.
B.The View Dataset Lineage report.
C.Any table in the lineage.
D.Any dataset in the lineage.

정답:

Question No : 11

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?
A. Mark field A as intermediate calculation.
B. Add a Manage Fields stage to the DDS and hide field A.
C. Add a Manage Fields stage to the DDS and hide field B.
D. Delete field A from their DDS and just leave field B.

정답: B

Question No : 12

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?

A.At report run time.
B.At dataset creation time.
C.At the calculated field creation time.
D.At time of publishing.

정답:

Question No : 13

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 with the current worker data.
Using current worker data as the primary pipeline, how can the historical worker data points be brought in?

A.Add a Join stage with a Right Outer Join.
B.Add a Union stage.
C.Add a Join stage with a Left Outer Join.
D.Add a Join stage with an Inner Join.

정답:

Question No : 14

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.Add a Manage Fields stage.
B.Click on the field name and check the stage statistics.
C.Create a Prism calculated field.
D.Join on the Worker ID field.

정답:

Question No : 15

When joining datasets, what items must match?

A.The field types for the Match Row fields.
B.The number of rows in each dataset.
C.The level of detail in each dataset.
D.The field names for the Match Row fields.

정답:

Workday Workday Prism Analytics 시험