Certified Data Analyst Associate Exam QuestionsBrowse all questions from this exam

Certified Data Analyst Associate Exam - Question 17


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?

Show Answer
Correct Answer: B

A temporary view in Databricks is session-scoped, meaning it only exists for the duration of the session in which it was created. Once the user logs out, the session ends, and any temporary views created during that session are dropped. Therefore, after logging back in two days later, the stakeholders.eur_customers view will no longer be available, meaning it has been dropped.

Discussion

1 comment
Sign in to comment
sanjeev735Option: A
Jun 5, 2024

I think the answer is A