The application owners say they need to be able to query a table and previous versions of that table. Which type of table is appropriate to satisfy this requirement?
The application owners say they need to be able to query a table and previous versions of that table. Which type of table is appropriate to satisfy this requirement?
A temporal table is designed to keep track of data changes over time, allowing users to query both current and historical data versions. This makes it the appropriate choice for application owners who need to query a table and its previous versions.
Answer is correct https://www.ibm.com/docs/en/db2/10.5?topic=tables-application-period-temporal