Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
What should you fill in the blank to successfully create a table in Databricks using data from an existing PostgreSQL database? The command is: CREATE TABLE employees USING ____________ OPTIONS (url “jdbc:postgresql:dbserver“, dbtable “employees“)
Explanation:
Using the JDBC library, Spark SQL can extract data from any existing relational database that supports JDBC. Examples include mysql, postgres, SQLite, and more. Reference: Microsoft Learn