CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #6
A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative.
Sign in or unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to reveal the answer and full explanation for question #6. The question stem and answer options stay visible for context.
Question
A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication. Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?
Options
- ACREATE TABLE table_silver AS
- CCREATE TABLE table_silver AS
- DINSERT INTO TABLE table_silver
- EINSERT OVERWRITE TABLE table_silver
Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to see the answer
You've previewed enough free CERTIFIED-DATA-ANALYST-ASSOCIATE questions. Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE 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.