CERTIFIED-DATA-ANALYST-ASSOCIATE Question #82: Real Exam Question with Answer & Explanation

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

Explanation

Option C is correct because store_sales represents a Gold-layer table - an aggregated, business-ready dataset summarizing sales by store - and it is created by reading from a Silver table (cleaned transaction data), making it a true Silver-to-Gold hop.

Option D (CREATE TABLE cleaned_transactions) produces a Silver table: it selects raw columns from a source table and cleans/filters them, which is characteristic of a Bronze-to-Silver transformation, not Silver-to-Gold. Option B (CREATE TABLE transactions AS SELECT * FROM raw_transactions) is also a Bronze-to-Silver hop, simply landing raw ingested data into a cleaner layer with minimal transformation.

Memory tip: Think of the medallion layers by what the table name implies and what it contains. Raw → Bronze, Cleaned/Filtered → Silver, Aggregated/Business-ready → Gold. A table named store_sales screams "Gold" because it aggregates to a business entity (store); cleaned_transactions screams "Silver" because it still holds row-level detail, just tidied up.

No community discussion yet for this question.