You are planning to upgrade a database application that uses merge replication. The table
currently has a column type of UNIQUEIDENTIFIER and has a DEFAULT constrain that
uses the NEWID() function. A new version of the application requires that the FILESTREAM
datatype be added to a table in the database. The data type will be used to store binary
files. Some of the files will be larger than 2 GB in size. While testing the upgrade, you
discover that replication fails on the articles that contain the FILESTREAM data. You find
out that the failure occurs when a file object is larger than 2 GB. You need to ensure that
merge replication will continue to function after the upgrade. You also need to ensure that
replication occurs without errors and has the best performance. What should you do? (More
than one answer choice may achieve the goal. Select the BEST answer.)
A.
Drop and recreate the table that will use the FILESTREAM data type.
B.
Use the sp_changemergearticle stored procedure and set the @stream_blob_columns
option to true for the table that will use the FILESTREAM data type.
C.
Change the DEFAULT constraint to use the NEWSEQUENTIALID() function.
D.
Place the table that will contain the FILESTREAM data type on a separate filegroup.