Which of the following lines of code fills in the above blank to successfully complete the task?
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
Answer: D
Explanation:
: In the given command, a data engineer is trying to create a table in Databricks using data from an SQLite database. The correct option to fill in the blank is “sqlite” because it specifies the type of database being connected to in a JDBC connection string. The USING clause should be followed by the format of the data, and since we are connecting to an SQLite database, “sqlite” would be appropriate here.
Reference: Create a table using JDBC JDBC connection string SQLite JDBC driver
Latest Databricks Certified Data Engineer Associate Dumps Valid Version with 87 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund