Noos
PT EN
RAN-DBDEA-00103
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: hard

main.sales.orders_hist is a Unity Catalog external Delta table whose files live at s3://acme-raw/orders_hist. The team now wants Unity Catalog to manage the table's storage and lifecycle, keeping the same table name, permissions, and history, with minimal reader and writer downtime. The team owns the table and uses Serverless compute. Which command should they run?

Options (Reading Mode) Click to filter discussion →
  1. A. ALTER TABLE main.sales.orders_hist SET MANAGED MOVE;
  2. B. CREATE TABLE main.sales.orders_managed AS SELECT * FROM main.sales.orders_hist; followed by DROP TABLE main.sales.orders_hist;
  3. C. ALTER TABLE main.sales.orders_hist UNSET MANAGED;
  4. D. ALTER TABLE main.sales.orders_hist SET MANAGED;
Reveal answer

Correct answer: ALTER TABLE main.sales.orders_hist SET MANAGED;

Reference: https://docs.databricks.com/aws/en/tables/convert-to-managed

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 (D): ALTER TABLE main.sales.orders_hist SET MANAGED;

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.