You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 computer named Certkiller -DBO1. Certkiller -DBO1 was installed with the default settings and on the server.
A database named CK_DATA is located on the Certkiller -DBO1. As administrator you noticed the recent failure of a hard disk controller and decide to check the integrity of CK_DATA. You need to create a maintenance task named Check CK_DATA that makes use of default settings.
You are then required to schedule the check to run over the weekend not to interfere with user transactions. You need to retrieve the outcome details of the Check CK_DATA maintenance plan the following Monday. What should you do to achieve this goal? (Choose all that apply)

You work as the database administrator at Domain.com. The Domain.com network contains two SQL Server 2005 database servers named Certkiller -DB01 and Certkiller -DB02. Certkiller -DB01 hosts a database named CK_Sales that is used to store sales information for the company, while Certkiller -DB02 is used for reporting purposes only.
You want to be notified by e-mail when ever a syntax error event occurs on the CK_Sales database but you want to keep the number of e-mails to a minimum. You configure SQL Server Agent Mail and you define a SQL operator object on Certkiller -DB01 for your administrative user account. What should you do? (Each correct answer represents part of the solution. Choose three.)

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02.
Certkiller -DB01 and Certkiller -DB02 both take part in replication. Certkiller -DB01 is the Publisher and Distributor of a publication named CK_Pub1. CK_Pub1 is the only publication on Certkiller -DB01 while Certkiller -DB02 is the only Subscriber. The CIO requests a status report regarding the replication latencies.
A Domain.com 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 Certkiller -DB01.
What should Rory Allen do?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has its headquarters in Washington and five field offices in the city. All servers on the Domain.com network run Windows Server 2003, all database servers run SQL Server 2005 and all client computers run Windows XP Professional. The Domain.com network contains a database server named Certkiller -DB01 that is located at headquarters. Certkiller -DB01 hosts a database named CK_Repairs.
Domain.com users in the Purchasing department order parts that technicians use to repair customer’s computers at customer sites. The parts are shipped to the field offices. At present Domain.com tracks the usage of parts through data entered on the customer’s invoice. Each field office has a client computer that runs SQL Server 2005 Standard Edition that is used to capture invoice data. Domain.com wants to implement a new inventory tracking application for the parts. The new application will access a table named _Parts in the CK_Repairs database. You need to enable users at headquarters and at the various field offices to update the _Parts table. You decide to implement merge replication with CERTKILLER-DB01 as the Publisher and the SQL Server 2005 Standard Edition computers at the field offices as the subscribers.
To minimize the usage of disk space on the Subscribers, you need to ensure that only the Publisher is used to store conflict records.
What should you do?

You work as the database administrator at Domain.com. Domain.com has its headquarters in New York, and branch offices in Boston, Chicago and Atlanta. Each office currently maintains its own database for customers in a single Microsoft Access table.
Domain.com wants to centralize the Microsoft Access databases in a single SQL Server 2005 database named Certkiller -DB01 that is located in the New York office. You enable the local administrator at each office to import data from the Microsoft Access databases into Certkiller -DB01. You need to ensure that the local administrator at each office has the minimum permissions necessary to perform the operation.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You need to import data from several comma-delimited lists into a SQL Server 2005 database server named Certkiller -DB02. You need to use a SQL Server Integration Services (SSIS) package to accomplish this task. To this end you are designing the Data Flow elements that will define the importing of data from comma-delimited lists. You need to make a choice regarding the Data Flow elements that should be used in the Destination – Data Flow step.
What should you do?