You administer 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 FULL recovery model.
• B. Create a DIFFERENTIAL database backup every 24 hours.
• C. Configure the database to use the SIMPLE recovery model.
• D. Create a FULL database backup every 24 hours.
• E. Create a DIFFERENTIAL database backup every 4 hours.
• F. Create a LOG backup every 5 minutes.

You develop a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerId . You need to create a query that meets the following requirements:
Returns the CustomerName for all customers and the OrderDate for any orders that they have placed.
Results must not include customers who have not placed any orders. Which Transact-SQL query should you use?

• A. SELECT CustomerName, OrderDate FROM Customers CROSS JOIN Orders ON Customers.CustomerId = Orders.CustomerId
• B. SELECT CustomerName, OrderDate FROM Customers JOIN Orders ON Customers.CustomerId = Orders.CustomerId
• C. SELECT CustomerName, OrderDate FROM Customers LEFT OUTER JOIN Orders ON Customers.CuscomerlD = Orders.CustomerId
• D. SELECT CustomerName, OrderDate FROM Customers RIGHT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerId

You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.

• A. Set the FILESTREAM directory name on the Database.
• B. Disable FILESTREAM on the Database.
• C. Configure the Database for Partial Containment.
• D. Create a non-empty FILESTREAM file group.
• E. Enable Contained Databases on the Server Instance.
• F. Enable FILESTREAM on the Server Instance.

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to prevent users from disabling server audits in Server01. What should you create?

• A. an Alert
• B. a Resource Pool
• C. a SQL Profiler Trace
• D. a Policy
• E. a Server Audit Specification
• F. an Extended Event session
• G. a Database Audit Specification

You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server. You need to create a server role named SpecialDBARole that can perform the following functions:
View all databases.
View the server state.
Assign GRANT, DENY, and REVOKE permissions on logins.
You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary. Which SQL statement or statements should you use? Choose all that apply.

• A. ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs];
• B. GRANT VIEW DEFINITION TO [SpecialDBARole];
• C. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin;
• D. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin;
• E. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin;
• F. GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole];