You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A runs Windows Server 2003 and hosts a database named DB1.
DB1 is used for a critical, enterprise-level application that all sales representatives in the company use. The database is currently 87 GB and grows 5 GB each quarter. AIOTestKing A recently experienced a hard disk failure that resulted in significant system downtime.
You purchase two new hardware RAID controllers named Controller1 and Controller2.
You also purchase five new hard disk drives to try to prevent reoccurrences of hardware-related downtime. The new hard disk drives are configured as shown in the following table.
Disk drive Size RPM Disk1 100 GB 7200 Disk2 100 GB 7200 Disk3 100 GB 7200 Disk 460 GB 7200 Disk5 60 GB 7200 The operating system is configured for redundancy. You decide to build a RAID5 array on Controller1 and a RAID1 array on Controller2.
You need to ensure that DB1 continues to perform in the event of a disk failure.
What should you do?

You are the database administrator for a SQL Server 2005 computer named AIOTestKing A.
A user reports that his query has been running for a very long time and is still running.
You access the sys.dm_tran_locks dynamic management view (DMV). The relevant results are shown in the following table.

You need to find the user name of the user with the blocking connection. 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 SQL Server 2005 computer named AIOTestKingA. AIOTestKing A runs three instances of SQL Server. Your company’s disaster recovery plan includes having the ability to connect to the dedicated administrative connection on each instance of SQL Server. While testing this ability, you discover that you can connect to the dedicated administrative connection on AIOTestKing As default instance. But you cannot connect to the dedicated administrative connection on the two other instances on AIOTestKingA. You verify that the instances are running and that client applications are able to access them. You also verify that the dedicated administrative connection is enabled for all instances. You confirm that no other administrators are attempting to connect to any dedicated administrative connections on AIOTestKingA. You need to ensure that you can connect to the dedicated administrative connection on all three instances. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. All servers run Microsoft Windows Server 2003 and belong to a Microsoft Active Directory domain. The companys written security policy mandates strong passwords for all domain, local, and application accounts. The appropriate domain password policy has been deployed through the use of a Group Policy object (GPO).
Many of the company’s computers run MS-DOS-based or UNIX-based operating systems. These computers require varying levels of access to a database named Services on AIOTestKingA . You need to ensure that these computers can access the Services database without violating the company’s written security policy. What should you do?

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 application. Each night, data is imported into a database, and the database is then set to be read-only. During business hours, users run predefined and ad hoc queries. You need to monitor the servers performance during the day. 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 two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. You were not responsible for the original installation of SQL Server on these computers. Yet you now must ensure that both computers are configured according to the following requirements. Administrators must be able to remotely connect to AIOTestKing A and AIOTestKing B for troubleshooting, even if the system becomes unresponsive. AIOTestKing A and AIOTestKing B must not be able to execute commands related to the operating system.Database access must be permitted by using Simple Object Access Protocol (SOAP) messages over HTTP. AIOTestKing A and AIOTestKing B must not be able to use stored procedures to send e-mail.Use of the OPENROWSET and OPENDATASOURCE Transact-SQL statements must not be permitted.Stored procedures for generating HTML must not be permitted. You need to configure AIOTestKing A and AIOTestKing B to meet these requirements. What should you do?

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?

You are a database administrator for AIOTestKing.com. You administer a SQL Server 2005 computer. Customers send orders to your company over the Internet in an XML format.
The XML is submitted as an input argument of a stored procedure. The stored procedure needs to produce a result set that includes all invalid product identification numbers (IDs) from the order. A company database contains a list of all valid product IDs. You need to ensure that the stored procedure can produce the desired result set. Your solution must provide the fastest possible query performance. 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 a SQL Server 2005 application is performing slowly. You check the SQL Server error log and discover that the server frequently runs out of memory to manage locks. The application designer informs you that dirty reads are acceptable. You need to resolve the problem indicated by the error log. What should you do?

You are a database administrator for AIOTestKing.com. The company has two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. AIOTestKing A is located on the local network. AIOTestKing B is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on AIOTestKing A that access data from both AIOTestKing A and AIOTestKing B. To ensure that your queries are functional, you must configure access to the vendors site. What should you do?