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.)
Which of the following solutions would meet the encryption requirement?
You work as a Systems Administrator at a company named ABC.com. You are in the
process of deploying new servers running SQL Server 2012.
You need to deploy a SQL Server 2012 server to host databases used by the Research and
Development department. The databases used by the Research and Development
department will store sensitive data.
A company security policy states that if Research and Development department database
files and log files are moved to another server, the files must be encrypted.
Which of the following solutions would meet the encryption 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 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.)
You need to ensure that you can copy the database from ABC-SQL1 to ABC-SQL2 and that users can access the data
Your role as a Database Administrator (DBA) at ABC.com includes the management of the
Microsoft SQL Server 2012 database server infrastructure. All servers are members of a
single Active Directory Domain Services (AD DS) domain named ABC.com.
A database server named ABC-SQL1 runs Microsoft SQL Server 2012. You plan to create a
database on ABC-SQL1. Database users have logins configured on ABC-SQL1. The
database will be configured to use SQL Server 2012 authentication.
A recently installed database server named ABC-SQL2 also runs Microsoft SQL Server
2012. Only the default logins have been created on ABC-SQL2.
You need to ensure that you can copy the database from ABC-SQL1 to ABC-SQL2 and that
users can access the database without the need to configure logins for the users.
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 instance in their environment.
ABC.com’s SQL Server 2012 instance includes a single-user database that has no user-created
stored procedures or user-created functions configured. You have been instructed to make sure
that the memory used for query plan caching is reduced.
Which of the following actions should you take?
Which of the following failover types should you configure for the availability group?
You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You are configuring a highly-available database solution using an AlwaysOn availability
group on two servers running SQL Server 2012. The two servers are in separate
datacenters. The two datacenters are connected by a fast WAN link with a network latency
of less than 10ms.
Which of the following failover types should you configure for the availability group?
Which of the following is the correct Transact-SQL statement for achieving your goal?
You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. These tables are
configured to contain a single index for every column.
When you are informed that item creation is slow, you decide to find unused indexes.
Which of the following is the correct Transact-SQL statement for achieving your goal?
Which of the following should you configure to meet the requirement?
You work as a Database Administrator (DBA) at ABC.com. The company has a SQL Server
2012 environment.
You have a requirement for a temporary application that stores data in a database. The
database must be highly available for one week while it is in use after which time the
database and application will be deleted.
You need to implement the database in the existing SQL Server environment whilst
ensuring that other databases are not affected.
Which of the following should you configure to meet the requirement?
Which of the following are data types that cannot be identified as SPARSE?
You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the
properties of sparse columns.
Which of the following are data types that cannot be identified as SPARSE? (Choose all that
apply.)
What should you do?
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. CorpDB contains 2TB of data.
You plan to import a large amount of data into tables in CorpDB. You want to minimize the
size of the transaction log while the data is imported.
What should you do?