QUESTION: 73

Which of the following steps is not required to partition an existing table onto multiple devices without affecting other data?

Create the clustered index
Create a device on one segment using sp_addsegment
Place the table on the segment using sp_placeobject
Extend the segment using sp_extendsegment
Partition the table using alter table command
Drop the segment from the database using sp_dropsegment

Answer(s): A,F

Reveal Solution Next Question

QUESTION: 74

When configuring the "additional network memory" parameter, the number of buffers required per connection must be taken into consideration. How many buffers does each connection require?

1
2
3
4
5

Answer(s): C

Reveal Solution Next Question

QUESTION: 75

Which of the following can be used to balance a partitioned table? (Choose all that apply)

optdiag
bcp
reorg rebuild
dbcc checktable

Answer(s): B,C

Reveal Solution Next Question

QUESTION: 76

Which of the following methods can reduce the partition skew for a given table?
(Choose all that apply.)

Execute sp_helpartition tablename
Increase the configured value of disk i/o structures
Alter the table to add more partitions
Create a clustered index on the table (or if one exists, drop and recreate it)
For a heap table, bulk copy data out, truncate table, bulk copy data in

Answer(s): D,E

Reveal Solution Next Question

Free 510-020 Exam Braindumps (page: 20)

QUESTION: 73

QUESTION: 74

QUESTION: 75

QUESTION: 76

510-020 Exam Discussions & Posts