Databricks
CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #82
A data analyst is working in an organization that utilizes a multi-hop, medallion architecture. They have been tasked with creating a new Gold table from an existing Silver table. Which query is perfo
Sign in or unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Question
A data analyst is working in an organization that utilizes a multi-hop, medallion architecture. They have been tasked with creating a new Gold table from an existing Silver table. Which query is performing a hop from a Silver table to a Gold table? CREATE TABLE cleaned_transactions AS A. SELECT store_id, customer_id, sales, units FROM transactions; CREATE TABLE transactions AS B. SELECT * FROM raw_transactions; CREATE TABLE store_sales AS
Options
- CCREATE TABLE store_sales AS
- DCREATE TABLE cleaned_transactions AS
Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to see the answer
You've previewed enough free CERTIFIED-DATA-ANALYST-ASSOCIATE questions. Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.