Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Databricks Certified Data Analyst Associate · Databricks
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- Correct answer : A — Run `CREATE TABLE catalog.schema.table (...)` without a `LOCATION` clause, letting Unity Catalog place the files under the schema's own managed storage path. A . Correct. Omitting `LOCATION` produces a managed table, and Unity Catalog automatically stores its data under the managed storage path configured for the containing schema, catalog, or metastore. B . Incorrect. Supplying an explicit `LOCATION` at creation makes the table external, with Unity Catalog governing only metadata over a team-controlled bucket rather than its own managed path. C . Incorrect. There is no `ALTER TABLE ... SET MANAGED` conversion path; a table's managed-versus-external type is fixed at creation and is not changed by altering it afterward. D . Incorrect. `MSCK REPAIR TABLE` is a Hive-style partition-discovery command for existing metastore tables, not a mechanism for adopting arbitrary uploaded files as a Unity Catalog managed table.