DP-300 Certification Practice Question #48

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.

Accepted Answer

Creating a partitioned table in Azure SQL Database follows a mandatory dependency chain: first define how data is partitioned with a partition function, then map partitions to storage locations with a partition scheme (which in Azure SQL DB maps to the default PRIMARY filegroup since multiple filegroups are unsupported), and finally create the table referencing the partition scheme. Microsoft Learn's documentation on "Create Partitioned Tables and Indexes" confirms this order. The highly-voted community consensus (IchiruTake 23 👍, jerrychan 5 👍) aligns exactly with this sequence.

More DP-300 practice questions