Câu 22: DP-600: Implementing Analytics Solutions Using Microsoft Fabric

HOTSPOT -You have a data warehouse that contains a table named Stage.Customers. Stage. Customers contains all the customer record updates from a customer relationship management (CRM) system. There can be multiple updates per customer. You need to write a T-SQL query that will return the customer ID, name. postal code, and the last updated time of the most recent row for each customer ID. How should you complete the code? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.

1. A. Box 1: ROW_NUMBER() Box 2: X = 1 — đáp án hiện tại
2. B. Box 1: RANK() Box 2: X = 1
3. C. Box 1: ROW_NUMBER() Box 2: X > 1
4. D. Box 1: DENSE_RANK() Box 2: MAX(LastUpdated)