To answer this question, we need to understand the concept of ODS (Operational Data Store) and the process of request deletion.
Option A) It is not possible to delete a request from ODS after the request has been activated.
This statement is incorrect. In an ODS, it is possible to delete a request even after it has been activated. However, deleting an active request may have implications, which we will discuss in the next options.
Option B) Deleting an (inactive) request will delete all requests that have been loaded into the ODS after this request was loaded.
This statement is incorrect. Deleting an inactive request will not delete other requests that have been loaded into the ODS after it was loaded. Each request in the ODS is independent and can be deleted individually.
Option C) Deleting an active request will delete the request from the change log table.
This statement is correct. When an active request is deleted from the ODS, it will be removed from the change log table. The change log table keeps track of all the changes made to the ODS. Deleting the request from the change log table ensures that the changes made by that request are undone.
Option D) None of the above.
This statement is incorrect. Option C is the correct statement regarding ODS request deletion.
Therefore, the correct answer is Option C. Deleting an active request will delete the request from the change log table.