The correct option is INSERT.

The INSERT statement adds a single new record to a database table. You specify the target table and either a VALUES clause or a subquery so that one new row is created with the provided column values.

In SQL you commonly write INSERT INTO table_name (column1, column2) VALUES (value1, value2) to add one record. The important point is that INSERT creates new data rather than reading or modifying existing data.

SELECT is wrong because it is used to retrieve rows from a table and it does not create new records. It returns data and does not perform insertion.

BigQuery is wrong because it is the name of a Google Cloud data warehouse service and not a SQL statement. You can run SQL inside BigQuery but the service name itself does not insert records.

UPDATE is wrong because it modifies existing rows in a table and does not add a new row. It is used to change values after a record already exists.

Full AWS Practitioner Certification Question