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 169 discussion

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

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.

Which of the following relational objects should the data engineer create?

  • A. Spark SQL Table
  • B. View
  • C. Delta Table
  • D. Temporary view
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
e872ce8
1 month, 3 weeks ago
Selected Answer: D
A Temporary view in Databricks allows a data engineer to create a relational object that pulls data from other tables but does not require physical storage. It is session-scoped, meaning it only exists for the duration of the session and is not persisted in storage, which saves on storage costs.
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago