Data bricks Certified Data Engineer Professional Practice Exam-2023 LATEST 2024 UPDATE
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