70-432 Sample Question: 18

Question: 18

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.The AdventureWorks database contains a table named Orders.The Orders table has several indexes and a very large number of rows.The database supports an enterprise Web environment that is constantly used.Thirty percent of the indexes on the Orders table is fragmented.You need to defragment the indexes by ensuring that the effect on database availability is minimized.Which option should you include in the ALTER INDEX statement?

A.Pad index
B.Sort in tempdb
C.Fill factor
D.Online

Answer : D

70-432 Sample Question: 17

Question: 17

You administer a SQL Server 2008 cluster in a high security environment.You plan to configure and use encrypted connections for the clustered virtual SQL Server.You need to install the certificate that will be used for encryption.What should you do?

A.Install the encryption certificate in the SQL Server shared disk.
B.Install the encryption certificate on each individual node.
C.Install the encryption certificate in the cluster quorum drive.
D.Install the encryption certificate in the cluster group.

Answer : B