1Z0-116 practice question 14 of 15

What does the Application Data Modeling module of the Oracle Data Masking and Subsetting Pack search for?

Full set: 90 questions
Answer options
A: data redaction policies
B: data masking transformations
C: parent/child relationships between the columns holding sensitive information Correct answer
D: encrypted columns
Correct Answer:
C. parent/child relationships between the columns holding sensitive information
Explanation

The Application Data Modeling (ADM) feature is a discovery module within the Oracle Data Masking and Subsetting Pack. Its primary purpose is to scan the application's data dictionary to discover sensitive data and, crucially, the relationships between tables. It identifies primary key and foreign key (parent/child) relationships to build a data model. This model is essential for creating valid, referentially intact subsets of production data for non-production environments and for applying masking consistently across related columns.

Why Incorrect

A. Data redaction is a separate security feature for redacting data in real-time queries; it is not the function of the ADM module.
B. Data masking transformations are the specific masking routines applied to data, which occurs after the ADM has discovered the data and its relationships.
D. Encrypted columns are handled by Transparent Data Encryption (TDE). While ADM might identify these columns, its core function is modeling relationships, not searching for encryption.

References

1. Oracle Database, Documentation, 19c, "Database Advanced Security Guide", Chapter 12, "Introduction to Oracle Data Masking and Subsetting". The section "Application Data Modeling" states: "Application Data Modeling facilitates the discovery of sensitive data and the relationships in an application."

2. Oracle Database, Documentation, 19c, "Database Advanced Security Guide", Chapter 13, "Managing Application Data Models, Sensitive Columns, and Masking Formats". The section "About Application Data Modeling" explains that it discovers metadata and relationships to create a data model.

Scroll to Top