ExamTopics Logo
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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
tkg13
Highly Voted 1 year, 5 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, 5 months ago
you are right, it is managed table
upvoted 2 times
...
CertPeople
1 year, 5 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, 5 months ago
Effectively doing a test on one of my clusters the table is MANAGED
upvoted 9 times
...
...
...
MarceloManhaes
Highly Voted 1 year, 4 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
...
ASRCA
Most Recent 1 month ago
Selected Answer: B
This is because the storage container is mounted to /mnt/finance_eda_bucket, and the code executed by the finance team member would create an external table in that location.
upvoted 1 times
...
AlejandroU
1 month, 3 weeks ago
Selected Answer: D
Answer D. The use of the LOCATION clause with a DBFS path (/mnt/finance_eda_bucket) suggests that Hive Metastore and DBFS location are being used. The answer is correct in the context of Hive Metastore and DBFS location, but if Unity Catalog (UC) is in use, the result would be an external table, not a managed one.
upvoted 1 times
...
benni_ale
3 months, 3 weeks ago
Selected Answer: D
No USE DATABASE statement otherwise it would have been external
upvoted 1 times
...
benni_ale
3 months, 3 weeks ago
Selected Answer: D
No USE DATABASE statement otherwise it would have been external
upvoted 1 times
...
coercion
8 months, 3 weeks 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
11 months, 2 weeks 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
11 months, 2 weeks 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 4 times
...
s_villahermosa91
1 year ago
Selected Answer: E
Correct Answer E
upvoted 2 times
...
kz_data
1 year 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
1 year, 1 month 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, 2 months 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, 2 months ago
I think the answer id D
upvoted 1 times
...
PearApple
1 year, 3 months ago
I followed the steps to create schema and table, the answer is D
upvoted 2 times
...
jerborder
1 year, 3 months 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, 3 months ago
Selected Answer: E
A managed table will be created on DBFS.
upvoted 2 times
spudteo
9 months, 3 weeks 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
...
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago