Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
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?
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