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 application

Correct Answer: B

Explanation
The answer is Control Pane,
Databricks operates most of its services out of a control plane and a data plane, please note serverless features like SQL Endpoint and DLT compute use shared compute in Control pane.
Control Plane: Stored in Databricks Cloud Account
*The control plane includes the backend services that Databricks manages in its own Azure account. Notebook commands and many other workspace configurations are stored in the control plane and encrypted at rest.
Data Plane: Stored in Customer Cloud Account
*The data plane is managed by your Azure account and is where your data resides. This is also where data is processed. You can use Azure Databricks connectors so that your clusters can connect to external data sources outside of your Azure account to ingest data or for storage.
Timeline Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

Which of the following table constraints that can be enforced on Delta lake tables are supported?

• A.Primary key, foreign key, Not Null, Check Constraints
• B.Primary key, Not Null, Check Constraints
• C.Default, Not Null, Check Constraints
• D.Not Null, Check Constraints
• E.Unique, Not Null, Check Constraints

Correct Answer: D

Explanation
The answer is Not Null, Check Constraints
https://docs.microsoft.com/en-us/azure/databricks/delta/delta-constraints
* CREATE TABLE events( id LONG,
* date STRING,
* location STRING,
* description STRING
* ) USING DELTA;
ALTER TABLE events CHANGE COLUMN id SET NOT NULL;
ALTER TABLE events ADD CONSTRAINT dateWithinRange CHECK (date > '1900-01-01'); Note: Databricks as of DBR 11.1 added support for Primary Key and Foreign Key when Unity Catalog is enabled but this is for information purposes only these are not actually enforced. You may ask then why are we defining these if they are not enforced, so especially these information constraints are very helpful if you have a BI tool that can benefit from knowing the relationship between the tables, so it will be easy when creating reports/dashboards or understanding the data model when using any Data modeling tool.
Primary and Foreign Key
Graphical user interface, text, application, email Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

Which of the following SQL keywords can be used to append new rows to an existing Delta table?

• A.DELETE
• B.UNION
• C.INSERT INTO
• D.COPY
• E.UPDATE

Comment: *

Name: *

Email: *

Verification: *

Which of the following features of data lakehouse can help you meet the needs of both workloads?

• A.Data lakehouse requires very little data modeling.
• B.Data lakehouse combines compute and storage for simple governance.
• C.Data lakehouse provides autoscaling for compute clusters.
• D.Data lakehouse can store unstructured data and support ACID transactions.
• E.Data lakehouse fully exists in the cloud.

Correct Answer: D

Explanation
The answer is A data lakehouse stores unstructured data and is ACID-compliant,

Comment: *

Name: *

Email: *

Verification: *

You noticed that a team member started using an all-purpose cluster to develop a notebook and used the same all-purpose cluster to set up a job that can run every 30 mins so they can update un-derlying tables which are used in a dashboard. What would you recommend for reducing the overall cost of this approach?

• A.Reduce the size of the cluster
• B.Reduce the number of nodes and enable auto scale
• C.Enable auto termination after 30 mins
• D.Change the cluster all-purpose to job cluster when scheduling the job
• E.Change the cluster mode from all-purpose to single-mode

Correct Answer: D

Explanation
While using an all-purpose cluster is ok during development but anytime you don't need to interact with a notebook, especially for a scheduled job it is less expensive to use a job cluster. Using an all-purpose cluster can be twice as expensive as a job cluster.
Please note: The compute cost you pay the cloud provider for the same cluster type and size be-tween an all-purpose cluster and job cluster is the same the only difference is the DBU cost.
The total cost of cluster = Total cost of VM compute(Azure or AWS or GCP) + Cost per DBU The per DBU cost varies between all-purpose and Job Cluster Here is the recent cost estimate from AWS between Jobs Cluster and all-purpose Cluster, for jobs compute its
$0.15 cents per DBU v$0.55 cents per DBU for all-purpose
Graphical user interface Description automatically generated

How do I check how much the DBU cost for my cluster?
When you click on an exister cluster or when you look at the cluster details you will see this in the top right corner Graphical user interface, text, application, email Description automatically generated

Comment: *

Name: *

Email: *

Verification: *