Tentamen (uitwerkingen)
Databricks Certified Data Analyst Practice questions with correct answers
- Vak
- Instelling
Databricks Certified Data Analyst Practice questions with correct answers
[Meer zien]Voorbeeld 4 van de 37 pagina's
Voorbeeld 4 van de 37 pagina's
In winkelwagen
In winkelwagen
gesponsord bericht van onze partner
Verkoper
Volgen
Fordenken
Ontvangen beoordelingen
Voorbeeld van de inhoud
Databricks Certified Data Analyst Practicequestions with correct answers
The data analysis team wants to perform a rapid analysis of data on the tableau from 2 different
x x x x x x x x x x x x x x x x x
data sources and their behavior together, what activity would they be performing
x x x x x x x x x x x x
A) Data integration
x x
B) last-mile ETL
x x
C) Data enhancement
x x
D) data blending - ANSWER: ➡ D
x x x x xx x
Which layer in the medallion architecture is best suited for ad-hoc reporting, advanced
x x x x x x x x x x x x
analytics, and ML?
x x x
A) Diamond Layer
x x
B) Bronze Layer
x x
C) Gold Layer
x x
D) Silver Layer - ANSWER: ➡ D
x x x x xx x
What is Delta Sharing?
x x x
A) Delta sharing allows data present in only Delta format to be sharable inside the organization
x x x x x x x x x x x x x x x
only
x
B) Delta Sharing is a protocol to share data present inside databricks with other organizations
x x x x x x x x x x x x x x
C) Delta Sharing is the industry's first open protocol for secure data sharing, making it simple
x x x x x x x x x x x x x x x
to share data with other organizations regardless of where the data lives
x x x x x x x x x x x x
D) Delta Sharing is a protocol to share data present inside databricks within the organizations -
x x x x x x x x x x x x x x x
ANSWER: ➡ C
x xx x
,Which of these is the incorrect approach to handling Complex Data Types?
x x x x x x x x x x x
A) Explore and Collect
x x x
B) Support for Complex Data types is yet to be introduced
x x x x x x x x x x
C) User Defined Function
x x x
D) Lambda Function - ANSWER: ➡ B
x x x x xx x
On the dashboard, If you have a parameter added to the dashboard, how will it affect the
x x x x x x x x x x x x x x x x
visualizations:
x
A) The parameter will be used to fetch data for all the visualizations which use this parameter
x x x x x x x x x x x x x x x x
B) The parameter will be used to fetch data for some visualizations but not for others though
x x x x x x x x x x x x x x x x
they use the same parameter
x x x x x
C) The parameter is not added if a parameterized query/visualization is added
x x x x x x x x x x x
D) The parameter will not make any difference to the visualizations - ANSWER: ➡ A
x x x x x x x x x x x x xx x
What are the use of the Delta Lake Transaction log?
x x x x x x x x x
A) To provide ACID transaction capabilities
x x x x x
B) To track changes
x x x
C) All of the above
x x x x
D) None of the above - ANSWER: ➡ C
x x x x x x xx x
Which of the following is NOT a benefit of data governance?
x x x x x x x x x x
A) Consistent and high data quality for analytics and machine learning
x x x x x x x x x x
B) Data democratization for Decision-making
x x x x
C) Increased data complexity
x x x
D) Reduced time to insight - ANSWER: ➡ C
x x x x x x xx x
,Which of the following is incorrect about Auto loader in Databricks SQL:
x x x x x x x x x x x
A) Loads json, parquet, csv files
x x x x x
B) Ensures file contents are loaded only once
x x x x x x x
C) Removes duplicates in the file
x x x x x
D) Automatically uploads files - ANSWER: ➡ C
x x x x x xx x
What are various warehouse types available in Databricks SQL when creating SQL Warehouse?
x x x x x x x x x x x x
A) Serverless warehouse only
x x x
B) Serverless, Classic, and Pro
x x x x
C) Enterprise, OnPrem and Classic
x x x x
D) Classic and Pro Warehouse - ANSWER: ➡ B
x x x x x x xx x
Question 12: Correct x x
For Data Ingestion in Databricks SQL using existing files, which of the following format is not
x x x x x x x x x x x x x x x
supported by Databricks?
x x x
A) Delta
x
B) JSON
x
C) Parquet
x
D) Microsoft Word
x x
E) CSV - ANSWER: ➡ D
x x x xx x
There seem to be SSN details in a particular table, it is considered as PII data in US. How should
x x x x x x x x x x x x x x x x x x x
the data engineering team deal with the PII data here?
x x x x x x x x x x
A) PII data should be encrypted and stored.
x x x x x x x
B) PII is Publicly available information
x x x x x
C) None of the above
x x x x
D) PII data doesn't get any additional special handling - ANSWER: ➡ A
x x x x x x x x x x xx x
, Databricks can integrate with which of the following BI tools?
x x x x x x x x x
A) Tableau
x
B) Qlik
x
C) HEX
x
D) Power BI
x x
E) All of the above - ANSWER: ➡ E
x x x x x x xx x
Which of the following statement is correct to display all the cities with the condition,
x x x x x x x x x x x x x x
temperature, and humidity whose humidity is in the range of 60 to 75 from the 'weather' table?
x x x x x x x x x x x x x x x x x
A) SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75
x x x x x x x x x x
B) SELECT * FROM weather WHERE humidity IN (60 to 75)
x x x x x x x x x x
C) SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75
x x x x x x x x x x x
D) SELECT * FROM weather WHERE humidity NOT IN (60 AND 75) - ANSWER: ➡ A
x x x x x x x x x x x x x xx x
How are Delta Live Tables and Delta Lake related?
x x x x x x x x
A) Delta Lake is a subset of Delta Live Table
x x x x x x x x x
B) Delta Live Tables extends the functionality of Delta Lake.
x x x x x x x x x
C) Both are same
x x x
D) None of the above - ANSWER: ➡ B
x x x x x x xx x
Which of the following is a benefit of Delta Lake?
x x x x x x x x x
A) Time Travel capabilities
x x x
B) All of the above
x x x x
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 Fordenken. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €13,32. 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