Microsoft
70-459 · Question #107
You have a table named ORDERS that contains 10,514,003 Orders. The ORDERS table has an IDENTITY (1,1) column named ORDERID. ORDERID is the UNIQUE CLUSTERED INDEX and PRIMARY KEY for the table. The…
The correct answer is A. Option A. See the full explanation below for the reasoning.
Question
You have a table named ORDERS that contains 10,514,003 Orders. The ORDERS table has an IDENTITY (1,1) column named ORDERID. ORDERID is the UNIQUE CLUSTERED INDEX and PRIMARY KEY for the table. The first ORDERID is 1. There are no missing ORDERIDs in the set. Based on table usage patterns, you decide to use partitioning on this table based off of the ORDERID column. You need to create the following partitions: Which code should you use to create the partition function?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(44 responses)- A73% (32)
- B14% (6)
- C5% (2)
- D9% (4)
Community Discussion
No community discussion yet for this question.

