Exam Databricks-Certified-Data-Analyst-Associate Topic 4 Question 26 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Analyst-Associate exam
Question #: 26
Topic #: 4

The stakeholders.customers table has 15 columns and 3,000 rows of dat
a. The following command is run:

After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks.
After 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.

Suggested Answer: A Vote an answer

In Databricks, a view is a saved SQL query definition that references existing tables or other views. Once created, a view remains persisted in the metastore (such as Unity Catalog or Hive Metastore) until it is explicitly dropped.
Key points:
Views do not store data themselves but reference data from underlying tables.
Logging out or being inactive does not delete or alter views.
Unless a user or admin explicitly drops the view or the underlying data/table is deleted, the view continues to function as expected.
Therefore, after logging back in-even days later-a user can still run SELECT * FROM stakeholders.eur_customers, and it will return the same data (provided the underlying table hasn't changed).

by Maureen at Apr 16, 2026, 03:30 AM

Limited Time Offer

15%

Off

Get Premium Databricks-Certified-Data-Analyst-Associate Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business