Databricks Certified Data Engineer Professional — Question 239

The marketing team is looking to share data in an aggregate table with the sales organization, but the field names used by the teams do not match, and a number of marketing-specific fields have not been approved for the sales org.

Which of the following solutions addresses the situation while emphasizing simplicity?

Answer options

• 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.

Correct answer: A

Explanation

Option A is correct because it directly addresses the need for simplicity by creating a view that aligns with the sales team's requirements while standardizing field names. The other options, while potentially effective, introduce additional complexity such as creating new tables or managing synchronization processes, which may not be necessary for this situation.