ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 11 discussion

Actual exam question from Microsoft's DP-600
Question #: 11
Topic #: 1
[All DP-600 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: Box 1: ROW_NUMBER()
Box 2: WHERE X = 1
by R3D_ENGINEER at Feb. 12, 2024, 3:04 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
R3D_ENGINEER
Highly Voted 1 year, 4 months ago
The correct query is: WITH CUSTOMERBASE AS ( SELECT CustomerID, CustomerName, PostalCode, LastUpdated, ROW_NUMBER() OVER(PARTITION BY CustomerID ORDER BY LastUpdated DESC) as X FROM LakehousePOC.dbo.CustomerChanges ) SELECT CustomerID, CustomerName, PostalCode, LastUpdated FROM CUSTOMERBASE WHERE X = 1
upvoted 37 times
semauni
8 months ago
Thanks, this makes sense. I was already wondering where the X was coming from, it appears part of the syntax is missing in the question.
upvoted 2 times
AdventureChick
6 months, 2 weeks ago
In the CTE, the X = is assigning the alias "X" to the value returned from the ROW_NUMBER statement. It's the same as using "AS X" to assign an alias.
upvoted 1 times
...
...
...
varun_r
Highly Voted 1 year, 3 months ago
Answer is RowNumber and X=1 -- No Brainer
upvoted 15 times
...
rohitrc8521
Most Recent 3 months, 4 weeks ago
calm down guys, the given answer is correct!
upvoted 1 times
...
Rakesh16
7 months, 2 weeks ago
ROW_NUMBER() and where X=1
upvoted 2 times
...
jass007_k
8 months ago
ROW_NUMBER(), WHERE X =1
upvoted 2 times
...
7d97b62
11 months, 2 weeks ago
The answer is correct RowNumber and X=1
upvoted 1 times
...
Darshan6232
1 year ago
Its straight forwarded. Provided answer is correct.
upvoted 1 times
...
stilferx
1 year, 1 month ago
IMHO, 1. Row_Number() 2. x = 1 It is a typical pattern. We are numerating by desc, and then filtering the first one (actually the last because of DESC order)
upvoted 3 times
...
TashaP
1 year, 4 months ago
ROW_NUMBER() + X = 1
upvoted 5 times
...
David_Webb
1 year, 4 months ago
First drop-down box: ROW_NUMBER() Second drop-down box: WHERE X = 1 As ORDER BY LastUpdated DESC was used, the first row will be the most recent row.
upvoted 5 times
...
Momoanwar
1 year, 4 months ago
Row_number X=1 Row_number give row position and start from 1
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel