ExamQuestions.com

Register
Login
Data Engineering on Microsoft Azure (DP-203) Exam Questions

Microsoft

Data Engineering on Microsoft Azure (DP-203)

3 / 240

Question 3:

You have been assigned the task of partitioning the FactOnlineSales table on the OrderDateKey column in the dedicated SQL pool. For this purpose, you decide to use the CREATE TABLE statement. 
image
Complete the statement by filling the blanks with the right words.

Answer options:

A.Distribution and Partition
B.DistributionTable and PartitionTable
C.Distribution and Collate
D.Partition and Distribution