
Ultimate access to all questions.
Which of the following commands will return the location of database customer360?
A
DESCRIBE LOCATION customer360;
B
DROP DATABASE customer360;
C
DESCRIBE DATABASE customer360;
D
ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user');
E
USE DATABASE customer360;
Explanation:
The correct answer is C. DESCRIBE DATABASE customer360; because:
DESCRIBE DATABASE customer360;, it displays the database metadata including the Location field which shows the HDFS or cloud storage path where the database is stored.DESCRIBE LOCATION in Spark SQLExample output of DESCRIBE DATABASE:
Database Name: customer360
Description:
Location: dbfs:/user/hive/warehouse/customer360.db
Properties:
Database Name: customer360
Description:
Location: dbfs:/user/hive/warehouse/customer360.db
Properties: