Which of the following does a database administrator need to know before planning the setup of a new server for a client?

Question

Options

• AThe performance of the server
• BThe size and importance of the server
• CThe connectivity status of the server
• DThe transaction logs for the server

• A
  5% (1)
• B
  82% (18)
• C
  5% (1)
• D
  9% (2)

Explanation

Option B is correct because before planning a new server setup, a DBA must first understand the scope of what they're building - how much data it will hold (size) and how critical it is to the business (importance). These factors drive every major decision: hardware specs, redundancy, backup strategies, and security controls.

Why the others are wrong:

• A (Performance) - Performance targets can only be determined after knowing the size and importance; you can't plan for performance in a vacuum.
• C (Connectivity status) - Connectivity is configured during setup, not a prerequisite for planning it; also, a new server has no connectivity status yet.
• D (Transaction logs) - Transaction logs are generated after a server is running and are used for auditing/recovery, not initial planning.

Memory tip: Think "size and importance = scope first." Just like building a house, you need to know how big it is and how it'll be used before you buy materials or hire contractors.

No community discussion yet for this question.