A report shows one row for each language an employee speaks. The employee information "Firstname" 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?

Why is it important to consider the People step of the report definition when you share a table report with another user?

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.

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.

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?