ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 11 discussion

Actual exam question from Microsoft's DP-203
Question #: 11
Topic #: 1
[All DP-203 Questions]

DRAG DROP -
You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool.
How should you complete the Transact-SQL statement? 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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: DISTRIBUTION -
Table distribution options include DISTRIBUTION = HASH ( distribution_column_name ), assigns each row to one distribution by hashing the value stored in distribution_column_name.

Box 2: PARTITION -
Table partition options. Syntax:
PARTITION ( partition_column_name RANGE [ LEFT | RIGHT ] FOR VALUES ( [ boundary_value [,...n] ] ))
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse
?
by Sunnyb at June 4, 2021, 3:04 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sasha_in_San_Francisco
Highly Voted 7 months ago
Correct answer by how to remember? Distribution option before the Partition option because… ‘D’ comes before ‘P’ or because the system needs to know the algorithm (hash, round-robin, replicate) before it can start to Partition or segment the data. (seem reasonable?)
upvoted 122 times
...
Sunnyb
Highly Voted 3 years, 10 months ago
Answer is correct
upvoted 67 times
...
krishna1303
Most Recent 2 months, 4 weeks ago
distribution and partition
upvoted 1 times
...
dgerok
1 year ago
Distribution Partition
upvoted 2 times
...
hassexat
1 year, 7 months ago
Distribution & Partition
upvoted 1 times
...
kkk5566
1 year, 7 months ago
correct
upvoted 1 times
...
TestingCRM
1 year, 11 months ago
The answer is correct. Here you can find an example: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition#syntax-differences-from-sql-server
upvoted 3 times
...
vigilante89
2 years, 4 months ago
Answer is: DISTRIBUTION = HASH (id) PARTITION (ID RANGE LEFT FOR VALUES (1, 1000000, 2000000) ) ---------------------------------------------------------- The table option syntax for creating a partitioned table within Dedicated SQL pool: <table_option> ::= { CLUSTERED COLUMNSTORE INDEX -- default for Azure Synapse Analytics } { DISTRIBUTION = HASH ( distribution_column_name ) } | PARTITION ( partition_column_name RANGE [ LEFT | RIGHT ] -- default is LEFT FOR VALUES ( [ boundary_value [,...n] ] ) )
upvoted 5 times
...
Deeksha1234
2 years, 8 months ago
correct
upvoted 2 times
...
gursimran_s
2 years, 10 months ago
Go with a logical explanation guys..what is this D before P..if u take it like that then C comes before D as well.. Try to grasp the logics.. answer is correct.
upvoted 3 times
topggggggg
1 year, 7 months ago
SAVAGE XD
upvoted 1 times
...
...
Dothy
2 years, 11 months ago
Answer is correct
upvoted 1 times
...
Egocentric
3 years ago
provided answer is correct
upvoted 1 times
...
PallaviPatel
3 years, 2 months ago
correct
upvoted 1 times
...
Jaws1990
3 years, 3 months ago
Wouldn't VALUES(1,1000000, 200000) create a partition for records with ID <= 1 which would mean 1 row?
upvoted 1 times
ploer
3 years, 2 months ago
Having three boundaries will lead to four partitions: 1. Partition for values < 1 2. Partition for values from 1 to 999999 3. Partition for values from 1000000 to 199999 4. Partition for values >= 2000000
upvoted 3 times
nastyaaa
3 years, 2 months ago
but only <= and >. it is range left for values, right
upvoted 2 times
...
...
...
Mahesh_mm
3 years, 3 months ago
Answer is correct
upvoted 1 times
...
hugoborda
3 years, 6 months ago
Answer is correct
upvoted 1 times
...
hsetin
3 years, 7 months ago
Indeed! Answer is correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago