You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the contents of a fact table that contains a non-clustered columnstore index. You need to run an update statem

There is no 'Pause' operation available for columnstore indexes in SQL Server 2012; this is not a valid index management option.

Changing the database recovery model to Bulk-logged affects transaction logging behavior but does not enable DML operations on tables with non-clustered columnstore indexes.

Changing a non-clustered columnstore index to a clustered columnstore index is a different structural change and does not resolve the read-only restriction in SQL Server 2012.

SQL Server 2012 non-clustered columnstore indexes are read-only, meaning any INSERT, UPDATE, or DELETE operation against the table will fail while the index exists. You must drop the index, perform the DML operation, and then recreate the index afterward.