C_THR92_2311 무료 덤프문제 온라인 액세스

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.Distinct Count
• C.Max
• D.Sum

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.Configure a table restriction of the Compensation table.
• B.Configure a table restriction of the Global Job Information table.
• C.Change the table join to the Compensation table to an inner join.
• D.Duplicate the Compensation table.

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.

• A.Select the chart on the canvas, view the action menu, and choose Export.
• B.Select the chart on the canvas, view the bookmark menu and choose Bookmark Current State.
• C.View the chart in explorer mode, view the action menu, and choose Export.
• D.View the chart in explorer mode and choose + New View to create an explorer view.

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 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.
• B.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.
• 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 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.

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

• A.Date Options
• B.Aggregated Calculated Columns
• C.Runtime Filters
• D.Calculated Columns