Exam Certified Data Engineer Professional topic 1 question 166 discussion

The table cannot be a **managed table**: - If a database specifies a `LOCATION`, all tables created inside it inherit that `LOCATION`, and they are **external tables**. - Managed tables cannot exist in a database where the storage location has been explicitly specified, as the managed table lifecycle is tied to Databricks' internal storage system. -Even if you don't explicitly define the table as external, the **database's external location forces all tables** to behave as external tables.

D. Managed tables - Since Location is not mentioned. mounted to /mnt/finance_eda_bucket - This is where our database is created as per first query and in second query we are using it to create the table further.

It will be created in database location, but it will be managed table (missing LOCATION keyword in CREATE TABLE).

D is correct

Correct Answer: D The table is still managed by Spark SQL in terms of metadata, but the data files are stored in the specified path due to the database’s location setting. Given the inherited location from the database, if the CREATE TABLE statement had explicitly used USING EXTERNAL or specified a LOCATION, it would definitely be an external table. However, since it inherits the database's location without these specifications, it creates a managed table.

Seems D