C_THR92_2311 by SAP Actual Free Exam Q&As

Question 1

You want to create a query that includes information about an employee's current job, as well as information such as name and date of birth.
How do you do this?
Note: There are 2 correct answers to this question.

A. 1. Select Employment from the Category drop down.
2. Expand the Global Job Information table.
3. Select the applicable job-related fields from Global Job Information.
4. Navigate to and expand the Person Category from within the Employment category.
5. Expand the Personal Information table.
6. Select the applicable personal fields from the Personal Information table. B. 1. Select Person from the Category drop down.
2. Expand the Personal Information table.
3. Select the applicable personal fields from the Personal Information table.
4. Navigate to and expand the Employment Category from within Person category.
5. Expand the Global Job Information table.
6. Select the applicable job-related fields from the Global Job Information table. C. 1. Select User from the Category drop down.
2. Expand the Employee Information table.
3. Select the applicable personal fields from the Employee Information table.
4. Navigate to the Employment category from within User and expand.
5. Expand the Global Job Information table.
6. Select the applicable job-related fields from the Global Job Information table. D. 1. Select Employment from the Category drop down.
2. Expand the Global Job Information table.
3. Select the applicable job-related fields from Global Job Information.
4. Navigate to and expand the User Category from within the Employment category.
5. Expand the Employee Information table.
6. Select the applicable personal fields from the Employee Information table.

Discussion 0

Correct Answer: B,D Vote an answer

Question 2

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

Discussion 0

Correct Answer: C,D Vote an answer

Question 3

What is the first step to make Ad Hoc reporting available for a customer?

A. Enable Table reports by assigning Role Based Permissions. B. Enable Table reports in Admin Center-> Reporting & Analytics. C. Enable Table reports in Admin Center-> Upgrade Center. D. Enable Ad Hoc report builder and domain schemas in Provisioning.

Discussion 0

Correct Answer: D Vote an answer

Question 4

You transferred a report to another instance.
Where can you start the validation of this report?
Note: There are 2 correct answers to this question.

A. Admin Center -> Report - Canvas Validation B. Report Distributor -> Validate C. Report Center -> Edit the Report D. Admin Center -> Manage Report Center

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

What provisioning setting must you enable to allow customers to upload a custom BIRT template to a Table Report?

A. Allow Bl Publisher template upload. B. Enable Visual Publisher. C. Additional Adhoc Sub domain Schemas Configuration. D. Enable Bl Publisher to BIRT Template Converter.

Discussion 0

Correct Answer: B Vote an answer

Question 6

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.

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.

Discussion 0

Correct Answer: A,D Vote an answer

Question 7

How can you give users permissions to see a tile?

A. 1. Go to Admin Center.
2. Select User Privileges.
3. Select Role.
4. Enable Analytics Tiles and Dashboards. B. 1. Go to Admin Center.
2. Select Manage Permission Roles.
3. Select Role.
4. Click Permission.
5. Go to User Privileges -> Reports Permissions.
6. Enable Analytics Tiles and Dashboards. C. 1. Go to Admin Center.
2. Go to User Privileges -> Report Permissions.
3. Click Permissions.
4. Select Role.
5. Select Manage Permission Roles.
6. Enable Analytics Tiles and Dashboards. D. 1. Go to Admin Center.
2. Select Role.
3. Click Permission.
4. Go to User Privileges -> Reports Permissions.
5. Enable Analytics Tiles and Dashboards.

Discussion 0

Correct Answer: B Vote an answer

Question 8

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 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. D. 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.

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

You are creating a query that lists employee information such as name, address, and dependent information.
The query uses Personal Information as the driving table and joins the Dependents and Address tables. You notice many employees are missing from the result set.

What are the reasons?

A. Personal Information is joined to both the Dependents table and the Address table with a left join. B. Personal Information is joined to Dependents table with a left join and the Dependents table is joined to the Address table with a left join. C. Personal Information is joined to both the Dependents table and the Address table with an inner join. D. Personal Information is joined to Address table with a left join and the Address table is joined to the Dependents table with a left join.

Discussion 0

Correct Answer: C Vote an answer

SAP Certified Application Associate - SAP SuccessFactors People Analytics: Reporting 2H/2023 - C_THR92_2311 Exam Practice Test