Explanation:
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.
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.