ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Analyst Associate All Questions

View all questions & answers for the Certified Data Analyst Associate exam
Go to Exam

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 Hide Answer
Suggested Answer: B 🗳️
by RasipalayamRDK at March 4, 2024, 9:33 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Az61
3 months, 1 week 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
6 months, 3 weeks ago
Selected Answer: B
temporary views are dropped after the user's session end
upvoted 3 times
...
31cadd7
7 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
8 months, 3 weeks ago
Selected Answer: B
It is a temp view that will get deleted after user closes current sessionm
upvoted 2 times
...
sanjeev735
10 months, 2 weeks ago
I think the answer is A
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago