IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 45

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?

Answer options

• A. Shadow Table
• B. Temporal Table
• C. Range-Partitioned Table
• D. Multidimensional Clustered Table

Correct answer: B

Explanation

The correct answer is B, Temporal Table, as it is specifically designed to track and query historical data by maintaining previous versions of rows. The other options do not provide the functionality for querying historical data in the same way that Temporal Tables do.