A data engineer wants to create an external table from a JSON file located at/data/input.

Databricks Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 Question Answer

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

Create an external table namedusers

Automatically infer schema

Merge records with differing schemas

Which code snippet should the engineer use?

Options:

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

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

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

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

Databricks-Certified-Associate-Developer-for-Apache-Spark-3.5 PDF/Engine

Get 75% Discount on All Products, Use Coupon: "ac75sure"