DRAG DROP
You administer a SQL Server 2014 instance.
The server is capable of 10000 IO/second (IOPS). During the time period when the second process executes, the disk IO can reach 7000 IOPS, and CPU use can average 30% over the eight processors.
The first process summarizes the day's activity executed by a login of [SummaryReportLogin]. The second process submits transactions executed by a login of [ETLLogin].
A Resource Governor classifier function has been created to return WG_Low for connections from the [ETLLogin] and [SummaryReportLogin].
You need to set up the Resource Group and Workgroup Pools on the instance.
You have the following requirements:
- Both processes must never use more than 50 percent of the CPU at any one time. - The number of active queries that these processes can execute simultaneously should be limited to a maximum of 10. - The SummaryReportLogin process must always achieve the minimum IOPS required to be minimally affected during executing the ETLLogin processes.
Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.

You execute the following code:

You create a nonclustered index named IXCustomerName on the CustomerName column. You execute the following query:

You need to reduce the amount of time it takes to execute the query.
What should you do?

• A. Replace LEFT(CustomerName ,1) = 'a' with SUBSTRING(CustomerName ,1,1) - 'a'.
• B. Replace LEFT(CustomerName ,1) = 'a' with CustomerName LIKE 'a%'.
• C. Replace IX_CustomerName with a clustered index.
• D. Partition the table and use the CustomerName column for the partition scheme.

You need to configure security on the Product table for customer support representatives.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

• A. Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice.
• B. GRANT SELECT on CustProduct TO OurDomain\CustomerSupport.
• C. Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice.
• D. Create a view called CustProduct that includes columns ProductID. ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierID.
• E. GRANT ALL on CustProduct TO OurDomain\CustomerSupport
• F. GRANT SELECT on CustProduct TO public.

You are troubleshooting an application that runs a query. The application frequently causes
deadlocks.
You need to identify which transaction causes the deadlock.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

• A. Query the sys.dm_exec_sessions dynamic management view.
• B. Query the sys.dm_exec_requests dynamic management view.
• C. Create an extended events session to capture deadlock information.
• D. Create a trace in SQL Server Profiler that contains the Deadlock graph event.