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

Comment: *

Name: *

Email: *

Verification: *

Which actions can you permit the report consumer to perform by your configuration of Interactive widgets?
Note: There are 3 correct answers to this question.

• A.Show/hide labels.
• B.Add/delete widgets.
• C.Switch between edit and view mode.
• D.Adjust filters within controls.
• E.Freeze table rows/columns.

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of the Include Starting From User setting in People Scope?

• A.To include a range of users
• B.To include the user column as the first column
• C.To include the results for the user the report is running for
• D.To include users the report is shared with

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *