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?
How should you troubleshoot the issue?
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
Company developers are testing a custom application. The developers report that
deadlocks often occur when the application runs a query. The developers have asked you
to help identify which transaction is causing the deadlocks.
How should you troubleshoot the issue?
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.)
Which of the following is the best solution to meet the requirement?
You work as a Database Administrator (DBA) at ABC.com. The company has a SQL Server
2008 R2 environment.
You have a requirement for a temporary database that requires the features of SQL Server
2012. The database must be highly available for one week while it is in use after which time
the database will be deleted.
Your solution must not affect the current SQL Server environment.
Which of the following is the best solution to meet the requirement?
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. 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 need to ensure that the no other transactions can modify data that has been read by the stored procedure u
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. You plan to create a stored procedure to access data
in CorpDB.
You need to ensure that the no other transactions can modify data that has been read by
the stored procedure until the current transaction completes.
What should you do?
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 need to ensure that the stored procedure cannot perform dirty reads
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. You plan to create a stored procedure to access data
in CorpDB.
You need to ensure that the stored procedure cannot perform dirty reads.
What should you do?
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?
Which two of the following actions would meet the backup and recovery requirements whilst ensuring the regular
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB.
A full backup of CorpDB is taken every week.
A differential backup of CorpDB is taken every night at midnight.
A transaction log backup of CorpDB is taken at 8am, 12pm, 4pm and 8pm.
You plan to deploy some changes to CorpDB at after the 4pm log backup completes. You
need to ensure that you can undo the changes quickly if the deployment fails. During the
deployment of the changes, no other changes must be made by users to the database.
You need a backup and recovery strategy for deploying the changes.
Which two of the following actions would meet the backup and recovery requirements
whilst ensuring the regular backup schedule is not disrupted? (Choose two).