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 venues.csv file located at dbfs:/FileStore/data/. The engineer successfully executes the following SQL statement to create the table:
CREATE TABLE venues
(name STRING, area INT)
USING CSV
LOCATION 'dbfs:/FileStore/data/'
CREATE TABLE venues
(name STRING, area INT)
USING CSV
LOCATION 'dbfs:/FileStore/data/'
Subsequently, the engineer attempts to add a record to the table using the INSERT INTO command. What will be the outcome of this command?
A
The record will be added to the venues table, and a new CSV file will be created in the dbfs:/FileStore/data/ directory.
B
The record will not be added to the table, and an error message will be shown.
C
The record will be added to both the table and the venues.csv file.
D
The record will not be added to the table, but a confirmation message will be displayed.
E
The record will be added to the venues.csv file but not to the venues table.