Microsoft 70-462 Administering Microsoft SQL Server 2012 Databases Online Training
Microsoft 70-462 Online Training
The questions for 70-462 were last updated at Nov 20,2024.
- Exam Code: 70-462
- Exam Name: Administering Microsoft SQL Server 2012 Databases
- Certification Provider: Microsoft
- Latest update: Nov 20,2024
You are the administrator of a Microsoft SQL Server database server.
Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications
You need to dynamically limit resource consumption.
What should you do?
- A . Create a new Plan Guide with a Scope Type of sql and define the resource limits for each application.
- B . Enable the Resource Governor, and then configure Resource Pools, Workload Groups, and Classifier Function.
- C . Configure SQL Activity Monitor to define resource limits for each application type.
- D . Configure Extended Events to monitor and restrict resource limits allowed by each application type.
You administer a Microsoft SQL Server database that includes a table named dbo.Log. This table contains millions of records about user activity in an application.
Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.
You need to be able to modify dbo.Log without requiring any changes to the applications that utilize dbo.Log.
Which type of solution should you use?
- A . Extended events
- B . Columnstore index
- C . Partitioned tables
- D . Read committed snapshot
You administer a Microsoft SQL Server database named Orders.
Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause.
You need to gather more data to be able to determine which processes are being blocked and to identify the root cause.
What should you do?
- A . Schedule a SQL Agent job to run every 60 seconds and insert the results of executing the sp_who2 stored procedure into a table.
- B . Use System Monitor to catch the Lock Wait Time event.
- C . Start a trace using SQL Server Profiler to catch the Lock: Timeout event.
- D . Use sp_configure to set the blocked process threshold. Start a trace using SQL Server Profiler to catch the Blocked Process Report event.
You administer a Microsoft SQL Server database. Users report that a billing application becomes unresponsive during busy times of the day. While investigating, you notice large number of processes taking or waiting for table locks. You suspect that SQL Server is assigning stronger locks to queries. You start a SQL Profiler trace.
Which event should you select?
- A . Deadlock graph
- B . Lock: Escalation
- C . Lock: Timeout
- D . Lock: Deadlock
Latest 70-462 Dumps Valid Version with 301 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
