SAP c-thr92-2505 practice test

SAP Certified Associate - SAP SuccessFactors People Analytics: Reporting

Last exam update: Nov 18 ,2025
Page 1 out of 6. Viewing questions 1-15 out of 80

Question 1

In Query Designer, you are trying to create a conditional expression to relabel a field. You create the
following expression: IF([User#Basic User Information#Gender] = "M" , "Male" : "Female") You
received an error message saying the formula could NOT be computed. Which symbol in your
expression is causing the error?

  • A. "
  • B. #
  • C. :
  • D. ,
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

A table report is shared with a user. That user CANNOT see the table report in the Report Center list.
Which role-based permission has NOT been set correctly for this user?

  • A. Ability to manage Tiles and Dashboards
  • B. Run Report access to the domain
  • C. Create Report access to the domain
  • D. Access to Insights
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

When constructing an expression for a calculated column in Query Designer, which syntax should you
use to enter a date?

  • A. #MM-DD-YYYY#
  • B. #YYYY-MM-DD#
  • C. #DD-MM-YYYY#
  • D. #MMM-DD-YYYY#
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

What happens when you enable inline translation of a Story as it relates to future edits of the Story
report? Note: There are 2 correct answers to this question.

  • A. The source language is chosen from enabled locales on the instance when enabling translation.
  • B. The report can be edited only in the source language.
  • C. The source language is set to the current locale of the individual who enabled translation.
  • D. The report can be edited in any language.
Mark Question:
Answer:

A, B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

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

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

A, C, D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 6

Which are valid destinations of a scheduled Report Distributor bundle? Note; There are 3 correct
answers to this question.

  • A. Home Page
  • B. Notification
  • C. Run Offline
  • D. FTP
  • E. E-Mail
Mark Question:
Answer:

C, D, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 7

How do you configure the Builder to display the chart in the screenshot in a story report?

Note: There are 3 correct answers to this question.

  • A. Set Dimensions to Pay Grade.
  • B. Set Dimensions to Gender.
  • C. Set Color to Gender.
  • D. Set Color to Pay Grade.
  • E. Set Measures to EOP Headcount.
Mark Question:
Answer:

B, C, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 8

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. Report results are shown on separate tabs in the output.
  • B. Report results are shown on a single tab in the output.
  • C. Data is joined in the query.
  • D. Data is NOT joined in the query.
Mark Question:
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

When using Report Center, what permissions are required to create a canvas report on Employee
Profile data using the Detailed Reporting tool? Note: There are 3 correct answers to this question.

  • A. Canvas Designer Admin
  • B. Canvas Designer
  • C. Create Reports: Employee Profile
  • D. Run Report: Employee Profile
  • E. Report Center
Mark Question:
Answer:

B, C, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 10

You want to join two tables, A and B, and you want to include all rows from Table A, and only
matching rows from Table B. Which join type must you use?

  • A. Outer
  • B. Left
  • C. Inner
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
Discussions
vote your answer:
A
B
C
0 / 1000

Question 11

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. View the chart in explorer mode, and choose + New View to create an explorer view.
  • C. Select the chart on the canvas, view the bookmark menu, and choose Bookmark Current State.
  • D. View the chart in explorer mode, view the action menu, and choose Export.
Mark Question:
Answer:

B, C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

What features are available only when you use Business Intelligence and Reporting Tools (BIRT) with
Table Reports? Note: There are 2 correct answers to this question.

  • A. SFTP scheduling
  • B. Simple data extraction
  • C. Printable chart with custom formatting requirements
  • D. Advanced cell level formulas
Mark Question:
Answer:

C, D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

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.
Select Date Options from the Toolbar. Set Date Type to Show All. Select Manage Run Time Filters
from the Toolbar. Expand Personal Information table. Select Date of Birth column. Select OK.

  • A. Select Manage Query Filters. Expand Personal Information table and select Date of Birth. Select Greater than or equal to from the operator list. Set Custom filter date to 1/1/1961.
  • B. Select OK and then select Add. Expand Personal Information table and select Date of Birth. Select less than or equal to from the operator list. Set Custom filter date to 12/31/1961. Select OK.
  • C. Select Date Options from the Toolbar. Set Date Type to Date Range (On Start Date). Set From date to 1/1/1961 and To date to 12/31/1961. Set Use Custom Columns. Select Date of Birth from Start Date Column. Set Selectable At Runtime.
  • D. Select Date Options from the Toolbar. Set Date Type to As of Date. Set As of Date to 1/1/1961. Set Use Custom Columns. Select Date of Birth from Start Date Column. Select Date of Birth from End Date Column. Set Selectable At Runtime.
Mark Question:
Answer:

A, D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

An executive reviews a canvas report on employee compensation. The executive discovers that NOT
all employees are included in the report. You need to adjust the report so that all employees are
included by default, but included employees can be adjusted at runtime. How do you accomplish this
task? Note: There are 2 correct answers to this question.

  • A. Enable User Prompted People Scope.
  • B. Set the People Scope Team Manager to Logged in User and set Team Reporting Type to other filters.
  • C. Set a run-time filter on User Sys ID.
  • D. Set the People Scope Team Manager to CEO and set Team Reporting Type to Team View.
Mark Question:
Answer:

A, B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

Which tool can you use to create tiles offline?

  • A. YouCalc Designer
  • B. Query Workspace
  • C. Advance Reporting
  • D. Detailed Reporting
Mark Question:
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2