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 a database administrator for your company. There is a Data Transformation Services (DTS) package, and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition (VBScript). The SQL Server 2005 Package Migration Wizard is run by you, but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005.
You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized?

• A. The SQL Server 2000 Data Transformation Services (DTS) package should be wrapped in an Execute DTS 2000 Package task.
• B. The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails, a Transfer SQL Server Objects task should be run.
• C. The SQL Server 2000 Data Transformation Services (DTS) package should be manually recreated as a SQL Server Integration Services (SSIS) package.
• D. The SQL Server 2000 Data Transformation Services (DTS) task should be configured to not utilize precedence constraints. Then, the SQL Server 2005 Package Migration Wizard should be run again.

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. You are in charge of managing 10 SQL Server 2005 computers in the company. Microsoft Windows Server 2003, Enterprise Edition is run by all the ten computers. All Group Policy object (GPO) deployments are handled by Microsoft Active Directory administrators of the company. A security template named SQL05_Security.inf has been deployed by the Active Directory administrators. The template has the appropriate settings to meet the security policy of the company. In order to make sure that the security policy is met, you have to identify the existing configuration of each SQL Server 2005 computer. What action should you perform?

• A. You should analyze the SQL05_Security.inf security template by using the Security Template snap-in.
• B. For the Network Interface performance object, counter logs should be created by using the Performance Logs and Alerts snap-in.
• C. You should find out discrepancies between system settings and database settings by using the Security Configuration and Analysis tool on each SQL Server 2005 computer.
• D. You should capture a detailed report of the types of network traffic on the local network adapter by using Network Monitor on each SQL Server 2005 computer.

According to the company requirement, you have to design the data archiving solution for the CRM database. You must make sure that your solution implements and satisfies the research and auditing requirements by using as little administrative effort as possible. Of the following actions, which should be specified to occur at the end of each month?

• A. You should print a copy of the older CRM data by using SQL Server Reporting Services (SSRS), and keep each report for five years. After printing each report, delete the older data should be deleted from the CRM database after each report is printed.
• B. The CRM data should be exported to a Microsoft Excel spreadsheet and each spreadsheet should be kept for five years. The older data should be deleted from the CRM database after each spreadsheet is created.
• C. In order to guarantee that the older data and the newer data are kept on different table partitions, the CRM database needs to be reorganized.
• D. A full backup of the CRM database should be created and each backup should be kept for five years. After creating each backup, delete the older data should be deleted from the CRM database after each backup is 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 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 that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.
• B. To achieve the goal, a DDL trigger should be created, and the ON ALL SERVER
  parameter is utilized by the DDL trigger.
• C. 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.
• D. To achieve the goal, a DML trigger on each table should be created to prevent deletion of data.

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 SQL Server Integration Services (SSIS) package is created by you. Confidential information is contained in this package. Only two company employees will use this package. The package is stored in the msdb database. You have to make sure that the package can only be executed by the appropriate employees. The company requires that you should use as little administrative effort as possible when you try to achieve this. So what action should you perform?

• A. The package should be configured to use the Encrypt all with password package protection level.
• B. The package should be configured to use the Encrypt all with user key package protection level.
• C. After the package is saved to a file. You should use the Encrypting File System (EFS) to encrypt the file.
• D. The package should be saved to a SQL Server 2005 computer that has an IPSec Secure Server policy applied.