Exam DP-600 topic 1 question 99 discussion

Actual exam question from Microsoft's DP-600

Question #: 99
Topic #: 1

HOTSPOT
-

You have a Fabric warehouse that contains a table named Sales.Orders. Sales.Orders contains the following columns.

You need to write a T-SQL query that will return the following columns.

How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

Show Suggested Answer

Suggested Answer:

by clux at April 7, 2024, 3:59 p.m.

Comments

Submit Cancel

stilferx

Highly Voted 1 year, 1 month ago

IMHO, datetrunc & weekday https://learn.microsoft.com/en-us/sql/t-sql/functions/datetrunc-transact-sql?view=sql-server-ver16 https://learn.microsoft.com/en-us/sql/t-sql/functions/datename-transact-sql?view=sql-server-ver16

upvoted 19 times

...

e0f0ce6

Highly Voted 1 year, 1 month ago

Just echecked it. Date trunc returns the first date of the month and datepart just the month number. So given answer is correct.

upvoted 10 times

...

zvezdan

Most Recent 8 months, 3 weeks ago

Note: The weekday, timezoneoffset, and nanosecond T-SQL dateparts aren't supported for DATETRUNC. https://learn.microsoft.com/en-us/sql/t-sql/functions/datetrunc-transact-sql?view=sql-server-ver16

upvoted 1 times

...