Microsoft
70-450 · Question #95
70-450 Question #95: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance. The instance runs on a computer that has the following features: - A 64-GB RAM - Four quad-core processors - Several independent physical raid volumes You plan to implement a transactional database on the instance. The database is expected to have a high volume of INSERT, UPDATE, and DELETE activities. The activities include creation of new tables. You need to optimize the performance of the database by maximizing disk bandwidth and reducing the contention in the storage allocation structures. What should you do?
Options
- ACreate multiple data files for the database.
- BPlace database and log files on the same volume.
- CConfigure the affinity mask option appropriately.
- DConfigure the affinity I/O mask option appropriately.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.