Free Preparation Discussions
MENU
Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 3 Question 39 Discussion
Topic #: 3
A data engineer has created a new database using the following command:
CREATE DATABASE IF NOT EXISTS customer360;
In which of the following locations will the customer360 database be located?
dbfs:/user/hive/warehouse Thereby showing 'dbfs:/user/hive/warehouse/customer360.db
The location of the customer360 database depends on the value of thespark.sql.warehouse.dirconfiguration property, which specifies the default location for managed databases and tables. If the property is not set, the default value isdbfs:/user/hive/warehouse. Therefore, the customer360 database will be located indbfs:/user/hive/warehouse/customer360.db. However, if the property is set to a different value, such asdbfs:/user/hive/database, then the customer360 database will be located indbfs:/user/hive/database/customer360.db. Thus, more information is needed to determine the correct response.
Option A is not correct, asdbfs:/user/hive/database/customer360is not the default location for managed databases and tables, unless thespark.sql.warehouse.dirproperty is explicitly set todbfs:/user/hive/database.
Option B is not correct, asdbfs:/user/hive/warehouseis the default location for the root directory of managed databases and tables, not for a specific database. The database name should be appended with.dbto the directory path, such asdbfs:/user/hive/warehouse/customer360.db.
Option C is not correct, asdbfs:/user/hive/customer360is not a valid location for a managed database, as it does not follow the directory structure specified by thespark.sql.warehouse.dirproperty.
[Databricks Data Engineer Professional Exam Guide]
Bettina
19 days agoTorie
21 days agoHuey
22 days agoBuck
23 days agoRebbecca
25 days agoStefania
8 days agoSalome
10 days agoBrent
18 days agoMargart
1 months agoCharlene
1 months agoChi
1 months agoLashawna
1 months agoBettyann
6 days agoRonald
9 days agoKeith
22 days agoFabiola
24 days agoOdette
2 months agoRosann
2 months agoLennie
17 days agoPamella
25 days agoSolange
29 days agoGary
1 months agoClaudio
1 months agoVesta
1 months agoEllsworth
2 months ago