QuestionQ71
Executing queries using Databricks SQL and Databricks SQL WarehousesThe stakeholders.customers table contains 15 columns and 3,000 rows of data. The following command is executed:
After SELECT * FROM stakeholders.eur_customers is run, 15 rows are returned. Once the command has completed, the user logs out of Databricks.
When the user logs 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.
Community Discussion