[Q23-Q46] Real Databricks-Certified-Professional-Data-Engineer dumps – Real Databricks dumps PDF in here [Apr-2023]

NEW QUESTION 23
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?

NEW QUESTION 24
Which of the following locations hosts the driver and worker nodes of a Databricks-managed clus-ter?

NEW QUESTION 25
Data engineering team has a job currently setup to run a task load data into a reporting table every day at 8: 00 AM takes about 20 mins, Operations teams are planning to use that data to run a second job, so they access latest complete set of data. What is the best to way to orchestrate this job setup?

NEW QUESTION 26
Which of the following is true, when building a Databricks SQL dashboard?

NEW QUESTION 27
A SQL Dashboard was built for the supply chain team to monitor the inventory and product orders, but all of the timestamps displayed on the dashboards are showing in UTC format, so they requested to change the time zone to the location of New York. How would you approach resolving this issue?

NEW QUESTION 28
Which of the following describes a benefit of a data lakehouse that is unavailable in a traditional data
warehouse?

NEW QUESTION 29
When investigating a data issue you realized that a process accidentally updated the table, you want to query the same table with yesterday’s version of the data so you can review what the prior version looks like, what is the best way to query historical data so you can do your analysis?

NEW QUESTION 30
What is the output of the below function when executed with input parameters 1, 3 :
1.def check_input(x,y):
2. if x < y:
3. x= x+1
4. if x<y:
5. x= x+1
6. if x <y:
7. x = x+1
8. return x
check_input(1,3)

NEW QUESTION 31
The data analyst team had put together queries that identify items that are out of stock based on orders and replenishment but when they run all together for final output the team noticed it takes a really long time, you were asked to look at the reason why queries are running slow and identify steps to improve the performance and when you looked at it you noticed all the code queries are running sequentially and using a SQL endpoint cluster. Which of the following steps can be taken to resolve the issue?
Here is the example query
1.— Get order summary
2.create or replace table orders_summary
3.as
4.select product_id, sum(order_count) order_count
5.from
6. (
7. select product_id,order_count from orders_instore
8. union all
9. select product_id,order_count from orders_online
10. )
11.group by product_id
12.– get supply summary
13.create or repalce tabe supply_summary
14.as
15.select product_id, sum(supply_count) supply_count
16.from supply
17.group by product_id
18.
19.– get on hand based on orders summary and supply summary
20.
21.with stock_cte
22.as (
23.select nvl(s.product_id,o.product_id) as product_id,
24. nvl(supply_count,0) – nvl(order_count,0) as on_hand
25.from supply_summary s
26.full outer join orders_summary o
27. on s.product_id = o.product_id
28.)
29.select *
30.from
31.stock_cte
32.where on_hand = 0

NEW QUESTION 32
Which of the following data workloads will utilize a Bronze table as its destination?

NEW QUESTION 33
As a Data Engineer, you were asked to create a delta table to store below transaction data?

NEW QUESTION 34
A data engineer has ingested data from an external source into a PySpark DataFrame raw_df. They need to
briefly make this data available in SQL for a data analyst to perform a quality assurance check on the data.
Which of the following commands should the data engineer run to make this data available in SQL for only
the remainder of the Spark session?

NEW QUESTION 35
What is the purpose of a gold layer in Multi-hop architecture?

NEW QUESTION 36
What is the underlying technology that makes the Auto Loader work?

NEW QUESTION 37
You are asked to write a python function that can read data from a delta table and return the Data-Frame, which of the following is correct?

NEW QUESTION 38
Which of the following SQL statements can replace python variables in Databricks SQL code, when the notebook is set in SQL mode?
1.%python
2.table_name = “sales”
3.schema_name = “bronze”
4.
5.%sql
6.SELECT * FROM ____________________

NEW QUESTION 39
Which of the following statements can successfully read the notebook widget and pass the python variable to a SQL statement in a Python notebook cell?

NEW QUESTION 40
What could be the expected output of query SELECT COUNT (DISTINCT *) FROM user on this table

NEW QUESTION 41
What is the output of below function when executed with input parameters 1, 3 :
1.def check_input(x,y):
2. if x < y:
3. x= x+1
4. if x>y:
5. x= x+1
6. if x <y:
7. x = x+1
8. return x

NEW QUESTION 42
Which of the below SQL commands create a Global temporary view?

NEW QUESTION 43
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?

NEW QUESTION 44
Which of the statements are incorrect when choosing between lakehouse and Datawarehouse?

NEW QUESTION 45
A Delta Live Table pipeline includes two datasets defined using STREAMING LIVE TABLE.
Three datasets are defined against Delta Lake table sources using LIVE TABLE . The table is configured to
run in Development mode using the Triggered Pipeline Mode.
Assuming previously unprocessed data exists and all definitions are valid, what is the expected outcome after
clicking Start to update the pipeline?

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