- All Exams Instant Download
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 branches B. Databricks Repos can merge changes from a secondary Git branch into a main Git branch C....
What is the underlying technology that makes the Auto Loader work?
What is the underlying technology that makes the Auto Loader work?A . Loader B. Delta Live Tables C. Structured Streaming D. DataFrames E. Live DataFamesView AnswerAnswer: C
What is the main difference between the bronze layer and silver layer in a medallion architecture?
What is the main difference between the bronze layer and silver layer in a medallion architecture?A . Duplicates are removed in bronze, schema is applied in silver B. Silver may contain aggregated data C. Bronze is raw copy of ingested data, silver contains data with production schema and optimized for...
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 lake B. Efficient storage and querying of full, unprocessed history of data C. Eliminates duplicate data, quarantines bad data D. Refined views with aggregated data E. Optimized query performance for business-critical dataView...
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 performance B. Eliminate duplicate records C. Preserves grain of original data, without any aggregations D. Data quality checks and schema enforcement E. Powers ML applications, reporting, dashboards and adhoc reports.View AnswerAnswer: E...
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 data B. Gold may contain aggregated data C. Data quality checks are applied in gold D. Silver is a copy of bronze data E. God is a copy of...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
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 LOADER B. JOBS and TASKS C. SQL Endpoints...
