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: *

Which SQL code snippet will correctly demonstrate a Data Definition Language (DDL) operation used to create a table?

• A.ALTFR TABIF employees add column salary DECTMA(10,2);
• B.CRFATF tabif employees ( id INT, name suing
• C.DROP TABLE employees;
• D.INSERT INTO employees (id, name) VALUES (1, 'Alice');

Comment: *

Name: *

Email: *

Verification: *

A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?

• A.REDUCE
• B.OPTIMIZE
• C.COMPACTION
• D.REPARTITION
• E.VACUUM

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:
CREATE TABLE jdbc_customer360
USING
OPTIONS (
url "jdbc:sqlite:/customers.db", dbtable "customer360"
)
Which line of code fills in the above blank to successfully complete the task?

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

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 more data than Silver tables.
• B.Gold tables are more likely to contain aggregations than Silver tables.
• C.Gold tables are more likely to contain truthful data than Silver tables.
• D.Gold tables are more likely to contain valuable data than Silver tables.
• E.Gold tables are more likely to contain a less refined view of data than Silver tables.

Comment: *

Name: *

Email: *

Verification: *