Certified Data Engineer Associate Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Associate Exam - Question 13

Which of the following commands will return the location of database customer360?

DESCRIBE LOCATION customer360;

DROP DATABASE customer360;

DESCRIBE DATABASE customer360;

ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};

USE DATABASE customer360;

Show Answer

Correct Answer: C

To retrieve the location of a database, the command DESCRIBE DATABASE followed by the database name is used. This command outputs detailed information about the database, including its location. Other commands like DROP DATABASE would delete the database, ALTER DATABASE would modify its properties, and USE DATABASE would select it for subsequent operations but none would return its location.

Discussion

12 comments

vctrhugoOption: C

Sep 3, 2023

C. DESCRIBE DATABASE customer360; To retrieve the location of a database named "customer360" in a database management system like Hive or Databricks, you can use the DESCRIBE DATABASE command followed by the database name. This command will provide information about the database, including its location.

XiltroXOption: C

Apr 1, 2023

Correct answer

kniveszOption: C

Apr 2, 2023

Muy facil

surrabhi_4Option: C

Apr 3, 2023

option c

Varma_SaraswathulaOption: C

Apr 21, 2023

Option C - https://spark.apache.org/docs/3.0.0-preview/sql-ref-syntax-aux-describe-database.html

Gowthamr02Option: C

Aug 5, 2023

Option C

Akshay67364Option: C

Aug 11, 2023

Option C

KalavathiPOption: C

Sep 26, 2023

C is correct

awofalusOption: C

Nov 7, 2023

Correct :C

SerGreyOption: C

Jan 3, 2024

Correct answer is C

ItmmaOption: C

Mar 19, 2024

C is correct

benni_aleOption: C

Apr 27, 2024

C is correct