
Ultimate access to all questions.
The marketing department needs to share data from an aggregate table with the sales department. The sales team requires different field names to align with their existing conventions, and certain marketing-specific columns must be excluded for security and compliance reasons.
Which approach offers the simplest, most efficient way to provide this data to the sales team while meeting these requirements?
A
Use a CTAS (Create Table As Select) statement to generate a new table from the marketing data and schedule a production job to keep it updated.
B
Modify the existing production pipeline to perform a parallel write to a new sales-specific table with the required schema.
C
Create a view on the marketing table that selects only approved fields and uses aliases to match the sales team's naming conventions.
D
Utilize Delta Lake's DEEP CLONE functionality to create a synchronized copy of the table with the required schema adjustments.