PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_DB that has a
table named CK_Tbl that is partitioned on the ProID column.
The partitioning characteristics are as follows:

Partition 1 has integer values between 5 and smaller than 30,000.
Partition 2 has integer values greater than 30,000.

Due to the growth in business operations the Domain.com management foresees the need to
have a third partition in the table. You receive instructions to create a third partition on the table.
This partition must be able to include the integer values greater than 60,000.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider adjusting existing partition function through utilizing a Split clause.

B.
You should consider adjusting existing partition function through utilizing a Merge clause.

C.
You should consider adjusting existing partition scheme.

D.
D. You should consider developing a new partition function.


Leave a Reply