HOTSPOT You have a semantic model named Model1 that contains a table named Table1. Table1 contains three columns named CustomerID, Age, and LoyaltyStatus. You have an order system that tracks the order history of each customer. You need to import the order system data into Model1 and create a single table that combines LoyaltyStatus with the number of orders. The solution must ensure that only customers that have orders are stored in the dataset. How should you create the table, and which join kind should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
