Microsoft
70-459 · Question #107
70-459 Question #107: Real Exam Question with Answer & Explanation
Sign in or unlock 70-459 to reveal the answer and full explanation for question #107. The question stem and answer options stay visible for context.
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
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.