Topic 1, Scenario 1
Application Data
You are employed as a developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
ABC.com has two servers, named ABC-SR13 and ABC-SR14, which are running SQL Server
2012. ABC.com wants to makes use of a recently developed application to plan and run music
concerts. However, users inform you that errors exist, and that the application reacts sluggishly.
You have been tasked with making sure that the related problems are sorted out. You intend to
develop a database to reinforce the application. This database will be hosted on ABC-SR13.
You have instructed a junior database developer to generate a script for creating tables, a script
for creating stored procedures, and a script for creating indexes.
ABC-SR14 hosts a database, named Concerts. The Concerts database includes a table, named
ArtistReview, which will review modifications to a table named Artists.
An existing stored procedure, named usp_UpdateArtistsName, will be only implemented by other
stored procedures that continuously deal with transactions. The names of Artists will be retrieved
via another existing stored procedure, named usp_SelectArtistsByName, which is also configured
to read uncommitted data. sessions taking place at some point will be retrieved via stored
procedure, named usp_GetFutureSessions.
********************************************************

You have been instructed to make sure that the auditing requirements of usp_UpdateArtistName
are supported by ABC-SR13.
Which of the following actions should you take?

A.
You should consider including the Distributed Transaction Coordinator (DTC) in the solution.

B.
You should consider including the Kernel Transaction Manager Resource Manager in the
solution.

C.
You should consider including the Remote Procedure Call (RPC) service (RpcSs) in the
solution.

D.
You should consider including the Component Object Model (COM) in the solution.

Explanation: