Answer-first summary for fast verification
Answer: The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
The correct answer is B because the view 'stakeholders.eur_customers' is created as a permanent view (not temporary) in the stakeholders schema. Permanent views persist in the metastore across sessions and logins. The community discussion shows confusion with some users incorrectly selecting B due to misunderstanding temporary vs permanent views, but the consensus based on the actual SQL command (CREATE OR REPLACE VIEW stakeholders.eur_customers) indicates this is a permanent view that remains available. Option A correctly describes the behavior of permanent views - they remain available in the metastore and can be queried after logging back in. Options B, C, D, and E are incorrect: B wrongly claims the view is dropped, C suggests accessing underlying data directly which isn't relevant, D incorrectly states views return empty results after logout, and E wrongly claims the view converts to a table.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The stakeholders.customers table contains 15 columns and 3,000 rows. The following command is executed:
CREATE OR REPLACE VIEW stakeholders.eur_customers AS
SELECT *
FROM stakeholders.customers
WHERE region = 'EU';
CREATE OR REPLACE VIEW stakeholders.eur_customers AS
SELECT *
FROM stakeholders.customers
WHERE region = 'EU';
After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command completes, the user logs out of Databricks. Upon logging back in two days later, what is the status of the stakeholders.eur_customers view?
A
The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.
B
The view has been dropped.
C
The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. stakeholders.eur_customers.
D
The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.
E
The view has been converted into a table.