DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ66

VerifiedSecure, optimize, and deploy database solutions

You have an Azure SQL database that contains a table named Table1. Table1 has 25,000,000 rows and a datetime2 column named DateKey. Its data spans the years 2020 through 2021.

You need to partition the data in Table1 by year. The solution must minimize the time needed to rebuild or reindex the table.

How should you complete the Transact-SQL code?

Select
CREATE PARTITION FUNCTION PartitionByYear (datetime2)
AS 
FOR VALUES ();
Explanation

A partition function with RANGE RIGHT places each boundary value in the partition to its right. Boundaries at 2020-01-01 and 2021-01-01 therefore isolate the 2020 and 2021 data into separate yearly partitions. Partition-level index rebuild or reorganization can then target only the required yearly partition, avoiding maintenance of all 25,000,000 rows.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!