Q 1. An administrator is asked to keep a daily backup of a very large transaction table. The table is defined with a PPI with a daily partitioning expression on insert date and the table is insert only. There is not enough of a window to backup the entire table each night. In this situation, which backup strategy is the best approach?
Q 2. A customer has a requirement to load data from a single message queue into a Sales table that is part of an active data warehouse. The Sales table has no additional indexes. The data latency requirements are daily. What is the most effective approach to support this requirement?
New applications are consistently being added to the current system. The administrator plans to analyze the workload to determine if adding indexes will be beneficial to the existing applications and to what extent the system can handle the additional work. Which tool should be used along with the Teradata Index Wizard to assist in the analysis?