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

March 11, 2023 No Comments READ 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...

March 11, 2023 No Comments READ MORE +

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 version B. Commit and push code C. Create and edit code D. Create a new branch E. Pull request...

March 11, 2023 No Comments READ MORE +

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

March 11, 2023 No Comments READ MORE +

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

March 11, 2023 No Comments READ 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 LOADER B. JOBS and TASKS C. SQL Endpoints...

March 11, 2023 No Comments READ 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, Incremental B. On-Demand runs, File notification from Cloud object storage C. Cron, On Demand runs D. Cron, File notification from Cloud object storage E. Once, ContinuousView AnswerAnswer: C Explanation: The answer is, Cron, On-Demand runs...

March 11, 2023 No Comments READ MORE +