You have two Microsoft Power Bl queries named Employee and Retired Roles.

You have two Microsoft Power Bl queries named Employee and Retired Roles.

You need to merge the Employee query with the Retired Roles query. The solution must ensure that rows in the Employee query that match the Retired Roles query are removed.

Which column and Join Kind should you use in Power Query Editor? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point