DP-300 · Question #268
Drag and Drop Question You have an Azure SQL database named DB1. You need to create a partitioned table in DB1. Which three objects should you create in sequence? To answer, move the appropriate objec
The correct answer is a partition function; a partition scheme; a table. Creating a partitioned table in Azure SQL Database requires three steps in sequence: first, create a partition function which defines how rows are mapped to partitions based on a column's values; second, create a partition scheme which maps the partition function's partitions to
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- a partition function
- a partition scheme
- a table
Explanation
Creating a partitioned table in Azure SQL Database requires three steps in sequence: first, create a partition function which defines how rows are mapped to partitions based on a column's values; second, create a partition scheme which maps the partition function's partitions to filegroups (or PRIMARY in Azure SQL); and third, create the table using that partition scheme to physically organize the data. This sequence is mandatory because each object depends on the previous one - the scheme references the function, and the table references the scheme.
Topics
Community Discussion
No community discussion yet for this question.