Exam DP-600 topic 1 question 174 discussion

Actual exam question from Microsoft's DP-600

Question #: 174
Topic #: 1

HOTSPOT
-

You have a Fabric warehouse that contains a table named Table1. Table1 contains the following data.

You need to create a T-SQL statement that meets the following requirements:

• Outputs the item name of each item and returns a null value if the item name is longer than 20 characters
• Outputs the PurchaseDate value in the format of МММ dd, yy

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

NOTE: Each correct selection is worth one point.