Databricks Certified Data Engineer Professional — Question 90

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.
• E. Instruct the marketing team to download results as a CSV and email them to the sales organization.

Correct answer: A

Explanation

Option A is correct because creating a view with the necessary fields and aliasing them simplifies the process and ensures compliance with naming conventions. The other options involve more complex solutions that may complicate data management and do not address the need for simplicity effectively.