A data engineer is processing ingested streaming tables and needs to filter out NULL values in the order_datetime column from the raw streaming table orders_raw and store the results in a new table orders_valid using DLT.
Which code snippet should the data engineer use?

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

Comment: *

Name: *

Email: *

Verification: *

A company is collaborating with a partner that does not use Databricks but needs access to a large historical dataset stored in Delta format. The data engineer needs to ensure that the partner can access the data securely, without the need for them to set up an account, and with read-only access. How should the data be shared?

• A.Share the dataset by exporting it to a CSV file and manually transferring the file to the partner's system.
• B.Grant your partner access to your Databricks workspace and assign them full write permissions to the Delta table, enabling them to modify the dataset.
• C.Share the dataset using Unity Catalog, ensuring that both teams have full write access to the data within the same organization.
• D.Share the dataset using Delta Sharing, which allows your partner to access the data using a secure, read-only URL without requiring a Databricks account, ensuring that they cannot modify the data.

Comment: *

Name: *

Email: *

Verification: *

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

• A.GRANT VIEW ON CATALOG customers TO team;
• B.GRANT CREATE ON DATABASE customers TO team;
• C.GRANT USAGE ON CATALOG team TO customers;
• D.GRANT CREATE ON DATABASE team TO customers;
• E.GRANT USAGE ON DATABASE customers TO team;

Comment: *

Name: *

Email: *

Verification: *

A data engineer is working with two tables. Each of these tables is displayed below in its entirety.

The data engineer runs the following query to join these tables together:

Which of the following will be returned by the above query?

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

Comment: *

Name: *

Email: *

Verification: *

A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which of the following SQL commands can be used to append the new record to an existing Delta table my_table?

• A.INSERT INTO my_table VALUES ('a1', 6, 9.4)
• B.my_table UNION VALUES ('a1', 6, 9.4)
• C.INSERT VALUES ( 'a1' , 6, 9.4) INTO my_table
• D.UPDATE my_table VALUES ('a1', 6, 9.4)
• E.UPDATE VALUES ('a1', 6, 9.4) my_table

Comment: *

Name: *

Email: *

Verification: *