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…

Question

Exhibit

Options

• ADistribution and Partition
• BDistributionTable and PartitionTable
• CDistribution and Collate
• DPartition and Distribution

• A
  74% (32)
• B
  14% (6)
• C
  2% (1)
• D
  9% (4)

Explanation

DISTRIBUTION = HASH ( distribution_column_name ) is the distribution method that assigns every row to one distribution by hashing the value present in distribution_column_name. The right syntax to use partition method is PARTITION ( partition_column_name RANGE [ LEFT | RIGHT ] FOR VALUES ([boundary_value [,...n]])). Option A is correct. Distribution and Partition are the right options to be used to complete the given Create Table statement. Option B is incorrect. The right syntax is to use only Distribution and Partition, not DistributionTable and PartitionTable. Option C is incorrect. The partition should be used instead of Collate. Option D is incorrect. Distribution and Partition are the right options to use. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-partition https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data- warehouse?view=aps-pdw-2016-au7

No community discussion yet for this question.