- All Exams Instant Download
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...
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, overwriteE . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, appendView AnswerAnswer: C Explanation: The answer is cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema. Here is the end to end syntax of streaming ELT, below link contains complete...
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python?
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python? row_count = spark.sql("select count(*) from table").collect()[0][0]A . assert (row_count = 10, "Row count did not match")B . assert if (row_count = 10, "Row...
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...
AS SELECT * FROM table_name
AS SELECT * FROM table_nameView AnswerAnswer: C Explanation:
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...
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...
When you drop an external DELTA table using the SQL Command DROP TABLE table_name, how does it impact metadata (delta log, history), and data stored in the storage?
When you drop an external DELTA table using the SQL Command DROP TABLE table_name, how does it impact metadata (delta log, history), and data stored in the storage?A . Drops table from metastore, metadata (delta log, history) and data in storageB . Drops table from metastore, data but keeps metadata...
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...
Which of the following developer operations in CI/CD flow can be implemented in Databricks Re-pos?
Which of the following developer operations in CI/CD flow can be implemented in Databricks Re-pos?A . Delete branchB . Trigger Databricks CICD pipelineC . Commit and push codeD . Create a pull requestE . Approve the pull requestView AnswerAnswer: C Explanation: The answer is Commit and push code. See the...
