Microsoft SQL Server 2005 Implementation & Maintenance

Question:1
Which of the following are required before a database can be reverted from a Database
Snapshot? (Choose all that apply.)
A. Full text catalogs on the source database must be dropped.
B. Users cannot be accessing the source database or the Database Snapshot.
C. Log shipping must be stopped.
D. All Database Snapshots except the Database Snapshot used for the revert must be
dropped.
Answer: B, D

Question:2
A website provides stock information to users. This website uses a SQL Server 2005
database. A Web service provided by a third party is used to gain the real-time investment
information. Users can see stock reports that combine data and this data are retrieved from
the database with this real-time investment information. You need to ensure the information is
current when the database executes the reports. What should you do when you create the
appropriate objects that support the reports?
A. Create a table to store the investment information for each customer. Create a trigger that
fires when data is inserted into the table that joins with the data coming from the Web service.
B. Publish the data in the database as an XML Web service by using the FOR XML AUTO
clause.
C. Create a Transact-SQL stored procedure that uses a temporary table to store the
investment information for each customer. Update the table with the values from the Web
service.
D. Create a CLR function by using the assembly that calls the remote Web service. Call the
CLR function and combine the results with investment information in the database.
Answer: D