Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data engineer is tasked with creating a table from a CSV file stored in local storage. After successfully creating the table with the SQL statement CREATE TABLE venues(name STRING, area INT) USING CSV LOCATION 'dbfs:/FileStore/data/venues.csv', the engineer attempts to add a record using the INSERT INTO command. What will be the outcome of this command?
A
The record will be inserted into the venues table and a new CSV file will be created in the dbfs:/FileStore/data/ directory.
B
The record will not be inserted into the table, and an error message will be displayed.
C
The record will be inserted into both the table and the venues.csv file.
D
The record will not be inserted into the table, but an OK message will be displayed.
E
The record will be inserted into the venues.csv file but not into the venues table.