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

Comment: *

Name: *

Email: *

Verification: *

You want to create a report thatreturns 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 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.
• B.1. Select Manage Query Filters.
  2. Expand Personal Information table and select Dateof 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.
• C.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.
• D.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.

Comment: *

Name: *

Email: *

Verification: *

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 Address table with a left join and the Address table is joined to the Dependents table with a left join.
• B.Personal Information is joined to both the Dependents table and the Address table with an inner join.
• C.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.
• D.Personal Information is joined to both the Dependents table and the Address table with a left join.

Comment: *

Name: *

Email: *

Verification: *

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.Run Report access to the domain
• B.Create Report access to the domain
• C.Ability to manage Tiles and Dashboards
• D.Access to Insights

Comment: *

Name: *

Email: *

Verification: *

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.Sum Function
• B.Group Columns
• C.Column Style Settings
• D.Show Total Row

Comment: *

Name: *

Email: *

Verification: *