How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?
A. Use the static method use_features of class cl_abap_dbfeatures.
B. Perform a static code check using the FUNCTIONAL_DB variant.
C. Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).
D. Check the value of the ABAP system field sy-cdsfeatures.
What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.
A. Automatic release of units
B. Changes to Delta Container
C. You need to refresh the content of the container manually
D. Take snapshot manually before releasing of the container
You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 answers
A. In the Project Explorer view, right-click the program and choose Run As -- ABAP Application from the context menu.
B. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter
C. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.
D. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
E. Call transaction SRUN_ADT and enter the name of the ABAP program.
Which engine is used to execute Analytic View?
A. SQL Engine
B. Calc Engine
C. OLAP Engine
D. Join Engine
Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?
Note: There are 2 correct answers to this question.
A. Keep unnecessary load away from the database.
B. Minimize the number of database accesses
C. Minimize the amount of transferred data
D. Minimize the search overhead.
Which system schema/user is the owner of all the activated objects?
A. _SYS_XS
B. _SYS_BI
C. _SYS_REP0
D. _SYS_BIC
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.
A. Use the UP TO n ROWS addition
B. Use the tilde symbol (-) to separate qualifier from column name
C. Use a Comma-separated column list
D. Specify the database schema if it is not the user's default schema
E. Explicitly handle the client field
What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.
A. All arithmetic expressions can be used for all type of variables
B. All ABAP variables must be escaped with a proceeding @ sign.
C. All Keywords are case sensitive.
D. All fields in the GROUP BY clause must be separated by commas.
Which conditional expressions can be used in Core Data Services (CDS) views? 2 answers
A. CASE statements in the projection list
B. IF statements in the projection list
C. WHILE statements in the WHERE clause
D. COALESCE functions in the projection list
E. CASE statements in the HAVING clause
Why is a security concept in SAP HANA required? There are 2 correct answers to this question
A. Need to have selected users in SAP HANA for Information Management
B. Access to ERP tables must be restricted
C. Editing of SAP HANA data models should only be possible for "Users" of the model
D. Database administration should be restricted to skilled
