Certified Data Engineer Associate Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Associate Exam - Question 20


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?

Show Answer
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

16 comments
Sign in to comment
rafahbOption: A
Apr 2, 2023

A is correct

kniveszOption: A
Apr 2, 2023

es JDBC

sdas1Option: A
Apr 4, 2023

option A

XiltroXOption: A
Apr 4, 2023

Option A is correct answer

MajjjjOption: A
May 4, 2023

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.

HuroyeOption: A
Nov 15, 2023

I think the correct answer is A. All that is missing the the jdbc drive. org.apache.spark.sql.jdbc

kniveszOption: A
Apr 4, 2023

Es JDBC osea la A, pregunta con truco para confundir

surrabhi_4Option: A
Apr 4, 2023

option A

naxacod574Option: A
Apr 20, 2023

JDBC - Option A

Varma_SaraswathulaOption: A
Apr 21, 2023

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

juliom6Option: A
Jun 20, 2023

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
Jun 20, 2023

I correct myself https://docs.yugabyte.com/preview/integrations/apache-spark/spark-sql/

KalavathiPOption: A
Sep 26, 2023

A is correct

chris_machOption: A
Sep 29, 2023

A is correct

SerGreyOption: A
Jan 4, 2024

Correct answer is A

benni_aleOption: A
Apr 27, 2024

A is correct

ranjan24Option: A
Jul 17, 2024

A is correct