Online Databricks Certified Data Engineer Professional Study Materials

test2022-08-25T03:54:49+00:00

Do you want to pass the Databricks Certified Data Engineer Professional exam with flying colors? The best tips to pass Databricks Certified Data Engineer Professional exam is to use Databricks Certified Data Engineer Professional Study Materials. FreeTestShare Databricks Certified Data Engineer Professional Study Materials allow you to practice the types of questions that may occur on the exam and to think about the answers ahead of time. Databricks Certified Data Engineer Professional Study Materials are exactly the right study tools that contain real exam questions and answers to help you pass the exam on the first try!

Take a free practice test to assess your skills!

Page 1 of 1

1. Which of the following locations hosts the driver and worker nodes of a Databricks-managed clus-ter?

Data plane

Control plane

Databricks Filesystem

Databricks web application

JDBC data source

2. Which of the following describes a scenario in which a data engineer will want to use a Job cluster instead of an all-purpose cluster?

An ad-hoc analytics report needs to be developed while minimizing compute costs

A data engineer needs to manually investigate a production error

An automated workflow needs to be run every 30 minutes

A data team needs to collaborate on the development of a machine learning model

A Databricks SQL query needs to be scheduled for upward reporting

3. WITH COLUMNS ( id STRING, birthDate DATE, avgRating FLOAT ) USING DELTA

E. 1. CREATE OR REPLACE TABLE table_name ( id STRING, birthDate DATE, avgRating FLOAT )

4. A data engineering team needs to query a Delta table to extract rows that all meet the same condition.

However, the team has noticed that the query is running slowly. The team has already tuned the size of the data files. Upon investigating, the team has concluded that the rows meeting the condition are sparsely located throughout each of the data files.

Based on the scenario, which of the following optimization techniques could speed up the query?

Tuning the file size

Bin-packing

Data skipping

Write as a Parquet file

Z-Ordering

5. GROUP BY district;

The data analyst would like the data engineering team to run this query every day. The date at the end of the table name (20220101) should automatically be replaced with the current date each time the query is run.

Which of the following approaches could be used by the data engineering team to efficiently auto-mate this process?

They could wrap the query using PySpark and use Python's string variable system to automatically update the table name

They could request that the data analyst rewrites the query to be run less frequently

They could pass the table into PySpark and develop a robustly tested module on the existing query

They could replace the string-formatted date in the table with a timestamp-formatted date

They could manually replace the date within the table name with the current day's date

6. Which method is used to solve for coefficients b0, b1, ... bn in your linear regression model:

Y = b0+b1x1+b2x2+ .... +bnxn

Apriori Algorithm

Ridge and Lasso

Ordinary Least squares

Integer programming

7. FROM json.`/path/to/json/file.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?

They need to add a CREATE LIVE TABLE table_name AS line at the beginning of the query

They need to add the cloud_files(...) wrapper to the JSON file path

They need to add a CREATE DELTA LIVE TABLE table_name AS line at the beginning of the query

They need to add a live. prefix prior to json. in the FROM line

They need to add a COMMENT line at the beginning of the query

8. A denote the event 'student is female' and let B denote the event 'student is French'. In a class of 100 students suppose 60 are French, and suppose that 10 of the French students are females. Find the probability that if I pick a French student, it will be a girl, that is, find P(A|B).

1/3

2/3

1/6

2/6

9. Suppose there are three events then which formula must always be equal to P(E1|E2,E3)?

P(E1,E2,E3)P(E1)/P(E2:E3)

P(E1,E2;E3)/P(E2,E3)

P(E1,E2|E3)P(E2|E3)P(E3)

P(E1,E2|E3)P(E3)

P(E1,E2,E3)P(E2)P(E3)

10. Which of the following describes a benefit of a data lakehouse that is unavailable in a traditional data

warehouse?

A data lakehouse couples storage and compute for complete control

A data lakehouse provides a relational system of data management

A data lakehouse utilizes proprietary storage formats for data

A data lakehouse enables both batch and streaming analytics

A data lakehouse captures snapshots of data for version control purposes