You are looking to process the data based on two variables, one to check if the department is supply chain and second to check if process flag is set to True

You are looking to process the data based on two variables, one to check if the department is supply chain and second to check if process flag is set to TrueA . if department = “supply chain” & process:B . if department == “supply chain” && process:C . if department...

November 13, 2023No CommentsREAD MORE +

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

November 13, 2023No CommentsREAD MORE +

What is the purpose of the silver layer in a Multi hop architecture?

What is the purpose of the silver layer in a Multi hop architecture?A . Replaces a traditional data lakeB . Efficient storage and querying of full, unprocessed history of dataC . Eliminates duplicate data, quarantines bad dataD . Refined views with aggregated dataE . Optimized query performance for business-critical dataView...

November 13, 2023No CommentsREAD MORE +

What is the purpose of a silver layer in Multi hop architecture?

What is the purpose of a silver layer in Multi hop architecture?A . Replaces a traditional data lakeB . Efficient storage and querying of full and unprocessed history of dataC . A schema is enforced, with data quality checks.D . Refined views with aggregated dataE . Optimized query performance for...

November 13, 2023No CommentsREAD 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 13, 2023No CommentsREAD 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 13, 2023No CommentsREAD MORE +

If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?

If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?A . Default location, DBFS:/user/B . Default location, /user/db/C . Default Storage accountD . Statement fails “Unable to create database without location”E . Default Location, dbfs:/user/hive/warehouseView AnswerAnswer: E...

November 13, 2023No CommentsREAD MORE +

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

November 13, 2023No CommentsREAD MORE +

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, appendE . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwriteView AnswerAnswer: C

November 13, 2023No CommentsREAD MORE +

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

November 13, 2023No CommentsREAD MORE +