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("5 seconds")
• B.trigger()
• C.trigger(once="5 seconds")
• D.trigger(processingTime="5 seconds")
• E.trigger(continuous="5 seconds")

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables.
Which of the following commands should be run to create a new table all_transactions that contains all records from march_transactions and april_transactions without duplicate records?

• A.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  MERGE SELECT * FROM april_transactions;
• B.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  INTERSECT SELECT * from april_transactions;
• C.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  INNER JOIN SELECT * FROM april_transactions;
• D.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  UNION SELECT * FROM april_transactions;
• E.CREATE TABLE all_transactions AS
  SELECT * FROM march_transactions
  OUTER JOIN SELECT * FROM april_transactions;

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

• A.None of these lines of code are needed to successfully complete the task
• B.USING CSV
• C.FROM CSV
• D.USING DELTA
• E.FROM "path/to/csv"

Comment: *

Name: *

Email: *

Verification: *

Which of the following is hosted completely in the control plane of the classic Databricks architecture?

• A.Worker node
• B.JDBC data source
• C.Databricks web application
• D.Databricks Filesystem
• E.Driver node

Comment: *

Name: *

Email: *

Verification: *