The team has decided to take advantage of table properties to identify a business owner for each table, which of the following table DDL syntax allows you to populate a table property identifying the business owner of a table

The team has decided to take advantage of table properties to identify a business owner for each table, which of the following table DDL syntax allows you to populate a table property identifying the business owner of a table CREATE TABLE inventory (id INT, units FLOAT)A . SET TBLPROPERTIES business_owner...

November 14, 2023No CommentsREAD 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 versionB . Commit and push codeC . Create and edit codeD . Create a new branchE . Pull request...

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

When using the complete mode to write stream data, how does it impact the target table?

When using the complete mode to write stream data, how does it impact the target table?A . Entire stream waits for complete data to writeB . Stream must complete to write the dataC . Target table cannot be updated while stream is pendingD . Target table is overwritten for each...

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