Ultimate access to all questions.
A CHECK constraint was successfully added to the Delta table activity_details
using the following SQL statement:
ALTER TABLE activity_details
ADD CONSTRAINT valid_coordinates
CHECK (
latitude >= -90 AND
latitude <= 90 AND
longitude >= -180 AND
longitude <= 180
);
A batch job is attempting to insert new records into this table, including one record with latitude = 45.50
and longitude = 212.67
.
What will be the result of this batch insert operation?