You administer a SQL Server 2008 instance. A payroll application is used to store sensitive data in a database named PayrollDB.
You plan to implement the following security measure:
- All the data files, log files, and backup files of the database are automatically encrypted.
You need to devise a method to encrypt data. What should you include in your solution?

• A. Use a symmetric key provisioned through Extensible Key Management (EKM).
• B. Use cell-level encryption to protect sensitive data.
• C. Use Transparent Data Encryption (TDE) for the PayrollDB database.
• D. Use a certificate to protect the data encryption key. Export the certificate to a file.

You configure a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database experiences deadlock problems.
You need to capture the deadlock information to the SQL Server error log.
What should you do?

• A. Configure a SQL Profiler trace to capture the deadlock graphs.
• B. Configure the data collector to capture the deadlock graphs.
• C. Enable Server Auditing for the AdventureWorks database.
• D. Set the appropriate trace flags as a startup parameter and restart the SQL Server instance.

You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 stores customer data for the company. The customers use a Web application to access their profile data. You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. Your solution must not affect the Web application or impact performance.
What should you do?

• A. Configure access to DB1 to only use stored procedures and functions.
• B. Enable Transparent Database Encryption for DB1 and then back up the transaction logs.
• C. Encrypt the customer data at the cell level and then back up DB1.
• D. Encrypt the customer data at the folder level by using Encrypted File System (EFS) and then back up the transaction logs.

You are mastering the company database; there are 15 retail stores in your company. On its own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a database table called Saling. The Saling table also includes sales information from other stores to enable customer returns to any of the 15 retail stores. You could refresh the data in the main office to every retail store every hour. You should use trigger called trg_Coupon to produce sales coupons based on customer sales and buying patterns. Through using the fewest number of steps, you should set replication between the server in every retail store and a middle server in the mainoffice. in real time. You should not have the Replication. Which is the correct answer?

• A. Snapshot replication should be utilized. You should set the trg_Coupon trigger on the server in every store to utilize the NOT FOR REPLICATION option.
• B. You should utilize transactions log between the server in each retail store and the central server in the main office.
• C. You should utilize merge replication. You should set the trg_Coupon trigger on the server in each retail store to use the NOT FOR REPLICATION option.
• D. You should build multiple merge publications, one at every store and one in the main office.

You administer a SQL Server 2008 instance.
A user named Julie reports repeated failed connections because of incorrect password usage for the login name srpc8521. Julie has been able to successfully login using this account in the past. Julie then recalls the correct password. However, her connection is still denied.
You need to enable the SQL Server login.
Which Transact-SQL statement should you use?

• A. ALTER LOGIN srpc8521 WITH CHECK_EXPIRATION = OFF;
• B. ALTER LOGIN srpc8521 ENABLE;
• C. ALTER LOGIN srpc8521 UNLOCK;
• D. ALTER LOGIN srpc8521 WITH NO CREDENTIAL;