Online Access Free 070-447 Practice Test

A most proper archiving strategy for the SalesData.Orders table in the Sales database should be identified. The archiving strategy should be implemented with the least amount of effect on performance. Which action should be performed?

• A.First, a table named ArchivedData.Orders should be created. Second, an INSERT statement will be utilized to copy data from the SalesData.Orders table into ArchivedData.Orders every three months. At last a DELETE statement should be utilized to remove archived data from SalesData.Orders.
• B.First, the Sales database should be backed up to tape every three months, and then a DELETE statement should be utilized to migrate archived data from the SalesData.Orders table.
• C.First, a database snapshot of the Sales database should be created every three months, and then a DELETE statement should be utilized to remove archived data from the SalesData.Orders table.
• D.First, a table named ArchivedData.Orders should be created. Second, the SalesData.Orders table and its indexes should be partitioned. At last, MERGE, SPLIT, and SWITCH functions should be utilized every three months to remove old order data into ArchivedData.Orders.

In order to satisfy the security requirements of the company, you are asked to make recommendations for tracking usage on the acct1 database. What should you recommend?

• A.On all sensitive tables, DML triggers should be created.
• B.In SQL Trace, the Security Audit event category in SQL Trace should be set up to track the Audit Database Object Management event class.
• C.In SQL Trace, the Security Audit event category should be set up to track the Audit Schema Object Access event class.
• D.On all sensitive tables, DDL triggers should be created.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. A new stored procedure is created by you. You find an error when running the stored procedure. The company asks you to collect and process any error information that is generated while running the procedure. Error logging must use the least possible resources while providing the needed functionality. You have to find out what caused the error. The appropriate error functions need to be included in the new stored procedure. What action should you perform?

• A.The XACT_ABORT command should be set to off.
• B.TRY...CATCH blocks should be used.
• C.The @@error function should be used.
• D.A GOTO statement should be used.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as the administrator of a SQL Server 2005 computer. An e-mail message should be sent to the company database auditing department, when the SQL Server service and the SQL Server Agent service are started, stopped, or paused. In addition, an e-mail message should be sent to them, when the users utilize the EXECUTE AS option with stored procedures and other commands.
Since you are the administrator, you are required to make sure that the e-mail messages that the auditing department needs should be sent to them. What should you do to finish the task? (Choose more than one.)

• A.To finish the task, SQL Server Profiler should be utilized to track the Audit Statement Permission event class.
• B.To finish the task, a Windows Group Policy Object should be created to audit System Events.
• C.To finish the task, SQL Server Profiler should be utilized to track the Audit Server Principal Impersonation event class.
• D.To finish the task, an Event Notification should be created on the Audit Server Principal Impersonation event class.
• E.To finish the task, an Event Notification should be created on the Audit Server Starts and Stops event class.
• F.To finish the task, SQL Server Profiler should be utilized to track the Audit Server Starts and Stops event class.

DRAG DROP
Drag Drop question

Correct Answer: