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

A schema is:

Answer options

• A. A logical data model
• B. A business conceptual data model
• C. A database object that increases performance of an application
• D. A subset of the overall database for security and/or operational purposes
• E. A plot to achieve better data governance

Correct answer: D

Explanation

The correct answer is D, as a schema can represent a subset of the database intended for specific security or operational functions. Options A and B describe different types of data models, while C incorrectly suggests that a schema is solely for performance enhancement. Option E mischaracterizes the purpose of a schema, focusing instead on data governance.