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

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 . Database
B . Function
C . View
D . Temporary view
E . Table

Answer: E

Explanation:

A table is a data entity that is stored in a physical location and can be accessed by other data engineers in other sessions. A table can be created from one or more tables using the CREATE TABLE or CREATE TABLE AS SELECT commands. A table can also be registered from an existing DataFrame using the spark.catalog.createTable method. A table can be queried using SQL or DataFrame APIs. A table can also be updated, deleted, or appended using the MERGE

INTO command or the DeltaTable API.

Reference: Create a table

Create a table from a query result Register a table from a DataFrame [Query a table]

[Update, delete, or merge into a table]

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments