Question 1

You are creating a calculated column to calculate an employee's organizational tenure.Why does the formula in the screenshot result in an error?

Options :

A : The result of the formula is negative.

B : An incorrect data type has been selected

C : An incorrect dynamic date variable has been used.

D : An "if then else" statement needs to be included.

Answer: C

Question 2

You are building a performance report. In reviewing the Performance Management schema, younotice that the 2019 Performance Review Table is listed in the Available Data section. You begin thequery by adding the Basic User Information table from the User schema. You notice that the 2019 Performance Review Table is NO longer listed in the Available Datasection.Why is the 2019 Performance Review table NOT in the list?

Options :

A : Only related or joined tables appear as available.

B : The table does NOT have a Report Object Configuration Entity record.

C : You do NOT have the data access permission to the schema.

D : You do NOT have RBP permission to the fields of the table.

Answer: A

Question 3

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 4

You want to return the quarter to date event records to count terminations.Which options would you set in the time filter?Note: There are 3 correct answers to this question.

Options :

A : Range Parameters: Period to Date

B : Range Type: dynamic

C : Range Type: fixed

D : Records Returned: Include only records that begin in your defined date range

E : Range period: Actual start/end date of the current quarter

Answer: A,B,D

Question 5

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

Options :

A : Row: Count

B : Table Structure: Aggregated List

C : Column: Count

D : Table Structure: Cross-tab

Answer: A,C,D

Free C_THR92_2505 Mock Exam – Practice Online Confidently

Buying Options: