A database administrator is assisting developers with finding the best tables and columns to include in an application. Which of the following resources is the most relevant for this task?

Question

Options

• ATransaction log
• BERD
• CData dictionary
• DSOP documents

• B
  3% (1)
• C
  88% (30)
• D
  9% (3)

Explanation

A data dictionary is correct because it is a centralized repository of metadata that describes every table, column, data type, constraints, relationships, and business definitions in a database - exactly what developers need to identify which tables and columns to use in an application. A transaction log records a history of database operations for recovery and auditing purposes, not for understanding schema structure. An ERD (Entity-Relationship Diagram) shows relationships between tables visually but does not provide detailed column-level metadata like data types, allowed values, or business rules. SOP documents (Standard Operating Procedures) describe operational processes and policies, not database structure details.

Memory tip: Think of a data dictionary as a "dictionary for your data" - just as a word dictionary tells you what a word means and how to use it, a data dictionary tells you what each field means and how to use it in your application.

No community discussion yet for this question.