Noos
PT EN
RAN-DBDEA-00297
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: hard

A company runs one Unity Catalog metastore shared by several business domains. Security policy requires that every managed table created in the finance catalog keeps its data files under a storage prefix dedicated to finance (s3://acme-managed/finance/), instead of the metastore root storage used by other domains. How should the platform team configure this?

Options (Reading Mode) Click to filter discussion →
  1. A. Spin up a second metastore whose root storage is the finance prefix, because managed storage locations exist only at the metastore level.
  2. B. Leave the catalog as it is, because managed tables in every catalog are always written to the metastore's root storage location and can never use anything else.
  3. C. Create the finance catalog with MANAGED LOCATION 's3://acme-managed/finance/', overriding the metastore root storage for that catalog's managed tables.
  4. D. Create the finance tables as external tables with LOCATION under the finance prefix, because managed locations per catalog work only with external tables.
Reveal answer

Correct answer: Create the finance catalog with MANAGED LOCATION 's3://acme-managed/finance/', overriding the metastore root storage for that catalog's managed tables.

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

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 (C): Create the finance catalog with MANAGED LOCATION 's3://acme-managed/finance/', overriding the metastore root storage for that catalog's managed tables.

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.