Microsoft 070-765 : Provisioning SQL Databases

You plan to deploy two new Microsoft Azure SQL Database instances. Once instance will support a data entry application. The other instance will support the company's business intelligence efforts. The databases will be accessed by mobile applications from public IP addresses.
You need to ensure that the database instances meet the following requirements:
The database administration team must receive alerts for any suspicious activity in the data entry database, including potential SQL injection attacks.
Executives around the world must have access to the business intelligence application.
Sensitive data must never be transmitted. Sensitive data must not be stored in plain text in the database.
In the table below, identify the feature that you must implement for each database.
NOTE: Make only one selection in each column. Each correct selection is work one point.

You develop a Microsoft SQL Server 2014 database that contains a heap named OrdersHistorical.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?

• A. XLOCK
• B. HOLDLOCK
• C. UPDLOCK
• D. ROWLOCK
• E. TABLOCK

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.
Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
You need to create the templates.
Solution: You use Visual Studio to create a JSON template that defines the deployment and configuration settings for the SQL Server environment.
Does the solution meet the goal?

• A. Yes
• B. No

You have a Microsoft Azure SQL Database server named server1-contoso.database.windows.net in a resource group named RG1.
You need to create an elastic pool.
How should you complete the script? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You administer a Microsoft SQL Server 2014 server. One of the databases on the server supports a highly active OLTP application.
Users report abnormally long wait times when they submit data into the application.
You need to identify which queries are taking longer than 1 second to run over an extended period of time.
What should you do?

• A. Run the sp_who command from a query window.
• B. Use sp_configure to set a value for blocked process threshold. Create an extended event session.
• C. use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000.
• D. Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step.
• E. Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.