DBDE

Isolated data systems can cause inconsistencies between teams, such as differing reports from the data analysis and data engineering teams. Which of the following best describes how a data lakehouse can help address this issue?

• By allowing both teams to automatically scale their workloads as data volume increases
• By enabling both teams to work from a unified and consistent source of truth
• By requiring both teams to operate under the same department or management structure
• By allowing both teams to collaborate on data projects in real time

Cluster pools will be utilized in which of the following scenarios?

• When an automated report needs to refresh as quickly as possible
• When an automated report needs to be reproducible
• When an automated report needs to be tested for errors
• When an automated report needs to be accessible to all stakeholders

Which of the following is a key benefit of using Delta Lake?

• Real-time notebook collaboration
• Query failure alerts
• Unified batch and streaming support
• Distributed data processing

How is data organized in storage when using Delta Lake?

• As raw files without any metadata
• As unstructured blobs optimized for speed
• As Parquet files with a transaction log for ACID compliance
• As JSON files grouped by ingestion time
• As key-value pairs stored in memory

Which SQL query will remove rows from a Delta table where the sales_amount is less than equal to 25?

• DELETE FROM delta_table WHERE sales_amount <= 25;
• REMOVE FROM delta_table WHERE sales_amount < 25;
• DROP ROWS FROM delta_table WHERE sales_amount <= 25;
• DELETE ROW FROM delta_table WHERE sales_amount <= 25;
• TRUNCATE delta_table WHERE sales_amount < 25;

Which of the following actions would result in the removal of old files no longer referenced by the Delta table?

• The VACUUM command was run on the table
• The DELETE HISTORY command was run on the table
• The OPTIMIZE command was run on the table
• The HISTORY command was run on the table

Which of the following best highlights a core advantage of using a data lakehouse architecture?

• It can store both structured and unstructured data efficiently
• It supports ACID-compliant transactions to ensure reliable and consistent data operations
• It enables querying data using SQL
• It uses open file formats to ensure compatibility

What is an advantage of using Databricks Repos over the built-in versioning feature of Databricks Notebooks?

• Repos automatically save notebook progress in real time
• Repos support multiple branches for collaborative development
• Repos allow reverting to earlier notebook versions
• Repos provide threaded comments directly within the notebook
• Repos eliminate the need for Git integration when tracking changes

Which of the following individuals is required to transfer ownership of Delta tables if the current owner has left the company?

• A Databricks account representative
• Ownership cannot be transferred after the owner leaves
• The workspace administrator
• The new team lead or data owner
• Any user with edit permissions on the table

A data engineering team is building a data quality pipeline using PySpark. They need to run validation tests on a Delta table named sales, which was originally created by a business intelligence team using SQL in Databricks. Which of the following commands should the engineers use to access the sales table in PySpark?

• SELECT * FROM sales
• spark.sql("sales")
• spark.delta.table("sales")
• spark.table("sales")