Which of the following explains why the data files are no longer present?

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version,...

September 8, 2024 No Comments READ MORE +

Which of the following describes the relationship between Gold tables and Silver tables?

Which of the following describes the relationship between Gold tables and Silver tables?A . Gold tables are more likely to contain aggregations than Silver tables.B . Gold tables are more likely to contain valuable data than Silver tables.C . Gold tables are more likely to contain a less refined view...

September 8, 2024 No Comments READ MORE +

Which of the following describes how a data lakehouse could alleviate this issue?

A data organization leader is upset about the data analysis team’s reports being different from the data engineering team’s reports. The leader believes the siloed nature of their organization’s data engineering and data analysis architectures is to blame. Which of the following describes how a data lakehouse could alleviate this...

September 8, 2024 No Comments READ MORE +

Which of the following approaches can the data engineer use to set up the new task?

A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task. Which of the following approaches can the data engineer use to set...

September 6, 2024 No Comments READ MORE +

Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?

A data engineer has left the organization. The data team needs to transfer ownership of the data engineer’s Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team. Assuming the original data engineer no longer has access, which of the following...

September 6, 2024 No Comments READ MORE +

Which of the following describes why the statement might not have copied any new records into the table?

A data engineer runs a statement every day to copy the previous day’s sales into the table transactions. Each day’s sales are in their own file in the location "/transactions/raw". Today, the data engineer runs the following command to complete this task: After running the command today, the data engineer...

September 6, 2024 No Comments READ MORE +

Which of the following describes why the data files still exist and the metadata files were deleted?

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer wants to delete all table metadata and data. They run the following command: DROP TABLE IF EXISTS my_table While the object no longer appears when they run SHOW TABLES, the data files still exist. Which...

September 6, 2024 No Comments READ MORE +

Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will...

September 5, 2024 No Comments READ MORE +

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?A . SELECT * FROM my_table WHERE age > 25;B . UPDATE my_table WHERE age > 25;C . DELETE FROM...

September 4, 2024 No Comments READ MORE +

Which of the following tools is used by Auto Loader process data incrementally?

Which of the following tools is used by Auto Loader process data incrementally?A . CheckpointingB . Spark Structured StreamingC . Data ExplorerD . Unity CatalogE . Databricks SQLView AnswerAnswer: B Explanation: Auto Loader provides a Structured Streaming source called cloudFiles that can process new data files as they arrive in...

September 4, 2024 No Comments READ MORE +