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

Explanation:

https://docs.yugabyte.com/preview/integrations/apache-spark/spark-sql/ CREATE TABLE new_employees_table USING JDBC

OPTIONS (

url "<jdbc_url>",

dbtable "<table_name>",

user ‘<username>’,

password ‘<password>’

) AS

SELECT * FROM employees_table_vw

https://docs.databricks.com/external-data/jdbc.html#language-sql

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments