070-459 試験問題を無料オンラインアクセス

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.Create a trace in SQL Server Profiler that contains the Deadlock graph event.
• B.Create an extended events session to capture deadlock information.
• C.Query the sys.dm_exec_requests dynamic management view.
• D.Query the sys.dm_exec_sessions dynamic management view.

DRAG DROP
You need to create the usp_AssignUser stored procedure.
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 have a table named ORDERS that contains 10,514,003 Orders. The ORDERS table has an IDENTITY (1,1) column named ORDERID. ORDERID is the UNIQUE CLUSTERED INDEX and PRIMARY KEY for the table. The first ORDERID is 1. There are no missing ORDERIDs in the set.
Based on table usage patterns, you decide to use partitioning on this table based off of the ORDERID column.
You need to create the following partitions:

Which code should you use to create the partition function?

• A.Option B
• B.Option D
• C.Option A
• D.Option C

You have a server named Server1 that has 16 processors.
You plan to deploy multiple instances of SQL Server 2012 to Server1.
You need to recommend a method to allocate processors to each instance.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Processor affinity
• B.Resource Governor
• C.Max Degree of Parallelism
• D.Windows System Resource Manager (WSRM)

You plan to create a database.
The database will be used by a Microsoft .NET application for a special event that will last for two days.
During the event, data must be highly available.
After the event, the database will be deleted.
You need to recommend a solution to implement the database while minimizing costs. The solution must not affect any existing applications.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.SQL Server 2012 Enterprise
• B.SQL Azure
• C.SQL Server 2012 Express with Advanced Services
• D.SQL Server 2012 Standard