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

Comment: *

Name: *

Email: *

Verification: *

A data engineer has created a new database using the following command:
CREATE DATABASE IF NOT EXISTS customer360;
In which of the following locations will the customer360 database be located?

• A.dbfs:/user/hive/database/customer360
• B.dbfs:/user/hive/warehouse
• C.dbfs:/user/hive/customer360
• D.More information is needed to determine the correct response

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes the storage organization of a Delta table?

• A.Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
• B.Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
• C.Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
• D.Delta tables are stored in a collection of files that contain only the data stored within the table.
• E.Delta tables are stored in a single file that contains only the data stored within the table.

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