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

Suggested Answer: A 🗳️

by Dip1994 at June 25, 2024, 3:10 p.m.

Comments

Submit Cancel

Gavin1272

2 weeks ago

Selected Answer: A

The key part of the question is that it must be saved to a physical location, views are not saved to physical locations, they are logical objects. Answer is A. Table.

upvoted 1 times

...

AndreLAO

2 months, 1 week ago

Selected Answer: A

To persist data we need to create a table

upvoted 1 times

...

kowal02

3 months, 3 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

4 months, 1 week 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

...