Which SQL DDL command is used to create an empty Delta table named 'players' with columns playerId (INT), playerName (STRING), and playerRuns (LONG), only if a table with this name does not already exist?

Real Exam

A

CREATE OR REPLACE TABLE players( playerId INT, playerName STRING, playerRuns LONG)USING DELTA;

13.0%

B

CREATE TABLE IF NOT EXISTS players( playerId INT, playerName STRING, playerRuns LONG);

66.9%

C

CREATE OR REPLACE TABLE players WITH COLUMNS( playerId INT, playerName STRING, playerRuns LONG)USING DELTA;

5.2%

D

CREATE TABLE players IF NOT EXISTS( playerId INT, playerName STRING, playerRuns LONG)USING DELTA;

11.7%

E

CREATE OR REPLACE TABLE players ASSELECT playerId INT, playerName STRING, playerRuns LONGUSING DELTA;

3.2%

Powered ByGPT-5.2

Databricks Certified Data Engineer - Associate