You are a database administrator for AIOTestKing.com. You are configuring a SQL Server 2005 database on a server named ServerA to use a CLR user-defined type. The CLR user-defined type needs to access a configuration file on a server named ServerB. You create a CLR assembly by using the default permission set. However, when the CLR user-defined type is called on ServerA, the assembly returns a security error. You need to correct the problem. What should you do?

You are a database administrator for AIOTestKing.com. You create a SQL Server Integration Services (SSIS) package that contains confidential information. The package will be used by only two company employees. The package is stored in the msdb database. You need to ensure that only the appropriate employees can execute the package. You must accomplish this goal by using the least amount of administrative effort. What should you do?

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 hosts a database named AssetTrack. You need to design a strategy to quickly perform point-in-time and page-level restores of the AssetTrack database. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are a database administrator for AIOTestKing.com. Users report that some reports are performing poorly. You ascertain that your tables have the appropriate indexes and that your queries should be performing optimally. You execute a SHOWPLAN statement on the poorly performing reports. You find that incorrect indexes are being used in some cases. You want the SQL Server 2005 query optimizer to automatically select the correct indexes. What should you do?

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 computer that runs Reporting Services. The server runs reports that include only data from the previous days sales. You discover that an OLTP database application runs slowly when reports are run during business hours and that reports sometimes time out.
You need to correct the problem and prevent it from recurring. What should you do?

You are a database administrator for AIOTestKing.com. You manage 10 SQL Server 2005 computers. The computers reside on an isolated portion of the company’s network that has been restricted from accessing the Internet. Only intranet client computers have access to the SQL Server 2005 computers. You need to audit the SQL Server computers to identify only the missing operating system or SQL Server patches, hotfixes, and service packs. What should you do?

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 stores confidential customer information in a database named Customers. The company’s written security policy states that transmission of customer data between client computers and servers must always take place in a manner that supports authentication, non-repudiation, and encryption. Client computers that do not support the company’s written security policy are denied data access. You need to ensure that the Customers database is in compliance with the company’s security policy. What should you do?

You are the administrator of a SQL Server 2005 computer named SQL1. Users report that SQL1 is not responsive. You discover that SQL1s network segment is heavily utilized. You cannot connect to SQL1 by using the graphical SQL Server administrative tools. You suspect that SQL1 is the target of a Denial of Service (DoS) attack. You need to connect to SQL1 to examine the current activities. What should you do first?

You are a database administrator for AIOTestKing.com. Your company uses a SQL Server 2005 application. The application executes a query that returns three columns of the nvarchar data type and one column of the XML data type. The query uses a WHERE clause that includes all three of the nvarchar columns. The table contains 5 million rows, and the query returns 50,000 rows. You need to improve the performance of the query.
What should you do?

You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application is performing slowly. You need to identify the queries that are experiencing slow performance due to blocking. What should you do?