Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Hadiler
4 months ago
Selected Answer: A
A is the simplest one
upvoted 1 times
...
vctrhugo
9 months, 3 weeks 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 3 times
...
spaceexplorer
10 months ago
Selected Answer: A
A is the simplest
upvoted 1 times
...
dmov
11 months ago
Selected Answer: A
Looks like A to me
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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