SAP Exam E_HANAAW_17 Topic 4 Question 73 Discussion

Actual exam question for SAP's E_HANAAW_17 exam

Question #: 73
Topic #: 4

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

ADirect access to a cluster on the database

BLeft outer joins in open SQL statements

CNative SQL statements

DCode that relies on implicit database sorting

EORDER BY Clauses in Open SQL statements

Show Suggested Answer

Suggested Answer: A, C, D

by Dalene at Feb 13, 2024, 02:47 PM

Limited Time Offer

25%

Off

Get Premium E_HANAAW_17 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carole

4 months ago

I think we should definitely review and potentially replace ORDER BY Clauses in Open SQL statements to avoid any issues post-migration.

upvoted 0 times

...

Hayley

5 months ago

What about ORDER BY Clauses in Open SQL statements? Should we be concerned about those too?

upvoted 0 times

...

Von

5 months ago

Yes, and we should also review any native SQL statements in the custom ABAP code.

upvoted 0 times

...

Katina

5 months ago

I think we should avoid any left outer joins in open SQL statements as well.

upvoted 0 times

...

Lorrine

5 months ago

I agree, we should also check for code that relies on implicit database sorting.

upvoted 0 times

...

Carole

5 months ago

I think we should look for and replace any direct access to a cluster on the database.

upvoted 0 times

...

Colette

5 months ago

Hmm, A, D, and E. Can't be too careful with that database stuff, you know? Wouldn't want to end up with a system that's more 'HANA-broken' than 'HANA-ready'!

upvoted 0 times

Tu

4 months ago

Absolutely, it's better to be safe than sorry when it comes to database migrations.

upvoted 0 times

...

Miesha

4 months ago

Yeah, those are key areas to focus on to ensure a smooth migration.

upvoted 0 times

...

Andrew

4 months ago

I think you're right, A, D, and E are definitely things to watch out for.

upvoted 0 times

...

Darci

5 months ago

That's a good point, we need to make sure the custom ABAP code is compatible with SAP HANA.

upvoted 0 times

...

Tomoko

5 months ago

This is like a game of 'Spot the HANA Gotcha'. I'm going with A, C, and D. Wouldn't want to end up in HANA jail for some sketchy ABAP!

upvoted 0 times

Jenise

5 months ago

User 2

upvoted 0 times

...

Tammara

5 months ago

User 1

upvoted 0 times

...

Leah

5 months ago

I think we should also be wary of any code that relies on implicit database sorting.

upvoted 0 times

...

Stevie

5 months ago

Yes, we should replace any left outer joins to avoid potential functional issues.

upvoted 0 times

...

Darci

6 months ago

What about left outer joins in open SQL statements? Should we be looking out for those too?

upvoted 0 times

...

Adelina

6 months ago

B, D, and E. Left joins, sorting, and ORDER BYs - all things that might need a closer look. Wouldn't want any nasty surprises post-migration!

upvoted 0 times

Sabine

5 months ago

B) Left outer joins in open SQL statements, D) Code that relies on implicit database sorting, E) ORDER BY Clauses in Open SQL statements

upvoted 0 times

...

Cathern

5 months ago

B) Left outer joins in open SQL statements, D) Code that relies on implicit database sorting, E) ORDER BY Clauses in Open SQL statements

upvoted 0 times

...

Maryann

6 months ago

I agree, that could cause issues during migration to SAP HANA.

upvoted 0 times

...

Youlanda

6 months ago

A, C, and D - gotta watch out for that direct database access and native SQL. Implicit sorting can trip you up too. Migration to HANA is tricky business!

upvoted 0 times