CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #50
CERTIFIED-DATA-ANALYST-ASSOCIATE Question #50: Real Exam Question with Answer & Explanation
The correct answer is B: The view has been dropped.. Option B is correct because the command run was CREATE TEMPORARY VIEW, and temporary views in Databricks are session-scoped - they exist only within the active SparkSession and are automatically dropped the moment that session ends (i.e., when the user logs out). Why the distract
Question
The stakeholders.customers table has 15 columns and 3,000 rows of data. 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?
Options
- AThe view remains available and SELECT * FROM stakeholders.eur_customers will execute
- BThe view has been dropped.
- CThe view is not available in the metastore, but the underlying data can be accessed with SELECT
- DThe view remains available but attempting to SELECT from it results in an empty result set
- EThe view has been converted into a table.
Explanation
Option B is correct because the command run was CREATE TEMPORARY VIEW, and temporary views in Databricks are session-scoped - they exist only within the active SparkSession and are automatically dropped the moment that session ends (i.e., when the user logs out).
Why the distractors are wrong:
- A is wrong because temporary views are not persisted to the metastore; they vanish with the session, so no
SELECTis possible. - C is wrong because the view doesn't survive in any accessible form - it's fully gone; however, the underlying table (
stakeholders.customers) is unaffected and still queryable independently. - D is wrong because the view doesn't return empty results - it simply doesn't exist, so the query would throw a "table/view not found" error, not return zero rows.
- E is wrong because Databricks never automatically promotes a view to a table; these are distinct object types requiring explicit DDL.
Memory tip: Think of a temporary view like a whiteboard note - it only lasts as long as you're in the room (your session). When you walk out (log off), the note is erased. If you want it to survive, use CREATE VIEW (no TEMP) to write it in the metastore permanently.
Community Discussion
No community discussion yet for this question.