Which of the following is TRUE with regards to the CHECK OPTION?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the CHECK
OPTION of the CREATE VIEW Transact-SQL statement.
Which of the following is TRUE with regards to the CHECK OPTION?

A.
It creates a spatial index on a specified table and column.

B.
It makes sure the data remains visible through the view after the modification is committed
when a row is modified through a view.

C.
It prevents the view from being published as part of SQL Server replication.

D.
It prevents the base table or tables from being modified in a way that would affect the view
definition.

Explanation: