A data engineer executes the following CTAS statement in a SQL notebook attached to an All-purpose cluster: `CREATE TABLE course_students AS (SELECT c.course_name, t.student_id, t.student_name FROM courses c LEFT JOIN (SELECT s.student_id, s.student_name, e.course_id FROM students s INNER JOIN enrollments e ON s.student_id = e.student_id) t ON c.course_id = t.course_id WHERE c.active = true)`. What best describes the resulting `course_students` table?

Real Exam

It’s a virtual table with no physical data. The SELECT statement runs each time the course_students table is queried._

4.1%

It’s a Delta Lake table. The SELECT statement executes at table creation, storing its output in Delta format on the underlying storage.

73.8%

It’s a cluster-scoped virtual table. The SELECT statement runs only the first time the table is queried, storing the output in the cluster's memory.

6.9%

It’s a cluster-scoped table. The SELECT statement executes at creation, storing output in the active cluster's memory.

9.0%

It’s a session-scoped table. The SELECT statement executes at creation, storing output in the current Spark session's cache.

6.2%

Databricks Certified Data Engineer - Professional