- All Exams Instant Download
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...
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 ....
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...
What is the purpose of a gold layer in Multi-hop architecture?
What is the purpose of a gold layer in Multi-hop architecture?A . Optimizes ETL throughput and analytic query performanceB . Eliminate duplicate recordsC . Preserves grain of original data, without any aggregationsD . Data quality checks and schema enforcementE . Powers ML applications, reporting, dashboards and adhoc reports.View AnswerAnswer: E...
Which of the following table constraints that can be enforced on Delta lake tables are supported?
Which of the following table constraints that can be enforced on Delta lake tables are supported?A . Primary key, foreign key, Not Null, Check ConstraintsB . Primary key, Not Null, Check ConstraintsC . Default, Not Null, Check ConstraintsD . Not Null, Check ConstraintsE . Unique, Not Null, Check ConstraintsView AnswerAnswer:...
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...
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...
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
How can we address this limitation?
When defining external tables using formats CSV, JSON, TEXT, BINARY any query on the exter-nal tables caches the data and location for performance reasons, so within a given spark session any new files that may have arrived will not be available after the initial query. How can we address this...
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...
