A data organization leader is upset about the data analysis team's reports being different from the data engineering team's reports. The leader believes the siloed nature of their organization's data engineering and data analysis architectures is to blame.
Which of the following describes how a data lakehouse could alleviate this issue?

• A.Both teams would autoscale their work as data size evolves
• B.Both teams would use the same source of truth for their work
• C.Both teams would reorganize to report to the same department
• D.Both teams would be able to collaborate on projects in real-time
• E.Both teams would respond more quickly to ad-hoc requests

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the location of database customer360?

• A.DESCRIBE LOCATION customer360;
• B.DROP DATABASE customer360;
• C.DESCRIBE DATABASE customer360;
• D.ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
• E.USE DATABASE customer360;

Comment: *

Name: *

Email: *

Verification: *

A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.
The cade block used by the data engineer is below:

If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?

• A.trigger(continuous="5 seconds")
• B.trigger()
• C.trigger(processingTime="5 seconds")
• D.trigger("5 seconds")
• E.trigger(once="5 seconds")

Comment: *

Name: *

Email: *

Verification: *

A data engineer has a Python notebook in Databricks, but they need to use SQL to accomplish a specific task within a cell. They still want all of the other cells to use Python without making any changes to those cells.
Which of the following describes how the data engineer can use SQL within a cell of their Python notebook?

• A.They can add %sql to the first line of the cell
• B.They can simply write SQL syntax in the cell
• C.They can attach the cell to a SQL endpoint rather than a Databricks cluster
• D.It is not possible to use SQL in a Python notebook
• E.They can change the default language of the notebook to SQL

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a scenario in which a data engineer will want to use a single-node cluster?

• A.When they are working interactively with a small amount of data
• B.When they are running automated reports to be refreshed as quickly as possible
• C.When they are working with SQL within Databricks SQL
• D.When they are concerned about the ability to automatically scale with larger data
• E.When they are manually running reports with a large amount of data

Comment: *

Name: *

Email: *

Verification: *