Question 1

A report that uses an indexed data source is running slowly for an HR analyst. The report is sorted by the Worker object field. What can you do to improve the sorting performance?

Accepted Answer

B

Explanation: Sorting a report by an object field, such as 'Worker', forces the system to resolve the primary display value for that object on every row before the sort can be executed. This process is resource-intensive and degrades performance. Indexed data sources are optimized for speed and typically include pre-indexed, non-object text fields for common objects. Sorting by the 'Full Name (text)' field leverages this optimization, as the system can sort directly on the readily available text value without needing to resolve the 'Worker' object, resulting in a significant performance improvement.

Question 2

Two people run the same report. One person can view all columns but the other person can only view some columns. Why is the second user missing columns?

Accepted Answer

C

Explanation: Workday's security framework operates at the field level through security domains. When a user runs a report, the system evaluates their security profile against the domains that secure each field (column) in the report definition. If the user does not have the necessary permissions for a specific domain, Workday automatically hides the corresponding column(s) from their report output. Therefore, the discrepancy in visible columns between the two users directly indicates that the second user lacks security access to the domain(s) governing the missing fields.

Question 3

A composite report sorts output based on the last column in ascending order. You want the sort to be based on the second to last column in descending order. How do you make this change?

Accepted Answer

B

Explanation: In Workday composite reports, the primary sort order for the report's output is defined directly on the columns within the report layout. To change which column controls the sort and in what direction, you must edit the specific column's properties. The process involves removing the existing sort from the last column and then editing the second-to-last column to add a new sort with the direction set to "Descending". Therefore, editing the column is the direct and correct method to achieve the desired change in sorting behavior.

Question 4

An HR analyst needs to schedule a collection of diversity reports to the HR director on a monthly basis. What mechanism should the HR analyst use to do this?

Accepted Answer

B

Explanation: Report Groups in Workday are specifically designed to bundle multiple reports together, allowing them to be run or scheduled as a single unit. This mechanism is ideal for scenarios where a collection of related reports, such as a diversity package, needs to be delivered on a recurring basis. The HR analyst can create a report group containing all the required diversity reports and then schedule this group to run monthly, with the output directed to the HR director.

Question 5

You are configuring a matrix report that shows workers' average base pay by job profile. You would
like to add a field to the Detail Data that shows a worker's compensation group, which is data that is
associated with the Job Profile business object.

Accepted Answer

C

Explanation: The Lookup Related Value (LRV) calculated field function is designed to retrieve the value of a field from a related business object. In this scenario, the report's primary business object is likely 'Worker'. The 'Worker' business object has a single-instance field that links to the 'Job Profile' business object. To display the 'Compensation Group' (a field on the 'Job Profile' object) on the report, an LRV calculated field is used to "look up" this value through the established relationship.

Question 6

You are building a report that shows employee performance ratings and their associated
performance review details. The report uses the Performance Review primary business object. Using
a calculated field, what formula should you use to retrieve the employee's job title from the related
Worker business object?

Accepted Answer

B

Explanation: The Lookup Related Value (LRV) calculated field function is used to retrieve a field's value from a related business object. The question requires retrieving the Job Title (located on the Job Profile object, which is related to the Worker object) from a report based on the Performance Review primary business object. Since Performance Review is directly related to the Worker business object, an LRV function is the correct and most direct method to traverse this relationship and pull the desired field into the report.

Question 7

You only want to show snapshot data on a custom trending report that uses the Trended Workers data source. How can you achieve this with minimal impact to report performance?

Accepted Answer

B

Explanation: The Trended Workers data source is designed to capture both point-in-time snapshots and transactional events (e.g., hires, promotions). This data source includes a specific boolean field, typically named Is Snapshot? or Snapshot, to distinguish between these record types. To display only snapshot data, the most efficient and direct method is to add a filter in the report definition where this Snapshot field is equal to "Yes" or "True". This approach filters the data at the source, ensuring that only the relevant records are processed, which is the best practice for minimizing performance impact.

Question 8

Refer to the following scenario to answer the question below. You have prepared the following matrix report for a recruiting manager. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Workday_Workday-Pro-HCM-Reporting/page_11_img_1.jpg The recruiting manager wants to dynamically refine the output results for various hiring sources and locations. How can you achieve this?

Accepted Answer

D

Explanation: Facet filters are designed specifically for the requirement described. They appear as interactive controls on the left-hand side of the report output, allowing the end-user to dynamically filter the report results after it has been run. By configuring facets for the 'Hiring Source' and 'Location' fields, the recruiting manager can click on specific values to instantly refine the data displayed in the matrix report without needing to re-run or edit the report definition. This provides the exact on-demand, dynamic refinement capability requested.

Question 9

You would like to create an advanced report that contains information about employees and their
dependents.
Where can you go to identify the field that links the two business objects, Worker and Dependent?

Accepted Answer

C

Explanation: The Business Object Details report is a fundamental metadata tool in Workday used to understand the structure and relationships of a business object. To find the linking field between two business objects, such as Worker and Dependent, the most direct and comprehensive method is to view the Related Business Objects tab on this report for the primary business object (Worker). This tab explicitly lists all business objects that have a direct relationship, showing the path or field that connects them.

Question 10

You need to create a report to show the trend of worker headcount over time. What is the most appropriate data source for this report?

Accepted Answer

A

Explanation: The Trended Workers data source is specifically designed for historical and point-in-time analysis. Workday populates this data source by taking periodic snapshots (e.g., monthly, quarterly) of worker data. This structure is optimal for creating reports that analyze changes and trends over time, such as headcount fluctuations, without needing to process a large volume of individual transaction records. It is the most efficient and appropriate choice for tracking metrics over a defined period.

Free Workday Workday-Pro-HCM-Reporting Actual Exam Questions