Câu 41: Databricks Certified Data Analyst Associate

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?

1. A. CREATE TABLE table_silver AS -SELECT DISTINCT *FROM table_bronze; — đáp án hiện tại
2. B. CREATE TABLE table_silver AS -INSERT *FROM table_bronze;
3. C. CREATE TABLE table_silver AS -MERGE DEDUPLICATE *FROM table_bronze;
4. D. INSERT INTO TABLE table_silver -SELECT * FROM table_bronze;
5. E. INSERT OVERWRITE TABLE table_silverSELECT * FROM table_bronze;