2023 Realistic Verified Databricks-Certified-Professional-Data-Engineer exam dumps Q&As - Databricks-Certified-Professional-Data-Engineer Free Update [Q102-Q117]

4.7/5 - (3 votes)

2023 Realistic Verified Databricks-Certified-Professional-Data-Engineer exam dumps Q&As – Databricks-Certified-Professional-Data-Engineer Free Update

Use Real Databricks-Certified-Professional-Data-Engineer Dumps – 100% Free Databricks-Certified-Professional-Data-Engineer Exam Dumps

NEW QUESTION 102
Create a sales database using the DBFS location ‘dbfs:/mnt/delta/databases/sales.db/’

CREATE DATABASE sales FORMAT DELTA LOCATION ‘dbfs:/mnt/delta/databases/sales.db/”

CREATE DATABASE sales USING LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’

CREATE DATABASE sales LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’

The sales database can only be created in Delta lake

CREATE DELTA DATABASE sales LOCATION ‘dbfs:/mnt/delta/databases/sales.db/’

NEW QUESTION 103
Data engineering team has provided 10 queries and asked Data Analyst team to build a dashboard and refresh the data every day at 8 AM, identify the best approach to set up data refresh for this dashaboard?

Each query requires a separate task and setup 10 tasks under a single job to run at 8 AM to refresh the dashboard

The entire dashboard with 10 queries can be refreshed at once, single schedule needs to be set up to refresh at 8 AM.

Setup JOB with linear dependency to all load all 10 queries into a table so the dashboard can be refreshed at once.

A dashboard can only refresh one query at a time, 10 schedules to set up the refresh.

Use Incremental refresh to run at 8 AM every day.

NEW QUESTION 104
How do you check the location of an existing schema in Delta Lake?

Run SQL command SHOW LOCATION schema_name

Check unity catalog UI

Use Data explorer

Run SQL command DESCRIBE SCHEMA EXTENDED schema_name
E Schemas are internally in-store external hive meta stores like MySQL or SQL Server

NEW QUESTION 105
A data analyst has provided a data engineering team with the following Spark SQL query:
1.SELECT district,
2.avg(sales)
3.FROM store_sales_20220101
4.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

NEW QUESTION 106
How does a Delta Lake differ from a traditional data lake?

Delta lake is Datawarehouse service on top of data lake that can provide reliability, se-curity, and performance

Delta lake is a caching layer on top of data lake that can provide reliability, security, and performance

Delta lake is an open storage format like parquet with additional capabilities that can provide reliability, security, and performance

Delta lake is an open storage format designed to replace flat files with additional capa-bilities that can provide reliability, security, and performance

Delta lake is proprietary software designed by Databricks that can provide reliability, security, and performance

NEW QUESTION 107
What is the probability that the total of two dice will be greater than 8, given that the first die is a 6?

1/3

2/3

1/6

2/6

NEW QUESTION 108
In order to use Unity catalog features, which of the following steps needs to be taken on man-aged/external tables in the Databricks workspace?

Enable unity catalog feature in workspace settings

Migrate/upgrade objects in workspace managed/external tables/view to unity catalog

Upgrade to DBR version 15.0

Copy data from workspace to unity catalog

Upgrade workspace to Unity catalog

NEW QUESTION 109
Which of the following statements describes Delta Lake?

Delta Lake is an open source platform to help manage the complete machine learning lifecycle

Delta Lake is an open format storage layer that delivers reliability, security, and per-formance

Delta Lake is an open source data storage format for distributed data

Delta Lake is an open source analytics engine used for big data workloads

Delta Lake is an open format storage layer that processes data

NEW QUESTION 110
What is the main difference between the silver layer and the gold layer in medalion architecture?

Silver may contain aggregated data

Gold may contain aggregated data

Data quality checks are applied in gold

Silver is a copy of bronze data

God is a copy of silver data

NEW QUESTION 111
You are asked to setup an AUTO LOADER to process the incoming data, this data arrives in JSON format and get dropped into cloud object storage and you are required to process the data as soon as it arrives in cloud storage, which of the following statements is correct

AUTO LOADER is native to DELTA lake it cannot support external cloud object storage

AUTO LOADER has to be triggered from an external process when the file arrives in the cloud storage

AUTO LOADER needs to be converted to a Structured stream process

AUTO LOADER can only process continuous data when stored in DELTA lake

AUTO LOADER can support file notification method so it can process data as it arrives

NEW QUESTION 112
You are working on IOT data where each device has 5 reading in an array collected in Celsius, you were asked to covert each individual reading from Celsius to Fahrenheit, fill in the blank with an appropriate function that can be used in this scenario.
Schema: deviceId INT, deviceTemp ARRAY<double>

SELECT deviceId, __(deviceTempC,i-> (i * 9/5) + 32) as deviceTempF
FROM sensors

APPLY

MULTIPLY

ARRAYEXPR

TRANSFORM

FORALL

NEW QUESTION 113
What is the purpose of the silver layer in a Multi hop architecture?

Replaces a traditional data lake

Efficient storage and querying of full, unprocessed history of data

Eliminates duplicate data, quarantines bad data

Refined views with aggregated data

Optimized query performance for business-critical data

NEW QUESTION 114
Which of the following approaches can the data engineer use to obtain a version-controllable con-figuration of the Job’s schedule and configuration?

They can link the Job to notebooks that are a part of a Databricks Repo.

They can submit the Job once on a Job cluster.

They can download the JSON equivalent of the job from the Job’s page.

They can submit the Job once on an all-purpose cluster.

They can download the XML description of the Job from the Job’s page

NEW QUESTION 115
You currently working with the marketing team to setup a dashboard for ad campaign analysis, since the team is not sure how often the dashboard should be refreshed they have decided to do a manual refresh on an as needed basis. Which of the following steps can be taken to reduce the overall cost of the compute when the team is not using the compute?
*Please note that Databricks recently change the name of SQL Endpoint to SQL Warehouses.

They can turn on the Serverless feature for the SQL endpoint(SQL Warehouse).

They can decrease the maximum bound of the SQL endpoint(SQL Warehouse) scaling range.

They can decrease the cluster size of the SQL endpoint(SQL Warehouse).

They can turn on the Auto Stop feature for the SQL endpoint(SQL Warehouse).

They can turn on the Serverless feature for the SQL endpoint(SQL Warehouse) and change the Spot Instance Policy from “Reliability Optimized” to “Cost optimized”

NEW QUESTION 116
Which of the below commands can be used to drop a DELTA table?

DROP DELTA table_name

DROP TABLE table_name

DROP TABLE table_name FORMAT DELTA

DROP table_name

NEW QUESTION 117
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)