You have two tables named Customers and Orders. They are related by a foreign key constraint on the CustomerID on each table. You need to generate the following XML structure that includes all customers and their related orders.
<Root>
<Customer>
<CustomerName>Customer1</CustomerName>
<Orders>
<Order>
<OrderDate>1/1/2008</OrderDate>
<OrderValue>422</OrderValue>
</Order>
<Order>
<OrderDate>4/8/2008</OrderDate>
<OrderValue>300</OrderValue>
</Order>
…
</Orders>
…
</Customer>
<Root>

Which query should you use?

You have implemented change tracking on a table named Sales.SalesOrder.
You need to determine all columns that have changed since the minimum valid version.

Which function should you use?

You are required to modify a table named Sales.SalesOrder. The table has change tracking enabled on it.
You need to disable change tracking prior to modifying the Sales.SalesOrder table.
Which Transact-SQL statement should you use?

You are using Microsoft SQL Server 2008 Enterprise Edition. You need to maintain a history of all data modifications made to a table, including the type of modification and the values modified. Which tracking method should you use?

You use the same Service Broker configuration to support a Web site and an internal application. The Web site generates a greater workload than the internal application.
You need to configure Service Broker to ensure that messages sent by the internal application are processed before those sent by the Web site.
Which Transact-SQL statement should you use?

You created a Service Broker queue by using the following Transact-SQL statement:

CREATE QUEUE VacationRequestQueue WITH RETENTION = OFF, ACTIVATION (
PROCEDURE_NAME = dbo.VacationRequestProcess,
MAX_QUEUE_READERS = 5, EXECUTE AS SELF
);

You need to modify the Service Broker queue to prevent it from processing received messages.
The queue should continue to receive messages.
Which Transact-SQL statement should you use?

You have a database named Contoso. The Contoso database has a Service Broker queue named VacationRequestQueue.
The Contoso database has been restored to a new server. Since restoring the database, Service Broker is no longer able to send new messages.
You need to configure Service Broker in order to resolve the issue.
Which Transact-SQL statement should you use?

You are configuring Service Broker to process messages within a single database. You have performed the following steps.

CREATE MESSAGE TYPE
CREATE CONTRACT
CREATE QUEUE

You need to complete the Service Broker configuration. What should be the next step?

You have a table named Inventory. You open a Microsoft Windows PowerShell session at the following location by using the SQL Server Windows PowerShell provider. PS

SQLSERVER:SQLCONTOSODEFAULTDatabasesReportServerTablesdbo.InventoryColumns>

Using the SQL Server Windows PowerShell provider, you need to query all the columns in the table. Which cmdlet should you use?