Answer-first summary for fast verification
Answer: CREATE DATABASE sales LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’
The correct answer is to use the command `CREATE DATABASE sales LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’`. It's important to note that with the introduction of the Unity catalog and three-layer namespace, the usage of `SCHEMA` and `DATABASE` is interchangeable.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How would you create a sales database using the DBFS location ‘dbfs:/mnt/delta/databases/sales.db/’?
A
CREATE DATABASE sales USING LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’
B
CREATE DELTA DATABASE sales LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’
C
The sales database can only be created in Delta lake
D
CREATE DATABASE sales LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’
E
CREATE DATABASE sales FORMAT DELTA LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’
No comments yet.