Exam Certified Data Analyst Associate topic 1 question 17 discussion

Actual exam question from Databricks's Certified Data Analyst Associate

Question #: 17
Topic #: 1

[All Certified Data Analyst Associate Questions]

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?

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by RasipalayamRDK at March 4, 2024, 9:33 p.m.

Comments

Submit Cancel

Az61

5 months, 2 weeks ago

Selected Answer: B

TEMPORARY views are visible only to the session that created them and are dropped when the session ends.

upvoted 1 times

...

MDWPartners

9 months ago

Selected Answer: B

temporary views are dropped after the user's session end

upvoted 3 times

...

31cadd7

9 months, 2 weeks ago

Selected Answer: A

Views in Databricks are metadata objects that do not store data themselves but provide a virtual representation of the underlying data. Once created, a view remains available in the metastore even after the user logs out. Therefore, SELECT * FROM stakeholders.eur_customers will execute correctly when the user logs back in.

upvoted 1 times

...

csrazdan

10 months, 4 weeks ago

Selected Answer: B

It is a temp view that will get deleted after user closes current sessionm

upvoted 2 times

...

sanjeev735

1 year ago

I think the answer is A

upvoted 1 times

...