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?

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 hosts an online analytical processing (OLAP) system for a customer. The customer requested that Domain.com provide data transformation and load support. They prefer the data load to be schedules to occur at noon every day. You need to accommodate this customer.
What should you do?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All client computers run Windows XP Professional. The Domain.com network contains an Oracle 9i database server named Certkiller -DB01 that hosts a database named CK_Data. The CK_Data database consists of five comma-delimited files. Domain.com wants to migrate the CK_Data database to SQL Server 2005. You install a new SQL Server 2005 database server named Certkiller -DB02. You want to create a new database named CK_Data and all the required tables on Certkiller -DB02. You must import the data into the CK_Data database on Certkiller -DB02. You want to accomplish this task as quickly as possible.
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. You are employed at the regional Marketing offices of Domain.com. Your duties at Domain.com encompass the importing and exporting data in the SQL Server 2005 databases. You have received instruction from the CIO to send a text file to the main office asks that contains the updated contact data for the clients in your area.
The CIO requests that the data be sorted by the State, LastName, and FirstName columns. A Domain.com employee named Mia Hamm works in the Sales department. You instruct Mia Hamm to forward the necessary information to the database administrator at the main office. Mia Hamm needs to accomplish this by using the minimum of effort.
What should she 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. Your duties include managing a SQL Server 2005 database server named Certkiller -DB01.
Certkiller -DB01 is updated with information exported from another site. Monthly the information is loaded into Certkiller -DB01 from a flat file by using the bcp utility. You have received instruction from the CIO to ensure that the operation is minimally logged. The users report that they receive error messages indicating that the transaction log is full.
After your investigation you detect that the errors occur when information is being imported. You need to prevent this problem from occurring.
What should you do?