You are a database administrator for AIOTestKing.com. You have a Data Transformation Services (DTS) package stored in SQL Server 2000 that you want to migrate into SQL Server 2005. The DTS package uses complex Microsoft Visual Basic Scripting Edition (VBScript) to dynamically configure precedence constraints. You run the SQL Server 2005 Package Migration Wizard, which fails to convert the package from SQL Server 2000 to SQL Server 2005. You need to ensure that the DTS package runs in SQL Server 2005. You must get the package running as quickly as possible. What should you do?

You are a database administrator for AIOTestKing.com. You discover that a SQL Server 2005 application performs slowly when you execute the following query. SELECT * FROM Orders WHERE OrderStatus = ‘InProgress’ The application executes this query as an ad hoc query. This query usually executes much more quickly. The OrderStatus column is indexed. Only a small number of the rows contain the value InProgress.
However, the OrderStatus column index is not being used, even though the index is optimal for this query. You need to improve the performance of this query. However, you cannot modify the application that executes the query. Your solution must also minimize the impact on end users. What should you do?

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains two databases named Production and DW. You create a new database named Staging.
The Staging database temporarily stores and manipulates data as the data moves from the Production database into the DW database. You need to ensure that tables are not removed from the Staging database. You also need to ensure that any attempts to remove tables are logged. Other databases must not be affected by your solution. What should you do?

You are a database administrator for a financial services company. You are configuring replication between two SQL Server 2005 computers named SQL1 and SQL2. SQL1 stores real-time transactional data. SQL2 is used for reporting. SQL2 must not change data on SQL1. The publication contains a large amount of data. You need to ensure that during replication, data is copied from SQL1 to SQL2 in as near real-time as possible to ensure accurate reporting. You need to ensure that this data is copied securely. What should you do?

You are a database administrator for AIOTestKing.com. You administer a SQL Server 2005 computer that contains a database named Customers. The database includes a table named CustInfo. The table includes an identity column named CustID and an nvarchar column named CustName. Company policy requires that rows containing duplicate CustName values be removed from the CustInfo table once each year. However, rows cannot be removed from the CustInfo table until they have been manually examined and verified as being duplicates. You need to provide a way to identify potential duplicate rows for manual examination. You need to accomplish this goal by using the least amount of administrative effort. What should you do?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains a user database named Products. You use SQL Server Integration Services (SSIS) packages to export data from the Products database to a text file. You use FTP to send the text file to your company’s trading partners. You need to ensure that you can recover your SSIS packages if a disaster occurs. What should you do?

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains two user databases. SQL1 also contains the publisher database for a transactional replication publication. Every night, a full backup is made of all databases. Transaction log backups are made twice each day for both user databases. SQL1 is configured to use SQL Server and Windows authentication. Client applications connect by using SQL Server login accounts. The disk subsystem on SQL1 experiences a complete failure. You replace the failed hardware, reinstall Microsoft Windows Server 2003, and reinstall SQL Server 2005. You need to ensure that SQL1 is operating normally as quickly as possible and with a minimum loss of data. Your solution must make the user databases available to client applications as soon as those databases are restored. What should you do first?

You need to design a stored procedure to import the registry information from AppServer1. You want to accomplish this goal without allowing the execution of unmanaged code. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Users report that all client applications that connect to AIOTestKing A are responding slowly. You discover that AIOTestKing As CPU and memory utilization is low and that disk activity is low. You need to identify the cause of the performance problem.
What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. The SQL Server service and the SQL Server Agent service are configured to start automatically. You need to configure AIOTestKing A to audit all user names and application names that attempt to access information from AIOTestKingA. AIOTestKing A must perform auditing at all times, and the results must be kept for 10 years. What should you do?