Which of the following indicates why a data administrator would conduct a baseline configuration in a database?

Question

Options

• ATo have an agreed-upon description of the attributes of a database at a point in time
• BTo establish if the updates in the database are causing defects
• CTo check if the tables, rows, and columns in the database are correctly structured
• DTo improve performance of applications in the database

• A
  88% (21)
• B
  8% (2)
• D
  4% (1)

Explanation

A baseline configuration is a formally agreed-upon snapshot of a database's attributes (structure, settings, and state) at a specific point in time - making A correct. This baseline serves as a reference point for change management, auditing, and compliance, not as a diagnostic or performance tool.

Why the distractors are wrong:

• B describes regression testing or change impact analysis, not baselining - comparing updates against a baseline is a use of the baseline, not the purpose of creating one.
• C describes schema validation or data quality checks, which is a structural audit, not a configuration baseline.
• D describes performance tuning or query optimization, an entirely different administrative activity.

Memory tip: Think of "baseline" like a photograph - you take it to capture what something looks like at this moment, so you can compare against it later. A database baseline is that photograph of configuration, not a test, a check, or a fix.

No community discussion yet for this question.