SAP Certified Technology Associate – SAP HANA 2.0 (SPS05) — Question 32

Which rules should you consider when creating a table distribution plan for SAP Business Suite powered by SAP HANA to get the best possible results? (Choose two.)

Answer options

• A. Keep all partitions on different hosts.
• B. Keep the number of partitions per table high.
• C. Keep the number of key columns low.
• D. Keep the number of partitioned tables low.

Correct answer: C, D

Explanation

The correct answers, C and D, focus on keeping the data model efficient. A lower number of key columns simplifies indexing and improves performance, while having fewer partitioned tables reduces complexity and overhead. Options A and B can lead to unnecessary complications and degraded performance in the system.