3 Months Free Update
3 Months Free Update
3 Months Free Update
You are building a performance report. In reviewing the Performance Management schema, you notice that the 2019 Performance Review Table is listed in the Available Data section. You begin the query by adding the Basic User Information table from the User schema. You notice that the 2019 Performance Review Table is NO longer listed in the Available Data section.
Why is the 2019 Performance Review table NOT in the list?
How do you configure the Builder to display the table in the screenshot in a story report? Note: There are 3 correct answers to this question. Headcount by Location
You want to create a query that includes information about an employee's current job, as well as information such as name and date of birth.
How do you do this?
Note: There are 2 correct answers to this question.
You are creating a Story report on Job Classifications. You have configured the chart, table, and input control on the canvas as displayed in the screenshot.
How do you set the input control?
Why would you export report definitions?
Note: There are 2 correct answers to this question.
When you share a tile, how can the user view that tile?
Note: There are 3 correct answers to this question.
User A schedules a report in Report Center Scheduler.
What can user A achieve by enabling the Job Completion notification option for a scheduled job in the Report Center Scheduler?
Which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to this question.
You want to create a pie chart of your company's headcount by country. For each slice you want to display the proportion by country and the country name. Which formatting options must you select?
Note: There are 2 correct answers to this question.
In the Advanced Reporting tool, you want to create a query where the results meet the following criteria
• Only show one row per employee,
• Only show the pay components Base Salary and Bonus,
• Show these pay components as individual columns.
You have joined the Global Job Information table with the Compensation table.What else must you do?
Note: There are 2 correct answers to this question.
A user wants to build a pivot chart based on a list report that has a run-time filter.
What must the user do?
You want to create a report that returns only employees who were born in 1961. You also want to enable the person who runs the report to specify a different birth year.
How can you achieve this?
Note: There are 2 correct answers to this question.
User A maintains a canvas report of employee contact information. User A leaves the company. Another report designer, user B, is assigned the responsibility to maintain the report, but
currently CANNOT modify the report.
How do you allow user B to modify only this report?
You want to create a query that shows only the current Job Information data for each employee.
On the Job Information table, which date type configurations can you use?
Note: There are 2 correct answers to this question.
You are using a pivot table in your canvas report but the report does NOT display the most recent data.
What could be the reason?
As a report owner, you want to share a table report with a user.
What must you configure to ensure the user can access data?
Note: There are 2 correct answers to this question.
Which of the following would make it possible for a filter to update multiple charts using linked analysis?
Note: There are 2 correct answers to this question.
You have created a custom MDF object to track company car information. You need to be able to create story reports on the data of the custom MDF object.
What must you do to enable a custom MDF object to be listed in the Available Data section of Query Designer?