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?
Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam
Question 20
Correct Answer: A
To create a table in Databricks using data from an SQLite database, you need to use the JDBC (Java Database Connectivity) format. The correct line of code to fill in the blank in this context is 'org.apache.spark.sql.jdbc'. This specifies that Spark should use the JDBC source to connect to the SQLite database and create the desired table. Therefore, the correct answer is option A.
Discussion
rafahbOption: A
A is correct
kniveszOption: A
es JDBC
HuroyeOption: A
I think the correct answer is A. All that is missing the the jdbc drive. org.apache.spark.sql.jdbc
MajjjjOption: A
To specify the JDBC driver and other options, the using clause should be followed by the fully qualified name of the JDBC data source, which is org.apache.spark.sql.jdbc.
XiltroXOption: A
Option A is correct answer
sdas1Option: A
option A
ranjan24Option: A
A is correct
benni_aleOption: A
A is correct
SerGreyOption: A
Correct answer is A
chris_machOption: A
A is correct
KalavathiPOption: A
A is correct
juliom6Option: A
must be "USING JDBC", there is no such thing as "USING org.apache.spark.sql.jdbc". https://docs.databricks.com/external-data/jdbc.html#language-sql
juliom6
I correct myself https://docs.yugabyte.com/preview/integrations/apache-spark/spark-sql/
Varma_SaraswathulaOption: A
Answer A - CREATE TABLE new_employees_table USING JDBC OPTIONS ( url "<jdbc_url>", dbtable "<table_name>", user '<username>', password '<password>' ) AS SELECT * FROM employees_table_vw
naxacod574Option: A
JDBC - Option A
surrabhi_4Option: A
option A
kniveszOption: A
Es JDBC osea la A, pregunta con truco para confundir