Online Access Free C-THR92-2005 Practice Test

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?

• A.Group Columns
• B.Show Total Row
• C.Sum Function
• D.Column Style Settings

You create a query using the Basic User Information table. After you add the Proxy Information table, you notice that some of the basic information records are NO longer displayed in the preview.
How do you adjust the query to return the missing records in the preview?

• A.Change the join type to Left Outer Join.
• B.Change the join type to Inner Join.
• C.Remove the related table and add it using the Show Related Tables command form the Action Menu.
• D.Remove the related table and select and drag it from the Available Data section.

When you format a list report component, which actions can you perform?
Note: There are 3 correct answers to this question.

• A.Save formats to a template.
• B.Change column types.
• C.Change the order of columns.
• D.Adjust column widths.
• E.Change column headers.

You want to create a report that returns only employees who were born in 1961. You also want to enable 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.

• A.1. Select Date Options from the Toolbar.
  2. Set Date Type to Date Range (On Start Date).
  3. Set From date to 1/1/1961 and To date to 12/31/1961.
  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/1/1961.
  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/1/1961.
  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 12/31/1961.
  9. Select OK.

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

• A.Concatenate
• B.Max
• C.Sum
• D.Distinct Count