EMT Practice Test

1. Question Content...

---

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

Question2: What is the purpose of the Include Starting From User setting in People Scope?

Question3: A report consumer claims that a canvas report shared with them is NO longer available in Report Center. Upon your investigation, you find the report has been deleted. You need to reproduce the report as quickly as possible.
What action do you take?

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

Question5: How do you configure the Builder to display the chart in the screenshot in a story report?

Note: There are 3 correct answers to this question.

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

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

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

Question9: 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.

Question10: 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.

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

Question12: Which permissions should you assign to allow a user to add a new story that will include Career Development Planning data?
Note: There are 2 correct answers to this question.

Question13: An executive reviews a canvas report on employee compensation. The executive discovers that NOT all employees are included in the report. You need to adjust the report so that all employees are included by default, but included employees can be adjusted at runtime.
How do you accomplish this task?
Note: There are 2 correct answers to this question.

Question14: What is the first step to make Ad Hoc reporting available for a customer?

Question15: In the Advanced Reporting tool, you want to create a query that includes the employee's matrix manager.
When you configure the table join with the Job Relationships table, the Results tab displays multiple rows per employee that also include relationships to HR managers and second managers.
How do you configure the query to return one row per employee that shows the employee's matrix manager when assigned?

Question16: 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.

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

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: Which actions can you perform in a Simple Text component?
Note: There are 3 correct answers to this question.

Question20: What features are available only when you use Business Intelligence and Reporting Tools (BIRT) with Table Reports?
Note: There are 2 correct answers to this question.

Question21: You want to build a query for a cross-domain report.
What does the system do with fields that are NOT available for this report?

Question22: You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.
You add the related table Compensation to the query.

When you preview the query, you only get the current compensation information for the employees.
Why do you only receive the current records?
Note: There are 2 correct answers to this question.

Question23: In addition to any chart filter you may have applied to your chart, which other filters may be affecting the chart filter, due to the Cascading effect?
Note: There are 2 correct answers to this question.

Question24: What permission type applied to table reports is defined by a combination of the user's View permissions and Target Population in role-based permissions?

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

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

Question27: How can you give users permissions to see a tile?

Question28: You create a query using the Basic User Information table. After you add the Proxy Information table, you notice that some of the basic information records are NO longer displayed in the preview.
How do you adjust the query to return the missing records in the preview?