Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?
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 data analyst created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer.Which of the following approaches can the analyst use to complete the task?
A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.Which of the following commands can the analyst use to complete the task without producing an error?
A data analyst runs the following command:INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;What is the result of running this command?
A data engineer is working with a nested array column products in table transactions. They want to expand the table so each unique item in products for each row has its own row where the transaction_id column is duplicated as necessary.They are using the following incomplete command:Which of the following lines of code can they use to fill in the blank in the above code block so that it successfully completes the task?
