Exam Certified Data Engineer Professional topic 1 question 80 discussion

Actual exam question from Databricks's Certified Data Engineer Professional

Question #: 80
Topic #: 1

[All Certified Data Engineer Professional 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 approved for the sales org.

Which of the following solutions addresses the situation while emphasizing 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.
E. Instruct the marketing team to download results as a CSV and email them to the sales organization.

Show Suggested Answer

Suggested Answer: A 🗳️

by dmov at Dec. 29, 2023, 6:12 p.m.

Comments

Submit Cancel

KadELbied

1 month, 3 weeks ago

Selected Answer: A

suretly A

upvoted 1 times

...

Hadiler

11 months, 1 week ago

Selected Answer: A

A is the simplest one

upvoted 1 times

...

vctrhugo

1 year, 4 months ago

Selected Answer: A

Creating a view is a simple and efficient way to provide access to a subset of data from a table. In this case, the view can be configured to include only the fields that have been approved for the sales team. Additionally, any fields that need to be renamed to match the sales team’s naming conventions can be aliased in the view. This approach does not require the creation of additional tables or the configuration of jobs to sync data, making it a relatively straightforward solution. However, it’s important to note that views do not physically store data, so any changes to the underlying marketing table will be reflected in the view. This means that the sales team will always have access to the most up-to-date approved data.

upvoted 4 times

...

spaceexplorer

1 year, 5 months ago

Selected Answer: A

A is the simplest

upvoted 1 times

...

dmov

1 year, 6 months ago

Selected Answer: A

Looks like A to me

upvoted 2 times

...