Exam (elaborations)
Databricks - Data Engineer Associate Practice Exam 5 questions with correct answers
- Course
- Institution
Databricks - Data Engineer Associate Practice Exam 5 questions with correct answers
[Show more]
Content preview
Databricks - Data Engineer AssociatePractice Exam 5 questions with correct
answers
How does Lakehouse replace the dependency on using Data lakes and Data warehouses in a
x x x x x x x x x x x x x x
Data and Analytics solution?
x x x x
a. Open, direct access to data stored in standard data formats.
x x x x x x x x x x
b. Supports ACID transactions.
x x x
c. Supports BI and Machine learning workloads
x x x x x x
d. Support for end-to-end streaming and batch workloads
x x x x x x x
e. All the above - ANSWER: ➡ e. All the above
x x x x x xx x x x x
xplanation
Lakehouse combines the benefits of a data warehouse and data lakes,
x x x x x x x x x x
Lakehouse = Data Lake + DataWarehouse x x x x x
Here are some of the major benefits of a lakehouse
x x x x x x x x x
You are currently working on storing data you received from different customer surveys, this
x x x x x x x x x x x x x
data is highly unstructured and changes over time, why Lakehouse is a better choice compared
x x x x x x x x x x x x x x x
to a Data warehouse?
x x x x
a. Lakehouse supports schema enforcement and evolution, traditional data warehouses lack
x x x x x x x x x x
schema evolution.
x x
b. Lakehouse supports SQL
x x x
,c. Lakehouse supports ACID
x x x
d. Lakehouse enforces data integrity
x x x x
e. Lakehouse supports primary and foreign keys like a data warehouse - ANSWER: ➡ a.
x x x x x x x x x x x x xx x
Lakehouse supports schema enforcement and evolution, traditional data warehouses lack
x x x x x x x x x x
schema evolution.
x x
Which of the following locations hosts the driver and worker nodes of a Databricks-managed
x x x x x x x x x x x x x
cluster?
x
a. Data plane
x x
b. Control plane
x x
c. Databricks Filesystem
x x
d. JDBC data source
x x x
e. Databricks web application - ANSWER: ➡ a. Data plane
x x x x x xx x x x
xplanation
The answer is Data Plane, which is where compute(all-purpose, Job Cluster, DLT) are stored
x x x x x x x x x x x x x
this is generally a customer cloud account, there is one exception SQL Warehouses, currently
x x x x x x x x x x x x x x
there are 3 types of SQL Warehouse compute available(classic, pro, serverless), in classic and
x x x x x x x x x x x x x x
pro compute is located in customer cloud account but serverless computed is located in
x x x x x x x x x x x x x x
Databricks cloud account.
x x x
You have written a notebook to generate a summary data set for reporting, Notebook was
x x x x x x x x x x x x x x
scheduled using the job cluster, but you realized it takes an average of 8 minutes to start the
x x x x x x x x x x x x x x x x x x
cluster, what feature can be used to start the cluster in a timely fashion?
x x x x x x x x x x x x x x
a. Setup an additional job to run ahead of the actual job so the cluster is running second job
x x x x x x x x x x x x x x x x x x
starts
x
,b. Use the Databricks cluster pools feature to reduce the startup time
x x x x x x x x x x x
c. Use Databricks Premium edition instead of Databricks standard edition
x x x x x x x x x
d. Pin the cluster in the cluster UI page so it is always available to the jobs
x x x x x x x x x x x x x x x x
e. Disable auto termination so the cluster is always running - ANSWER: ➡ b. Use the Databricks
x x x x x x x x x x x xx x x x x
cluster pools feature to reduce the startup time
x x x x x x x x
xplanation
Cluster pools allow us to reserve VM's ahead of time, when a new job cluster is created VM are
x x x x x x x x x x x x x x x x x x
grabbed from the pool. Note: when the VM's are waiting to be used by the cluster only cost
x x x x x x x x x x x x x x x x x x
incurred is Azure. Databricks run time cost is only billed once VM is allocated to a cluster.
x x x x x x x x x x x x x x x x x
Here is a demo of how to setup and follow some best practices,
x x x x x x x x x x x x
https://www.youtube.com/watch?v=FVtITxOabxg&ab_channel=DatabricksAcademy
Which of the following statement is true about Databricks repos?
x x x x x x x x x
a. You can approve the pull request if you are the owner of Databricks repos
x x x x x x x x x x x x x x
b. A workspace can only have one instance of git integration
x x x x x x x x x x
c. Databricks Repos and Notebook versioning are the same features
x x x x x x x x x
d. You cannot create a new branch in Databricks repos
x x x x x x x x x
, e. Databricks repos allow you to comment and commit code changes and push them to a remote
x x x x x x x x x x x x x x x x
branch - ANSWER: ➡ e. Databricks repos allow you to comment and commit code changes and
x x x xx x x x x x x x x x x x x
push them to a remote branch
x x x x x x
xplanation
See below diagram to understand the role Databricks Repos and Git provider plays when
x x x x x x x x x x x x x
building a CI/CD workdlow.
x x x x
All the steps highlighted in yellow can be done Databricks Repo, all the steps highlighted in
x x x x x x x x x x x x x x x
Gray are done in a git provider like Github or Azure Devops
x x x x x x x x x x x x
Which of the statement is correct about the cluster pools?
x x x x x x x x x
a. Cluster pools allow you to perform load balancing
x x x x x x x x
b. Cluster pools allow you to create a cluster
x x x x x x x x
c. Cluster pools allow you to save time when starting a new cluster
x x x x x x x x x x x x
d. Cluster pools are used to share resources among multiple teams
x x x x x x x x x x
e. Cluster pools allow you to have all the nodes in the cluster from single physical server rack -
x x x x x x x x x x x x x x x x x x
ANSWER: ➡ c. Cluster pools allow you to save time when starting a new cluster
x xx x x x x x x x x x x x x x
Once a cluster is deleted, which of the below additional actions need to performed by the
x x x x x x x x x x x x x x x
administrator?
x
a. Remove virtual machines but storage and networking are automatically dropped
x x x x x x x x x x
b. Drop storage disks but Virtual machines and networking are automatically dropped
x x x x x x x x x x x
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Fordenken. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81531 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now