which action should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. You have received instructions to ensure
that the entire SQL Server samples are set to comply with specific corporate standards. In
particular index creation should be forced, naming conventions should be implemented and data
fragmentation should be prevented.
Which tool and which action should you take? (Each correct option is part of the answer. Choose
TWO)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. You have received instructions to ensure
that the entire SQL Server samples are set to comply with specific corporate standards. In
particular index creation should be forced, naming conventions should be implemented and data
fragmentation should be prevented.
Which tool and which action should you take? (Each correct option is part of the answer. Choose
TWO)

A.
Use the Package Migration Wizard.

B.
Use the SQL Server Configuration Manager.

C.
Use the ISIS.

D.
Use the Microsoft SQL Server Management Studio.

E.
Use the Process Control Tool.

F.
Use the Web Service Tool.

G.
Use the bulk copy program.

H.
Use the Microsoft SQL Server Import and Export Wizard.

I.
Use the dtexec.exe.

J.
Use the DTS Designer.
K.
Create a configuration package.
L.
Create a policy.
M.
Create a recovery plan.
N.
Create a maintenance plan.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *