Microsoft
70-451 · Question #128
70-451 Question #128: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #128. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains a table that has two partitions. The first partition contains the current data, and the second partition contains historical data. There is a high frequency of data manipulation on the current data. The testers report that they are frequently unsuccessful in querying the historical data only. You discover that locks are being escalated to the table-level lock. You need to ensure that without modifying the SELECT statements, you enable users to query the historical data. You want to achieve this goal by using the minimum amount of administrative effort and minimally affecting other queries. What should you do?
Options
- AUse the ALTER TABLE ... SET (LOCK_ESCALATION = AUTO) command.
- BMove the historical partition to a read-only filegroup.
- CSet the Server Startup Parameters to include -T1211.
- DSet DEADLOCK PRIORITY to HIGH.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.