AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: A data engineer is assigned the task of databricks video

Question 1 Be Honest
« Back   Next data-engineer-professional Certification Question »
Answer

Full Certification Question

A data engineer is assigned the task of creating a table using a venues.csv file stored at dbfs:/FileStore/data/ The data engineer executes the following SQL statement and the table is created successfully. CREATE TABLE venues ( name STRING , area INT ) USING CSV LOCATION 'dbfs:/FileStore/data/' Now, the data engineer tries to add a record to the table using INSERT INTO command. Which of the following would be the output of the INSERT INTO command?