Databricks-Certified-Professional-Data-Engineer Exam Question 61
John Smith is a newly joined team member in the Marketing team who currently has access read access to sales tables but does not have access to delete rows from the table, which of the following commands help you accomplish this?
Databricks-Certified-Professional-Data-Engineer Exam Question 62
if you run the command VACUUM transactions retain 0 hours? What is the outcome of this command?
Databricks-Certified-Professional-Data-Engineer Exam Question 63
How do you handle failures gracefully when writing code in Pyspark, fill in the blanks to complete the below statement
1._____
2.
3. Spark.read.table("table_name").select("column").write.mode("append").SaveAsTable("new_table_name")
4.
5._____
6.
7. print(f"query failed")
1._____
2.
3. Spark.read.table("table_name").select("column").write.mode("append").SaveAsTable("new_table_name")
4.
5._____
6.
7. print(f"query failed")
Databricks-Certified-Professional-Data-Engineer Exam Question 64
A notebook accepts an input parameter that is assigned to a python variable called department and this is an optional parameter to the notebook, you are looking to control the flow of the code using this parameter. you have to check department variable is present then execute the code and if no department value is passed then skip the code execution. How do you achieve this using python?
Databricks-Certified-Professional-Data-Engineer Exam Question 65
Which of the following developer operations in CI/CD flow can be implemented in Databricks Re-pos?

