Question 23 of 240 from exam DP-203: Data Engineering on Microsoft Azure

Question 23 of 240 from exam DP-203: Data Engineering on Microsoft Azure

Question

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.

CREATE TABLE [dbo].[FactonlineSales]

(

[Productkey] int NOT NULL
»  [OrderDatekey] int NOT NULL
»  [Customerkey] int NOT NULL
»  [Promotionkey] int NOT NULL
»  [SalesOrderNumber] nvarchar(20) NOT NULL
»  [OrderQuantity] smallint NOT NULL
»  [UnitPrice] money NOT NULL
»  [SalesAmount] money NOT NULL
)
WITH
(CLUSTERED COLUMNSTORE INDEX

HASH([ProductkKey])

(| [OrderDateKey] RANGE RIGHT FOR VALUES
(20000101, 20010101, 20020101

20030101, 20040101 , 20050101

)

Complete the statement by filling the blanks with the right words.

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Correct Answer: A

DISTRIBUTION = HASH ( distribution_column_name )is the distribution method that assigns every row to one distribution by hashingthe 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.

References:

To know more about partitioning the tables, please visit the below-given link: