- All Exams Instant Download
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...
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...
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 statements are true about a lakehouse?
Which of the following statements are true about a lakehouse?A . Lakehouse only supports Machine learning workloads and Data warehouses support BI workloadsB . Lakehouse only supports end-to-end streaming workloads and Data warehouses support Batch workloadsC . Lakehouse does not support ACIDD . Lakehouse do not support SQLE . Lakehouse...
SELECT * FROM ____________________
SELECT * FROM ____________________A . SELECT * FROM f{schema_name.table_name}B . SELECT * FROM {schem_name.table_name}C . SELECT * FROM ${schema_name}.${table_name}D . SELECT * FROM schema_name.table_nameView AnswerAnswer: C Explanation: The answer is, SELECT * FROM ${schema_name}.${table_name} %python table_name = "sales" schema_name = "bronze" %sql SELECT * FROM ${schema_name}.${table_name} ${python variable} -> Python...
While investigating a data issue in a Delta table, you wanted to review logs to see when and who updated the table, what is the best way to review this data?
While investigating a data issue in a Delta table, you wanted to review logs to see when and who updated the table, what is the best way to review this data?A . Review event logs in the WorkspaceB . Run SQL SHOW HISTORY table_nameC . Check Databricks SQL Audit logsD...
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 ....
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 silverB . Silver may contain aggregated dataC . Bronze is raw copy of ingested data, silver contains data with production schema and optimized for...
