- All Exams Instant Download
You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.
You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.A . Databricks notebooks support change tracking and versioningB . Databricks notebooks should be copied to a local machine and setup source control locally to version...
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to N
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to NA . MODIFY transactions SET active_flag = 'N' WHERE active_flag = 'Y'B . MERGE transactions SET active_flag = 'N' WHERE active_flag = 'Y'C . UPDATE transactions...
table(table_name))
table(table_name))A . format, checkpointlocation, schemalocation, overwriteB . cloudfiles.format, checkpointlocation, cloudfiles.schemalocation, overwriteC . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchemaD . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwriteE . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, appendView AnswerAnswer: C Explanation: The answer is cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema. Here is the end to end syntax of streaming ELT, below link contains complete...
What steps need to be taken to set up a DELTA LIVE PIPELINE as a job using the workspace UI?
What steps need to be taken to set up a DELTA LIVE PIPELINE as a job using the workspace UI?A . DELTA LIVE TABLES do not support job clusterB . Select Workflows UI and Delta live tables tab, under task type select Delta live tables pipeline and select the notebookC...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup time
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup timeA . Setup a second job ahead of first job to start the cluster, so...
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the Databricks Lakehouse Platform?A . Databricks Repos can facilitate the pull request, review, and approval process before merging branchesB . Databricks Repos can merge changes from a secondary Git branch into a main Git branchC ....
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not been run in an hour?
A data engineer is using a Databricks SQL query to monitor the performance of an ELT job. The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL query returns the number of minutes since the job’s most recent runtime. Which of...
