Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

SAP Exam C_ABAPD_2309 Topic 1 Question 17 Discussion

Actual exam question for SAP's C_ABAPD_2309 exam
Question #: 17
Topic #: 1
[All C_ABAPD_2309 Questions]

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? Note:

There are 2 correct answers to this question.

Show Suggested Answer Hide Answer
Suggested Answer: A, C

To redefine a component of a superclass in a subclass, you need to do the following12:

You add the clause REDEFINITION to the component declaration in the subclass. This indicates that the component is inherited from the superclass and needs to be reimplemented in the subclass. The redefinition must happen in the same visibility section as the component declaration in the superclass. For example, if the superclass has a public method m1, the subclass must also declare the redefined method m1 as public with the REDEFINITION clause.

You implement the redefined component in the subclass. This means that you provide the new logic or behavior for the component that is specific to the subclass. The redefined component in the subclass will override the original component in the superclass when the subclass object is used. For example, if the superclass has a method m1 that returns 'Hello', the subclass can redefine the method m1 to return 'Hi' instead.

You cannot do any of the following:

You implement the redefined component for a second time in the superclass. This is not possible, because the superclass already has an implementation for the component that is inherited by the subclass. The subclass is responsible for providing the new implementation for the redefined component, not the superclass.

You add the clause REDEFINITION to the component in the superclass. This is not necessary, because the superclass does not need to indicate that the component can be redefined by the subclass. The subclass is the one that needs to indicate that the component is redefined by adding the REDEFINITION clause to the component declaration in the subclass.


Contribute your Thoughts:

Billye
2 months ago
This question is a real brain teaser, but I'm confident that A and B are the way to go. After all, what's the point of having a fancy column store if you're not going to take advantage of it, right? Unless, of course, you're a fan of the retro row store vibe.
upvoted 0 times
Roxane
1 days ago
I think setting the storage type to column store is a good idea for performance.
upvoted 0 times
...
Johnathon
3 days ago
Yeah, column store and column loadable make sense for a large table like spfli.
upvoted 0 times
...
Gertude
9 days ago
I agree, A and B seem like the best choices for this scenario.
upvoted 0 times
...
...
Nicolette
2 months ago
A and B, for sure. Column store and column loadable - it's like a match made in database heaven! Unless, of course, you're a row store enthusiast. In that case, you might as well move to the 90s and never look back.
upvoted 0 times
...
Royal
2 months ago
I'm going with A and C. Row store might be better for a rarely-run program, and column store is the way to go for large tables. Who needs fancy loading when you can just load the whole thing, am I right?
upvoted 0 times
Lai
20 days ago
Exactly, why complicate things with fancy loading when you can just load the whole table.
upvoted 0 times
...
Ryan
1 months ago
I agree, row store might be better for a rarely-run program, and column store is ideal for large tables.
upvoted 0 times
...
Crissy
1 months ago
I think A and C are the correct settings for the spfli database table.
upvoted 0 times
...
...
Camellia
2 months ago
Hmm, I'm not sure about B. Since this is a rarely-run program, I'm not sure if the overhead of column-level loading is worth it. Maybe A and D would be better?
upvoted 0 times
Emilio
18 days ago
Let's go with A and D for the general settings of the spfli database table.
upvoted 0 times
...
Tequila
19 days ago
Column store and page loadable would be more efficient for a large table with rare program runs.
upvoted 0 times
...
Keneth
1 months ago
I agree, column store and page loadable seem like the best options.
upvoted 0 times
...
Skye
2 months ago
I think A and D would be better for this scenario.
upvoted 0 times
...
...
Hailey
2 months ago
I'm not sure about the 'Load Unit' setting, but setting the 'Storage Type' to 'Column Store' makes sense based on the information provided.
upvoted 0 times
...
Loren
2 months ago
I agree with Ma. Since the table will have over one million rows and the program will run rarely, using 'Column Store' will optimize performance.
upvoted 0 times
...
Terina
2 months ago
I think the correct answers are A and B. Storing the table in a column store will optimize performance for this read-heavy workload, and setting the load unit to column loadable will also help with query performance.
upvoted 0 times
Jerry
1 months ago
With over one million rows, these settings will definitely make a difference in performance.
upvoted 0 times
...
Graciela
1 months ago
It's important to optimize the table for read-heavy workloads like this one.
upvoted 0 times
...
Nan
2 months ago
I think setting the load unit to column loadable is also a good idea for this scenario.
upvoted 0 times
...
Jarod
2 months ago
I agree, setting the storage type to column store will definitely help with performance.
upvoted 0 times
...
...
Ma
2 months ago
I think we should set the 'Storage Type' to 'Column Store' because it is an SAP HANA database table.
upvoted 0 times
...

Save Cancel