- All Exams Instant Download
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...
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 SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_name B. COPY INTO table_name C. UPDATE table_name D. INSERT INTO OVERWRITE table_name E. INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
Which of the following commands results in the successful creation of a view on top of the delta stream (stream on delta table)?
Which of the following commands results in the successful creation of a view on top of the delta stream (stream on delta table)?A . Spark.read.format("delta").table("sales").createOrReplaceTempView("streaming_vw") B. Spark.readStream.format("delta").table("sales").createOrReplaceTempView("streaming_vw ") C. Spark.read.format("delta").table("sales").mode("stream").createOrReplaceTempView("strea ming_vw") D. Spark.read.format("delta").table("sales").trigger("stream").createOrReplaceTempView("stre aming_vw") E. Spark.read.format("delta").stream("sales").createOrReplaceTempView("streaming_vw") F. You can not create a view on streaming data source.View AnswerAnswer: B Explanation:...
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 branches B. Databricks Repos can merge changes from a secondary Git branch into a main Git branch C....
Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user's access?
Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user's access?A . Use Unity catalog to grant access to rows and columns B. Row and column access control lists C. Use dynamic view functions D....
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...
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
Which of the following programming languages can be used to build a Databricks SQL dashboard?
Which of the following programming languages can be used to build a Databricks SQL dashboard?A . Python B. Scala C. SQL D. R E. All of the aboveView AnswerAnswer: C
Data engineering team is required to share the data with Data science team and both the teams are using different workspaces in the same organization which of the following techniques can be used to simplify sharing data across?
Data engineering team is required to share the data with Data science team and both the teams are using different workspaces in the same organization which of the following techniques can be used to simplify sharing data across? *Please note the question is asking how data is shared within an...
