DP-300 · Question #268
DP-300 Question #268: Real Exam Question with Answer & 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
Question
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 objects from the list of objects to the answer area and arrange them in the correct order. Answer:
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.