- All Exams Instant Download
Which of the following locations in the Databricks product architecture hosts the notebooks and jobs?
Which of the following locations in the Databricks product architecture hosts the notebooks and jobs?A . Data plane B. Control plane C. Databricks Filesystem D. JDBC data source E. Databricks web applicationView AnswerAnswer: B Explanation: The answer is Control Pane, Databricks operates most of its services out of a control...
Which of the statements are incorrect when choosing between lakehouse and Datawarehouse?
Which of the statements are incorrect when choosing between lakehouse and Datawarehouse?A . Lakehouse can have special indexes and caching which are optimized for Machine learning B. Lakehouse cannot serve low query latency with high reliability for BI workloads, only suitable for batch workloads. C. Lakehouse can be accessed through...
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...
How would you approach resolving this issue?
A SQL Dashboard was built for the supply chain team to monitor the inventory and product orders, but all of the timestamps displayed on the dashboards are showing in UTC format, so they requested to change the time zone to the location of New York. How would you approach resolving...
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...
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...
You have configured AUTO LOADER to process incoming IOT data from cloud object storage every 15 mins, recently a change was made to the notebook code to update the processing logic but the team later realized that the notebook was failing for the last 24 hours, what steps team needs to take to reprocess the data that was not loaded after the notebook was corrected?
You have configured AUTO LOADER to process incoming IOT data from cloud object storage every 15 mins, recently a change was made to the notebook code to update the processing logic but the team later realized that the notebook was failing for the last 24 hours, what steps team needs...
Which of the following approaches can the data engineer use to obtain a version-controllable con-figuration of the Job’s schedule and configuration?
Which of the following approaches can the data engineer use to obtain a version-controllable con-figuration of the Job’s schedule and configuration?A . They can link the Job to notebooks that are a part of a Databricks Repo. B. They can submit the Job once on a Job cluster. C. They...
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....
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 storage B. Drops table from metastore, data but keeps metadata...
