Explanation:
When a database is created without specifying a location, it defaults to the warehouse directory under dbfs:/user/hive/warehouse. The database folder is named with a .db extension. Similarly, a table created without a specified location becomes a managed table under the database directory, hence the employees table will be located in the db_hr.db folder. Reference: Databricks SQL Language Manual.
Ultimate access to all questions.
After executing the following commands in sequence: CREATE DATABASE db_hr;, USE db_hr;, CREATE TABLE employees;, where will the employees table be stored?
A
dbfs:/user/hive/warehouse
B
dbfs:/user/hive/warehouse/db_hr
C
dbfs:/user/hive/warehouse/db_hr.db
D
dbfs:/user/hive/databases/db_hr.db
E
More information is needed to determine the correct answer
No comments yet.