Noos
PT EN
RAN-DBDEA-00136
Ranvier · DBDEA

Exam DBDEA Topics: transformation Difficulty: hard

Two analysts on different teams must share the same SQL definition — a curated customer list built over several silver tables. The definition must live in one governed place: secured with Unity Catalog permissions, centrally versioned, and readable from any workspace attached to the metastore. The analysts use separate notebooks on separate compute. Which object meets these requirements?

Options (Reading Mode) Click to filter discussion →
  1. A. A temporary view (CREATE TEMP VIEW), which lives only inside the session that defines it
  2. B. A global temporary view (CREATE GLOBAL TEMP VIEW), shared across sessions on the same cluster
  3. C. A .sql script in a shared folder, which each analyst must open and run in her own session
  4. D. A view created with CREATE VIEW in a Unity Catalog schema, stored in the metastore and governed with grants
Reveal answer

Correct answer: A view created with CREATE VIEW in a Unity Catalog schema, stored in the metastore and governed with grants

Reference: https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-view

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 (D): A view created with CREATE VIEW in a Unity Catalog schema, stored in the metastore and governed with grants

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.