EMT Practice Test

1. Question Content...


Question List

Question1: Which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to thisquestion.

Question2: The drill-down list of a tile contains more entries than the values displayed in a chart (see attached image).

How do you make the outputs match?

Question3: While constructing a dashboard, youfind that you need to create a tile that requires more complex configuration than what is available with the Online Tile Builder tool.
What tool can you use to create this tile?

Question4: You want to join two tables, A and B, and you want to include all rows from Table A, and only matching rows from Table B.
Which join type must you use?

Question5: 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?

Question6: 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?

Question7: Why is it important to consider the People step of the report definition when you share a table report with another user?

Question8: When you format a list reportcomponent, which actions can you perform?
Note: There are 3 correct answers to this question.

Question9: An administrator creates a new MDF object forstoring attachments related to an employees' dependents. After uploading some test data, the administrator states they are unable to report on the new data with Advanced Reporting tool in a canvas report. The administrator is working for a client that hasalready had their system transitioned to Workforce Analytics on SAP HANA.
How can the administrator quickly make the data available for reporting?

Question10: A table report is shared with a user. That user CANNOT see the table report in the Report Center list.
Which role-based permission has NOT been set correctly for this user?

Question11: When you create a table report, in which step can you include inactive users?

Question12: You are using a Multi Dataset table report without Business Intelligence Reporting Tools (BIRT).
What are characteristics of the report output?
Note: There are 2 correct answers to this question.

Question13: You want to create a tile-based dashboard and make it available to users. After you created and named thedashboard, which steps are required?

Question14: Which actions can you perform in a Simple Text component?
Note: There are 3 correct answers to this question.

Question15: 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 belisted in the Available Data section of Query Designer?

Question16: You are using Report Center to share a canvas report. You share the report with a Dynamic Group (see attached image).

Who is the report shared with?

Question17: What functionality can be used in a calculated column? Note: There are 2 correct answers to this question.

Question18: When you share a canvas report, from where can the user access that report?
Note: There are 2 correct answers to this question.

Question19: What can you hidefrom query results using the Edit menu of Detailed Reporting?

Question20: When constructing an expression for a calculated column, which syntax should you use to enter a date?

Question21: User A creates a dashboard with four tiles. When User B accesses the dashboard, onlythree tiles are visible.
Why can User B see only three tiles?

Question22: You transferred a report to another instance.
Where can you start the validation of this report?
Note: There are 2 correct answers to this question.

Question23: 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 thepay 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.

Question24: You want to return the quarterto date event records to count terminations.
Which options would you set in the time filter?
Note: There are 3 correct answers to this question.

Question25: A report shows one row for each language an employee speaks. The employee information "Firstname" and
"Last name" is repeated for each language on each row.
Which format option allows you to display the employee information "First name" and "Last name" only once for each employee?

Question26: You support report consumers. A report consumer asks if it is possible to save the selected items when viewing the detail of a chart ina story report (see screenshot).

How do you tell the report consumer to save the state?
Note: There are 2 correct answers to this question.

Question27: Why would you export report definitions?
Note: There are 2 correct answers to this question.

Question28: You want to create a pie chart of your company's headcount by country. Foreach 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.