Noos
PT EN
RAN-DBDEA-00100
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: easy

A data engineer is decommissioning two production tables governed by Unity Catalog. Both tables currently hold live data, and the engineer runs the following statements, which complete successfully: ```sql DROP TABLE main.sales.orders; -- originally created with CREATE TABLE main.sales.orders (...); DROP TABLE main.sales.orders_hist; -- originally created with CREATE TABLE ... LOCATION 's3://acme-raw/orders_hist'; ``` The cloud storage team asks what will happen to the underlying data files once the DROP statements complete. Which answer is correct?

Options (Reading Mode) Click to filter discussion →
  1. A. orders (managed): UC deletes the data files; orders_hist (external): the files stay in cloud storage.
  2. B. The files for both tables are deleted, because DROP TABLE in Unity Catalog always removes the underlying data.
  3. C. The files for both tables remain in place, because DROP TABLE in Unity Catalog removes only table metadata.
  4. D. The files for orders remain in place, while the files for orders_hist are deleted from the external location.
Reveal answer

Correct answer: orders (managed): UC deletes the data files; orders_hist (external): the files stay in cloud storage.

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 (A): orders (managed): UC deletes the data files; orders_hist (external): the files stay in cloud storage.

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.