The DeliveryVans, AirlinePreferences, and SeasonalContractors databases should be removed into the data center. Which action should be performed?

• A. A separate instance of SQL Server 2005 should be installed for each of the databases on a single server.
• B. A SQL Server database should be created for each of the databases in a single instance of SQL Server 2005.
• C. A default instance of SQL Server 2005 should be installed on three separate servers. And then, one server should be utilized for each of the databases.
• D. The data should be imported from each of the databases into a single database in an instance of SQL Server 2005.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment.
In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. There is a SQL Server 2005 computer in the company. A single user database named DB01 is contained in this computer. All company employees connect to DB1. According to the requirement of the company policy, the database should be fault-tolerant and that failovers require no administrative effort. Therefore, you are asked to provide fault tolerance for the database.
Your solution must guarantee that even if a complete hardware failure occurs on the SQL Server 2005 computer, client computers are able to connect to the database, including a failure of all disks. What action should you perform to achieve your goal?

• A. Log shipping needs to be implemented to another SQL Server 2005 computer.
• B. Transactional replication needs to be implemented to another SQL Server 2005 computer.
• C. Database mirroring to another SQL Server 2005 computer needs to be implemented.
• D. A two-node server cluster that contains the database needs to be implemented.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. There is a SQL Server 2005 computer named SQL01 in the company. A stores sales history data is stored in a database on SQL01 for the company's Web-based order system. Twenty of the business analysts in the company create ad hoc queries against the database. SQL01 has a slow performance all the time. Since you work as the technical support, the company asks you to identify which business analyst is causing the problem. What action should you perform to achieve this goal? (Choose more than one.)

• A. In order to achieve the goal, you should view the activity of specific business analysts by using the Activity Monitor.
• B. In order to achieve the goal, the sp_who system stored procedure should be run.
• C. In order to achieve the goal, you should gather database activity by running SQL Trace system stored procedures.
• D. In order to achieve the goal, you should use SQL Server Profiler to create a trace that uses a predefined template.

According to the company requirements, a data archival strategy should be designed for order data. You can see the placements of data and partitions for the Sales.Orders table at the end of July from display below. From the following filegroups, which one should partition 2 of the Sales.OrderArchive table locate on?

• A. Partition 2 of the Sales.OrderArchive table should locate on FG2
• B. Partition 2 of the Sales.OrderArchive table should locate on FG3
• C. Partition 2 of the Sales.OrderArchive table should locate on FG1
• D. Partition 2 of the Sales.OrderArchive table should locate on FG4

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. Transaction information for the company's Web-based order system is stored by a database on one of the company's SQL Server 2005 computers. The company configures the database to utilize the full recovery model. Quite few orders are received between the hours of 19:00 and 04:00. And the risk for data loss which the company can accept should not be longer than an hour. The company requires performing the Database backups in the shortest time. A maintenance plan should be developed to administrate this risk. Which action should be performed?

• A. A Back Up Database task should be set to do a full backup of the database every day at
  19:00.
  And then, a second Back Up Database task should be set to do differential backups at 09:00 and 14:00. At last, a Check Database Integrity task should be set to run every hour.
• B. A Back Up Database task should be set to do a full backup at 09:00 and 14:00. And then, a second Back Up Database task should be set to do transaction log backups every hour.
• C. A Back Up Database task should be set to do a full backup of the database every hour. And then, a Check Database Integrity task should be set to run every hour.
• D. A Back Up Database task should be set to do a full backup of the database every day at
  19:00.
  And then, a second Back Up Database task should be set to do differential backups at 09:00 and 14:00. At last, a third Back Up Database task should be set to do transaction log backups every hour.