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?
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?
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. 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?
What should she do?
You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include importing data into SQL Server 2005 databases. A Domain.com user named Amy Wilson is a member of the Sales department. You have received numerous text files that contain the sales transactions from various stores across the country. The data are separated by semicolons in columns. You instruct Amy Wilson to import the files into the sales database.
What should she do?
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 servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database named CK_Data.
You install a new SQL Server 2005 database server named Certkiller -DB02. You create a new database named CK_Sales on Certkiller -DB02. You must populate the CK_Sales database with data from several tables in the CK_Data database. You want to use the bcp command line utility to export the data to a text file. You want to accomplish this task as quickly as possible.
What should you do?
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. 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?
Which CREATE CONTRACT statement should you use?
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 Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts two database named CK_Staff and CK_Projects.
You need to create a Service Broker to enable the CK_Staff and CK_Projects databases to communicate. You create three message types using the following Transact-SQL statements:
CREATE MESSAGE TYPE [// Domain.com/Staff/Name] VALIDATION = WELL_FORMED_XML ;
CREATE MESSAGE TYPE [// Domain.com/Projects/Budget] VALIDATION = WELL_FORMED_XML ;
CREATE MESSAGE TYPE [// Domain.com/Projects/Completion] VALIDATION = EMPTY ;
You now want to create a contract named // Domain.com/Project/Progress between two services that include the two message types. You want to ensure that both the sender and the target is able to use // Domain.com/Staff/Name message type; but that only the sender is able to use the // Domain.com/Projects/Budget message type, and only the target is able to use the // Domain.com/Projects/Completion message type.
Which CREATE CONTRACT statement should you use?
What should you do first?
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 Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts two database named CK_Sales and CK_Inventory. You create a Service Broker to enable the CK_Sales and CK_Inventory databases to communicate. You want to create a new service named // Domain.com/Income.
What should you do first?
Which CREATE SERVICE statement should you use?
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 Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts two database named CK_Staff and CK_Projects.
You create a Service Broker to enable the CK_Staff and CK_Projects databases to communicate. You create two message types named // Certkiller /Projects/Budget and // Domain.com/Projects/Expenses as well as the queue named // Domain.com/Expenses/ExpenseQueue.
You create a contract named // Domain.com/Expenses/ExpenseSubmission that uses the two message types and the queue. You want to create a new service named // Domain.com/Expenses that will listen for and accept messages from // Domain.com/Expenses/ExpenseSubmission by using // Domain.com/Expenses/ExpenseQueue.
Which CREATE SERVICE statement should you use?
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. Some of the servers on the Domain.com network run Windows Server 2003 while the rest run Windows NT 4.0 Server. The client computers run Windows 98, Windows NT 4.0 Workstation and Windows XP Professional.
The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 runs Windows Server 2003 and hosts a database named CK_Projects. You need to enable the CK_Projects database to accept Simple Object Access protocol (SOAP) requests. You plan to accomplish this by creating a Hypertext Transfer Protocol (HTTP) endpoint. You want to ensure that the most secure authentication method is used when client computers connect to the HTTP endpoint.
What should you do?