- All Exams Instant Download
Which task can you perform with the SQL Monitor (transaction SQLM)?
Which task can you perform with the SQL Monitor (transaction SQLM)?A . Capture the SQL profile of an application. B. Search for problematic SELECT * statements. C. Combine static and dynamic performance analysis results. D. Display the execution plan of an SQL statement.View AnswerAnswer: A
Which of the following objects must you create?
You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-In (BAdI). Which of the following objects must you create? Note: There are 3 correct answers to this question.A . A BAdI fallback implementation B. A BAdI definition C. A...
Why would you choose HTA?
Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA), and NOT the SAP HANA Transport Container (HTC). Why would you choose HTA? Note: There are 2 correct answers to this question.A . Because you use...
What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Note: There are 2 correct answers to this question.
What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Note: There are 2 correct answers to this question.A . All classical open SQL statements in your program will become invalid. B. All ABAP variables must be escaped with...
When using an SAP HANA full text search, what do you have to keep in mind?
When using an SAP HANA full text search, what do you have to keep in mind?A . The LIKE operator is required in your SELECT statement to implement fuzzy logic. B. SAP HANA has to be the primary database to create a full text search. C. The SCORE () function...
Which of the following table types fulfill this requirement?
In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog. Which of the following table types fulfill this requirement?A . HISTORY COLUMN B. GLOBAL TEMPORARY C. LOCAL TEMPORARY D. ROWView AnswerAnswer: C
Which step of the Guided Performance Analysis should you perform in the production system?
Which step of the Guided Performance Analysis should you perform in the production system?A . Executing a check run with ABAP Test Cockpit (ATC) B. Collecting data with SQL Monitor (SQLM) C. Performing an inspection with Code Inspector (SCI) D. Building a work list with SQL Performance Tuning Worklist (SWLT)View...
Which of the following are necessary adjustments?
You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.A ....
Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.
Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.A . Data Definition B. ABAP class with new Open SQL Syntax C. Full-text index D. Database Procedure Proxy...
Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database?
You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2...
