You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema, application roles, and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been granted membership in the local Administrators group on AIOTestKing A. You perform most of the management of AIOTestKing A from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to AIOTestKing A. What should you do?

You are a database administrator for AIOTestKing.com. You are responsible for managing 10 SQL Server 2005 computers that run Microsoft Windows Server 2003, Enterprise Edition. The company’s Microsoft Active Directory administrators handle all Group Policy object (GPO) deployments. The Active Directory administrators have deployed a security template named SQL05_Security.inf that has the appropriate settings to meet the company’s security policy. You need to identify the existing configuration of each SQL Server 2005 computer to ensure that it meets the company’s security policy. What should you do?

You are a database administrator for AIOTestKing.com. You have separate SQL Server 2005 development and production environments. You use the Business Intelligence Development Studio to create a SQL Server Integration Services (SSIS) package in your development environment. Then, you use the SSIS package to import data into your development environment from one of your company’s trading partners. You need to deploy the SSIS package to your production environment. Your production environment uses different table names than your development environment. What should you do?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete 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. 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?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains one user database that holds sales transaction information. Users report that the queries and stored procedures that they use every day are taking progressively longer to execute. You also notice that the amount of free disk space on the SQL Server computer is decreasing. You need to create a maintenance plan to correct the performance and storage problems. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

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?