Domain.com as employed you as a database administrator. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database named Certkiller -DB06
Certkiller -DB06 consists of a trigger named trg_InsertOrders. The trigger fires when order data is inserted into the Orders table. The trigger ensures that a client exists in the Customers table prior to the information being inserted into the Orders table. You have received instruction from the CIO to configure the trigger to prevent it from firing during the information import process. You need to accomplish this using the minimum of administrative effort. Which Transact-SQL statements should you use? (Choose all that apply)

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com uses a SQL Server 2005 database named Certkiller -DB01. Client information from the trading partners of Domain.com is imported into the CK_Clients table every night. You need to make certain that the client record is updated if it already exists in the CK_Clients table. However, if the record does not exist the information needs to be inserted into the CK_Clients table.
What should you do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database named Certkiller -DB01. You have received instruction from the CIO to create a view to join the Clients and Products tables in Certkiller -DB01. You instruct him to make sure that the view cannot be affected by modifications to underlying table schemas. You need to accomplish this with the minimal amount of overhead.
What should Rory Allen do?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com makes use of a database named CK_DATA. CK_DATA is located on a server named Certkiller -DB01.
You have been informed by the CIO that a table scan on the Products table in CK_DATA causes a slow query. This is a large table that is used regularly. You investigate and discover that the query contains the following statement:
SELECT PrName, PrDesc FROM Products WHERE PrID = <value> However, the Products table should at all times remain available to users.
What should you do?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. A full backup of your database named CK_Data is created automatically at midnight every day. You have been informed by the CIO that differential backups of CK_Data occur twice a day at 10:00 and at 16:00. A database snapshot is thus created daily at noon. A Domain.com user named Dean Austin is appointed as the technician in the Research and Development department. The CIO informs you that a developer accidentally dropped the NewProjects table in CK_Data at 12:30. You check and notice that the NewProjects was last updated one week ago. You instruct Dean Austin to recover the NewProjects table. He needs to accomplish this by using the minimum amount of administrative effort. It is important that he reduces the amount of information that is lost.
What should he do?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received instruction from the CIO to implementing transaction log shipping for a database named CK_Data from a server named Certkiller -DB01 to a server named Certkiller -DB02. A Domain.com user named Rory Allen is appointed as a junior technician in the Research and Development department. You inform Rory Allen that CK_Data is 100 GB in size. It is therefore too big to transfer over the network in a reasonable amount of time. You instruct Rory Allen to minimize the impact on the network. Rory Allen needs to accomplish this by initializing the secondary database.
What actions should Rory Allen perform? (Choose all that apply)

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server. Certkiller -DB01 contains a database named CK_Sales.
Domain.com intends migrating Certkiller -DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express on a server named Certkiller -SR31. You verify that Certkiller -SR31 exceeds the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?

You manage a SQL Server 2005 computer that was installed using default settings. After a power failure, the SQL Server (MSSQLSERVER) service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

You use Service Broker manage data requests between SQL Server 2005 databases. You need to make changes to objects for an existing service. You want to ensure that no messages can be received by the service until the changes are complete. What should you do?

You work in San Francisco at the main office of your company. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares cusMikeer activity in the previous quarter between the main office in San Francisco and the branch office in Paris. They want the data sorted by surname and first name.
You restore a recent backup of the Paris database onto your server. You write queries to build the report, ordering the data by the Surname and FirstName columns.
You review the data and notice that the cusMikeer list from the Paris database is sorted differently.
The sales department needs the revised data within 15 minutes for a presentation. You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do?