Exam (elaborations)
Databricks Certified Data Analyst Practice questions with complete solutions
- Course
- Institution
Databricks Certified Data Analyst Practice questions with complete solutions
[Show more]
Content preview
Databricks Certified Data Analyst Practice questions withcomplete solutions
A Data Analyst has joined your team, however, he is not
familiar with Databricks SQL. Which of the following steps will
allow him to locate Data Explorer?
A) Go to SQL Warehouse, and click on the "Data Explore"
button
B) Go to SQL Editor, next to Schema Explore, and click on Data
Explore to access Data Explorer
C)Click "Data" in the sidebar menu to access the Data Explorer
D) On Databricks SQL, landing page, under SQL, click on
"Data Explore" next to "SQL Query Editor" to access Data
Explorer Correct Answer C
A data analyst has noticed that their Databricks SQL queries are
running very slowly. They claim that this issue is impacting all
of their sequentially run queries. They ask the data engineering
team for help. The data engineering team notices that each of the
queries uses the same SQL endpoint, but the SQL endpoint is
not used by any other user.
Which of the following approaches can the data engineering
team use to improve the latency of the data analyst's queries?
A) They can turn on the Auto Stop feature for the SQL endpoint.
B) They can increase the cluster size of the SQL endpoint.
C) They can increase the maximum bound of the SQL
endpoint's scaling range.
,D) They can turn on the Serverless feature for the SQL endpoint
and change the Spot Instance Policy to "Reliability Optimized."
E) They can turn on the Serverless feature for the SQL endpoint.
Correct Answer B
A data analyst wants to horizontally combine two tables as part
of a query. They want to use a shared column as a key column
and only want the query output to contain rows where the value
in the key column is present in both tables.
Which of the following SQL commands can they use to
accomplish this task?
A) OUTER JOIN
B) LEFT JOIN
C) COPY INTO
D) INNER JOIN Correct Answer D
A new data analyst da.analyst@company.com has been assigned
to a Reporting project in your organization.
You Manager has asked you to provide the new data analyst full
privileges on the table sales to manage the project entirely.
Which of the following commands can grant full permissions on
the table to the new data analyst?
A) GRANT ALL PRIVILEGES ON TABLE
da.analyst@company.com TO sales;
B) GRANT SELECT ON TABLE sales TO
da.analyst@company.com;
C) GRANT ALL PRIVILEGES ON TABLE sales TO
da.analyst@company.com;
,D) GRANT SELECT CREATE MODIFY ON TABLE sales TO
da.analyst@company.com;
E) GRANT USAGE ON TABLE sales TO
da.analyst@company.com; Correct Answer C
A new data analyst has joined your team. He has recently been
added to the company's Databricks workspace as
da.analyst@company.com. The data analyst should be able to
query the table sales in the database retail. The new data analyst
has been granted USAGE on the database retail already.
Which of the following commands can be used to grant the
appropriate permission to the new data analyst?
A)
GRANT SELECT ON TABLE sales TO
da.analyst@company.com;
B)
GRANT USAGE ON TABLE sales TO
da.analyst@company.com;
C)
GRANT SELECT ON TABLE da.analyst@company.com TO
sales;
D)
GRANT CREATE ON TABLE sales TO
da.analyst@company.com.
E)
, GRANT USAGE ON TABLE da.analyst@company.com TO
sales; Correct Answer A
A new data analyst has joined your team. He has recently been
added to the company's Databricks workspace as
da.analyst@company.com. The data analyst should be able to
query the table sales in the database retail. The new data analyst
has been granted USAGE on the database retail already.
Which of the following commands can be used to grant the
appropriate permission to the new data analyst?
A) GRANT USAGE ON TABLE sales TO
da.analyst@company.com;
B) GRANT USAGE ON TABLE da.analyst@company.com TO
sales;
C) GRANT SELECT ON TABLE da.analyst@company.com
TO sales;
D) GRANT SELECT ON TABLE sales TO
da.analyst@company.com;
E) GRANT CREATE ON TABLE sales TO
da.analyst@company.com; Correct Answer D
Account-level management of the Unity Catalog metastore
means:
A) schema, saved queries, and dashboard can be shared across
Databricks workspaces.
B) databases, tables, and views can be shared across Databricks
workspaces.
C) Delta lake will store meta information about declared schema
or database
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 Classroom. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
78861 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now