Which method should you use?
A database contains tables named Sales and SalesArchive. SalesArchive contains historical sales data. You configure Change Tracking on the Sales table. The minimum valid version of the Sales table is
You need to write a query to export only sales data that changed since version 10, including the primary key of deleted rows. Which method should you use?
Which tracking method 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?
Which Transact-SQL statement 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?
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?
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?
What should be the next step?
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?
Which cmdlet should you use?
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?
which script will produce the desired list of databases. What script should you use?
You have a server named Contoso with multiple databases.
You have been tasked to write a PowerShell script to determine which databases on the server are larger than 100GB.
You open PowerShell from SQL Server Management Studio. You create two variables as follows:
PS SQLSERVER:SQLContoso> $MultipleOfGB = 1024 * 1024
PS SQLSERVER:SQLContoso> $Server = Get-Item
You need to determine which script will produce the desired list of databases.
What script should you use?
Which Transact-SQL statement should you use?
Your company manufactures and distributes bowling balls. You have a full-text catalog named ftCatalog which contains the ftInventory index on the Products table. Your marketing department has just inserted a new bowling ball into the Inventory table. You notice only the new bowling ball is not being included in the results of the full-text searches. You have confirmed that the row exists in the Products table. You need to update the full-text catalog in the least amount of time. Which Transact-SQL statement should you use?
Which Transact-SQL statement should you use?
Your company manufactures and distributes bicycle parts. You have a full-text catalog on the Inventory table which contains the PartName and Description columns. You also use a full-text thesaurus to expand common bicycle terms. You need to write a full-text query that will not only match the exact word in the search, but also the meaning.
Which Transact-SQL statement should you use?