• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 4 out of 33 pages
Exam (elaborations)

Data bricks Certified Data Engineer Professional Practice Exam-2023 LATEST 2024 UPDATE

Document preview thumbnail
Preview 4 out of 33 pages

Data bricks Certified Data Engineer Professional Exam 1.A data engineer has written the following query: 1. SELECT * 2. FROM json.`/path/to/json/`; The data engineer asks a colleague for help to convert this query for use in a Delta Live Tables (DLT) pipeline. The query should create the first table in the DLT pipeline. Which of the following describes the change the colleague needs to make to the query? A. They need to add a CREATE LIVE TABLE table_name AS line at the beginning of the query B. They need to add the cloud_files(...) wrapper to the JSON file path C. They need to add a CREATE DELTA LIVE TABLE table_name AS line at the beginning of the query D. They need to add a live. prefix prior to json. in the FROM line E. They need to add a COMMENT line at the beginning of the query Answer: A 2. Which of the following describes a benefit of a data lakehouse that is unavailable in a traditional data warehouse? A. A data lakehouse couples storage and compute for complete control B. A data lakehouse provides a relational system of data management C. A data lakehouse utilizes proprietary storage formats for data D. A data lakehouse enables both batch and streaming analytics E. A data lakehouse captures snapshots of data for version control purposes Answer: D 3. Which of the following statements describes Delta Lake? A. Delta Lake is an open source platform to help manage the complete machine lear ning lifecycle B. Delta Lake is an open format storage layer that delivers reliability, security, and p er-formance C. Delta Lake is an open source data storage format for distributed data D. Delta Lake is an open source analytics engine used for big data workloads E. Delta Lake is an open format storage layer that processes data Answer: B 4.A data engineering team has created a series of tables using Parquet data stored in an external sys-tem. The team is noticing that after appending new rows to the data in the external system, their queries within Databricks are not returning the new rows. They identify the caching of the previous data as the cause of this issue. Which of the following approaches will ensure that the data returned by queries is always up- to-date? A. The tables should be updated before the next query is run B. The tables should be converted to the Delta format C. The tables should be refreshed in the writing cluster before the next query is run D. The tables should be altered to include metadata to not cache E. The tables should be stored in a cloud-based external system Answer: B 5. You are working on a email spam filtering assignment, while working o n this you find there is new word e.g. HadoopExam comes in email, and i n your solutions you never come across this word before, hence probabilit y of this words is coming in either email could be zero. So which of the following algorithm can help you to avoid zero probabilit y? A. Naive Bayes B. Laplace Smoothing C. Logistic Regression D. All of the above Answer: B


Document information

Uploaded on
January 12, 2024
Number of pages
33
Written in
2023/2024
Type
Exam (elaborations)
Contains
Questions & answers
$9.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Creativewriters
3.8
(37)
Sold
199
Followers
40
Items
2351
Last sold
1 week ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.