Microsoft Data Engineering on Microsoft Azure DP-203 Question # 31 Topic 4 Discussion

Microsoft Data Engineering on Microsoft Azure DP-203 Question # 31 Topic 4 Discussion

DP-203 Exam Topic 4 Question 31 Discussion:
Question #: 31
Topic #: 4

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool. You plan to deploy a solution that will analyze sales data and include the following:

• A table named Country that will contain 195 rows

• A table named Sales that will contain 100 million rows

• A query to identify total sales by country and customer from the past 30 days

You need to create the tables. The solution must maximize query performance.

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

NOTE: Each correct selection is worth one point.

DP-203 Question 31


Get Premium DP-203 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.