Exam Certified Data Engineer Associate topic 1 question 64 discussion

B B. dbfs:/user/hive/warehouse Thereby showing "dbfs:/user/hive/warehouse/customer360.db

D I think you can have different configurations in each env so it doesn't mean that it will be created in this location dbfs:/user/hive/warehouse

D , The database could be created after using use catalog statement . In that case location would be different, not in hive warehouse

B. B is "default"

D is correct. We do not know if this is a Unity Catalog enabled database. If so it would be created in default location of catalog as managed table. Therefore too little info to answer.

B is correct

While usage schema and database is interchangeable, schema is preferred. Option B is correct

Creating tables without using the LOCATION keyword to specify a location will create the table (a managed table) in the default directory which is: dbfs:/user/hive/warehouse https://docs.databricks.com/en/dbfs/root-locations.html

B. dbfs:/user/hive/warehouse Explanation: In Databricks, the default location for databases created in the Hive Metastore is often under the warehouse directory. The CREATE DATABASE command usually creates the metadata entry for the database in the Hive Metastore, but it doesn’t directly create the physical database directory within DBFS (Databricks File System). The exact path structure may differ based on configuration or settings in the Databricks environment, but generally, the warehouse directory is where Hive databases' metadata resides. The physical data within the database will be stored in DBFS, but the metadata for the customer360 database should be within the warehouse directory in Hive Metastore.

B is correct

correct answer is B. dbfs:/user/hive/warehouse. All managed objects are stored in the default location unless specified.

b is correct

dbfs:/user/hive/warehouse - which is the default location

Ans A : https://community.databricks.com/t5/data-engineering/database-within-a-database-in-databricks/td-p/20731#:~:text=The%20default%20location%20of%20a,and%20Table%20location%20are%20independent. The default location of a database will be in the /user/hive/warehouse/<databasename. db>. Irrespective of the location of the database the tables in the database can have different locations and they can be specified at the time of creation. Database location and Table location are independent.

dbfs:/user/hive/warehouse - which is the default location of any object created