EMT Practice Test

1. Question Content...


Question List

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

Question2: When you use a column of type text as a measure in a pivot query, which of the following pivot functions are available?
Note: There are 2 correct answers to this question.

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

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

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

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

Question7: What provisioning setting must you enable to allow customers to upload a custom BIRT template to a Table Report?

Question8: What is included in the saved state of a bookmark for a Story report?
Note: There are 3 correct answers to this question.

Question9: You want to create a page in a canvas report that includes a custom image, a user editable title centered underneath the image, and the current date in the top-right corner.
Which combinations of components can you use to accomplish this?
Note: There are 2 correct answers to this question.

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

Question11: An administrator creates a new MDF object for storing 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 has already had their system transitioned to Workforce Analytics on SAP HANA.
How can the administrator quickly make the data available for reporting?

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

Question13: Which tool can you use to upload a report from the test instance to the production instance?
Note: There are 2 correct answers to this question.

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

Question15: The data source used by the two tables only displays current (active) employees.
How would you configure a filter on the table End of Previous Year Headcount by Location to display data accurately?

Note: There are 2 correct answers to this question.

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

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

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

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

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

Question21: When a user builds a query, what is the default People Scope of the query?

Question22: A manager changed jobs and subsequently lost access to a custom tile-based dashboard.
What functionality would an administrator use to restore access?
Note: There are 2 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: 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.

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

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

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

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

Note: There are 3 correct answers to this question.

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