You are the database administrator for AIOTestKing.com. You manage a SQL Server 2005 database named Sales. You are given a SQL Server Profiler sample workload with queries to the Sales database on a typical day. You need to evaluate the effectiveness of current indexing and identify changes that would be appropriate. What should you do first?

You are a database administrator for AIOTestKing.com. The company’s manufacturing floor has three automated testing areas for finished items. Each testing area uses SQL Server 2005 to store test results. You need to develop a replication strategy to ensure that test results flow continuously from the testing areas to the central SQL Server as quickly as possible. The test results are used for reporting. What should you do?

You are a database administrator for AIOTestKing.com. You are creating a new SQL Server Integration Services (SSIS) package. The package will import one or more text files into a database each night. These text files are provided by company vendors and are not related to one another. You need to ensure that the package always succeeds, even if no text files are provided, with the least amount of administrative effort. What should you do?

You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application stops responding for several seconds at a time during the day. This problem occurs randomly throughout the day and affects many users at once. When the problem occurs, you notice that CPU utilization and disk utilization on the SQL Server 2005 computer are low, but that the network is operating normally. You need to examine additional information relevant to the problem. What should you do?

You are a database administrator for AIOTestKing.com. You are creating a SQL Server 2005 database that will contain many tables to store contact information for customers, partners, and vendors. You need to ensure consistency in the data types that are used in all columns in the database tables. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2005. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company’s written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges. You need to configure the SQL Server service to run under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night, a full backup is made of the database, and all database indexes are rebuilt. The company’s network administrator reports that AIOTestKing As network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for AIOTestKing A.
What should you do?

You are the database administrator for AIOTestKing.com. You create a new stored procedure.
You run the stored procedure and discover an error. You want to gather and process any error information that is generated while running the procedure. Error logging must use the minimal amount of resources while providing the needed functionality. You need to know what caused the error. You also need to include the appropriate error functions in the new stored procedure. What should you do?

You are a database administrator for AIOTestKing.com. Your company uses merge replication to replicate data between SQL Server 2005 computers. Users sometimes report that data on some of the computers is out of date. When this happens, you discover that merge replication times out before the merge could complete. You need to ensure that you are automatically notified by SQL Server when this problem occurs. What should you do?

You are a database administrator for AIOTestKing.com. A new SQL Server 2005 computer named AIOTestKing B hosts a mission-critical customer relationship management (CRM) database. All of the companys 500 employees in the sales and marketing departments access the CRM database. Your department has an annual budget for the purchase of new hardware and software. You need to devise a monitoring strategy that enables you to make decisions about the history of server performance. The monitoring strategy should also advise you on how to best allocate funds for hardware upgrades. What should you do?