
Ultimate access to all questions.
A data engineer has created a new managed Delta table named students in the university database using the following SQL DDL:
CREATE DATABASE IF NOT EXISTS university;
USE university;
CREATE OR REPLACE TABLE students(id INT, name STRING, age INT, course STRING);
CREATE DATABASE IF NOT EXISTS university;
USE university;
CREATE OR REPLACE TABLE students(id INT, name STRING, age INT, course STRING);
Where will the data files for this table be stored?
A
dbfs:/user/warehouse/university.db/
B
dbfs:/user/hive/university.db/
C
dbfs:/user/warehouse/university/
D
dbfs:/user/hive/warehouse/university.db/
E
dbfs:/user/hive/warehouse/university/