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, and the computer is called SQL1. There are two databases on the SQL1, and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database, the Staging database is utilized temporarily to store and manipulate data.
Since you are the database administrator, you are required to make sure the points listed below.
First, the tables should not be removed from the Staging database.
Second, any attempts to have tables migrated should be logged.
Third, your solution should not impact on other databases.
Which action should be performed to achieve the goal?

• A. To achieve the goal, a DDL trigger should be created, and the ON ALL SERVER
  parameter is utilized by the DDL trigger.
• B. To achieve the goal, an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.
• C. To achieve the goal, a DML trigger on each table should be created to prevent deletion of data.
• D. To achieve the goal, a DDL trigger should be created, and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.

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 a SQL Server 2005 computer named SQL01. There are five databases in the company. All of them run on a single SQL Server 2005 instance. In order to minimize the amount of time required and the amount of space used in the user databases when creating and rebuilding indexes, all indexes are created with the use of the SORT_IN_TEMPDB option. You are asked to design the tempdb database for optimal performance. What action should you perform?

• A. The tempdb database needs to be placed on a different RAID-0 volume from the user databases.
• B. The tempdb database needs to be placed on a different RAID-5 volume from the user databases.
• C. The tempdb database needs to be placed on the same RAID-0 volume as the user databases.
• D. The tempdb database needs to be placed on the same RAID-5 volume as the user databases.

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 Server Principal Impersonation event class.
• B. To finish the task, SQL Server Profiler should be utilized to track the Audit Statement Permission event class.
• C. To finish the task, a Windows Group Policy Object should be created to audit System Events.
• 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.

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. There is a SQL Server 2005 database on a server named S1. According to the company requirement, you are configuring this database to use a CLR user-defined type. The CLR user-defined type needs to access a configuration file on a server named S2. You use the default permission set to create a CLR assembly. But the assembly returns a security error is returned by the assembly at the time that the CLR user-defined type is called on S1. You have to correct the problem. So what action should you perform to achieve the goal?

• A. The assembly should be changed to use the EXTERNAL_ACCESS permission set.
• B. The assembly should be changed to use the SAFE permission set.
• C. The assembly should be changed to use the UNCHECKED DATA option.
• D. The assembly should be changed to use the VISIBILITY = ON option.

The code is being reviewed, and the code is utilized to retrieve order data in the ASP.NET Web application. The application should be updated to satisfy the security requirements. Which action should you perform?

• A. An HTTP endpoint that has BATCHES enabled should be created, and the ASP.NET code should be changed to connect to the HTTP endpoint.
• B. A stored procedure should be created to retrieve the order data, and the ASP.NET code should be changed to call the stored procedure by utilizing parameters.
• C. A view should be created to retrieve the order data, and then, the table name should be replaced with the view name in the ASP.NET code.
• D. A SQL Server login that has a complex password should be created, and the ASP.NET code should be changed to connect by utilizing the SQL Server login.