You have a Snowflake Native Application that utilizes a managed table. After upgrading your application to version 2.0, some users report that they are missing data in the managed table. After investigation, you realize version 2.0 changed the schema of the managed table and also did not properly migrate all the data from old format into new format. Which of the following steps should be taken to address the missing data after upgrading a Snowflake Native Application?
Correct Answer: D
Option D is the correct approach. By dynamically detecting the upgrade and running a data migration script, the application ensures data integrity during the upgrade process. The data migration script will convert data from old format to new format. Option A is almost correct, however we don't assume the user is at 1.0. The application may be updated from earlier versions as well. Option B is not feasible due to operational overhead of doing it for each consumers and requires high privilege on consumer side which is not allowed for native apps. Option C is not practical or scalable. Managed tables are managed by your application code within the package, so Snowflake support won't perform data manipulation (Option E).