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?

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?

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 WAN link with a network latency of
more than 200ms.
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 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 supports dirty reads.
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.
The sales and marketing departments contain a total of 60 users. Each user uses a custom
application that stores data in a SQL Server database. Each user has a separate database.

A server named ABC-SQL1 hosts the 60 databases.
You need to configure a backup solution for all the databases. The solution must ensure
that any new databases configured on ABC-SQL1 are automatically added to the backup
schedule.
The backup schedule consists of a full backup every night, a differential backup every hour
and a transaction log backup every 15 minutes.
How should you configure the backup solution?

You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
Computer users use custom applications that store data in SQL Server databases hosted
on a server named ABC-SQL1.
You discover that the Windows Application event log on ABC-SQL1 contains error events.
You need to configure a solution that will run an application whenever an event with a
specific event ID number is generated in the Windows Application event log.
What should you configure?

You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You plan to deploy three new servers running SQL Server 2012 Standard Edition.
You need to configure the three servers to host databases that must be highly available.
Automatic failover is required in the event of a server failure.
Which of the following SQL Server features should you configure?

You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You plan to deploy a new SQL Server named ABC-Dev1. The server will be used by users
in the Development department for testing their applications.

You need to ensure that all stored procedures start with “usp_” to comply with the
company naming convention.
How can you ensure that stored procedures on ABC-Dev1 comply with the company
naming convention?

You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
You need to create a table for a database. The table will have between 1 million and 5
million rows. The table will have columns that have null-valued rows 70% of the time.
You need to optimize the table so that the storage space used for each row is minimized.
What should you do?

You work as a Database Administrator (DBA) for a company named ABC.com. The
company has a Windows Azure subscription. The company uses a cloud-based SQL
Server environment hosted on SQL Azure.
Developers in your company are creating an ecommerce web site. You are designing a
database for the website. The database will be hosted on SQL Azure.
The database will store and reuse web site login details and customer credit card numbers.
You need to ensure the usernames, passwords and credit card details are securely stored
in the database.
Which of the following would be most suitable secure storage solution?