The SAP BW certification exam focuses a lot on the candidate's basic foundational concepts in Business warehousing. Today's BW exam practice question is based on one such concept. Q). In SAP BW, table partitioning is used to optimize which of the following? Note: This question has more than one answer. a. Data deletion b. Activation of InfoCube c. Reporting d. Data extract e. None of the above Answer: The correct answer is 'a' and 'c'. Table partitioning is used in SAP to improve the performance of queries and load basic data. In a scenario where infocube size keeps increasing, partitioning helps keeping the database sizing and data load in check. Thus out of the options available in the question, options 'a' data deletion and 'c' reporting are the most important options.