Which of the following developer operations in the CI/CD can only be implemented through a GIT provider when using Databricks Repos.

Which of the following developer operations in the CI/CD can only be implemented through a GIT provider when using Databricks Repos.A . Trigger Databricks Repos pull API to update the latest versionB . Commit and push codeC . Create and edit codeD . Create a new branchE . Pull request...

November 23, 2023No CommentsREAD MORE +

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_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...

November 23, 2023No CommentsREAD MORE +

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...

November 23, 2023No CommentsREAD MORE +

You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?

You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?A . AUTO LOADERB . JOBS and TASKSC . SQL EndpointsD...

November 23, 2023No CommentsREAD MORE +

What are the different ways you can schedule a job in Databricks workspace?

What are the different ways you can schedule a job in Databricks workspace?A . Continuous, IncrementalB . On-Demand runs, File notification from Cloud object storageC . Cron, On Demand runsD . Cron, File notification from Cloud object storageE . Once, ContinuousView AnswerAnswer: C Explanation: The answer is, Cron, On-Demand runs...

November 23, 2023No CommentsREAD MORE +

You are working on IOT data where each device has 5 reading in an array collected in Celsius, you were asked to covert each individual reading from Celsius to Fahrenheit, fill in the blank with an appropriate function that can be used in this scenario.

You are working on IOT data where each device has 5 reading in an array collected in Celsius, you were asked to covert each individual reading from Celsius to Fahrenheit, fill in the blank with an appropriate function that can be used in this scenario. Schema: deviceId INT, deviceTemp ARRAY<double>...

November 23, 2023No CommentsREAD MORE +