Exam DP-700 topic 2 question 16 discussion

Actual exam question from Microsoft's DP-700

Question #: 16
Topic #: 2

HOTSPOT -
You have a Fabric workspace.
You are debugging a statement and discover the following issues:
Sometimes, the statement fails to return all the expected rows.
The PurchaseDate output column is NOT in the expected format of mmm dd, yy.
You need to resolve the issues. The solution must ensure that the data types of the results are retained. The results can contain blank cells.
How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by 8d6881f at Jan. 30, 2025, 7:48 a.m.

Comments

Submit Cancel

henryphchan

Highly Voted 2 months, 1 week ago

I'm curious how can people memorize the date format code for the exam lol.

upvoted 8 times

...

cuomuqi

Most Recent 1 month, 2 weeks ago

3rd and 1st. SELECT TRY_CAST('abc' AS INT) AS Result; -- Returns NULL (no error) SELECT CONVERT(INT, 'abc') AS Result; -- Throws an error! I think that is the reason for try_cast() in here

upvoted 1 times

...

8d6881f

2 months, 4 weeks ago

As a european I would not know it has to be 7, we never use that format and I do not know (or want to know) all formats by heart..... try_cast: https://learn.microsoft.com/en-us/sql/t-sql/functions/try-cast-transact-sql?view=sql-server-ver16 convert: https://learn.microsoft.com/en-us/sql/t-sql/functions/cast- and-convert-transact-sql?view=sql-server-ver16

upvoted 2 times

8d6881f

2 months, 4 weeks ago

But 7 is a format smaller then 100 so the year-part =yy, so otherwise it would be yyyy

upvoted 1 times

...

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 2 question 16 discussion

Comments

henryphchan

cuomuqi

8d6881f

8d6881f

SY0-701