1. Home
  2. Discussions
  3. Databricks
  4. Databricks Certification
  5. Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Discussions
  6. Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Exam Topic 3 Question 25 Discussion

Databricks Certified Associate Developer for Apache Spark 3.5 – Python Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Question # 25 Topic 3 Discussion

 Databricks Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Databricks Certified Associate Developer for Apache Spark 3.5 – Python Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Question # 25 Topic 3 Discussion

Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Exam Topic 3 Question 25 Discussion:
Question #: 25
Topic #: 3

A data engineer wants to create an external table from a JSON file located at /data/input.json with the following requirements:

Create an external table named users

Automatically infer schema

Merge records with differing schemas

Which code snippet should the engineer use?

Options:
A.

CREATE TABLE users USING json OPTIONS (path '/data/input.json')

B.

CREATE EXTERNAL TABLE users USING json OPTIONS (path '/data/input.json')

C.

CREATE EXTERNAL TABLE users USING json OPTIONS (path '/data/input.json', mergeSchema 'true')

D.

CREATE EXTERNAL TABLE users USING json OPTIONS (path '/data/input.json', schemaMerge 'true')

Get Premium Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Questions
Actual exam question for Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 exam by Xander2965 at Oct 20, 2025, 3:32:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next