nerdexam
CompTIA

SK0-004 · Question #844

An administrator is sizing a new server for a 500GB database application. Which of the following components on the server will provide the BEST performance?

The correct answer is C. RAM. For a 500GB database application, RAM provides the best performance by allowing the database engine to cache large data sets in memory, dramatically reducing disk I/O.

Server administration

Question

An administrator is sizing a new server for a 500GB database application. Which of the following components on the server will provide the BEST performance?

Options

  • ADisk
  • BProcessor
  • CRAM
  • DNetwork card

How the community answered

(54 responses)
  • A
    6% (3)
  • B
    9% (5)
  • C
    83% (45)
  • D
    2% (1)

Why each option

For a 500GB database application, RAM provides the best performance by allowing the database engine to cache large data sets in memory, dramatically reducing disk I/O.

ADisk

Disk speed affects read/write throughput, but RAM caching reduces disk access frequency so dramatically that disk alone is not the best single performance lever.

BProcessor

The processor handles query execution and sorting, but database workloads are typically memory-bound before they are CPU-bound.

CRAMCorrect

Database engines use RAM to cache table data, indexes, and query results, minimizing slow disk reads. With a 500GB database, maximizing RAM allows more of the working data set to reside in memory, which is orders of magnitude faster than any storage medium. RAM is consistently the most impactful hardware component for database server performance tuning.

DNetwork card

The network card affects data transfer speed to clients but is rarely the bottleneck for a server-side database application.

Concept tested: RAM sizing for database server performance

Source: https://learn.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide

Topics

#server sizing#RAM#database performance#capacity planning

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice