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.)

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You administer a Microsoft SQL Server 2012 database named Human_Resources.
You need to ensure that all read activity against any object in the Human_Resources database is audited and written to a text file.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

Explanation:
Create a new Audit. For destination, select File.
Create a new Database Audit Specification on Human_Resources. For Audit Action Type,
select Select, and for Object Class, select Database.
Enable Audi and Audi Specification.
The general process for creating and using an audit is as follows. Create an audit and define the target. Create either a server audit specification or database audit specification that maps to the audit. Enable the audit specification. Enable the audit. Read the audit events by using the Windows Event Viewer, Log File Viewer, or the fn_get_audit_file function.
References: https://msdn.microsoft.com/en-us/library/cc280386%28v=sql.110%29.aspx https://msdn.microsoft.com/en-us/library/cc280663%28v=sql.110%29.aspx
-- --

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer all the deployments of Microsoft SQL Server in your company.
You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.
You also need to minimize the amount of storage used by the database.
Which configuration should you use?

• A.Two servers configured in the same data center
  A primary server configured to perform log-shipping every 10 minutes
  A backup server configured as a warm standby
• B.Two servers configured in different data centers
  SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
• C.Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance
• D.Two servers configured in the same data center
  SQL Server Availability Group configured in Asynchronous-Commit Availability Mode One server configured as an Active Secondary
• E.SQL Server that includes an application database configured to perform transactional replication
• F.SQL Server that includes an application database configured to perform snapshot replication
• G.Two servers configured on the same subnet
  SQL Server Availability Group configured in Synchronous-Commit Availability Mode
• H.Two servers configured in different data centers
  SQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary

Comment: *

Name: *

Email: *

Verification: *

You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that data changes are sent to a non-SQL Server database server in near real time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?

• A.SQL Server that includes an application database configured to perform transactional replication
• B.Two servers configured in different data centers
  SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
• C.Two servers configured in different data centers
  SQL Server Availability Group configured in Synchronous-Commit Availability Mode
  One server configured as an Active Secondary
• D.SQL Server that includes an application database configured to perform snapshot replication
• E.Two servers configured in the same data center
  SQL Server Availability Group configured in Asynchronous-Commit Availability Mode
  One server configured as an Active Secondary
• F.Two servers configured on the same subnet
  SQL Server Availability Group configured in Synchronous-Commit Availability Mode
• G.Two servers configured in a Windows Failover Cluster in the same data center
  SQL Server configured as a clustered instance
• H.Two servers configured in the same data center
  A primary server configured to perform log-shipping every 10 minutes
  A backup server configured as a warm standby

Comment: *

Name: *

Email: *

Verification: *

You administer a Microsoft 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?

• A.Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to the role. Add all users to the role.
• B.Add all users to the db_datawriter role. Add all users to the db_datareader role.
• C.Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.
• D.Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Add all users to the role. Add all users to the db_datareader role.

Comment: *

Name: *

Email: *

Verification: *