You need to configure FullText
Search to ignore specific words. Which FullText

Search component
should you use?

Your company manufactures and distributes bicycle parts. You have a fulltext
catalog on the
Inventory table which contains the PartName and Description columns. You also use a fulltext
thesaurus
to expand common bicycle terms. You need to write a fulltext
query that will not only match the exact
word in the search, but also the meaning.
Which TransactSQL
statement should you use?

Your company manufactures and distributes bowling balls. You have a fulltext
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 fulltext
searches. You have confirmed that the row exists in the Products
table. You need to update the fulltext
catalog in the least amount of time.
Which TransactSQL
statement 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:\SQL\Contoso> $MultipleOfGB = 1024 * 1024
PS SQLSERVER:\SQL\Contoso> $Server = GetItem
You need to determine which script will produce the desired list of databases.
What script 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:\SQL\CONTOSO\DEFAULT\Databases\ReportServer\Tables\dbo.Inventory\Columns>
Using the SQL Server Windows PowerShell provider, you need to query all the columns in the table.
Which cmdlet should you use?

You are configuring Service Broker to process messages within a single database. You have
performed the following steps.
1. CREATE MESSAGE TYPE
2. CREATE CONTRACT
3. CREATE QUEUE
You need to complete the Service Broker configuration. What should be the next step?

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 TransactSQL
statement should you use?

You created a Service Broker queue by using the following TransactSQL
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 TransactSQL
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 TransactSQL
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?