Databricks Exam Databricks-Certified-Professional-Data-Engineer Topic 1 Question 5 Discussion

Actual exam question for Databricks's Databricks-Certified-Professional-Data-Engineer exam

Question #: 5
Topic #: 1

[All Databricks-Certified-Professional-Data-Engineer Questions]

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 approval for the sales org.

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

ACreate a view on the marketing table selecting only these fields approved for the sales team alias the names of any fields that should be standardized to the sales naming conventions.

BUse a CTAS statement to create a derivative table from the marketing table configure a production jon to propagation changes.

CAdd a parallel table write to the current production pipeline, updating a new sales table that varies as required from marketing table.

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

Show Suggested Answer

Suggested Answer: A

Creating a view is a straightforward solution that can address the need for field name standardization and selective field sharing between departments. A view allows for presenting a transformed version of the underlying data without duplicating it. In this scenario, the view would only include the approved fields for the sales team and rename any fields as per their naming conventions.

Databricks documentation on using SQL views in Delta Lake: https://docs.databricks.com/delta/quick-start.html#sql-views

by Van at Mar 19, 2024, 07:15 AM

Limited Time Offer

25%

6 months ago

I think option A is the best solution.

upvoted 0 times

...