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;
Billye
1 months agoAmie
1 months agoJosphine
12 days agoGianna
20 days agoLauna
2 months agoEulah
20 days agoVal
22 days agoShaun
27 days agoDarrin
2 months agoTyisha
2 months agoMatthew
2 months agoAlaine
2 months agoReid
1 months agoRickie
1 months agoLindsey
2 months agoLenna
1 months agoLashaunda
1 months agoSol
1 months agoEve
2 months agoNatalya
2 months ago