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

November 10, 2023 No Comments READ MORE +

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 columnsB . Row and column access control listsC . Use dynamic view functionsD ....

November 10, 2023 No Comments READ MORE +

What is the main difference between the silver layer and the gold layer in medallion architecture?

What is the main difference between the silver layer and the gold layer in medallion architecture?A . Silver may contain aggregated dataB . Gold may contain aggregated dataC . Data quality checks are applied in goldD . Silver is a copy of bronze dataE . God is a copy of...

November 10, 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 LOADERB . JOBS and TASKSC . SQL EndpointsD...

November 10, 2023 No Comments READ MORE +

Which of the following data workloads will utilize a Bronze table as its destination?

Which of the following data workloads will utilize a Bronze table as its destination?A . A job that aggregates cleaned data to create standard summary statisticsB . A job that queries aggregated data to publish key insights into a dashboardC . A job that ingests raw data from a streaming...

November 10, 2023 No Comments READ MORE +

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

November 10, 2023 No Comments READ MORE +

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

November 10, 2023 No Comments READ MORE +

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 versioning B. Databricks notebooks should be copied to a local machine and setup source control locally to version...

March 21, 2023 No Comments READ MORE +

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?

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?A . GRANT USAGE ON TABLE table_name TO [email protected] B....

March 21, 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 20, 2023 No Comments READ MORE +