Exam4Training

Which type of table should you use?

You plan to create a dimension table in Azure Data Warehouse 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.

Which type of table should you use?
A . hash distributed
B . heap
C . replicated
D . round-robin

Answer: C

Explanation: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/design-guidance-for-replicated-tables

Latest DP-200 Dumps Valid Version with 242 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version