Exam DP-300 topic 1 question 59 discussion

Actual exam question from Microsoft's DP-300

Question #: 59
Topic #: 1

DRAG DROP
-

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.

Show Suggested Answer

Suggested Answer:

by vcloudpmp at July 14, 2023, 1 a.m.

Comments

Submit Cancel

IchiruTake

Highly Voted 1 year, 11 months ago

A partition function A partition scheme A table

upvoted 21 times

...

jerrychan

Highly Voted 1 year, 9 months ago

Reference: https://learn.microsoft.com/en-us/sql/relational-databases/partitions/create-partitioned-tables-and-indexes?view=sql-server-ver16 Obviously, the answer is: A partition function => A partition scheme => A table

upvoted 5 times

...

nova24

Most Recent 8 months ago

Partition Function: Define how the data will be partitioned based on values. Partition Scheme: Map partitions to filegroups for storage. Partitioned Table: Create the table using the partition scheme.

upvoted 1 times

...

Dalamain

1 year, 2 months ago

Last option needs correcting, it should be "table" - the question clearly states "create a partitioned table".

upvoted 1 times

...

bsk1983

1 year, 9 months ago

A partition function A partition scheme A table. I think you need to have partioned table created before creating an aligned index. As its Azure sql database, it DOESNOT support multiple filegroup's. I believe above is the correct sequence

upvoted 3 times

...