A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.Which Git operation does the data engineer need to run to accomplish this task?
Which file format is used for storing Delta Lake Table?
A data architect has determined that a table of the following format is necessary:Which code block is used by SQL DDL command to create an empty Delta table in the above format regardless of whether a table already exists with this name?
A data engineer has been given a new record of data:id STRING = 'a1'rank INTEGER = 6rating FLOAT = 9.4Which SQL commands can be used to append the new record to an existing Delta table my_table?
A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance.Which keyword can be used to compact the small files?
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 notices that the number of records in table transactions has not changed.What explains why the statement might not have copied any new records into the table?
