NO.24 The HR administrator is complaining about a report that is running slowly. The report uses the Trended Workers data source and includes a field on the related Worker business object.
How can you improve report performance without altering the report requirements?

NO.25 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?

NO.26 Refer to the following scenario to answer the question below.
You have prepared the following matrix report for a recruiting manager.

The recruiting manager wants the rows to sort by Total Count, rather than Total Average Base Pay.
How can you adjust the report definition to address this requirement?

NO.27 You want the ability to view every summarization in the composite report by Location.
What do you do?

NO.28 You want to create a report that groups all employees by area code. However, the field you are pulling from contains the entire phone number.

NO.29 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?

NO.30 An HR administrator shares a discovery board with a manager and gives the manager Can Edit permissions. The manager is able to open Drive and access the discovery board. However, upon opening the discovery board, the manager notices that there are placeholders for each visualization and the data does not display.
What permission does the manager need to view the data in the visualizations?

NO.31 The Chief Learning Officer wants you to build a report that lists all current learning content and any information you have relating to ratings and popularity.
How should you find the relevant fields and data sources that are available for you to create this report?

NO.32 You are creating a custom report to calculate the monthly bonus for each worker in the sales department. The bonus is calculated as 10% of the total sales for the month. What calculated field function would return the monthly bonus for each worker?

NO.33 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?

NO.34 Refer to the following scenario to answer the question below.
You have prepared the following matrix report for a recruiting manager.

The recruiting manager wants to dynamically refine the output results for various hiring sources and locations.
How can you achieve this?

NO.35 Refer to the following scenario to answer the question below.
You have prepared the following matrix report for a recruiting manager.

The recruiting manager would like to view the top ten hiring sources, rather than just three.
How can you adjust the report definition to address this requirement?

NO.36 You are configuring a data column on a composite report. You would like to map a subreport prompt to a value in a prompt set, but the prompt is not appearing on the Map Sub Report Prompts grid in the column configuration options.
What could be causing this?

NO.37 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?

NO.38 A user needs to view additional data on the delivered Headcount By Job Profile report.
What should you recommend?

NO.39 How can you capture proposed values relating to a business process event on a report?

NO.40 You are building a composite report that uses two subreports with different data sources. You are noticing duplicate prompts when you run your composite report.
How can you resolve this problem?

NO.41 You have created a composite report and are trying to add a matrix report as a subreport. However, when trying to configure a Data column, the matrix report is not available to select in the Sub Report Name field.
What can you check to identify the cause of this issue?

NO.42 A user needs to view additional data on the delivered Headcount By Job Profile report.
What should you recommend?

NO.43 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?

NO.44 You are creating a custom report that displays employee salary amounts. You need to ensure that compensation analysts have the appropriate security permissions to view this information for all employees.
How do you confirm the security group’s access to salary amounts?

NO.45 You transferred ownership of your report to an HR Analyst. Then, you run the Custom Report Exception Audit report, and a critical error appears next to the report you just transferred.
Why could this be?