Microsoft Exam DP-201 Topic 3 Question 2 Discussion

Actual exam question for Microsoft's DP-201 exam

Question #: 2
Topic #: 3

[All DP-201 Questions]

You are designing an Azure SQL Data Warehouse. 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?

ARound-robin distributed table

BHash-distributed table

CReplicated table

DExternal table

Show Suggested Answer

Suggested Answer: A

To achieve the fastest loading speed for moving data into a data warehouse table, load data into a staging table. Define the staging table as a heap and use round-robin for the distribution option.

References:

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/guidance-for-loading-data

by Judy at May 10, 2022, 12:57 AM

Limited Time Offer

25%

Off

Get Premium DP-201 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!