Certified Data Analyst Associate Exam

Exam Certified Data Analyst Associate All QuestionsBrowse all questions from this 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?

The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.

The view has been dropped.

The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.

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.

The view has been converted into a table.

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

sanjeev735Option: A

I think the answer is A