Microsoft
70-450 · Question #95
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…
The correct answer is A. Create multiple data files for the database. See the full explanation below for the reasoning.
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.
How the community answered
(39 responses)- A72% (28)
- B5% (2)
- C15% (6)
- D8% (3)
Community Discussion
No community discussion yet for this question.