An external object storage container has been mounted to the location /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:
After the database was successfully created and permissions configured, a member of the finance team runs the following code:
If all users on the finance team are members of the finance group, which statement describes how the tx_sales table will be created?
The table tx_sales will be created as a managed table because the LOCATION keyword was not specified during the table creation. In Databricks, if a LOCATION is provided during the creation of the database, all tables created in that database will inherit that location by default, unless a different LOCATION is provided during table creation. In this case, since no specific LOCATION was specified for the table, it will be created as a managed table in the location defined at the database level, which is /mnt/finance_eda_bucket.
Correct Answer D https://docs.databricks.com/en/data-governance/unity-catalog/create-schemas.html#language-SQL
you are right, it is managed table
Nope, you are talking about MANAGED LOCATION (from Unity). In the question states LOCATION (not Unity based), which is not managed https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-schema.html
Effectively doing a test on one of my clusters the table is MANAGED
Every unmanaged(external) table creation needs to put keyword LOCATION despite if database, that table resides, is put with LOCATION sententece. So B is incorrect. D is correct because the sentence to creates the table is a managed table. https://docs.databricks.com/en/lakehouse/data-objects.html
D is correct. The table will be created as managed, because no LOCATION is specified on table creation. The table will be created in the location specified with database creation
A managed table will be created on DBFS.
The LOCATION of a database will determine the default location for data of all tables registered to that database. from the documentation
I followed the steps to create schema and table, the answer is D
It will be a managed table created under specified database. Location keyword used for database will make sure all the managed tables are stored in database location.
Correct Answer E
Correct answer D. just did a test. As with DBR12.2, UC databases are not supported with location on dbfs, but s3/abfss. However, Hive_metastore databases are supported with location on dbfs. Then, a table created in this database IS a managed table, as verified with describe extend command.
E is correct coz this table is managed on top of the external source file. amanaged tables are stored on DBFS.
D as the word LOCATION is not specified. Although the data will be stored in an external location but the table will still be a managed table.
Correct answer is D. "data for a managed table resides in the location of the database it is registered to
I think the answer id D
D is the correct answer, the table created is a managed table and not external, and it will be located under the location defined in the database's creation DDL.