CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #111
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #111: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate a view on the marketing table selecting only these fields approved for the sales team alias
- BUse a CTAS statement to create a derivative table from the marketing table configure a
- CAdd a parallel table write to the current production pipeline, updating a new sales table that varies
- DCreate a new table with the required schema and use Delta Lake's DEEP CLONE functionality to
- EInstruct the marketing team to download results as a CSV and email them to the sales
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.