A data engineer run the following CTAS databricks video
data-engineer-professional video for a data engineer run the following CTAS statement in a SQL notebook attached to an All-purpose cluster: CREATE TABLE
Answer
Full Certification Question
A data engineer run 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 ) Which statement describes the resulting course_students table ?