exam questions

Exam Certified Data Engineer Professional All Questions

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

Exam Certified Data Engineer Professional topic 1 question 206 discussion

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

The data architect has mandated that all tables in the Lakehouse should be configured as external (also known as "unmanaged") Delta Lake tables.

Which approach will ensure that this requirement is met?

  • A. When a database is being created, make sure that the LOCATION keyword is used.
  • B. When the workspace is being configured, make sure that external cloud object storage has been mounted.
  • C. When data is saved to a table, make sure that a full file path is specified alongside the USING DELTA clause.
  • D. When tables are created, make sure that the UNMANAGED keyword is used in the CREATE TABLE statement.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
c315d10
3 weeks ago
Selected Answer: C
path should be provided for external table
upvoted 2 times
...
KadELbied
1 month, 1 week ago
Selected Answer: D
the correct answer is E : When tables are created, make sure that the EXTERNAL keyword is used in the CREATE TABLE statement.
upvoted 1 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 ...