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.
An existing database includes a table whose ID column has a clustered index definition. You are in
the process of creating a script to generate a stored procedure that should allow for the number of
locks and deadlocks to be reduced.
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.
You have created a new table in an existing database. You want to make sure that a user-defined
function is called to validate the row prior to a new row being added to the table.

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 subscribes to SQL Azure, which hosts a ABC.com database used for Online
Transaction Processing (OLTP).
A table in the database contains an index that makes use of too much physical disk space. You
have been instructed to make sure that the physical disk space used by the index is reduced.
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. ABC.com subscribes to
SQL Azure, which hosts a ABC.com database.
You have received instructions to create a new application for ABC.com. The new application
must be configured to store data in the ABC.com database on a temporary basis.

To achieve this, you have to pinpoint the database object type that should be employed for hosting
the application data. You are then informed that your strategy allows for the application to modify
the schema of a temporary object during a session.
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 that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should be allow dirty reads and ABCSPB should be configured to place range locks on
the data to guarantee read reliability.
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 used for Online

Transaction Processing (OLTP).
A table in the database contains an index. You have found that inserting or updating records in the
table results in numerous page splits taking place.
You want to make sure that page splits are reduced.
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.
You have created a new table in an existing database. You want to make sure that a table, which
is used for auditing, is updated whenever a row is added to the table.
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 subscribes to SQL Azure, which hosts a ABC.com database.
You are preparing to generate an indexed view. You are informed that the necessary keyword
should be used to achieve this.
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 that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should accept a parameter that guarantees numerous rows of data can pass into the
stored procedure. ABCSPB should be configured to make use of business logic, which exists in a
Microsoft .NET Framework assembly.
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 makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should allow for a table to be returned and ABCSPB should be configured to yield a
scalar value.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)