Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Objective: Identify DDL (Data Definition Language)/DML features.
A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which SQL command can be used to append the new record to an existing Delta table my_table?_
Other Sources
Community
UAnonymous
Explanation:
The correct syntax to append a single row to a table in SQL (including Delta tables) is INSERT INTO table_name VALUES (...). Options A and B use UPDATE which modifies existing rows and requires a WHERE clause and SET syntax, not VALUES. Option C uses an invalid order (INSERT VALUES ... INTO ...) which is not valid SQL. Therefore option D is correct: INSERT INTO my_table VALUES ('a1', 6, 9.4). In practice it's recommended to specify column names explicitly, e.g., INSERT INTO my_table (id, rank, rating) VALUES ('a1', 6, 9.4), to avoid mistakes if table schema changes._
Comments
Loading comments...