Free DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Web TestEngine Demo

Q8 Single choice

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?

A
CREATE TABLE table_silver AS
SELECT DISTINCT *
FROM table_bronze;
B
CREATE TABLE table_silver AS
INSERT *
FROM table_bronze;
C
CREATE TABLE table_silver AS
MERGE DEDUPLICATE *
FROM table_bronze;
D
INSERT INTO TABLE table_silver
SELECT * FROM table_bronze;
E
INSERT OVERWRITE TABLE table_silver
SELECT * FROM table_bronze;

DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Web TestEngine demo