BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Databricks Exam Databricks-Certified-Data-Analyst-Associate Topic 4 Question 20 Discussion
Actual exam question for
Databricks's
Databricks-Certified-Data-Analyst-Associate exam
Question #: 20
Topic #: 4
[All Databricks-Certified-Data-Analyst-Associate Questions]
Topic #: 4
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
2 months agoAmie
2 months agoJosphine
1 months agoGianna
2 months agoLauna
3 months agoEulah
2 months agoVal
2 months agoShaun
2 months agoDarrin
3 months agoTyisha
3 months agoMatthew
3 months agoAlaine
3 months agoReid
2 months agoRickie
2 months agoLindsey
3 months agoLenna
2 months agoLashaunda
2 months agoSol
2 months agoEve
3 months agoNatalya
3 months ago