Exam DP-600 Topic 1 Question 31 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 31
Topic #: 1
You need to resolve the issue with the pricing group classification.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Suggested Answer:


Explanation:

* You should use CREATE VIEW to make the pricing group logic available for T-SQL queries.
* The CASE statement should be used to determine the pricing group based on the list price.
The T-SQL statement should create a view that classifies products into pricing groups based on the list price.
The CASE statement is the correct conditional logic to assign each product to the appropriate pricing group.
This view will standardize the pricing group logic across different databases and semantic models.

by Lewis at May 09, 2024, 03:03 AM

Limited Time Offer

15%

Off

Get Premium DP-600 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.

Contact Us

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday

Support: Contact now 

日本語 Deutsch 繁体中文 한국어

Useful Links

Latest Updated