Which query is performing a streaming hop from raw data to a Bronze table?

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

Comment: *

Name: *

Email: *

Verification: *

A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start.
Which of the following actions can the data engineer perform to improve the start up time for the clusters used for the Job?

• A.They can use endpoints available in Databricks SQL
• B.They can use jobs clusters instead of all-purpose clusters
• C.They can configure the clusters to be single-node
• D.They can use clusters that are from a cluster pool
• E.They can configure the clusters to autoscale for larger data sizes

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.org.apache.spark.sql.jdbc
• B.autoloader
• C.org.apache.spark.sql.sqlite
• D.sqlite
• E.DELTA

Comment: *

Name: *

Email: *

Verification: *

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?

• A.The table's data was larger than 10 GB
• B.The table's data was smaller than 10 GB
• C.The table was external
• D.The table did not have a location
• E.The table was managed

Comment: *

Name: *

Email: *

Verification: *

A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

• A.GRANT USAGE ON DATABASE customers TO team;
• B.GRANT ALL PRIVILEGES ON DATABASE team TO customers;
• C.GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
• D.GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
• E.GRANT ALL PRIVILEGES ON DATABASE customers TO team;

Comment: *

Name: *

Email: *

Verification: *