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 that is new to using Python needs to create a Python function to add two integers together and return the sum?
Which of the following code blocks can the data engineer use to complete this task?

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

A data engineer is using the following code block as part of a batch ingestion pipeline to read from a composable table:

Which of the following changes needs to be made so this code block will work when the transactions table is a stream source?

• A.Replace predict with a stream-friendly prediction function
• B.Replace schema(schema) with option ("maxFilesPerTrigger", 1)
• C.Replace "transactions" with the path to the location of the Delta table
• D.Replace format("delta") with format("stream")
• E.Replace spark.read with spark.readStream

Comment: *

Name: *

Email: *

Verification: *

Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query.
For the first week following the project's release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project's release.
Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project's release?

• A.They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
• B.They can set the query's refresh schedule to end after a certain number of refreshes.
• C.They cannot ensure the query does not cost the organization money beyond the first week of the project's release.
• D.They can set a limit to the number of individuals that are able to manage the query's refresh schedule.
• E.They can set the query's refresh schedule to end on a certain date in the query scheduler.

Comment: *

Name: *

Email: *

Verification: *