DRAG DROP
You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso
database has a table named EmployeeSalary in a schema named HumanResources.
You need to create a script that writes audit events into the application log whenever data in the
EmployeeSalary table is modified.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements
from the list of statements to the answer area and arrange them in the correct order.)

DRAG DROP
You administer a Microsoft SQL Server 2012 database called Human_Resources. The database
contains a table named dbo.Salary.
You need to ensure that all read activity against dbo.Salary is audited and written to the Windows
Security Log.
What should you do? (To answer, move the three appropriate actions from the list of actions to the
answer area and arrange them in the correct order.)

You install Microsoft SQL Server 2012 on a new server.
After setup is complete, you attempt to start the SQL Server service. After being in a starting state
for a few moments, the service goes back to a stopped state.
You need to determine the cause of the failure.
Which file should you use?

DRAG DROP
You administer a Microsoft SQL Server 2012 database.
The database contains a schema named CUSTOMER. CUSTOMER contains several tables and views
with sensitive data, as well as various stored procedures and functions.
In order to configure security for CUSTOMER, you need to determine how to meet the security
requirements listed in the answer area.
Which command or commands should you use? (To answer, drag the appropriate command or
commands to their corresponding security requirement or requirements in the answer area. Answer
choices may be used once, more than once, or not at all. Answer targets may be used once or not at
all. Additionally, you may need to drag the split bar between panes or scroll to view content.)

DRAG DROP
You administer a Microsoft SQL Server 2012 server along with a Windows Azure SQL Database
database.
For both servers, you need to grant users the ability to create logins and create databases.
You need to determine which permission to grant users in each instance.
Which permission or permissions should you choose? (To answer, drag the appropriate permission
or permissions to their corresponding instance type or types in the answer area.
Answer choices may be used once, more than once, or not at all. Answer targets may be used once
or not at all. Additionally, you may need to drag the split bar between panes or scroll to view
content.)

You administer a Windows Azure SQL Database database named Inventory that contains a stored
procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?

You administer a SQL Server 2012 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?

You administer a Windows Azure SQL Database database named Human_Resources. The database
contains 2 tables named Employees and SalaryDetails.
You add two Windows groups as logins for the server:
CORP\Employees – All company employees

CORP\HRAdmins – HR administrators only
HR Administrators are also company employees.
You need to grant users access according to the following requirements:
CORP\Employees should have SELECT access to the Employees table.
Only users in CORP\HRAdmins should have SELECT access to the SalaryDetails table.
Logins are based only on Windows security groups.
What should you do?

You administer a Microsoft SQL Server 2012 database instance.
You plan to migrate the database to Windows Azure SQL Database. You verify that all objects
contained in the database are compatible with Windows Azure SQL Database.
You need to ensure that database users and required server logins are migrated to Windows Azure
SQL Database.
What should you do?

You administer a Microsoft SQL Server 2012 database named Orders.
Orders contains a table named OrderShip that is defined as follows:

A NULL value represents a domestic order. Ninety percent of the values in CountryCode are NULL.
Customers require a procedure that will return orders for all customers from a specified country.
You create a new procedure:

Performance on this procedure is slow.
You need to alter the schema to optimize this query. Objects created must use a minimum amount
of resources.
Which Transact-SQL statement should you use?