Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Question 14 A data engineer wants to create a relational object by pulling data from two tables. The relational object must 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?
Real Exam
Community
LLeetQuiz
A
View
B
Temporary view
C
Delta Table
D
Database
E
Spark SQL Table
Explanation:
Explanation
The correct answer is A. View.
Here's why:
-
View: A view is a virtual table that represents the result of a SQL query. It doesn't store physical data but rather provides a logical representation of data from underlying tables. Views can be accessed by multiple users across different sessions, making them ideal for sharing relational objects without duplicating data.
-
Temporary view (B): Temporary views are session-scoped and cannot be accessed by other data engineers in different sessions, which violates the requirement.
-
Delta Table (C): Delta Tables store physical data on storage, which would incur storage costs and duplicate data, contrary to the requirement to avoid copying and storing physical data.
-
Database (D): A database is a container for tables and other objects, not a relational object that pulls data from tables.
-
Spark SQL Table (E): Like Delta Tables, Spark SQL Tables store physical data and would require storage space, defeating the cost-saving objective.
Views provide the perfect solution as they:
- Create relational objects from multiple tables
- Don't store physical data (no storage costs)
- Are accessible across different sessions
- Can be shared with other data engineers
Comments
Loading comments...