MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

Review Questions

1. Which of the following would ensure audit capability for physical access to your server? (Choose two.)
   1. A door secured by a key lock
   2. A door secured by a keypad lock
   3. Video monitoring of the data center
   4. A backup generator
2. What type of SQL Server object is most useful in preventing SQL injection attacks?
   1. Stored procedure
   2. Function
   3. SELECT query
   4. INSERT/UPDATE/DELETE queries
3. You are moving your Sales database from ServerA to ServerB. Inside the database are a series of DDL triggers to prevent tables and views from being altered. You want to be sure that these triggers are still enforced on the new server. What is the easiest way to do this?
   1. Move the database using a detach/attach procedure.
   2. Script out the triggers, back up and ...