You admi

nister a Microsoft SQL Server 2012 instance.

The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week.

You plan to define a

backup strategy for the database. You need to ensure that the following requirements are met:

No more than 5 minutes worth of transactions are lost.

Data can be recovered by using the minimum amount of administrative effort.

What should you do? Choose

all that apply.

A. Configure the database to use the SIMPLE recovery model.

B. Create a DIFFERENTIAL database backup every 4 hours.

C. Create a LOG backup every 5 minutes.

D. Configure the database to use the FULL recovery model.

E. Create a FULL database

backup every 24 hours.

F. Create a DIFFERENTIAL database backup every 24 hours.

You administer a Microsoft SQL Server 2012 instance.

You need to configure a new database to support FILETABLES.

What should you do? Cho

ose all that apply.

A. Disable FILESTREAM on the Database.

B. Enable FILESTREAM on the Server Instance.

C. Configure the Database for Partial Containment.

D. Create a non-empty FILESTREAM file group.

E. Enable Contained Databases on the Server Instance.

F

. Set the FILESTREAM directory name on the Database.

Reference:

You administer a Microsoft SQL Server 2012 instance.

You discover that the SQL Agent Error Log file is rapidly growing in size.

You need to ensure that the SQL Agent Erro

r Log file does not grow rapidly when SQL Server agent jobs execute.

What should you do?

A. Execute the sp_cycle_agent_errorlog stored procedure.

B. Configure event forwarding.

C. Enable the Auto Shrink option on the master database.

D. Enable the Auto S

hrink option on the msdb database.

E. Disable the Include execution trace messages feature.