Tentamen (uitwerkingen)
Databricks Certified Data Analyst Practice questions with complete solutions
- Vak
- Instelling
Databricks Certified Data Analyst Practice questions with complete solutions
[Meer zien]Voorbeeld 4 van de 42 pagina's
Voorbeeld 4 van de 42 pagina's
In winkelwagen
In winkelwagen
gesponsord bericht van onze partner
Verkoper
Volgen
Classroom
Ontvangen beoordelingen
Voorbeeld van de inhoud
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
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Classroom. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €15,22. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 85651 samenvattingen verkocht
Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen