Discuss Databricks Databricks Certified Data Engineer Associate Exam Topic 4 Question 33

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?

Adbfs:/user/hive/database/customer360

Bdbfs:/user/hive/warehouse

Cdbfs:/user/hive/customer360

DMore information is needed to determine the correct response

Suggested Answer: B

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.

Databases and Tables

[Databricks Data Engineer Professional Exam Guide]

Get Premium Databricks Certified Data Engineer Associate Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

33 comments · newest first

Beatriz 10 months ago

More info needed? Really? Seems straightforward to me!

Dan 11 months ago

Nah, I'm pretty sure it's A, no doubt about it.

Felix 11 months ago

Wait, could it be in the warehouse instead?

Arlette 11 months ago

I think it's definitely A!

Felton 11 months ago

It's usually in dbfs:/user/hive/database/ for Hive databases.

Gerri 12 months ago

I feel like more information might be needed to be certain about the location. Maybe option D is the safest choice?

Glory 12 months ago

I’m a bit confused; I thought the database would be in a user-specific folder, but I can’t recall if that’s always the case.

Allene 12 months ago

I think I practiced a similar question where the database was created in the warehouse location. Could it be option B?

Essie 1 year ago

I remember something about databases being stored in a specific directory, but I’m not sure if it’s always under the warehouse path.

Gaston 1 year ago

Okay, I think I've got this. The CREATE DATABASE command specifies the database name, so the location is likely going to be related to that. I'll analyze the options and see which one makes the most sense.

Annelle 1 year ago

Hmm, I'm a bit unsure about this one. The question doesn't provide much context, and I'm not familiar with the specific syntax for creating databases. I'll have to think this through carefully.

Margarita 1 year ago

This seems like a straightforward question about the location of the customer360 database. I'll carefully read through the options and think about what the CREATE DATABASE command implies.

Margarita 1 year ago

This is a tricky one. The question doesn't give much information about the database environment or the underlying file system. I'll have to make an educated guess based on the options provided.

Lili 1 year ago

I'm feeling pretty confident about this one. Option B is the way to go - being transparent about the challenges ahead is crucial for effective change management.

Bonita 1 year ago

Okay, let me break this down. The company has an insurance policy, which means they are transferring the risk. But the question is asking about the risk management technique they are using, so I think the answer is C - risk transfer.

Tawna 2 years ago

Ha! This question is like a riddle. I'm going to go with option B, just to be different. Who knows, it might work!

Tarra 2 years ago

↳ replying to Tawna

I'm not sure, we might need more information to determine the correct response.

Tony 2 years ago

↳ replying to Tawna

I'm going with option B, just to mix things up.

Lucina 2 years ago

↳ replying to Tawna

I believe it will be in option C.

Mabel 2 years ago

↳ replying to Tawna

I think the database will be located in option A.

Kristal 2 years ago

Hmm, I'm leaning towards option C. It makes sense to have the database in its own directory, but I could be wrong. This is a tricky one!

Thaddeus 2 years ago

I'd go with option D. We need more information about the environment and the configuration to determine the exact location of the database.

Glenna 2 years ago

Option A seems logical, as that's where the Hive databases are typically stored. But I'm not sure if that's the only possible location.

Ahmad 2 years ago

↳ replying to Glenna

I'm not sure, we might need more details to know for sure.

Tamra 2 years ago

↳ replying to Glenna

D) More information is needed to determine the correct response

Pilar 2 years ago

↳ replying to Glenna

D) More information is needed to determine the correct response

Kristeen 2 years ago

↳ replying to Glenna

I think option A is correct, that's where Hive databases are usually stored.

Holley 2 years ago

↳ replying to Glenna

A) dbfs:/user/hive/database/customer360

Glenna 2 years ago

↳ replying to Glenna

I think option A is correct, it makes sense for the database to be located there.

Lashaunda 2 years ago

↳ replying to Glenna

A) dbfs:/user/hive/database/customer360

Maira 2 years ago

I'm not sure, maybe we need more information to determine the correct location.

Shawnna 2 years ago

I believe it could also be in dbfs:/user/hive/customer360.

Lizbeth 2 years ago

I think the database will be located in dbfs:/user/hive/database/customer360.

Databricks Certified Data Engineer Associate Exam - Topic 4 Question 33 Discussion