IT Certification Exam Questions & Answers

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

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

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

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

QUESTION 43
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?

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

QUESTION 45
What can you hidefrom query results using the Edit menu of Detailed Reporting?

QUESTION 46
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.

QUESTION 47
How do you configure the Builder to display the table in the screenshot in a story report? Note: There are 3 correct answers to this question. Headcount by Location

QUESTION 48
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 thatall 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.

QUESTION 49
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.

QUESTION 50
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?

QUESTION 51
Which tool can you useto create tiles offline?

QUESTION 52
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?

QUESTION 53
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.

QUESTION 54
You want to create a report that shows onerow per employee, that includes the total number of previous employers for each employee.
Which tool must you use?

QUESTION 55
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.

QUESTION 56
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 Addresstables. You notice many employees are missing from the result set.
What are the reasons?

QUESTION 57
You are creating a calculated column to calculate an employee’s organizational tenure.

Why does the formula in the screenshotresult in an error?

QUESTION 58
You are using a pivot table in your canvas report but the report does NOT display the most recent data.
Whatcould be the reason?

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