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?

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.

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

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.

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

Databricks Certified Data Engineer - Professional