You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com stores information consumed by ABC.com’s e-commerce application via SQL
Azure.
You have generated a stored procedure, which is employed to read and modify the value of all the
goods offered on ABC.com’s e-commerce site. You have been instructed to make sure that while
the stored procedure executes, other transactions are prevented from updating goods information.

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has a database, whose log file has reached capacity. You are instructed to make sure
that the database is able to successfully conclude transactions without having an effect on the
chain of log sequence numbers (LSNs).

Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has a database, which is hosted on a SQL Server 2012 instance, and supports an
essential business web application. The web application dynamically creates all T-SQL statements
without the use of stored procedures.
You have received instructions to increase the available data caching memory.
Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has a SQL Server 2012 database table that includes a million rows. You have
configured a column in the table with a columnstore index.

Which of the following is TRUE with regards to columnstore indexes?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has a server, named ABC-SR13, which runs SQL Server 2012. You are instructed to
find out what parallel execution plans are processing serially.
Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
You have been informed of several deadlocks on an existing ABC.com database, named
ABCDB1. You have been tasked with devising a strategy to examine the deadlocks in real-time.
The strategy should allow for trouble-free enabling and disabling, and also allow monitored
information to be queried.

Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures. The
stored procedures will be named ABCSPA and ABCSPB. ABCSPA should be configured to return
a table and ABCSPB should be configured to return status code.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com subscribes to SQL Azure, which hosts a ABC.com database.
You are in the process of creating a script to generate a view. This view is intended for updating
table data.

You have been instructed to make sure that view is able to update table data, but not the data in a
specific column.
Which of the following is the option that should be included in the code?

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 CHECK
OPTION of the CREATE VIEW Transact-SQL statement.
Which of the following is TRUE with regards to the CHECK OPTION?

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 XML
schema collections.

Which of the following is TRUE with regards to XML schema collections?