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. For the Network Interface performance object, counter logs should be created by using the Performance Logs and Alerts snap-in.
• B. 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.
• C. You should analyze the SQL05_Security.inf security template by using the Security Template snap-in.
• 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.

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 a database administrator for your company. You find a problem that when the following query is executed, a SQL Server 2005 application will perform slowly.
SELECT * FROM Orders WHERE OrderStatus = 'InProgress'
This query is executed by the application as an ad hoc query. In most occasions, this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless, the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However, the application that executes the query should not be changed. In addition, the effect on end users should be cut to the least.
Which action should be performed to finish the task?

• A. To finish the task, an indexed view of the Orders table should be viewed.
• B. To finish the task, the index should be recreated to have all of the columns in the table included.
• C. To finish the task, the index should be built by utilizing a FILLFACTOR of 10 percent.
• D. To finish the task, the statistics should be updated on the index.

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 recently the server performs gradually slowly. The indexing environment is troubleshooted by you. The clustered indexes are rebuilt by you, and the clustered indexes are utilized the most frequently. The most frequently accessed nonclustered index will be optimized by you. The sys.dm_db_index_usage_stats dynamic management view (DMV) is accessed by you. You can see the results from the table listed below.

When the entire index is not read, the nonclustered index which is being utilized the most frequently should be identified. From the following four object_id and index_id combinations, which one should be utilized to finish the task?

• A. To finish the task, the object_id 869578136 and the index_id 1 should be utilized.
• B. To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.
• C. To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.
• D. To finish the task, the object_id 309576141 and the index_id 1 should be utilized.
• E. To finish the task, the object_id 869578136 and the index_id 5 should be utilized.

The new server named SQLCLUST is set with test versions of the Research, Engineering, and Parts databases. The data in these databases is merely utilized for testing and is not present. According to the company requirements, the new Research, Engineering, and Parts databases should be moved from the test stage to the production stage with the highest efficiency level. Before making the databases accessible to all users, which three actions should be performed? (Choose more than one)

• A. All indexes should be built, and the statistics should be updated on all tables.
• B. One or more jobs should be scheduled to move all data from the mainframe computer databases to the new databases.
• C. Scripts should be run on the production server to build all tables, views, and stored procedures.
• D. The DELETE statement should be utilized to move all test data from the three databases.
• E. All data should be manually moved from the mainframe computer to the new databases by utilizing the SELECT INTO command.

The procedure should be specified for the implement of cryptographic functionality in the HRData database.
Which action should be performed? (Choose the appropriate options and arrange them in the correct order)
1.The ALTER ANY SYMMETRIC KEY permission should be granted to the HRAPP user.
2.A certificate that is owned by the HRApp user should be created.
3.A master key should be created.
4.Two stored procedures should be created. Both of them open the symmetric key by using the certificate. Have one of them encrypt the data with the symmetric key, and have the other encrypt the data with the symmetric key.
5.Create a symmetric key that is owned by the HRApp user and encrypted with the certificate.
6.A stored procedure that encrypts the data with the certificate should be created, and another stored procedure that decrypts the data with the certificate should be created.

• A. 5, 4, 2, 3
• B. 3, 4, 1, 6
• C. 5, 1, 4, 2
• D. 4, 6, 5, 2
• E. 1, 6, 3, 5