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 writing code to add a column, named Verified, to the Performers table. The column should
allow for disk space usage to be reduced, and have a default value of False.
Which of the following actions should you take?

A.
You should consider adding an int column.

B.
You should consider adding a bit column.

C.
You should consider adding a char column.

D.
You should consider adding an nvarchar column.

Explanation: