Q41. 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.

Q42. 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?

Q43. 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?

Q44. 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.

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

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

Q47. Which actions can you permit the report consumer to perform by your configuration of Interactive widgets?
Note: There are 3 correct answers to this question.

Q48. When a user builds a query, what is the default People Scope of the query?

Q49. 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?

Q50. 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?

Q51. 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.

Q52. 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?

Q53. 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?

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

Q55. What is the purpose of the Include Starting From User setting in People Scope?

Q56. 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?

Q57. What can you hide from query results using the Edit menu of Detailed Reporting?

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

Q59. 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.

Q60. 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.

Q61. 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.

Q62. 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?

Q63. 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?

Q64. 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.