Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
The marketing team needs to share aggregated data with the sales organization, but the field names differ between teams and some marketing-specific fields are not approved for sales.
Which solution best resolves this scenario while prioritizing simplicity?
A
Create a view on the marketing table selecting only those fields approved for the sales team; alias the names of any fields that should be standardized to the sales naming conventions.
B
Create a new table with the required schema and use Delta Lake's DEEP CLONE functionality to sync up changes committed to one table to the corresponding table.
C
Use a CTAS statement to create a derivative table from the marketing table; configure a production job to propagate changes.
D
Add a parallel table write to the current production pipeline, updating a new sales table that varies as required from the marketing table.