Answer-first summary for fast verification
Answer: 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.
The most efficient and simplest solution is to create a **view**. ### Why this is the optimal choice: 1. **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. 2. **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`). 3. **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. ### Why other options are less ideal: * **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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A marketing team needs to share data from an aggregate table with the sales team. However, the two teams use different field naming conventions, and specific marketing-only fields must remain restricted. Which of the following approaches is the simplest way to provide the sales team with the necessary data while adhering to these constraints?
A
Execute a CREATE TABLE AS SELECT (CTAS) statement to generate a new table and schedule a production job to refresh it periodically.
B
Utilize Delta Lake’s DEEP CLONE functionality to create a synchronized copy of the table with the modified schema.
C
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.
D
Incorporate a parallel write step into the current production pipeline to create a secondary sales-specific table.