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 6 months, 1 week ago
i think No,Yes,No. Region column is not in the where clause
upvoted 16 times
JuanGonzalezT
3 months, 3 weeks ago
it always returns a value, 0 when refunded, but always a value Yes, Yes, No
upvoted 3 times
Sr18
2 months, 2 weeks ago
Region value will be returned no matter the refund status, look at case statement and there are no where clause for region. So "Statement returns Region values when a sales item has a refund status of refunded " : NO It will always return some values no matter the refund or not.
upvoted 1 times
...
...
AngryJack
6 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
...
...
a89bfbf
Most Recent 1 week, 5 days ago
It doesn't "returns" a TransactionDate. It returns PCategory, Region and TRev of Sales of this year.
upvoted 1 times
...
Pegooli
3 months 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 2 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