Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
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.
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
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
kbaba101
Highly Voted 10 months, 3 weeks agosamverma
Most Recent 1 month, 2 weeks agoaspix82
3 months, 2 weeks agojskibick
3 months, 3 weeks agobenni_ale
4 months, 1 week agoBob123456
6 months, 2 weeks agoUGOTCOOKIES
7 months, 2 weeks agoGaryn
8 months, 1 week agokz_data
9 months agoHuroye
9 months, 3 weeks agoanandpsg101
10 months, 2 weeks agoSD5713
10 months, 2 weeks agomeow_akk
10 months, 3 weeks agoSD5713
10 months, 2 weeks agokishanu
10 months, 3 weeks ago