Hana

A vibrant illustration showcasing SAP HANA concepts, including data processing, database management, and ABAP programming, with symbols representing various database elements like tables, indexes, and performance metrics.

SAP HANA Mastery Quiz

Test your skills and knowledge of SAP HANA with our comprehensive 40-question quiz. Designed for professionals and enthusiasts alike, this quiz covers various aspects of ABAP, SQL, data modeling, and performance tuning.

Whether you are preparing for a certification, brushing up on your skills, or just curious about your knowledge level, this quiz is a valuable tool to assess your expertise!

40 Questions10 MinutesCreated by QueryKnight234
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.
SUM( revenue ) AS total_revenue
CAST( 'USD' AS abap.cuky ) AS currency_key
Crtdby AS created_by
CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type
ASSOCIATION TO sflight AS _flights
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.
It has syntax check at compile time
It supports exception handling.
It supports locking and commit handling.
It supports where-used list.
You created and activated a database procedure. From where can you call this procedure? Note: There are 2 correct answers to this question.
From another database procedure
From a Script-based calculation view
From a Core Data Services view
From a graphical calculation view
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?
LOCAL TEMPORARY
ROW
HISTORY COLUMN
GLOBAL TEMPORARY
Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.
SQL Trace (transaction: ST05)
SQL Monitor (transaction: SQLM)
Database Performance Monitor (transaction: DB50)
Code Inspector (transaction: SCI)
ABAP Test Cockpit (transaction: ATC)
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?
Existence check for Secondary Indexes
Missing ORDER BY or SORT after SELECT
Direct access to Table Pools/Cluster
Use of Native SQL and DB Hints
What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers to this question.
Increased parallel processing
Optimized data partitioning
Optimized access to column store tables
Reduced memory consumption
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 correct answers to this question.
View CA_CUSTOMER has deployment mode A.
Package ZHA400_00 has deployment mode A.
Package ZHA400_00 is listed in table SNHI_DUP_PREWORK.
System P81 has SAP HANA as primary database
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.
De-pooling and de-clustering
Definition of full-text indexes
Storage type for tables
Definition of enhancement category
Change of data class
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.
Flexible schedule of check runs
Enhanced distribution of results
Configuration of check variants
Documented checks
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.
All fields in the GROUP BY clause must be separated by commas.
All classical open SQL statements in your program will become invalid
All ABAP variables must be escaped with a preceding @ sign.
All arithmetic expressions can be used for all types of variables.
Why would you implement Smart Data Access (SDA)?
To generate delta images when sources cannot provide this function
To replicate data between SAP ECC and SAP HANA
To define caching rules based on usage patterns
To provide real-time access to remote data sources
Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question.
Core Data Services (CDS) data definition
Open SQL
Core Data Services (CDS) access control
ABAP Dictionary
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?
_flights.carrid and planetype
_flights.carrid and _flights.planetype
carrid and planetype
carrid and _flights.planetype
You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primd+ How can you address the calculation view? Note: There are 2 correct answers to this question.
_SYS_BI+"ha400.primdb/CA_BOOKINGS_COUNT"
"ha400.primdb/CA_BOOKINGS_COUNT"
_SYS_BI+"ha400.primdb::CA_BOOKINGS_COUNT"
"ha400.primdb::CA_BOOKINGS_COUNT"
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.
Because you always transport entire SAP HANA content packages.
Because you can manually re-deploy objects after a failed import.
Because you automatically add changed objects to the transport request.
Because you use the technique that is recommended by SAP.
You analyze SQL Monitor data in transaction SQLM+ You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its
The data has NOT yet been transferred to the SQL Monitor database tables.
Program X was executed in the background.
Database table Y is a buffered table.
SQL Monitor was activated with a filter that excludes database table Y.
SQL Monitor was activated for a specific application server.
Dat+But the relevant database access is NOT listed in SQLM+ What could be the reason? Note: There are 3 correct answers to this question.
The data has NOT yet been transferred to the SQL Monitor database tables.
Program X was executed in the background
Database table Y is a buffered table
SQL Monitor was activated with a filter that excludes database table Y.
SQL Monitor was activated for a specific application server.
You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the databas+ Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call?
NEXT
SET_PARAM_TABLE
EXECUTE_QUERY
NEXT_PACKAGE
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.
Replace UP TO n ROWS additions.
Add explicit client handling.
Replace CORRESPONDING FIELDS additions.
Replace ORDER BY additions.
Specify the schema for every table
Which task does the ABAP Managed Database Procedure (AMDP) framework perform?
Deploy the database procedure whenever the AMDP is activate+
Deploy a new version of the database procedure when the AMDP is first called
Deploy the database procedure whenever the AMDP is called
Deploy the database procedure when the AMDP is first activated
What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question.
It is used to transport ABAP repository objects.
It represents the connection to the SAP HANA server.
It represents the connection to an ABAP system.
It provides access to all ABAP repository objects in an ABAP system.
Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.
Ensure the WHERE clause contains at least one index field
Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement.
Perform all calculations and aggregations in the ABAP layer.
Ensure the access to buffered tables uses the SAP table buffer.
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.
Database Procedure Proxy
ABAP class with SQL script coding
ABAP class with new Open SQL Syntax
Data Definition
Full-text index
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 database procedure
A BAdI sample implementation
A BAdI fallback implementation
An enhancement spot
A BAdI definition
User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated?
_SYS_BIC
_SYS_BI
STUDENT_A
SYSTEM
Which task can you perform with the SQL Monitor (transaction SQLM)?
Capture the SQL profile of an application.
Search for problematic SELECT * statements.
Display the execution plan of an SQL statement.
Combine static and dynamic performance analysis results.
Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA?
Parallel processing
Columnar data storage
Database table compression
Dictionary encoding
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.
ABAP Dictionary views used in the procedure body
ABAP Dictionary tables used in the procedure body
AMDPs used in the procedure body
CE functions used in the procedure body
SAP HANA views used in the procedure body
What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question.
Double-click on rows
Group rows
Search in content
Edit cells
Display diagrams
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.
Map the ADDRESS field to a constant value
Create an input parameter for the ADDRESS field
Exclude the ADDRESS field from the union.
Create a restricted column for the ADDRESS field
How many result sets are returned when an SAP HANA database procedure is called using the CALL...WITH OVERVIEW statement?
As many result sets as there are table output parameters in the procedure
As many result sets as there are input parameters in the procedure
One result set
Two result sets
You define a Core Data Services (CDS) view to merge the results of queries using the UNION keyword. What must the column lists of these queries contain? Note: There are 2 correct answers to this question.
Columns of identical types
The same number of columns
All key fields
Columns of compatible types
In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view?
Define the cardinality for the target entity.
Specify the other views in which the association can be use+
Specify an alias for the target entity.
Include all fields used in the ON condition in the projection list.
Which step of the Guided Performance Analysis should you perform in the production system?
Building a work list with SQL Performance Tuning Worklist (SWLT)
Executing a check run with ABAP Test Cockpit (ATC)
Collecting data with SQL Monitor (SQLM)
Performing an inspection with Code Inspector (SCI)
You are debugging in ABAP Development Tools in Eclipse. What features are available? Note: There are 2 correct answers to this question.
Memory usage analysis
Watchpoints
Conditional breakpoints
Debugger scripting
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.
You have to specify the DB schema explicitly in your statement.
All tables and fields you are using must exist in the ABAP Dictionary of the secondary DB.
You have to use native SQL when reading data from the secondary DB.
You have to specify the DB connection explicitly in your statement.
When using an SAP HANA full text search, what do you have to keep in mind?
The LIKE operator is required in your SELECT statement to implement fuzzy logic.
The full-text index is always updated asynchronously.
The SCORE( ) function is required to ensure the best hits of your search appear on top.
SAP HANA has to be the primary database to create a full text search.
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?
F1
F3
F4
F2
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.
Minimize the search overhead.
Minimize the amount of transferred data.
Minimize the number of database accesses.
Keep unnecessary load away from the database.
{"name":"Hana", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your skills and knowledge of SAP HANA with our comprehensive 40-question quiz. Designed for professionals and enthusiasts alike, this quiz covers various aspects of ABAP, SQL, data modeling, and performance tuning.Whether you are preparing for a certification, brushing up on your skills, or just curious about your knowledge level, this quiz is a valuable tool to assess your expertise!","img":"https:/images/course6.png"}
Powered by: Quiz Maker