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

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam Certified Data Engineer Professional topic 1 question 45 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 45
Topic #: 1
[All Certified Data Engineer Professional Questions]

An external object storage container has been mounted to the location /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:

After the database was successfully created and permissions configured, a member of the finance team runs the following code:

If all users on the finance team are members of the finance group, which statement describes how the tx_sales table will be created?

  • A. A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
  • B. An external table will be created in the storage container mounted to /mnt/finance_eda_bucket.
  • C. A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.
  • D. An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.
  • E. A managed table will be created in the DBFS root storage container.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
tkg13
Highly Voted 3 months, 2 weeks ago
Correct Answer D https://docs.databricks.com/en/data-governance/unity-catalog/create-schemas.html#language-SQL
upvoted 6 times
CertPeople
3 months ago
Nope, you are talking about MANAGED LOCATION (from Unity). In the question states LOCATION (not Unity based), which is not managed https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-schema.html
upvoted 2 times
CertPeople
3 months ago
Effectively doing a test on one of my clusters the table is MANAGED
upvoted 4 times
...
...
cotardo2077
3 months, 1 week ago
you are right, it is managed table
upvoted 2 times
...
...
azurelearn2020
Most Recent 2 days, 10 hours ago
Selected Answer: D
It will be a managed table created under specified database. Location keyword used for database will make sure all the managed tables are stored in database location.
upvoted 1 times
...
Enduresoul
2 weeks, 2 days ago
Selected Answer: D
D is correct. The table will be created as managed, because no LOCATION is specified on table creation. The table will be created in the location specified with database creation
upvoted 1 times
...
Dileepvikram
1 month ago
I think the answer id D
upvoted 1 times
...
PearApple
1 month ago
I followed the steps to create schema and table, the answer is D
upvoted 2 times
...
jerborder
1 month, 1 week ago
Correct answer is D. "data for a managed table resides in the location of the database it is registered to
upvoted 1 times
...
sturcu
1 month, 3 weeks ago
Selected Answer: E
A managed table will be created on DBFS.
upvoted 1 times
...
MarceloManhaes
2 months, 2 weeks ago
Every unmanaged(external) table creation needs to put keyword LOCATION despite if database, that table resides, is put with LOCATION sententece. So B is incorrect. D is correct because the sentence to creates the table is a managed table. https://docs.databricks.com/en/lakehouse/data-objects.html
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 ...