Q18. 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?

Q19. 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?

Q20. 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?

Q21. A recruiter is running a dashboard and no data is appearing in the Top New Applications by Job Profile worklet tile.
What could be the cause of the issue?

Q22. 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?

Q23. An HR analyst has many visualizations in different discovery boards that use the Workers for HCM Reporting data source on the Worker primary business object. The analyst wants to drill into one of the visualizations by Worker. Upon drilling, the analyst notices that Worker is not a listed Drill By field option. They want to drill by Worker without editing the Drill By list of the other visualizations.
How would the analyst configure this?

Q24. A compensation analyst would like a report that includes an Expected Deadline field that returns a date 60 days after the Bonus Approval Date field.

Q25. 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?

Q26. 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?

Q27. A report writer needs to create a report and wants to ensure they are using a data source that provides optimized performance on large volumes of data they will generate.
What type of data source should the report writer use for the required data set?

Q28. A compensation analyst wants to provide C-level executives with a readable and easily accessible display of annual average base pay for workers by region.
What would be an effective option for this case?

Q29. 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.
Where do you make this change?

Q30. You need a calculated field that returns whether or not the initiator for a Manage Goals event is the worker’s manager.

Q31. 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?

Q32. The benefits manager position has recently been filled by a different worker. The previous benefits manager has transferred ownership of the report schedules to the new manager. Month end is coming up and the new manager is wondering which reports are scheduled to be run automatically.
Where can the manager view this information?

Q33. 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?

Q34. 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?

Q35. 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?

Q36. 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?

Q37. You need to create a matrix report that evaluates the effectiveness of recruiters on each region.
How can you ensure the report displays the percentage of hires for each recruiter in relation to all recruiters and regions?

Q38. A customer was receiving a report on a weekly basis but has not received it since the new year started.
What task should you use to confirm the report frequency?

Q39. You are building a report to identify employees who have exceeded the allowed number of 10 sick days in the current year.
Using the Sick Days Taken field, what is the correct formula to create a Boolean calculated field that returns True if an employee has exceeded the allowed number of sick days?

Q40. How can you view the latest content housed in WDSetup?