Your company has a network that consists of two domains named DOM1 and DOM2. There is no trust relationship between DOM1 and DOM2. DOM1 contains a server named SQL1. DOM2 contains a server named SQL2. Both servers run SQL Server 2005. The SQL Server instance on SQL1 uses the DOM1SQLService1 service account. The SQL Server instance on SQL2 uses the DOM2SQLService2 service account. There are no mirroring endpoints on either server. SQL1 contains a database named DB1 . You want to mirror DB1 to SQL2 by using high-protection mode without a witness. You need to create the database mirroring endpoints and configure security on all participating server instances. What should you do?

You are employed as a database administrator at Hi-tech Company. The Hi-tech Company network consists of a single Active Directory domain named Hi-tech Company.
The Hi-tech Company network contains two SQL Server 2005 computers named Datebase01 and Datebase02.
Datebase01 and Datebase02 both take part in replication. Datebase01 is the Publisher and Distributor of a publication named Pub1.
Pub1 is the only publication on Datebase01 while Datebase02 is the only Subscriber. The CIO requests a status report regarding the replication latencies.
A Hi-tech Company user named Rory Allen is a member of the Research and Development department. You instruct him to determine the current latencies between the Publisher and Distributor as well as between the Distributor and Subscriber using the Replication Monitor on Datebase01. What should Rory Allen do?

You are employed as a database administrator at Hi-tech Company. The Hi-tech Company network consists of a single Active Directory domain named Hi-tech Company. A full backup of your database named DB_Data is created auMikeatically at midnight every day. You have been informed by the CIO that differential backups of DB_Data occur twice a day at 10:00 and at
16:00.
A database snapshot is thus created daily at noon.
A Hi-tech Company 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 DB_Data at12: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 are employed as a database administrator at Hi-tech Company. The Hi-tech Company network consists of a single Active Directory domain named Hi-tech Company. Your duties at Hi-tech Company include maintaining a SQL Server 2005 database named DataBase01.
Analysts in the Sales department of Hi-tech Company usually make use of a view named v_ClientSales to join the Clients and the Sales tables in the DataBase01. The analysts make use of this view to combine the total sales by clients per month. You want to increase the performance of the view. What should you do?

Which of the following sentences is true for recovery models?

Which of the following statements let you create a SQL Server login called Peter? (Choose all that apply.)

Which of the following statements enables you to create a database certificate?

Which role membership level is the minimum necessary to subscribe to a publication? (Choose all that apply.)

Which of the following are required before a database can be reverted from a Database Snapshot? (Choose all that apply.)