Databricks Certified Data Engineer - Associate

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