ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam
Go to Exam

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 Hide Answer
Suggested Answer: A 🗳️
by dmov at Dec. 29, 2023, 6:12 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Hadiler
6 months, 3 weeks ago
Selected Answer: A
A is the simplest one
upvoted 1 times
...
vctrhugo
1 year 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 ago
Selected Answer: A
A is the simplest
upvoted 1 times
...
dmov
1 year, 1 month ago
Selected Answer: A
Looks like A to me
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago