Certified Data Engineer Associate Practice Test practice questions, page 10 of 12, with answer review and explanations.
Question 46
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 of the following Git operations does the data engineer need to run to accomplish this task?
Merge
Push
Pull
Commit
Clone
Question 47
Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?
Cloud-specific integrations
Simplified governance
Ability to scale storage
Ability to scale workloads
Avoiding vendor lock-in
Question 48
A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions. In which of the following locations can the data engineer review their permissions on the table?
Databricks Filesystem
Jobs
Dashboards
Repos
Data Explorer
Question 49
Which of the following describes a scenario in which a data engineer will want to use a single-node cluster?
When they are working interactively with a small amount of data
When they are running automated reports to be refreshed as quickly as possible
When they are working with SQL within Databricks SQL
When they are concerned about the ability to automatically scale with larger data
When they are manually running reports with a large amount of data
Question 50
A data engineer has been given a new record of data: id STRING = 'a1' rank INTEGER = 6 rating FLOAT = 9.4 Which of the following SQL commands can be used to append the new record to an existing Delta table my_table?