Certified Data Management Professional – Fundamentals (CDMP) — Question 138

Where is the best place to find the following metadata: database table names, column names and indexes?

Answer options

• A. Security access authorisation
• B. Enterprise data model
• C. Database catalogue
• D. Detailed business processes
• E. Logical data model -

Correct answer: C

Explanation

The correct answer is C, as the database catalogue contains detailed information about the structure of the database, including table names, column names, and indexes. The other options, such as the enterprise data model and logical data model, provide higher-level abstractions and do not focus specifically on the database's internal schema.