You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing a query hint
argument that instructs the query optimizer to make use of statistical data instead of the initial
values for all local variables when the query is compiled and optimized.
Which of the following is the argument being discussed?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the benefits

of using table-valued parameters.
Which of the following are benefits of using table-valued parameters?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing tablevalued parameters.
Which of the following is TRUE with regards to table-valued parameters

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing a query hint

argument that instructs the query optimizer to make use of a particular value for a local variable
when the query is compiled and optimized.
Which of the following is the argument being discussed?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing a TransactSQL management command that ends a user procedure that is based on the session ID or unit of
work.
Which of the following is the command being discussed?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. You have been
instructed to create a foreign key relationship between two ABC.com tables.

Which of the following describes limitations or restrictions with regards to foreign key constraints
for this scenario? (Choose all that apply.)

CORRECT TEXT
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the process
of signing stored procedures in SQL Server 2012.
Which of the following can be used to sign stored procedures? (Choose two.)

You work as a database developer at ABC.com. The ABC.com network consists of a single
domain named ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. You have received

instructions to create a user-defined function.
Which of the following is TRUE with regards to user-defined functions? (Choose all that apply.)

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing a TransactSQL management command that updates the currently configured value of a configuration option
changed with the sp_configure system stored procedure.
Which of the following is the command being discussed?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing a query hint
argument that instructs the SQL Server Database Engine to discard the plan generated for the
query after it executes.
Which of the following is the argument being discussed?