Answer-first summary for fast verification
Answer: dbfs:/user/hive/warehouse/university.db/
The correct answer is `dbfs:/user/hive/warehouse/university.db/`. Here's why: - **Managed Delta tables**: When you create a managed Delta table in Hive, the table data is stored within the Hive warehouse directory. - **Hive warehouse location**: By default, Hive uses the `/user/hive/warehouse` directory in the Distributed File System (DFS) for storing managed table data. - **Database name**: The table data is further organized into subdirectories based on the database name (`university.db` in this case). Therefore, the most probable location for the `students` table data is `dbfs:/user/hive/warehouse/university.db/`.
Author: LeetQuiz Editorial Team
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/