Questions
SAP HANA Information Models and Database Procedures
1. You are using a calculated column COUNTS within your Dimension Calculation View and an
aggregation node. This is the data that goes into the aggregation node:
AT Vienna 26
DE Berlin 26 AT Vienna 11
AT Vienna 15
DE Berlin 13
DE Berlin 13 AT Vienna 11
AT Vienna 15
DE Berlin 13 AT Vienna 11
DE Berlin 13.
Guided Performance Analysis
2. Which tools can you use to provide input data for the SQL Performance Tuning Work list
(transaction SWLT)?
Note: There are 3 correct answers to this question,
A ABAP Test cockpit Transaction ATC
B SQL Monitor (Transaction: SQLM)
c. Database Performance Monitor (transaction: 0650)
d. SQL Trace (transact on: ST05)
E Code Inspector (Transaction:SCI).
SAP HANA Basics and Technical Concepts
3. Which of the following takes advantage of the computing power of multiple CPUs used by SAP
HANA?
Note: There are 2 correct answers to this question
a. Columnar data storage
B Dictionary encoding
c. Database table compression
D Parallel Processing.
Guided Performance analysis
4. You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.
What could be the reason?
Note: There are 3 correct answers to this question.
A The data has NOT yet been transferred to the SQL monitor database tables
b. Database table Y is a buffered table.
C SQL Monitor was activated for a specific application server
D SQL monitor was activated with a filter that excludes database table Y
e. Program X was executed in the background.
SAP HANA Basics and Technical Concepts
5. What benefits does SAP HANA Data Compression provide?
Note: There are 2 correct answers to this question.
a. Optimized data partitioning
b. Optimized access to column store tables
c. Reduced memory consumption
d. Increased parallel processing.
6. 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 varaibles must be escaped with a preceding @ sign
c. All fields in the GROUP clause must be seperated by commas
d. All arithmetic expressions can be used for all types of variables.
7. Which task can you perform with the SQL Monitor (transaction SQLM)?
a. Display the execution plan Of an SQL statement.
b. Combine stat c and dynamic performance analysis results.
c. Search for problematic SELECT • statements.
d. Capture the SQL profile of an application.
8. You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)?
Note: There are 2 correct answers to this question.
a. It supports exception handling
b. It supports where used list
c. It has syntax check at compile time.
d. It supports locking and commit handling. .
9. Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer?
Note: There are 2 correct answers to this question.
a. Enhanced Distribution of results
b. Configuration of check variants
c. Documented checks
d. flexible schedule of check runs.
10. You are debugging in ABAP Development Tools in Eclipse. What features are available?
Note: There are 2 correct answers to this question.
a. Watch points
b. Debugger scripting
c. Memory usage analysis
d. Conditional breakpoints.
11. 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. Replace ORDER BY additions.
b. Add explicit client handling
c. Specify the schema for every table.
d. Replace CORRESPONDING FIELDS additions
e. Replace UP TO n ROWS additions.
12, What is the purpose of an ABAP project in ABAP Development Tools for Eclipse?
Note: There are 2 correct answers to this question.
a. It provides access to all ABAP repository objects in an ABAP system
b. It represents the connection to the SAP HANA server.
c. It is used to transport ABAP repository Objects.
d. It represents the connection to an ABAP system.
13. You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause?
Note: There are 3 correct answers to this question.
a. ABAP Dictionary tables used in the procedure body
b. AMDPs used in the procedure body
c. ABAP dictionary views used in the procedure body
d. SAP HANA views used in the procedure body
e. CE functions used in the procedure body .
14. Which of the following tools and programming techniques use the SQL Data Definition Language?
Note: There are 2 correct answers to this question.
a. Open SQL
b. ABAP Dictionary
c. Core data services (CDS) data definition
d. Core Data Services (CDS) access control .
15. 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 fulfil this requirement?
a. HISTORY COLUMN
b. ROW
c. GLOBAL TEMPORARY
d. LOCAL TEMPORARY.
16. You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation ?
a. F2
b. F3
c. F1
d. F4.
17. HOW many result sets are returned When an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement?
a. Two result sets
b. One result set
c. As many result sets as there are table output parameters in the procedure
d. As many result sets as there are input parameters in the procedure .
18. You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights
On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid
{
…
}
Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?
a. _ flights.carrid and planetype
b. carrid and _flights.planetype
c. flights.carrid and _flight.s .planetype
d. carrid and planetype .
19. 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 search overhead.
c. Minimize the amount of transferred data
d. Minimize the number of database accesses.
20. When using an SAP HANA full text search, What do you have to keep in mind?
a. The full-text index is always updated asynchronously.
b. SAP HANA has to be the primary database to create a full text search.
c. The SCORE () function is required to ensure the best hits of your search appear on top
d. The LIKE operator is required in your SELECT statement to implement fuzzy logic. .
21. You are programming a report that reads data from a secondary HANA database (DB). What do
you need to consider in your SQL statement?
Note: There are 2 correct answers to this question.
a. You have to specify the DB schema explicit y in your statement.
b. All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB
c. You have to use native SQL when reading data from the secondary DB.
d. You have to specify the DB connection explicitly in your statement.
22. Which data provisioning methods can you use when you need real-time replication?
Note: There are 2 correct answers to this question.
a. SAP Data Services
b. SAP Replication Server
c. SAP HANA Direct Extractor Connection (SAP DXC)
d. SAP Landscape Transformation Replication server (SAP SLT).
23. You define a Core Data Services (CDS) view to merge the results of queries using the UNION
keyword. What must the columnists of these queries contain?
Note: There are 2 correct answers to this question.
a. The same number of Columns
b. All key fields
c. Columns of identical types
d. Columns of compatible types.
24. You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.
How can you address the calculation view?
Note: There are 2 correct answers to this questions.
a. _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"
b. _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"
c. "ha400.primdb::CA_BOOKINGS_COUNT"
d. "ha400.primdb/CA_BOOKINGS_COUNT".
25, Which task does the ABAP Managed Database Procedure (AMDP) framework perform?
a. Deploy the database procedure when the AMDP is first activated.
b. Deploy a new version of the database procedure when the AMDP is first called.
c. Deploy the database procedure whenever the AMDP is called
d. Deploy the database procedure whenever the AMDP is activated. .
26. You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the database. Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call?
a. NEXT
b. EXECUTE_OUERY
c. SET PARAM TABLE
d. NEXT_PACKAGE.
27. 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 HA NA content package
ZHA400_00.
Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database ?
Note: There are 2 correct answers to this question.
a. Package ZHA400_00 has deployment mode A.
b. System P81 has SAP HANA as primary database
c. View CA_CUSTOMER has deployment mode A
d. Package ZHA400_00 is listed in table SNHI_DUP_PREWORK.
28. You created and activated a database procedure. From where can you call this procedure?
Note: There are 2 correct answers to this question.
a. From a graphical calculation View
b. From a script-based calculation view
c. From a core data services view
d. From another database procedure .
29. Which of the following features were added to the ABAP dictionary to support the SAP HANA database ?
Note: There are 3 correct answers to this question.
a. Change of data class
b. Storage type for tables
c. De-pooling and de-clustering
d. Definition of full text indexes
e. Definition of enhancement category .
30. In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you
achieve this in a union node?
Note: There are 2 correct answers to this question.
a. Exclude the ADDRESS field from the union
b. Map the ADRESS field to a constant value
c. Create an input parameter for the ADDRESS field.
d. Create a restricted column for the ADDRESS field.
31. What are some of the features available for SAP List Viewer with Integrated Data Access (SALV IDA)?
Note: There are 3 correct answers to this question.
a. Display diagrams
b. Double-click on rows
c. Edit cells
d. Search in content
e. Group rows.
32. You developed an ABAP Managed Database Procedure (AMDP). You want to allow the enhancement of this AMDP using a Business Add-ln (BAdl). Which of the following objects must you
create ?
Note: There are 3 correct answers to this question.
a. A database procedure
b. An enhancement spot
c. A Badi definition
d. A BAdl sample implementation
e. A BAdI fallback implementation.
33. Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA?
Note: There are 2 correct answers to this question.
a. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
b. Use array variants of INSERT UPDATE MODIFY and DELETE
c. Perform all calculations and aggregations in the ABAP layer
d. Ensure the access to buffered tables uses the SAP Table buffer.
34. 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. ABAP class with new Open SQL Syntax
b. Database procedure proxy
c. ABAP class with SQL script coding
d. Data definition
e. Full-text index .
35. In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view?
a. Define the cardinality for the target entity.
b. Specify the other views in which the association can be used.
c. Include all fields used in the ON condition in the project on list
d. Specify an alias for the target entity. .
36. Which step of the Guided Performance Analysis should you perform in the product on system?
a. Building a work list with SQL Performance Tuning Work list (SWLT)
b. Executing a check run with ABAP Test Cockpit (ATC)
c. Collecting data with SQL Monitor (SQLM)
d. Performing an inspection with Code Inspector (SCI) .
37. Which functional problem can you detect when using the Runtime Check Monitor (SRTCM ) ?
a. Use of Native SQL and DB Hints
b. Missing ORDER BY or SORT after SELECT
c. Existence check for secondary indexes
d. Direct access to table pools/cluster.
38. User STUDENT_A creates and activates a design-time Object. In which schema is the runtime
object generated?
a. SYS_Bl
b. SYSTEM
c. _SYS_BIC
d. STUDENT_A .
39. You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory?
Note: There are 3 correct answers to this question.
a. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type
b. Crtdby AS created_by
c. SUM( revenue ) AS total_revenue
d. ASSOCIATION TO sflight AS_flights
e. CAST( 'USO' AS abap.cuky) AS currency_key.
40. 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 automatically add changed objects to the transport request.
b. Because you always transport entire SAP HANA content packages.
c. Because you can manually re-deploy objects after a failed import
d. Because you use the technique that is recommended by SAP.
|
