CDPSE · Question #275
Which of the following would BEST enable a data warehouse to limit access to individual database objects?
The correct answer is D. Data control dictionary. A data control dictionary is a centralized metadata repository that documents and enforces access control policies, ownership, sensitivity classifications, and permissions for every individual object in a data warehouse-tables, views, columns, and procedures. By maintaining…
Question
Which of the following would BEST enable a data warehouse to limit access to individual database objects?
Options
- APrivate storage volumes
- BVirtual private database
- CDatabase privacy firewall
- DData control dictionary
How the community answered
(33 responses)- A6% (2)
- B18% (6)
- C3% (1)
- D73% (24)
Explanation
A data control dictionary is a centralized metadata repository that documents and enforces access control policies, ownership, sensitivity classifications, and permissions for every individual object in a data warehouse-tables, views, columns, and procedures. By maintaining this authoritative catalog of who can access what at the object level, administrators can systematically restrict access in a consistent and auditable way. Private storage volumes address physical storage isolation, not logical object-level access. A 'database privacy firewall' is not a standard data warehouse construct. A virtual private database (VPD) is a product-specific Oracle feature and is not the best general answer in a data governance context.
Topics
Community Discussion
No community discussion yet for this question.