Exam DP-200 topic 1 question 54 discussion

Actual exam question from Microsoft's DP-200

Question #: 54
Topic #: 1

You are designing an enterprise data warehouse in Azure Synapse Analytics. You plan to load millions of rows of data into the data warehouse each day.
You must ensure that staging tables are optimized for data loading.
You need to design the staging tables.
What type of tables should you recommend?

A. Round-robin distributed table
B. Hash-distributed table
C. Replicated table
D. External table

Show Suggested Answer

Suggested Answer: A 🗳️

by syu31svc at Nov. 26, 2020, 1:59 p.m.

Comments

Submit Cancel

syu31svc

Highly Voted 4 years, 4 months ago

From https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview: Use round-robin for the staging table. The load with CTAS is fast. Once the data is in the staging table, use INSERT...SELECT to move the data to production tables.

upvoted 17 times

memo43

3 years, 11 months ago

keyword is staging table

upvoted 1 times

...

jayeshstudies

Most Recent 3 years, 10 months ago

keyword --> staging table --> round robin is best

upvoted 1 times

...

cadio30

3 years, 11 months ago

round robin is entirely correct for staging tables

upvoted 3 times

...

cjh1912

4 years, 3 months ago

answer is correct its specifically asked for fast loading , not read, which leads to round robin being the correct answer

upvoted 4 times

...

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam