Exam C-ABAPD-2507 Topic 5 Question 72 Discussion
Actual exam question for SAP's C-ABAPD-2507 exam
Question #: 72
Topic #: 5
Question #: 72
Topic #: 5
Given the following ABAP SQL statement excerpt from an ABAP program:
SELECT SINGLE *
FROM spfli
WHERE carrid = 'LH' AND connid = '0400'
INTO @DATA(wa).
You are given the following information:
* The data source spfli on line #2 is an SAP HANA database table.
* spfli will be a large table with over one million rows.
* This program is the only one in the system that accesses the table.
* This program will run rarely.
Based on this information, which of the following general settings should you set for the spfli database table?
Note: There are 2 correct answers to this question.
SELECT SINGLE *
FROM spfli
WHERE carrid = 'LH' AND connid = '0400'
INTO @DATA(wa).
You are given the following information:
* The data source spfli on line #2 is an SAP HANA database table.
* spfli will be a large table with over one million rows.
* This program is the only one in the system that accesses the table.
* This program will run rarely.
Based on this information, which of the following general settings should you set for the spfli database table?
Note: There are 2 correct answers to this question.
Suggested Answer: A,D Vote an answer
Comprehensive and Detailed Explanation From Exact Extract:
In SAP HANA, the choice of storage type and load unit depends on access patterns, table size, and usage frequency.
Here's how each part applies:
* A. "Storage Type" to "Row Store" - This is correct.Since:
* The table is accessed by only one program.
* The program runs rarely.
* The access pattern is row-oriented (SELECT SINGLE with filters).
Row store is more suitable for rare access with small result sets and no aggregation.
* D. "Load Unit" to "Page Loadable" - This is correct.Since the program runs infrequently, loading the entire column into memory (column loadable) is not efficient. Page-loadable units load only required parts into memory on demand, which reduces memory footprint.
Incorrect options:
* B. "Storage Type" to "Column Store" - Incorrect here. Column store is ideal for frequent reads, aggregations, or analytics, not for rarely accessed tables with simple lookups.
* C. "Load Unit" to "Column Loadable" - Also not optimal for rarely accessed data. Column loadable preloads entire columns into memory, which is memory-intensive and unnecessary in this case.
Reference:ABAP CDS Development Guide and SAP HANA Table Storage Guidelines - Recommended storage strategies based on access pattern, frequency, and usage role.
In SAP HANA, the choice of storage type and load unit depends on access patterns, table size, and usage frequency.
Here's how each part applies:
* A. "Storage Type" to "Row Store" - This is correct.Since:
* The table is accessed by only one program.
* The program runs rarely.
* The access pattern is row-oriented (SELECT SINGLE with filters).
Row store is more suitable for rare access with small result sets and no aggregation.
* D. "Load Unit" to "Page Loadable" - This is correct.Since the program runs infrequently, loading the entire column into memory (column loadable) is not efficient. Page-loadable units load only required parts into memory on demand, which reduces memory footprint.
Incorrect options:
* B. "Storage Type" to "Column Store" - Incorrect here. Column store is ideal for frequent reads, aggregations, or analytics, not for rarely accessed tables with simple lookups.
* C. "Load Unit" to "Column Loadable" - Also not optimal for rarely accessed data. Column loadable preloads entire columns into memory, which is memory-intensive and unnecessary in this case.
Reference:ABAP CDS Development Guide and SAP HANA Table Storage Guidelines - Recommended storage strategies based on access pattern, frequency, and usage role.
by Brook at Oct 15, 2026, 05:18 AM
0
0
0
10
Comments
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.
Report Comment
Commenting
You can sign-up / login (it's free).