A data engineer needs to provide the sales organization with access to data stored in a marketing table. However, there are two issues: specific field names do not match the sales team's naming conventions, and the table contains several unapproved marketing-specific columns that should not be visible to the sales team. Which solution addresses these requirements while prioritizing architectural simplicity and minimizing maintenance overhead?

Real Exam

Last updated: January 6, 2026 at 15:41

Create a new table using Delta Lake's DEEP CLONE functionality to replicate data into a sales-specific schema, then manually rename columns.

Introduce a parallel write operation in the current production pipeline to update a second table specifically formatted for the sales team.

Define a SQL view on the marketing table that selects only approved fields and uses aliases to rename them according to sales conventions.

Use a CREATE TABLE AS SELECT (CTAS) statement to generate a derivative table and configure a scheduled production job to propagate updates.

Export the filtered and renamed data as a CSV file and automate an email delivery system to send it to the sales organization.

Databricks Certified Data Engineer - Professional