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 are in the process of writing code to create a table, named Performers. The table will include
a stored procedure, named usp_ PerformersReport.
You have to make sure that the code allows for a reduction in the length of time required for usp_
PerformersReport to complete.
Which of the following should be included in the code?
A.
The nvarchar data type.
B.
The bit data type.
C.
The int data type.
D.
The char data type.
Explanation:
?