Databricks-Certified-Professional-Data-Engineer Actual Questions - Instant Download 61 Questions
Download Free Latest Exam Databricks-Certified-Professional-Data-Engineer Certified Sample Questions
NEW QUESTION 20
A data engineer needs to create a database called customer360 at the loca-tion /customer/customer360. The
data engineer is unsure if one of their colleagues has already created the database.
Which of the following commands should the data engineer run to complete this task?
- A. CREATE DATABASE IF NOT EXISTS customer360 LOCATION '/customer/customer360';
- B. CREATE DATABASE customer360 DELTA LOCATION '/customer/customer360';
- C. CREATE DATABASE IF NOT EXISTS customer360 DELTA LOCATION '/customer/customer360';
- D. CREATE DATABASE IF NOT EXISTS customer360;
- E. CREATE DATABASE customer360 LOCATION '/customer/customer360';
Answer: A
NEW QUESTION 21
Which of the following locations hosts the driver and worker nodes of a Databricks-managed clus-ter?
- A. JDBC data source
- B. Databricks Filesystem
- C. Data plane
- D. Databricks web application
- E. Control plane
Answer: C
Explanation:
Explanation
See the Databricks high-level architecture
NEW QUESTION 22
Two junior data engineers are authoring separate parts of a single data pipeline notebook. They are working on
separate Git branches so they can pair program on the same notebook simultaneously. A senior data engineer
experienced in Databricks suggests there is a better alternative for this type of collaboration.
Which of the following supports the senior data engineer's claim?
- A. Databricks Notebooks support the creation of interactive data visualizations
- B. Databricks Notebooks support commenting and notification comments
- C. Databricks Notebooks support the use of multiple languages in the same notebook
- D. Databricks Notebooks support automatic change-tracking and versioning
- E. Databricks Notebooks support real-time co-authoring on a single notebook
Answer: E
NEW QUESTION 23
A data architect is designing a data model that works for both video-based machine learning work-loads and
highly audited batch ETL/ELT workloads.
Which of the following describes how using a data lakehouse can help the data architect meet the needs of
both workloads?
- A. A data lakehouse fully exists in the cloud
- B. A data lakehouse stores unstructured data and is ACID-compliant
- C. A data lakehouse combines compute and storage for simple governance
- D. A data lakehouse provides autoscaling for compute clusters
- E. A data lakehouse requires very little data modeling
Answer: B
NEW QUESTION 24
You are using k-means clustering to classify heart patients for a hospital. You have chosen Patient Sex,
Height, Weight, Age and Income as measures and have used 3 clusters. When you create a pair-wise plot of
the clusters, you notice that there is significant overlap between the clusters. What should you do?
- A. Identify additional measures to add to the analysis
- B. Decrease the number of clusters
- C. Increase the number of clusters
- D. Remove one of the measures
Answer: B
NEW QUESTION 25
A data engineer has created a Delta table as part of a data pipeline. Downstream data analysts now need
SELECT permission on the Delta table.
Assuming the data engineer is the Delta table owner, which part of the Databricks Lakehouse Plat-form can
the data engineer use to grant the data analysts the appropriate access?
- A. Jobs
B Dashboards - B. Databricks Filesystem
- C. Repos
- D. Data Explorer
Answer: C
NEW QUESTION 26
A data engineer is designing a data pipeline. The source system generates files in a shared directory that is also
used by other processes. As a result, the files should be kept as is and will accumulate in the directory. The
data engineer needs to identify which files are new since the previous run in the pipeline, and set up the
pipeline to only ingest those new files with each run.
Which of the following tools can the data engineer use to solve this problem?
- A. Databricks SQL
- B. Unity Catalog
- C. Auto Loader
- D. Delta Lake
- E. Data Explorer
Answer: C
NEW QUESTION 27
A data engineer has set up a notebook to automatically process using a Job. The data engineer's manager wants
to version control the schedule due to its complexity.
Which of the following approaches can the data engineer use to obtain a version-controllable con-figuration of
the Job's schedule?
- A. They can link the Job to notebooks that are a part of a Databricks Repo
- B. They can submit the Job once on an all-purpose cluster
- C. They can submit the Job once on a Job cluster
- D. They can download the XML description of the Job from the Job's page
- E. They can download the JSON description of the Job from the Job's page
Answer: E
NEW QUESTION 28
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 refreshed in the writing cluster before the next query is run
- B. The tables should be updated before the next query is run
- C. The tables should be altered to include metadata to not cache
- D. The tables should be stored in a cloud-based external system
- E. The tables should be converted to the Delta format
Answer: E
NEW QUESTION 29
A data engineering team is in the process of converting their existing data pipeline to utilize Auto Loader for
incremental processing in the ingestion of JSON files. One data engineer comes across the following code
block in the Auto Loader documentation:
1. (streaming_df = spark.readStream.format("cloudFiles")
2. .option("cloudFiles.format", "json")
3. .option("cloudFiles.schemaLocation", schemaLocation)
4. .load(sourcePath))
Assuming that schemaLocation and sourcePath have been set correctly, which of the following changes does
the data engineer need to make to convert this code block to use Auto Loader to ingest the data?
- A. There is no change required. Databricks automatically uses Auto Loader for streaming reads
- B. There is no change required. The inclusion of format("cloudFiles") enables the use of Auto Loader
- C. There is no change required. The data engineer needs to ask their administrator to turn on Auto Loader
- D. The data engineer needs to add the .autoLoader line before the .load(sourcePath) line
- E. The data engineer needs to change the format("cloudFiles") line to format("autoLoader")
Answer: B
NEW QUESTION 30
A data engineer wants to horizontally combine two tables as a part of a query. They want to use a shared
column as a key column, and they only want the query result to contain rows whose value in the key column is
present in both tables.
Which of the following SQL commands can they use to accomplish this task?
- A. LEFT JOIN
- B. INNER JOIN
- C. MERGE
- D. UNION
- E. OUTER JOIN
Answer: B
NEW QUESTION 31
What is the probability that the total of two dice will be greater than 8, given that the first die is a 6?
- A. 2/3
- B. 2/6
- C. 1/3
- D. 1/6
Answer: A
NEW QUESTION 32
Which of the following is a Continuous Probability Distributions?
- A. Negative binomial distribution
- B. Binomial probability distribution
- C. Normal probability distribution
- D. Poisson probability distribution
Answer: C
NEW QUESTION 33
In which phase of the data analytics lifecycle do Data Scientists spend the most time in a project?
- A. Discovery
- B. Model Building
- C. Communicate Results
- D. Data Preparation
Answer: D
NEW QUESTION 34
A data engineer has developed a code block to perform a streaming read on a data source. The code block is
below:
1. (spark
2. .read
3. .schema(schema)
4. .format("cloudFiles")
5. .option("cloudFiles.format", "json")
6. .load(dataSource)
7. )
The code block is returning an error.
Which of the following changes should be made to the code block to configure the block to successfully
perform a streaming read?
- A. A new .stream line should be added after the .read line
- B. A new .stream line should be added after the .load(dataSource) line
- C. A new .stream line should be added after the spark line
- D. The .read line should be replaced with .readStream
- E. The .format("cloudFiles") line should be replaced with .format("stream")
Answer: D
NEW QUESTION 35
A data engineer has three notebooks in an ELT pipeline. The notebooks need to be executed in a specific order
for the pipeline to complete successfully. The data engineer would like to use Delta Live Tables to manage this
process.
Which of the following steps must the data engineer take as part of implementing this pipeline using Delta
Live Tables?
- A. They need to create a Delta Live Tables pipeline from the Data page
- B. They need to create a Delta Live tables pipeline from the Compute page
- C. They need to refactor their notebook to use SQL and CREATE LIVE TABLE keyword
- D. They need to create a Delta Live Tables pipeline from the Jobs page
- E. They need to refactor their notebook to use Python and the dlt library
Answer: D
NEW QUESTION 36
A new data engineer has started at a company. The data engineer has recently been added to the company's
Databricks workspace as [email protected]. The data engineer needs to be able to query the table
sales in the database retail. The new data engineer already has been granted USAGE on the database retail.
Which of the following commands can be used to grant the appropriate permissions to the new data engineer?
- A. GRANT USAGE ON TABLE [email protected] TO sales;
- B. GRANT SELECT ON TABLE [email protected] TO sales;
- C. GRANT USAGE ON TABLE sales TO [email protected];
- D. GRANT CREATE ON TABLE sales TO [email protected];
- E. GRANT SELECT ON TABLE sales TO [email protected];
Answer: E
NEW QUESTION 37
A data engineer has written the following query:
1. SELECT *
2. 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?
- A. They need to add the cloud_files(...) wrapper to the JSON file path
- B. They need to add a CREATE LIVE TABLE table_name AS line at the beginning of the query
- C. They need to add a live. prefix prior to json. in the FROM line
- D. They need to add a CREATE DELTA LIVE TABLE table_name AS line at the beginning of the query
- E. They need to add a COMMENT line at the beginning of the query
Answer: B
NEW QUESTION 38
Which of the following statements describes Delta Lake?
- A. Delta Lake is an open format storage layer that processes data
- B. Delta Lake is an open source analytics engine used for big data workloads
- C. Delta Lake is an open source data storage format for distributed data
- D. Delta Lake is an open source platform to help manage the complete machine learning lifecycle
- E. Delta Lake is an open format storage layer that delivers reliability, security, and per-formance
Answer: E
Explanation:
Explanation
Delta Lake
NEW QUESTION 39
A data engineering manager has noticed that each of the queries in a Databricks SQL dashboard takes a few
minutes to update when they manually click the "Refresh" button. They are curious why this might be
occurring, so a team member provides a variety of reasons on why the delay might be occurring.
Which of the following reasons fails to explain why the dashboard might be taking a few minutes to update?
- A. The Job associated with updating the dashboard might be using a non-pooled endpoint
- B. The SQL endpoint being used by each of the queries might need a few minutes to start up
- C. The queries attached to the dashboard might first be checking to determine if new data is available
- D. The queries attached to the dashboard might take a few minutes to run under normal circumstances
- E. The queries attached to the dashboard might all be connected to their own, unstarted Databricks clusters
Answer: A
NEW QUESTION 40
A data engineer has a Job with multiple tasks that runs nightly. One of the tasks unexpectedly fails during 10
percent of the runs.
Which of the following actions can the data engineer perform to ensure the Job completes each night while
minimizing compute costs?
- A. They can institute a retry policy for the entire Job
- B. They can observe the task as it runs to try and determine why it is failing
- C. They can institute a retry policy for the task that periodically fails
- D. They can set up the Job to run multiple times ensuring that at least one will complete
- E. They can utilize a Jobs cluster for each of the tasks in the Job
Answer: C
NEW QUESTION 41
A data engineering team needs to query a Delta table to extract rows that all meet the same condi-tion.
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?
- A. Tuning the file size
- B. Data skipping
- C. Z-Ordering
- D. Bin-packing
- E. Write as a Parquet file
Answer: C
NEW QUESTION 42
......
Free Databricks Databricks-Certified-Professional-Data-Engineer Exam 2022 Practice Materials Collection: https://www.passtorrent.com/Databricks-Certified-Professional-Data-Engineer-latest-torrent.html