Answers to Exam Prep Questions


1.

D. To achieve the best performance, you need to make sure that the file is in order when it is created. The order hint does not reorder data. Ordering the data at the time of import using any mechanism would be sluggish. Because you cannot create a file by using BULK INSERT, the only possibility is BCP file creation with a query to create the file in order. For more information see the "Using the Bulk Copy Program (BCP)" section.

2.

C. SSIS is ideal for this situation. Depending on the details of the process, this can be performed directly by using replication. Given the complexity of the scenario, it is more likely that SSIS would be used because of its great flexibility. For more information, see the "Using SQL Server Integration Services (SSIS)" section.

3.

C. Web services utilize HTTP or HTTPS endpoints and SOAP processing, whereas Service Broker requires a TCP endpoint. For more information, see the "Implementing Service Broker" section.

4.

C. HTTP naming can either be done explicitly using sp_reserve_http_namespace or implicitly through creation of endpoints that apply and add to the namespace. For more information, see the "Implementing Service Broker" section.

5.

B, C, D, E. It doesn't matter how the files were created. You can perform the import operation by using BCP, BULK INSERT, OPENROWSET, or SSIS . RESTORE can only work with files that were created with the BACKUP operation.

6.

B. Service Broker automatically delivers any messages sent to the queue assigned to the service receiving the message. This makes it easier to control queues and operations against the queues. No service can gain access to messages that are not intended for the service. For more information, see the "Implementing Service Broker" section.

7.

D. When VALID_XML is defined, the XML is checked against the schema that was assigned to the message type at the point of creation. For more information, see the "Designing a Service" section.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net