Microsoft
70-450 · Question #20
70-450 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Question
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 constratin 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.)
Options
- ADrop and recreate the table that will use the FILESTREAM data type.
- BChange the DEFAULT constraint to use the NEWSEQUENTIALID() function.
- CPlace the table that will contain the FILESTREAM data type on a separate filegroup.
- DUse the sp_changemergearticle stored procedure and set the @stream_blob_columns
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.