EMT Practice Test

1. Question Content...


Question List

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

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

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

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

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

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

Question7: If you want to create a single filter that utilizes criteria from multiple tables in the same query, which filter do you need to use?

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

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

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

Question10: You want to create a report that shows one row per employee, that includes the total number of previous employers for each employee.
Which tool must you use?

Question11: Which tool can you use to create tiles offline?

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

Question13: You are creating a query that lists employee information such as name, address, and dependent information. The query uses Personal Information as the driving table and joins the Dependents and Address tables. You notice many employees are missing from the result set.

What are the reasons?

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

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

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

Question17: You create a report page and want to change the grid column width and grid row height. Where can you do this?

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

Question19: In a canvas report, to which of the following can you export multipage reports in a single transaction?
Note: There are 3 correct answers to this question.

Question20: A report shows one row for each language an employee speaks. The employee information "First name" 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?

Question21: Which are valid destinations of a scheduled Report Distributor bundle?

Note: There are 3 correct answers to this question.

Question22: When using Report Center, what permissions are required to create a canvas report on Employee Profile data using the Detailed Reporting tool?
Note: There are 3 correct answers to this question.

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

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

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

Question26: While constructing a dashboard, you find 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?

Question27: When you create a table report with filter groups, what is the logical relationship between filter groups?

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

Question29: 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 schem a. 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?