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 161 discussion

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

HOTSPOT
-

You have the following T-SQL statement.



For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by nzin at Jan. 21, 2025, 9:06 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
nzin
Highly Voted 3 months, 2 weeks ago
i think No,Yes,No. Region column is not in the where clause
upvoted 12 times
JuanGonzalezT
3 weeks, 2 days ago
it always returns a value, 0 when refunded, but always a value Yes, Yes, No
upvoted 2 times
...
AngryJack
3 months ago
The 1st question is, will Region values still returned even though they have RefundStatus value of "Refunded". The answer is yes, Regions will still get returned.
upvoted 8 times
...
...
Pegooli
Most Recent 5 days, 11 hours ago
The answer is NO, Yes, NO The statement return sales items that is refunded. if status is refunded then return zero - NO The statement return transaction dates that created this year - Yes The TotalRevenue is aggregation of sales items that are Refunded - NO
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago