https://www.crackyourinterview.com/quiz

SelectCategory

SelectQuestionNo

A data analysis team is working with the table bronze SQL table Question 23? (View:-19)
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?

Choose the correct answer from below list

CREATE TABLE table_silver AS SELECT DISTINCT * FROM table_bronze;

CREATE TABLE table_silver AS INSERT * FROM table_bronze;

CREATE TABLE table_silver AS MERGE DEDUPLICATE * FROM table_bronze;

INSERT INTO TABLE table_silver SELECT * FROM table_bronze;

INSERT OVERWRITE TABLE table_silver SELECT * FROM table_bronze;

Some Other Questions

Which of the following layers of the medallion architecture is most commonly used by data analysts?

A data analyst has recently joined a new team that uses Databricks SQL

Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

Data professionals with varying titles use the Databricks SQL service

A data analyst wants to create a dashboard with three main sections