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

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

A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.

Which of the following data entities should the data engineer create?

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

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
AndreLAO
1 week, 2 days ago
Selected Answer: A
To persist data we need to create a table
upvoted 1 times
...
kowal02
1 month, 2 weeks ago
Selected Answer: A
You can create a table using CTAS: CREATE TABLE AS SELECT ... FROM ... and the results will be saved to a physical location.
upvoted 1 times
...
SrinivasR
2 months ago
Selected Answer: C
correct Answer is C View , as question say wants to create entity using couple of tables and that's needs to used by others, so i think Answer is C View.
upvoted 1 times
...
Yuvazz
7 months ago
VIEW will not be physically like Meterialized VIEW. Answer is Table
upvoted 3 times
...
MohdAltaf19
7 months, 1 week ago
Correct Answer is C As View is persited they are physically stored and accessable across cluster even when restarted or detactched .
upvoted 2 times
...
Dip1994
10 months, 1 week ago
A is the correct answer as the question is asking for physical location
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago