Correct Answer: D
To drop the temporal table or change the Schema, first, you must set System Versioning to OFF.
The below is an example of the command:
Option A is incorrect. ALTER, not MODIFY, is used to change the schema. Also, System Versioning needs to be set to OFF.Option B is incorrect. ALTER, not MODIFY, is used to change the schema.
Option C is incorrect. ALTER, not MODIFY, is used to change the schema. Also, System Versioning needs to be set to OFF.Option D is correct. ALTER and OFF are the right solution.
Option E is incorrect. System versioning needs to be set to OFF, not ON.
Option F is incorrect. System versioning needs to be set to OFF, not NULL.
Reference:
To know more about Temporal Tables, please visit the below-given link:
https://visualbi.com/blogs/microsoft/azure/designing-slowly-changing-dimension-scd-azure-data-factory-using-sql-server-temporal-tables/