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/'
Subsequently, the engineer attempts to add a record to the table using the INSERT INTO
command. What will be the outcome of this command?