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 66 discussion

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

You plan to create a dimension table in Azure Synapse Analytics that will be less than 1 GB.
You need to create the table to meet the following requirements:
✑ Provide the fastest query time.
✑ Minimize data movement during queries.
Which type of table should you use?

  • A. replicated
  • B. hash distributed
  • C. heap
  • D. round-robin
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by anks84 at Sept. 6, 2022, 3:51 a.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
anks84
Highly Voted 2 years, 9 months ago
Given answer is correct ! Replicated because - Dimension table - Less than 2 GB ( less than 1 GB in this case)
upvoted 11 times
...
allagowf
Highly Voted 2 years, 9 months ago
Selected Answer: A
correct answer
upvoted 5 times
...
samianae
Most Recent 5 months ago
Selected Answer: A
answer correct
upvoted 1 times
...
EmnCours
7 months ago
Selected Answer: A
Correct Answer: A
upvoted 1 times
...
17lan
7 months ago
Selected Answer: A
correct
upvoted 1 times
...
Thameur01
9 months ago
The question is: Which type of table should you use? Actually, it should be Which type of distribution should you use? Table types = Clustered Columnstore, heap, clustered index Distribution types = hash, round robin and replicated
upvoted 1 times
...
rocky48
1 year, 4 months ago
Selected Answer: A
Replicated Table: Caches a full copy of the table on each compute node. While it eliminates data movement during joins or aggregations, it requires extra storage and is not suitable for large tables.
upvoted 2 times
...
hcq31818
1 year, 7 months ago
Selected Answer: A
Replicated
upvoted 2 times
...
kkk5566
1 year, 9 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
Deeksha1234
1 year, 10 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
akhil5432
1 year, 10 months ago
Selected Answer: A
replicated
upvoted 1 times
...
mamahani
2 years, 1 month ago
Selected Answer: A
A is correct answer
upvoted 3 times
...
GodfreyMbizo
2 years, 4 months ago
answer is correct for Dimension tables and less than 2 GB microsoft recommends replicated tables
upvoted 3 times
...
vigilante89
2 years, 6 months ago
Selected Answer: A
Since the dim table is under 1 GB size which is quite small, it should be replicated across all the partitions so that data movement is less and efficiency is more.
upvoted 3 times
...
MEIRONGD
2 years, 6 months ago
correct answer
upvoted 3 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