Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 13 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 13
Topic #: 1
[All Certified Data Engineer Associate 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;
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
vctrhugo
Highly Voted 1 year, 2 months ago
Selected Answer: C
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.
upvoted 7 times
...
80370eb
Most Recent 3 months, 2 weeks ago
Selected Answer: C
C. DESCRIBE DATABASE customer360; this will show the location of the databaase.
upvoted 1 times
...
benni_ale
7 months ago
Selected Answer: C
C is correct
upvoted 1 times
...
Itmma
8 months, 1 week ago
Selected Answer: C
C is correct
upvoted 1 times
...
SerGrey
10 months, 3 weeks ago
Selected Answer: C
Correct answer is C
upvoted 1 times
...
awofalus
1 year ago
Selected Answer: C
Correct :C
upvoted 1 times
...
KalavathiP
1 year, 2 months ago
Selected Answer: C
C is correct
upvoted 1 times
...
Akshay67364
1 year, 3 months ago
Option C
upvoted 1 times
...
Gowthamr02
1 year, 3 months ago
Option C
upvoted 1 times
...
Varma_Saraswathula
1 year, 7 months ago
Option C - https://spark.apache.org/docs/3.0.0-preview/sql-ref-syntax-aux-describe-database.html
upvoted 1 times
...
surrabhi_4
1 year, 7 months ago
Selected Answer: C
option c
upvoted 2 times
...
knivesz
1 year, 7 months ago
Selected Answer: C
Muy facil
upvoted 2 times
...
XiltroX
1 year, 7 months ago
Selected Answer: C
Correct answer
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...