Databricks Certified Data Engineer - Professional

Get started today

Ultimate access to all questions.

Explanation:

The most efficient and simplest solution is to create a view.

Zero Data Duplication: A view is a virtual table. It does not move or copy data, which avoids unnecessary storage costs and ensures that the sales team always sees the most recent data without synchronization lag.
Simultaneous Filtering and Renaming: Within the SELECT statement of the view, you can explicitly list only approved columns and use aliases (AS) to match the sales team's naming conventions (e.g., SELECT mkt_id AS customer_id).
Granular Access Control: You can grant the sales team SELECT privileges on the view while denying access to the underlying source table, ensuring restricted fields remain secure.

Deep Clone (B) and CTAS (A): Both methods create physical copies of the data, leading to increased storage costs and the operational burden of keeping the secondary table in sync with the source.
Parallel Writes (D): Adding writes to a production pipeline increases architectural complexity and makes the pipeline more fragile, as schema changes must now be managed across multiple destinations.

Explanation:

The most efficient and simplest solution is to create a view.

Zero Data Duplication: A view is a virtual table. It does not move or copy data, which avoids unnecessary storage costs and ensures that the sales team always sees the most recent data without synchronization lag.
Simultaneous Filtering and Renaming: Within the SELECT statement of the view, you can explicitly list only approved columns and use aliases (AS) to match the sales team's naming conventions (e.g., SELECT mkt_id AS customer_id).
Granular Access Control: You can grant the sales team SELECT privileges on the view while denying access to the underlying source table, ensuring restricted fields remain secure.

Deep Clone (B) and CTAS (A): Both methods create physical copies of the data, leading to increased storage costs and the operational burden of keeping the secondary table in sync with the source.
Parallel Writes (D): Adding writes to a production pipeline increases architectural complexity and makes the pipeline more fragile, as schema changes must now be managed across multiple destinations.

Comments (0)

No comments yet.

Real Exam

Last updated: January 6, 2026 at 15:43

Execute a CREATE TABLE AS SELECT (CTAS) statement to generate a new table and schedule a production job to refresh it periodically.

0.0%

Utilize Delta Lake’s DEEP CLONE functionality to create a synchronized copy of the table with the modified schema.

4.5%

Establish a view on the marketing table that selects only the authorized fields and uses aliases to map them to the sales team's naming standards.

90.9%

Incorporate a parallel write step into the current production pipeline to create a secondary sales-specific table.

4.5%