Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam
Go to Exam

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: D 🗳️
by tkg13 at Aug. 24, 2023, 3:57 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
tkg13
Highly Voted 1 year, 3 months ago
Correct Answer D https://docs.databricks.com/en/data-governance/unity-catalog/create-schemas.html#language-SQL
upvoted 11 times
cotardo2077
1 year, 2 months ago
you are right, it is managed table
upvoted 2 times
...
CertPeople
1 year, 2 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
1 year, 2 months ago
Effectively doing a test on one of my clusters the table is MANAGED
upvoted 8 times
...
...
...
MarceloManhaes
Highly Voted 1 year, 2 months 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 7 times
...
benni_ale
Most Recent 1 month, 1 week ago
Selected Answer: D
No USE DATABASE statement otherwise it would have been external
upvoted 1 times
...
benni_ale
1 month, 1 week ago
Selected Answer: D
No USE DATABASE statement otherwise it would have been external
upvoted 1 times
...
coercion
6 months, 1 week ago
Selected Answer: D
D as the word LOCATION is not specified. Although the data will be stored in an external location but the table will still be a managed table.
upvoted 2 times
...
Curious76
9 months ago
Selected Answer: E
E is correct coz this table is managed on top of the external source file. amanaged tables are stored on DBFS.
upvoted 2 times
...
hal2401me
9 months ago
Selected Answer: D
Correct answer D. just did a test. As with DBR12.2, UC databases are not supported with location on dbfs, but s3/abfss. However, Hive_metastore databases are supported with location on dbfs. Then, a table created in this database IS a managed table, as verified with describe extend command.
upvoted 2 times
...
s_villahermosa91
10 months ago
Selected Answer: E
Correct Answer E
upvoted 2 times
...
kz_data
10 months, 2 weeks ago
Selected Answer: D
D is the correct answer, the table created is a managed table and not external, and it will be located under the location defined in the database's creation DDL.
upvoted 1 times
...
azurelearn2020
11 months, 3 weeks 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 2 times
...
Enduresoul
1 year 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 4 times
...
Dileepvikram
1 year ago
I think the answer id D
upvoted 1 times
...
PearApple
1 year ago
I followed the steps to create schema and table, the answer is D
upvoted 2 times
...
jerborder
1 year 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 year, 1 month ago
Selected Answer: E
A managed table will be created on DBFS.
upvoted 2 times
spudteo
7 months, 1 week ago
The LOCATION of a database will determine the default location for data of all tables registered to that database. from the documentation
upvoted 2 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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