How do you check the location of an existing schema in Delta Lake?

• A.Run SQL command SHOW LOCATION schema_name
• B.Check unity catalog UI
• C.Use Data explorer
• D.Run SQL command DESCRIBE SCHEMA EXTENDED schema_name
  E Schemas are internally in-store external hive meta stores like MySQL or SQL Server

Correct Answer: D

Explanation
Here is an example of how it looks
Graphical user interface, text, application, email Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer: E

Explanation
The answer is Powers ML applications, reporting, dashboards and adhoc reports.
Review the below link for more info,
Medallion Architecture - Databricks
Gold Layer:
1.Powers Ml applications, reporting, dashboards, ad hoc analytics
2.Refined views of data, typically with aggregations
3.Reduces strain on production systems
4.Optimizes query performance for business-critical data
Exam focus: Please review the below image and understand the role of each layer(bronze, silver, gold) in medallion architecture, you will see varying questions targeting each layer and its purpose.
Sorry I had to add the watermark some people in Udemy are copying my content.

Comment: *

Name: *

Email: *

Verification: *

You are currently working on a project that requires the use of SQL and Python in a given note-book, what would be your approach

• A.Create two separate notebooks, one for SQL and the second for Python
• B.A single notebook can support multiple languages, use the magic command to switch between the two.
• C.Use an All-purpose cluster for python, SQL endpoint for SQL
• D.Use job cluster to run python and SQL Endpoint for SQL

Comment: *

Name: *

Email: *

Verification: *

Which of the following locations hosts the driver and worker nodes of a Databricks-managed clus-ter?

• A.Data plane
• B.Control plane
• C.Databricks Filesystem
• D.JDBC data source
• E.Databricks web application

Correct Answer: A

Explanation
The answer is Data Plane, which is where compute(all-purpose, Job Cluster, DLT) are stored this is generally a customer cloud account, there is one exception SQL Warehouses, currently there are 3 types of SQL Warehouse compute available(classic, pro, serverless), in classic and pro compute is located in customer cloud account but serverless computed is located in Databricks cloud account.
Diagram, timeline Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

While investigating a data issue, you wanted to review yesterday's version of the table using below command, while querying the previous version of the table using time travel you realized that you are no longer able to view the historical data in the table and you could see it the table was updated yesterday based on the table history(DESCRIBE HISTORY table_name) command what could be the reason why you can not access this data?
SELECT * FROM table_name TIMESTAMP AS OF date_sub(current_date(), 1)

• A.You currently do not have access to view historical data
• B.By default, historical data is cleaned every 180 days in DELTA
• C.A command VACUUM table_name RETAIN 0 was ran on the table
• D.Time travel is disabled
• E.Time travel must be enabled before you query previous data

Comment: *

Name: *

Email: *

Verification: *