PL-300 Question 67

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  * Answer: - 1. Merge Region_Manager and Manager using an inner join Why: Every record in Region_Manager has a corresponding record in Manager. Result: Adds manager details (like name) to the region-manager mapping, keeping only managers linked to a region. - 2. Merge Sales_Region and Region_Manager using an inner join Why: Ensures only regions that have managers remain. Result: Combines region info with its associated manager details. - 3. Merge Sales_Region and Sales_Manager using an inner join Why: Every region has at least one sales manager, but not all sales managers belong to a region. Result: Adds sales manager details to the region-level data, keeping only regions that exist in both tables.

• 1

  1.Merge [Region_Manager] and [Manager] by using an inner join. 6.Merge [Sales_Region] and [Region_Manager] by using an inner join. 3.Merge [Sales_Region] and [Sales_Manager] by using an inner join. should be the answer, As is no relation between 1 -> 3, We can merge the Region_manager from 1 and 6 Similarly, sales_region between 6 and 3

• 1

  The explanations make no sense since this should not be a series of disparate merges - all three must be connected! This makes sense to me, but it is not the answer: 1. Merge Sales_Region and Region_Manager using a one-to-one join 2. Merge the result with Manager using an inner join 3. Merge the result with Sales_Manager using an inner join