You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Users regularly report that they receive error messages stating that the transaction log is full. When they get this message, their data changes fail. You notice that disk space on AIOTestKing A is limited. You need to configure AIOTestKing A to automatically prevent users’ data changes from failing due to full transaction logs. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. All databases on AIOTestKing A have been created with the default auto file growth properties on one RAID 10 volume. All transaction logs on AIOTestKing A have been created without file growth enabled on a second RAID 10 volume. You need to ensure that you are notified when the databases are approaching disk capacity. You also need to prevent errors caused when any transaction log runs out of space. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are a database administrator for AIOTestKing.com. The company has a SQL Server 2005 computer that contains a single user database named DB1. All company employees connect to DB1. Company policy requires that the database be fault-tolerant and that failovers require no administrative effort. You need to provide fault tolerance for the database. Your solution must ensure that client computers can connect to the database, even if the SQL Server 2005 computer experiences a complete hardware failure, including a failure of all disks. What should you do?

You are a database administrator for AIOTestKing.com. You review the error log for a SQL Server 2005 Enterprise Edition computer. You notice torn page errors for one database.
You need to resolve the torn page problem as quickly as possible. What should you do?

You are a database administrator for AIOTestKing.com. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 database that includes a table named Customers. The table includes a column named EmailAddress that contains string data. Company policy specifies a required format for data in the EmailAddress column. Changes to the EmailAddress column are made several ways, including by using ad hoc queries. You need to ensure that the data in the EmailAddress column is properly formatted. Your solution must provide the best possible performance when thousands of rows are added to the database. What should you do?

You are the database administrator for AIOTestKing.com. You have a single processor in your SQL Server 2005 computer. You run System Monitor and discover that your total processor utilization is averaging 95 percent. You need to use System Monitor to find out which application or service is causing the problem. What should you do?

You are a database administrator for AIOTestKing.com. Developers need access to create, alter, and drop tables in your SQL Server 2005 database. A list of production tables is maintained in a table named Valid_Production_Tables in the database. You need to be able to automatically roll back any commands that drop or alter current production tables.
You need to do this while minimizing the processor resources being used. What should you do?

You are a database administrator for an electronics distribution company. You are documenting your company’s requirements for data quality. You need this information so that you can store part numbers, components, and stock levels from your company’s trading partners in your SQL Server 2005 environment. You need to determine the standards for data quality. You need to consult with the business analysts and other database administrators (DBAs) in your organization to do so. What are three possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose three.)

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?