nerdexam
Isaca

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…

Privacy Architecture

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)
  • A
    6% (2)
  • B
    18% (6)
  • C
    3% (1)
  • D
    73% (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

#Database Security#Access Control#Data Warehouse#Data Dictionary

Community Discussion

No community discussion yet for this question.

Full CDPSE Practice