Online Access Free C-THR92-2205 Practice Test

In a live data query, what are user-prompted filter types?
Note: There are 2 correct answers to this question.

• A.Runtime
• B.Dynamic
• C.Filter Groups
• D.People Scope

You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.
You add the related table Compensation to the query.

When you preview the query, you only get the current compensation information for the employees.
Why do you only receive the current records?
Note: There are 2 correct answers to this question.

• A.The compensation table time filter is set to: As of Date > Dynamic Date: Today.
• B.The Job information table time filter is set to: As of Date > Dynamic Date: Today.
• C.The compensation table time filter is set to: Same Filter as First Table.
• D.The Query Advanced Filter is set to: Job Information effective start date equal to Dynamic Date: Today.

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?

• A.Remove the category assignment field.
• B.Configure a filter to remove the duplicate column.
• C.Remove the column that would generate multiple entries per metric.
• D.Change the metric calculation from Count to Count distinct.

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.

• A.Change the table join to the Compensation table to an inner join.
• B.Configure a table restriction of the Compensation table.
• C.Configure a table restriction of the Global Job Information table.
• D.Duplicate the Compensation table.

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?

• A.Change the Job Relationship join to a left join.
• B.Change the Job Relationship join to a right join.
• C.Change the Job Relationship join to an inner join.
• D.Change the Job Relationship to include a table restriction.