Câu 101: Databricks Certified Data Engineer Professional

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?

1. 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. — đáp án hiện tại
2. 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.
3. C. Use a CTAS statement to create a derivative table from the marketing table; configure a production job to propagate changes.
4. D. Add a parallel table write to the current production pipeline, updating a new sales table that varies as required from the marketing table.
5. E. Instruct the marketing team to download results as a CSV and email them to the sales organization.