Question 1

You want to create a report that returns only employees who were born in 1961. You also want toenable the person who runs the report to specify a different birth year.How can you achieve this?Note: There are 2 correct answers to this question.

Options :

A : 1. Select Date Options from the Toolbar.2. Set Date Type to Date Range (On Start Date).3. Set From date to 1 and To date to 121.4. Set Use Custom Columns.5. Select Date of Birth from Start Date Column.6. Set Selectable At Runtime.

B : 1. Select Date Options from the Toolbar.2. Set Date Type to As of Date.3. Set As of Date to 1.4. Set Use Custom Columns.5. Select Date of Birth from Start Date Column.6. Select Date of Birth from End Date Column.7. Set Selectable At Runtime.

C : 1. Select Date Options from the Toolbar.2. Set Date Type to Show All.3. Select Manage Run Time Filters from the Toolbar.4. Expand Personal Information table.5. Select Date of Birth column.6. Select OK.

D : 1. Select Manage Query Filters.2. Expand Personal Information table and select Date of Birth.3. Select Greater than or equal to from the operator list.4. Set Custom filter date to 1.5. Select OK and then select Add.6. Expand Personal Information table and select Date of Birth. 7. Select less than or equal to from the operator list.8. Set Custom filter date to 121.9. Select OK.

Answer: A,D

Question 2

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

Options :

A : Currency fields

B : Date fields

C : Picklist fields

D : Number fields

Answer: B,C

Question 3

You want to create a page in a canvas report that includes a custom image, a user editable titlecentered 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.

Options :

A : 1 custom image component, 2 rich text components

B : 1 custom image component, 1 rich text component

C : 1 custom image component, 1 rich text component, 1 simple text component

D : 1 custom image component, 1 simple text component

Answer: A,C

Question 4

If you want to create a single filter that utilizes area from multiple tables in the same query , which filter do you need to use in Query Designer?

Options :

A : Query scope filter

B : Table Advanced filter

C : Table simple filter

D : Query Advanced filter

Answer: D

Question 5

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.

Options :

A : Data is NOT joined in the query.

B : Report results are shown on a single tab in the output.

C : Data is joined in the query.

D : Report results are shown on separate tabs in the output.

Answer: A,D

Free C_THR92_2505 Mock Exam – Practice Online Confidently

Buying Options: