- All Exams Instant Download
Which of the following approaches could be used by the data engineering team to complete this task?
A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day. They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task. Which of...
Which of the following benefits of using the Databricks Lakehouse Platform is provided by Delta Lake?
Which of the following benefits of using the Databricks Lakehouse Platform is provided by Delta Lake?A . The ability to manipulate the same data using a variety of languagesB . The ability to collaborate in real time on a single notebookC . The ability to set up alerts for query...
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,...
Which of the following data lakehouse features results in improved data quality over a traditional data lake?
Which of the following data lakehouse features results in improved data quality over a traditional data lake?A . A data lakehouse provides storage solutions for structured and unstructured data.B . A data lakehouse supports ACID-compliant transactions.C . A data lakehouse allows the use of SQL queries to examine data.D ....
Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?
Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?A . DROPB . IGNOREC . MERGED . APPENDE . INSERTView AnswerAnswer: C Explanation: To write data into a Delta table while avoiding the writing of duplicate records, you...
Which of the following Git operations must be performed outside of Databricks Repos?
Which of the following Git operations must be performed outside of Databricks Repos?A . CommitB . PullC . PushD . CloneE . MergeView AnswerAnswer: E Explanation: For following tasks, work in your Git provider: Create a pull request. Resolve merge conflicts. Merge or delete branches. Rebase a branch. https://docs.databricks.com/repos/index.html
Which of the following lines of code fills in the above blank to successfully complete the task?
A data engineer needs to create a table in Databricks using data from their organization’s existing SQLite database. They run the following command: Which of the following lines of code fills in the above blank to successfully complete the task?A . org.apache.spark.sql.jdbcB . autoloaderC . DELTAD . sqliteE . org.apache.spark.sql.sqliteView...
Which of the following describes the storage organization of a Delta table?
Which of the following describes the storage organization of a Delta table?A . Delta tables are stored in a single file that contains data, history, metadata, and other attributes.B . Delta tables store their data in a single file and all metadata in a collection of files in a separate...
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...
Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?
A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos. Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?A . Databricks Repos automatically saves development progressB . Databricks Repos supports the use...
