Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

• A.SELECT * FROM my_table WHERE age > 25;
• B.UPDATE my_table WHERE age > 25;
• C.DELETE FROM my_table WHERE age > 25;
• D.UPDATE my_table WHERE age <= 25;
• E.DELETE FROM my_table WHERE age <= 25;

Comment: *

Name: *

Email: *

Verification: *

A Databricks single-task workflow fails at the last task due to an error in a notebook. The data engineer fixes the mistake in the notebook. What should the data engineer do to rerun the workflow?

• A.Repair the task
• B.Rerun the pipeline
• C.Restart the cluster
• D.Switch the cluster

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?

• A.Parquet files can be partitioned
• B.CREATE TABLE AS SELECT statements cannot be used on files
• C.Parquet files have a well-defined schema
• D.Parquet files have the ability to be optimized
• E.Parquet files will become Delta tables

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes the relationship between Gold tables and Silver tables?

• A.Gold tables are more likely to contain aggregations than Silver tables.
• B.Gold tables are more likely to contain valuable data than Silver tables.
• C.Gold tables are more likely to contain a less refined view of data than Silver tables.
• D.Gold tables are more likely to contain more data than Silver tables.
• E.Gold tables are more likely to contain truthful data than Silver tables.

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database.
They run the following command:

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

• A.autoloader
• B.sqlite
• C.org.apache.spark.sql.sqlite
• D.DELTA
• E.org.apache.spark.sql.jdbc

Comment: *

Name: *

Email: *

Verification: *