BenchMark Quizzes by MDFT Pro

Create Objects For A Partitioned Table In Sequence

You work for MDFT Pro, a well-known training agency with an Azure SQL database named CourseHistory that stores historical student assessment data. Mark, the Table Partitioning Expert, needs to create a partitioned table in CourseHistory to improve query performance and manageability. The table will store millions of assessment records spanning multiple years, and partitioning by date will allow Mark to efficiently query recent data while archiving older partitions. Partitioning will also enable efficient data deletion by dropping old partitions instead of running expensive DELETE operations. Mark needs to understand the correct sequence of database objects that must be created to implement table partitioning in Azure SQL Database.

Which three objects should you create in sequence?

Choose all correct answers from the options below.

Explanations for each answer:

A filegroup is incorrect. Filegroups are not required for partitioned tables in Azure SQL Database, which uses a single filegroup.
A partition function is correct. The partition function must be created first as it defines how rows will be distributed across partitions based on column values.
An aligned index is incorrect. Aligned indexes are created after the table exists, not before creating the partitioned table.
A partition scheme is correct. The partition scheme is created second and maps the partitions defined by the partition function to filegroups (or PRIMARY in Azure SQL Database).
A table is correct. The table is created last, using the partition scheme to distribute data across partitions.

Learn more about Creating Partitioned Tables And Indexes:

Partitioned Tables And Indexes

Practice Exam

Create Objects For A Partitioned Table In Sequence

Discuss this question on social media: