Exam Prep Questions

1.	You would like to perform a bulk data load. This process will be repeated often. You will be exporting from one server and importing into the other. To speed up the process, you want to have the data imported in the primary key sequence. How do you implement this so that it will occur as quickly as possible? (Select the best answer.) A. Import using BCP with an order hint. B. Import using BULK INSERT with an order hint. C. Import using OPENROWSET with ORDER BY. D. Export using BCP with ORDER BY. E. Export using BULK INSERT with ORDER BY.
2.	A small manufacturing company has a considerable number of data sources because no standardization has occurred across any platform. One of the database servers has SQL Server installed; the others come from various vendors. For a project you are working on, you need to gather data from the SQL Server machine and merge it together with data from two other sources. You then need to bring the data into Excel to do some charting. How would you accomplish this task? (Select the best answer.) A. Export the data from the other sources into a comma-delimited file. Then export from SQL Server the data that is to be imported into Excel. B. Export the data from all three sources so that it can be imported into Excel. C. Use SSIS to transfer all the data from all sources directly into Excel. D. Use Excel to transfer data from all three sources into a spreadsheet.
3.	You are implementing a portion of the corporate extranet. You want to make the server accessible for web services over HTTP. You also want to use the asynchronous features of Service Broker. How would you accomplish this task? (Select the best answer.) A. Create a TCP endpoint. B. Create an HTTP endpoint. C. Create one TCP endpoint and one HTTP endpoint. D. Create an HTTPS endpoint.
4.	You would like to use HTTP naming conventions to create services locally and to allow them to be registered from remote systems. How would you accomplish this task? (Select the best answer.) A. Create services using standard SQL names and establish aliases. B. Create the service queue with an activation process. C. Use sp_reserve_http_namespace and use this namespace for services, endpoints, and other objects. D. Establish an http namespace in the BEGIN DIALOG operation.
5.	You have a data file with its associated format file. You need to perform an import operation that allows for the use of both files. How can you accomplish this task? (Select all that apply.) A. Use the same process that created the file. B. Use BCP to perform the import. C. Use BULK INSERT to perform the import. D. Use OPENROWSET to perform the import. E. Use SSIS to perform the import. F. Use the RESTORE statement to perform the import.
6.	You have created multiple queues for use by Service Broker. You have assigned each service to its own queue. You initiate a message from BefService targeting AftService. No queues have automation enabled. In which queue or queues would you find the initial message sent by BefService? (Select the best answer.) A. In the queue assigned to BefService B. In the queue assigned to AftService C. In both the BefService queue and the AftService queue D. In neither queue because the operation requires a shared queue
7.	A message is defined using the VALIDATION clause with VALID_XML. What checks are performed against the message before it is delivered? (Select the best answer.) A. The message must contain well-formed XML. B. The message must contain a full XML document. C. The message must contain an XML segment. D. The XML must conform to the schema provided.