Noos
PT EN
RAN-DBDEA-00104
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: easy

A data team is building a new curated table that summarizes several silver tables, computed with a single query. They want Unity Catalog to own the table's storage location, optimization, and deletion — no external system will ever write to these files. Which single statement creates the table with the intended ownership of the data lifecycle?

Options (Reading Mode) Click to filter discussion →
  1. A. CREATE TABLE gold.daily_summary LOCATION 's3://acme-gold/summary' AS SELECT ... FROM silver.orders;
  2. B. CREATE TABLE gold.daily_summary AS SELECT ... FROM silver.orders;
  3. C. CREATE VIEW gold.daily_summary AS SELECT ... FROM silver.orders;
  4. D. df.write.option("path", "s3://acme-gold/summary").saveAsTable("gold.daily_summary")
Reveal answer

Correct answer: CREATE TABLE gold.daily_summary AS SELECT ... FROM silver.orders;

Reference: https://docs.databricks.com/aws/en/data-governance/unity-catalog/managed-versus-external

Train this exam on Ranvier →

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (B): CREATE TABLE gold.daily_summary AS SELECT ... FROM silver.orders;

Ranvier · DBDEA

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.