Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
How can a data engineer register the table orders from an existing SQLite database?
A
CREATE TABLE orders USING org.apache.spark.sql.jdbc OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
CREATE TABLE orders USING org.apache.spark.sql.jdbc OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
B
CREATE TABLE orders USING sqlite OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
CREATE TABLE orders USING sqlite OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
C
CREATE TABLE orders USING cloudfiles OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
CREATE TABLE orders USING cloudfiles OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
D
CREATE TABLE orders USING EXTERNAL OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
CREATE TABLE orders USING EXTERNAL OPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
E
CREATE TABLE ordersUSING DATABASEOPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)
CREATE TABLE ordersUSING DATABASEOPTIONS (
url “jdbc:sqlite:/bookstore.db“,
dbtable “orders“
)