ExamTopics Logo
Mail Us[email protected]
Menu
Sap Discussions
exam questions

Exam C_ABAPD_2309 All Questions

View all questions & answers for the C_ABAPD_2309 exam
Go to Exam

Exam C_ABAPD_2309 topic 2 question 14 discussion

Actual exam question from SAP's C_ABAPD_2309
Question #: 14
Topic #: 2
[All C_ABAPD_2309 Questions]

Given the following ABAP SQL statement excerpt from an ABAP program:

You are given the following information:
1. The data source “spfli” on line #2 is an SAP HANA database table.
2. “spfli” will be a large table with over one million rows.
3. This program is the only one in the system that accesses the table.
4. This program will run rarely.
Based on this information, which of the following general settings should you set for the spfli database table? (Choose two.)

  • A. “Storage Type” to “Row Store”
  • B. “Storage Type” to “Column Store”
  • C. “Load Unit” to “Page Loadable”
  • D. “Load Unit” to “Column Loadable”
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by avadillo74 at May 11, 2025, 8:36 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
avadillo74
3 weeks, 4 days ago
Selected Answer: BC
Row store should only be used in SAP HANA databases if the database table is used mainly for frequent single row accesses. Page Loadable is used for large tables with less frequent accesses.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel