[Data Prep and Transformation]
You are adding a Join stage and choose Join type of Left Outer Join, causing Workday to search for a
matching row in the imported pipeline. What happens if no matching rows exist?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 2
[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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Thank you for your visit.
Q: 3
[Data Prep and Transformation]
You want to convert each instance of a multi-instance field and convert it to a single-instance field.
What transformation stage can you use to do this?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 4
[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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Q: 5
[Security and Governance in Prism]
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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 6
[Data Prep and Transformation]
What is the primary purpose of window functions in Prism?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Q: 7
[Publishing and Visualizing Data]
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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 8
[Data Prep and Transformation]
You created a derived dataset that imports data from a table, which will become your Stage 1. What
can you add to this dataset?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Q: 9
[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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Q: 10
[Data Prep and Transformation]
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?
