Microsoft-PRO Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

You are a database administrator for Certkiller .com. You are configuring a new SQL Server 2005 computer named Certkiller A. Certkiller A will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to Certkiller A will be made by using Certkiller As DNS name. You need to disable any unnecessary services on Certkiller A. Which service or services should you disable? (Choose all that apply.)

You work as DBA at Certkiller .com. You administer a SQL Server 2005 computer named Certkiller A. Certkiller 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 Certkiller A. You perform most of the management of Certkiller A from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to Certkiller A. What should you do?

You work as DBA at Certkiller .com. You administer a SQL Server 2005 computer named Certkiller A. Certkiller A is configured to automatically perform transaction log backups, database integrity checks, and other maintenance tasks on a regular basis. Another administrator uses the SQL Server Surface Area Configuration tool to reconfigure Certkiller A. You notice that Certkiller A no longer performs the automated maintenance tasks. You need to ensure that the maintenance tasks on Certkiller A are completed automatically. What should you do?

You are a database administrator for Certkiller .com. The SQL 2005 Server computer has been in operation for more than one month. This past week, query performance problems have led you to investigate locking contention. The sys.dm_os_wait_stats dynamic management view (DMV) is showing a high value in the max_wait_time_ms column. You need to find out if this value is a factor in the current performance problems. You also must minimize the impact on database users. What should you do?

You are a database administrator for Certkiller .com. You manage a database named Invoicing. The Invoicing database is backed up with a full backup nightly and transaction log backups once every two hours from 08:00 to 17:00. You implement database snapshots for the Invoicing database. A database snapshot is created each day at 07:00. At 09:30 today, a user inadvertently deleted all of the invoices that were entered into the CurrentInvoice table yesterday. None of these invoices had been changed today prior to the deletion. It is now 11:45 and many other changes have occurred in the database. You need to recover the lost rows with as few administrative steps as possible while minimizing data loss. What should you do?

You work as DBA at Certkiller .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 are a database administrator for Certkiller .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 the database administrator for Certkiller .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 Certkiller .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 a database administrator for Certkiller .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?