Exam DP-600 topic 1 question 175 discussion

DRAG DROP
-

You have a Fabric warehouse named Warehouse1 that contains a table named dbo.Product.

dbo.Product contains the following columns.



You need to use a T-SQL query to add a column named PriceRange to dbo.Product. The column must categorize each product based on UnitPrice. The solution must meet the following requirements:

• If UnitPrice is 0, PriceRange is "Not for resale".
• If UnitPrice is less than 50, PriceRange is "Under $50".
• If UnitPrice is between 50 and 250, PriceRange is "Under $250“.
• In all other instances, PriceRange is "$250+".

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Suggested Answer: