HANA Exam
HANA Exam Mastery Quiz
Welcome to the HANA Exam Mastery Quiz! Test your knowledge on SAP HANA concepts, core data services, and ABAP applications with this comprehensive quiz featuring 236 questions. Perfect for beginners and experienced professionals alike, this quiz is designed to help you solidify your understanding and enhance your skills in SAP HANA.
- Multiple choice and checkbox questions
- Detailed coverage of key HANA topics
- Ideal for anyone seeking certification or improvement in SAP HANA expertise
1. Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question
There are three joins in the table
Referential integrity holds true in both the directions
There is at least one join in the other table
There are two joins in the table
2. What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question.
Sales
Procurement
Stock
Services
Product
3. How to create a core data services view? (3 ans)
Use SQL capabilities for Netweaver
Use data services tools for updates
Use DDL statement DEFINE VIEW and SQL like syntax to define the view
Use the ABAP Development Tools for SAP Netweaver
Use additional annotations - marked with the @sign
4. What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer
The SAP HANA database supports login of Owners only
To support scenarios where clients are not directly connected to the SAP HANA Database
The assertion is issued by a user after the client was successfully authenticated
SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio
5. The SAP HANA database is a hybrid in-memory database that combines Few technologies within. What are these technologies? There are 3 correct answers to this question
Row-based database technology
Time-based database technology
Column-based database technology
Object-based database technology
Value-based database technology
6. What are the two layers of ABAP system interacts with its database? There are 2 correct answers to this question.
The Data Storage interface
The Database specific library
The Database independent interface
The Client database interface
7. What are the supported joins in CDS view? There are 2 correct answers to this question.
Injection
Upper join
Left outer join
Operators join
8. What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question.
HW technology and innovations
DBMS technology and innovations
SAP BW innovations
SAP SW technology and innovations
9. You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Please choose the correct answer.
Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
Implement the interface IF_AMDP_MARKER_HDB.
Set the visibility of the corresponding class method in the declaration section to PUBLIC.
Implement the ABAP AMDPJHDB Event Handler.
10. Which of the following tool is introduced as a holistic quality assurance tool? Choose the correct answer
BW system
DBA Cockpit
ABAP Test Cockpit (ATC)
DBMS Cockpit
11. What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA DB? There are 2 correct answer to this question.
The ABAP system check the syntax of the Native SQL statements
Client handling needs to be done explicitely in the Native SQL statement
The database independency of your report can be lost
Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword
12. Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? Please choose the correct answer.
Catalogue outlook
Modeler Perspective
System Perspective
Open Content outlook
13. Which of the following are view annotations for a CDS view? There are 3 correct answers to this question.
Semantics
Client handling
Buffering type
Environment
Access control
14. Hybrid Data Management System - Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? There are 3 correct answers to this question.
Built-in support for planning
Text analysis and search
Text indexing capabilities
Traditional disk-based tables
Linguistic search capabilities
15. What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question.
Organizing
Administer
Configure
Monitor
Selecting
16. What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question.
Scaling
Optimize
Detect
Innovate
Tuning
17. What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question.
Specifying unit of measurement
Passing other values to be used in calculations
Create a copy of a report
To store data for critical analysis
Setting a filter for columns
18. You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y. What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? Please choose the correct answer.
The gross and net run times are identical
The net run time is less than the gross run time
The net run time is equal to Zero
The net run time is greater than the gross run time
19. Explain Transitioning ABAP Code to SAP HANA - Performance Considerations? There are 3 correct answers to this question.
Some codes immediately run faster
Some shifts in priorities, examples, nested selects(higher) indices(lower)
Some codes transferred to other systems
Classical performances recommendations for open SQL remain valid
Some codes impacted positively and should be priorities
20. Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.
Combine information from static ABAP code scans with runtime data from the SQL Monitor.
Create a graph comparing the runtimes of ABAP code before and after optimization.
Estimate the new total runtime of optimized code.
Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
21. Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.
Programming model
Table buffering
New advanced SQL syntax Procedures
ABAP-Managed Database Procedures
22. Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.
Use the DDL statement DEFINE VIEW and SQL like Syntax
Create a data definition in your ABAP package
Create a proxy object for the defined view.
Specify the name of the SQL view in ABAP Dictionary
Define the type mapping between ABAP and SAP HANA
23. Which form of services is responsible for defining and consuming semantically rich data models? (1 ans)
It services
Model-ll services
Conditional services
Core Data Services (CDS)
24. You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain? There are 2 correct answers to this question.
The same number of columns
All key fields
Columns of compatible types
Columns of identical types
25. The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... There are 3 correct answers to this question.
ACID search
Freestyle search
Isolation search
Fuzzy search
Linguistic search
26. What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question
Simplification of massive data
Fast insights into business activity
Query Speed support
High modeling flexibility
27. Explain how and when to create calculated column - Using graphical Modeling Tools? There are 3 correct answers to this question
The calculation could be an arithmetic of character manipulation
It is possible to nest so that one calculated column, in turn, is based on other calculated columns
Calculated column also support non-measure attributes as a part of the calculation
Time calculation will be opened in a read-only mode ] Time characteristics based calculation columns
28. How SAP HANA supports SQL? There are 3 correct answers to this question.
Transferring data
As a means to define
Manipulate data
Read
As a Data Calculator
29. Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question
OLAP engine
Analytic engine
OPAX engine
Join engine
30. Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question.
Define indexes on the columns that are used in calculations.
Move data-intensive calculations from the database to an application server.
Filter data in lower layers.
Avoid transferring large result sets between database and client applications.
31. To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question
The application suggests the column name and data type for the new tables, and it is possible to edit them
The supported file types for upload are: .cssv, .xlls, and .xlsxxx
The new table always has a 2:2 mapping between the file and table columns
When loading new data in the table, it gets appended to the existing data
32. ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA. What are these transparent optimizations? (3 ans)
Performance analysis tools have been improved
Do all the data processing in Application server
The consumption of SAP HANA artifacts was simplified
Re-use components have been extended or optimized for SAP HANA
The ABAP language and the Open SQL language have been extended
33. In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question
The table contains data that you want to aggregate.
The table contains mainly distinct values per column across rows.
The table contains text that you want to search.
The table contains only a small number of records.
34. What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to his question
To reduce main memory consumption and to improve insert performance
To keep all the loads away from the DB
It is beneficial to move data-intensive calculations into the database
It is beneficial for maximizing your search into database
35. Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized. Which of the following steps must you perform to get this information? There are 2 correct answers to this question.
Combine the results of the SQL Monitor with the results of a static source code analysis.
Activate the new SQL Monitor in a development system.
Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.
Activate the new SQL Monitor in a productive system.
36. The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question.
Creating Method Implementations from the Method Definition
Creating interface from Method Calls
Creating Method Definitions from Implementation Parts
Creating Parts for Interface Methods
37. Which of the following are characteristics of an external view? There are 3 correct answers to this question.
It can be used as a data type in ABAP programs.
It defines the underlying SAP HANA information view.
It can be used in Open SQL statements for database updates.
It is an ABAP Dictionary object type.
It allows access to an SAP HANA information view with Open SQL.
38. User STUDENT_A create and activates a design-time object. In which schema is the run object generated? Please choose the correct answer
_SYS_BI
STUDENT_A
SYSTEM
_SYS_BIC
39. To connect with the SAP HANA system and seethe corresponding catalog content etc., use the Systems view. How will you add a system to this view? There are 2 correct answers to this question.
Database user- also different from your ABAP user
By using Open Catalog look
Password for the database user
By using SQL application
40. Which of the following is not involved in database table of "The NewABAP SQL Monitor- Architecture? Choose the correct answer
Selection data table
Performance data table
Critical data table
Runtime monitor data
41. What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question.
A set of open, language- and platform-independent APIs
A brand new ABAP development experience on top of the Eclipse platform
An open platform for developing new ABAP-related tools
An open platform for developing powerful database view
A set of Eclipse data pool and Client- Open platform
42. You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this. In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question.
X is a stored procedure.
X is an SAP HANA view
X is an ABAP Dictionary table
X is an AMDP method
43. What is the purpose of an ABAP project in ABAP Development Tool for eclipse? There are 2 correct answers to this question
It represents the connection to an ABAP System
It provides access to all ABAP repository objects in an ABAP system
It represents the connection to the SAP HANA Layer
It is used to transport the ABAP repository Objects.
44. Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Choose the correct answer
Administration folder
Content folder
Security folder
Provisioning folder
45. Which repository objects can you edit only in the ABAP development tools in eclipse and not in the classical abap workbench? There are 3 correct answers to this question.
Core data services view
Database procedure proxy
Full text index
External view
ABAP program containing new open sql
46. Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question
The Landscape view
The System Monitor view
The Security view
The Administration view
47. SAP HANA DB Migration: you want to avoid any fun
Native sql statement
Direct access to a cluster on the database
Left outer joins in open SQL statements
Order by clause in open SQL statement
Code that relies on implicit database sorting
48. What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question
Manually
By Resource console
By Importing a Landscape
Automatically
49. What is the main fun
Integrates with SAP Solution Manager
To detect code that would lead to functional or performance issues When migrating to SAP HANA
Integrated into ABAP Development Tools and ABAP Workbench
ABAP source code with performance optimization potential
50. What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question.
No unit/ currency split if aggregating amounts/ currency values
Restricted to 5000 records / unit
Restricted to 10,000 records
Without currency/unit consideration
All unit/ currency restricted to 10,000,00 records
51. You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI). Which of the following objects must you create? There are 3 correct answers to this question.
A BADI definition
A BADI fallback implementation
An enhancement spot
A database procedure
A BADI simple implementation
52. Name some perspectives that are available in the SAP HANA Studio? (3 ans)
The technology & innovation perspective
The Administration Console perspective
The information perspective
The SAP HANA Modeler Perspective
The Resources perspective
53. Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question.
SAP Landscape transformation Replication server (SAP SLT)
SAP Data services
SAP Replication server
SAP HANA Direct extractor connection (SAP DXC)
54. You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table? Why do you create a row store instead of a column store Please choose the correct answer.
To allow creation of a full-text index
To limit the unpacking and reconstruction of rows
To limit the need of indexes
To limit the data footprint
55. What information can you specify using annotations (marked with the @ sign) when you define a CDS view in an ABAP system? There are 3 correct answers to this question.
The join conditions of the CDS view
The logic for aggregations, grouping records, and filtering groups of the CDS view
The client dependency of the CDS view
The name of the representation of the CDS view in the ABAP dictionary
The extent to which records of the CDS view should be buffered on the application server
56. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? There are 1 correct answer to this question.
Display the execution plan of an SQL statement
Capture the SQL profile of an application
Combine static and dynamic performance analysis results
Search for problematic SELECT* statements
57. What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question.
Open SQL settings
Technical settings
High-speed data analysis
DB specific properties
Column store
58. Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.
SAP HANA specific features
Database oriented programming model
New SQL parser used in model
Database for sophisticated analysis
59. You follow the Code-to-Data paradigm in your ABAP coding. Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecesary load away from the database"? Choose the correct answer
Then in-memory architecture of SAP HANA prevents the transfer of large datasets between the database layer and the application layer
The transfer of coding to the database reduces the memory consumption of associated ABAP Dictionary tables in the application layer
The data-intensive calculations can be performed on SAP Netweaver Application Server ABAP when code-to-data mode is switched on
The in-memory capabilities of SAP HANA allow calculations to be performed on the database layer, which helps to avoid unnecesary movement of data
60. How to call the stored procedures in ABAP code? Please choose the correct answer.
Open SQL
Only SQL
Native SOL
CDS view
61. What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.
Applying Code inspector
Locate database performance issues
Display record of all database access
Detect redundant or identical select statements
Locate work base issues
62. What are the different views provided by the ABAP Profiling? There are 2 correct answers to this question.
Database accesses
Metadata accesses
A Hitlist of the most time-consuming programs or methods
Performance Check methods
63. What all are the factors involved in Working with ADT. If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available? There are 3 correct answers to this question.
ABAP interface
Module interface
Workbench programs
ABAP programs
ABAP Class
64. What made SAP HANA possible? There are 2 correct answers to this question.
Improved hardware technology
CPU with single core network
RAM limitation
Technology and innovations
65. Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question.
Partitioning
Database table compression
Column data storage
Parallel processing
66. If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available? There are 3 correct answers to this question
Weights for ranking
Fuzzy search
Point base ranking
Index search
Freestyle search
67. Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question.
Quick Fix
Screen Painter
Content Assist
Form-based Class Builder
68. When to use Enhanced Open SQL? There are 2 correct answers to this question.
To view scalar components
At the time of Dictionary Views
Need the query in one piece of code only
To access system fields
69. How will you select a preference for Validation rules? Choose the correct answer
Windows- SAP HANA-Modeler-Preferences-Validation Rules
Windows- Preferences-SAP HANA-Modeler-Validation Rules
Windows- Modeler- Preferences-SAP HANA-Validation Rules
Windows- SAP HANA-Preferences-Modeler-Validation Rules
70. What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question.
Data described declaratively instead of passing big internal tables
The ALV Optimization for SAP HANA to display data on the screen
Only retrieve the database data which is to be displayed on screen
To ensure that the user chooses the data on the selection screen is displayed
71. What are the steps involved in SAP HANA Evolution? There are 3 correct answers to this question.
ABAP as accelerator on SAP HANA
ABAP applications on SAP HANA
ABAP can access SAP HANA
ABAP can run on SAP HANA
Optimized ABAP on SAP HANA
72. You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.
By another database procedure
By using Sap Analysis for Microsoft office
By a script-based calculation view
By a core data services view
73. What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question
Account-based Profitability
Costing-based Profitability
Product-based Profitability
Service-based profitability
74. What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.
Open system properties
Administration console
Development properties
System Properties
75. 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? Please choose the correct answer.
ROW
GLOBAL TEMPORARY
COLUMN
LOCAL TEMPORARY
76. What is an attribute view and what are its practices? There are 3 correct answers to this question.
May contain filters
Used in diagrammatic Projections
May use in calculation views
Used to join tables
May contains flow charts
77. Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? There are 3 correct answers to this question.
Returning
Receiving
Exporting
Changing
Importing
78. 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.
Use the UP TO n ROWS addition
Use the tilde symbol (-) to separate qualifier from column name
Use a Comma-separated column list
Specify the database schema if it is not the user's default schema
Explicitly handle the client field
79. You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.
Choose the debug as option in the context menu of the ABAP program
Create a debug configuration for the ABAP application and run the program
Set a breakpoint in the ABAP program and execute the program
Choose the Run --> Debug options in the menu
80. You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DAT Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.
Read-write
Read only
Write only
Read-update
81. What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.
Code execution
Quick Fix
Debug perspective
ABAP debugger
82. What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question.
Tools analyzing performance at run-time, to determine if critical constructs
A new tool called SQL Monitor to determine the priority if different programs access the database intensively
A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption
83. DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.
Column store
Development Store
Row store
Technology store
Re-use component store
84. Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question
Calculation views
ABAP managed database procedures
Stored procedure
Core data services views
85. In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer
Code completion option
Statement Template options
Editor shortcut options
Code formatting option
86. Which of the following is a limitation when you create an external view? Please choose the correct answer.
You must include the name of the SAP HANA view in the name of the external view.
You can only use native SQL to consume the external view
You must know the underlying tables and join conditions of the SAP HANA view.
You must use the ABAP Development tools (ADT) TO CREATE the external view
87. Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.
Database Optimization
Transparent Optimizations
HANA Specific features
Buffer system Optimization
88. What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.
It collects monitoring data asynchronously without additional database interaction.
It schedules ABAP programs to monitor and log all database accesses.
It displays the database execution plan for all SQL statements.
It can be active in a production system with minimal performance overhead.
89. You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statement check. What does this check report? Please choose the correct answer.
SELECT * statements where fewer than a specified percentage of all fields are effectively used
SELECT * statements on tables with more than a specified number of fields
SELECT * statements on tables with more than 100,000 records
SELECT * statements on tables with the Column Store storage type
90. What are the elements of ABAP Database Integration? There are 3 correct answers to this question.
Client database handling
Application server
DB client-server
Other DB
DB For ABAP
91. What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question
Attribute view
Schema view
Column view
Analytical view
92. 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.
All arithmetic expressions can be used for all type of variables
All ABAP variables must be escaped with a proceeding @ sign.
All Keywords are case sensitive.
All fields in the GROUP BY clause must be separated by commas.
93. Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench? There are 3 correct answers to this question.
Full-text index
Database procedure proxy
ABAP program containing new Open SQL
Core Data service (CDS) view
External view
94. Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer
Create data by members and tables
Insert filter components
Swap axes
Create Presentations
95. Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.
Create a new version of the database when the AMDP is first activated
Delete the obsolete versions of the database procedure synchronously
Delete the obsolete versions of the database procedure asynchronously
Create a new version of the database when the AMDP is first called
96. What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question
Delimited identifiers
Limited identifiers
Undelimited Identifiers
Numeric identifiers
97. Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.
Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
Use array variants of INSERT UPDATE MODIFY and DELETE
Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES
Perform all calculations and aggregations in the ABAP layer
98. You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.
View CA_CUSTOMER has deployment mode A.
Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK
SYSTEM P81 has SAP HANA has primary database
PACKAGE ZHA400J30 HAS deployment Mode A
99. You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.
ABAP dictionary tables used in procedure body
ABAP dictionary views used in procedure body
CE function used in procedure Body
AMDP Used in Procedure Body
SAP HANA views used in procedure body
100. Discuss the basic approach of classical ABAP programming. Two answers
Collect all the data and perform parallel processing in ABAP
Creating and consuming all the contents from network
Get all the data you need on the application server and do your processing in ABAP
Keep load from the database
101. What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.
Use native SQL to access SAP HANA built-in functions.
Perform expensive calculations on the database.
Aggregate data on the database, and transfer the results to the ABAP layer.
Perform expensive calculations on the ABAP application server.
Transfer all data from the database to the ABAP layer, and then aggregate the results.
102. What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.
Read
Create
Delete/Edit Table
Update
103. In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.
Include all fields used in the ON condition in projection list
Specify an alias for the target entity
Define the cardinality for the target entity
Specify the other views in which the association can be used
104. Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.
Get all the data you need on the application server and do your processing in ABAP
Creating and consuming all the contents from network
Keep load from the database
Collect all the data and perform Parallel processing in ABAP
105. Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.
Data base performance monitor (transaction DB50)
Code inspector (transaction SCI)
SQL Trace (transaction ST05)
SQL monitor (transaction SQLM)
ABAP test cockpit (transaction ATC)
106. 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? There are 2 correct answers to this question.
Create an input parameter for the ADDRESS field
Exclude the ADDRESS field from the union
Create a restricted column for the ADDRESS field
Map the ADDRESS field to a constant value
107. How will you hide the attributes that are not required for client consumption? Choose the correct answer
By setting the hidden property flag of the attribute in the View
By setting the hidden property flag of the attribute provider
By setting the hidden property flag of the attribute column
By setting the hidden property flag of the attribute in the Semantics screen
108. You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.
SET_PARAM_TABLE
SET_PARAM
EXECUTE_QUERY
NEXT_PACKAGE
109. When would you use a column store table instead of a row store table? There are 2 correct answers to this question.
When you require aggregation and analysis of values
When the table has a small number of records
When there are mainly distinct values in the table
When you want to enable a full-text-search of the table
110. What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.
Process on alCheck Pre-Requisitesl the input fields
Automatic updates of all the input fields
Check Pre-Requisites
Identify Elementary Search Help
Switch on proposal search for input fields
111. You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.
Open the SAP HANA transport containerSelect take snapshot and Save Activate the SAP HANA Transport Container
Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container
Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container
Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container
112. What you must do when you define and implement an ABAP Managed Database Procedure AMDP? (3 ans) There are 3 correct answers to this question.
Define all the method parameters to pass by value
List all the ABAP dictionary tables used in the procedure body in the USING clause
Use Scalar types for all the AMDP method parameters
Specify the database system and language
Mark the AMDP method as read-only
113. What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question
Fewer data duplication and movement
Exploit structured contents in SQL
Easy to use modeling tool
Large number of toolkits are available
114. In addition to closing the result set. What does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.
Release resources
Update resources
Update resources
Update packages
115. Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question
Data Evaluation Language(DEL)
The Data Definition Language (DDL)
Data Transferring Language(DTL)
The Data Control Language (DCL)
Data Manipulation Language (DML)
116. An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question
View restrictions
Analytic restrictions
Validity restrictions
Activity restrictions
Cube restrictions
117. Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.
ABAP Dictionary
Open SQL
Core data services (CDS) data definition
Core data service (CDS) access control
118. What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question
SQL units
Consume using native SQL
Stored Procedures
Interaction with Database
119. List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question
Manage users
Assign Job security
Assign security
Work Management
Create users
120. You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.
Select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd
Select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
Select from snwd_so {sojd, sum(net_amount) as sum_amount}
Select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount
121. Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.
CDS View
Database procedure
External view
Database Table
Internal table
122. Why is not a key factor of ALV for HAN A? Please choose the correct answer.
The data display is restricted to a maximum of 2 billion cell
To supply suitable values for any input parameters
To activate and execute the program in the application
Derived column headings from the data element
123. What is the central goal of using SAP HANA? Please choose the correct answer
Positive Impact on Business
Accelerate Performance
To set Priorities for system
Monitor database for record keeping
124. What are the ABAP development guidelines? There are 2 correct answers to this question.
Consuming Only ABAP contents for SAP HANA
Improved tools for performance analysis
Improved hybrid components for SAP HANA
Extensions to ABAP Language
125. What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question
Active clusters for all servers
Shared file systems for only one server
Services-Name and index server on all nodes
High availability configuration
126. What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.
A new and advanced Open SQL
Core Data services
Buffer system services
Advanced and specific models
127. How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer.
As many result sets as there are input parameters in the procedur
Two result sets
One result set
As many result sets as there are table output parameters in the procedure
128. What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question.
Import of Transport Request
To create Transport container of delivery unit
Automatic update for all export methods
Release of Transport request
Takes a 'snapshot' of all SAP HANA objects of delivery unit
129. You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.
:it_books
It_books
{it.books}
@it_books
130. Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.
Core Data Services
ITe services
Conditional services
Modell-ll services
131. One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any fun
Direct access to a cluster on the database
Left outer joins in open SQL statements
Native SQL statements
Code that relies on implicit database sorting
ORDER BY Clauses in Open SQL statements
132. What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.
Calculate aggregations using ABAP code on the application server to limit database load
Eliminate nested SELECT statements to reduce the overall number of database accesses
Use a column list in the SELECT clause to ensure that you only read a column if it is really required
Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required
133. The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.
Avoid idiling CPU cores
Avoid CPU cache misses
Avoid optimizing data
Avoid single network
134. Which of the following is not an element of Analytical view? Please choose the correct answer.
Currency conversion is not applicable
Join fact tables
Read Data from the joined database tables
Used to Joined table
135. What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.
Huge potential to optimize business applications that are running on SAP HANA
The ability to create new complex processes with ABAP application cloud
Huge potential to optimize AMDP application DATA Tables
Huge potential to maximize the number of disk blocks in the application
136. What are the features associated with ABAP CDS? There are 3 correct answers to this question.
Create
Export
Update
Read
Distribution
137. You define a core data services (CDS) View. For which of the following expressions and built in fun
CASTE Expression
CASE expression
Currency Conversion
Nested CASE expression
Unit conversion
138. List down the three main concepts of the SAP HANA database There are 3 correct answers to this question
Column Store
Tools combinations
Object store
Partitioning
Compression
139. Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before? There are 2 correct answers to this question
Include the client field in the field list.
Include the client field in the WHERE condition.
Include the client field in the join condition.
Use the CLIENT SPECIFIED addition.
140. Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question
HANAAccelerators
All HANA Combinations on one platform
HANA Modeling
All SAP applications on one SAP HANA platform
Business Suite on HANA/ BW on SAP HANA
141. What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.
Server based on SAP HANA
Innovation based on SAP HANA
New or Native SAP HANA
Data Mart based on SAP HANA
142. SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet. What are these goals? There are 2 correct answers to this question.
Analytical DBMS features
Support for system tables
High Performance and Scalability
Hybrid data and management system
143. Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question
Convert crosstab cells to formula
Analyze data with the design pane
Suggests style sets for crosstabs
Sort data by characteristics
144. What are the two types of editors available in ADT? There are 2 correct answers to this question.
Eclipse (native)
Client (native)
SAP (GUI)
ABAP (native)
145. Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.
Documented checks
Enhanced distribution of results
Configuration of check variants
Flexible schedule of check runs
146. AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.
UNION specific syntax errors
Database platform syntax errors
Database independent syntax errors
HANA specific syntax errors
SQLScript errors
147. Which is not a Golden Rule for Open SQL? Please choose the correct answer.
Minimize the Number of Database Accesses
Reduce the Database Load
Minimize the Amount of Data Transferred
Keep the result set large
148. Why is a security concept in SAP HANA required? There are 2 correct answers to this question
Need to have selected users in SAP HANA for Information Management
Access to ERP tables must be restricted
Editing of SAP HANA data models should only be possible for "Users" of the model
Database administration should be restricted to skilled
149. What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.
Display diagrams
Double-click on rows
Search in content
Edit cells
Group rows
150. Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question
Analytic privileges
Package privileges
Application privileges
Object privileges
System privileges
151. Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.
De-pooling and de-clustering
Changes of data class
Definition of full-text indexes
Definition of an enhancement category
Storage type for tables
152. What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.
Speed up the processing within the database
Bring logic to where the data is calculated first then only move to results
Provide combinations of objects and partitioning
Huge potential for hybrid database
153. What is the main fun
To detect code that would lead to functional or performance issues When migrating to SAP HANA
Integrates with SAP Solution Manager
Integrated into ABAP Development Tools and ABAP Workbench
ABAP source code with performance optimization potential
154. When are referential joins executed in analytical views? Choose the correct answer
When all the tables are optimized
When fields are selected
When fields are optimized
When fields from both the tables are requested
155. You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db In the check parameters, which value would you use for the percentage of fields that are effectively used? Please choose the correct answer.
A value that you calculate based on the number of tables
A higher value than on a traditional, row-store only based database
A lower value than on a traditional, row-store only based database
The same value as on a traditional, row-store only based database
156. What are the features of New Open SQL? There are 2 correct answers to this question.
Supports arithmetic and string expressions
Supports Code adjustment model
Supports specific units of database
Supports conditional expressions
157. ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.
Data Manipulation Language
The Data Control Language
The Database Language
The Data Definition Language
Data Transferred Language
158. 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.
Automatic release of units
Changes to Delta Container
You need to refresh the content of the container manually
Take snapshot manually before releasing of the container
159. What are the Fun
Use Schema for the Connections
Maintain, Monitor and test secondary database connection
Maintain only HANA specific objects
Used to access local or remote database system
160. You plan a database migration to SAP HANA and want to check your ABAP coding for potential fun
PREV_FUNC_REG
FUNCTIONAL_DB
FUNCTIONAL_CHECK
PERFORMANCE DB
161. Where can you consume associations in a Core Data Services (CDS) view? 3 ans
In the projection list
In the name list
In the input parameter list
In the FROM clause
In the WHERE and HAVING clauses
162. Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?
"Map to Data source"
"Consume CDS view"
"Relate to Business Entity"
"Read from DDL source"
163. Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?
Service Adaptation Description Language (SADL)
Process Agent Framework (PAF)
ABAP Messaging Channels (AMC)
ABAP Managed Database Procedures (AMDP)
164. You want to implement business logic on the database layer. Which approach do you follow when implementing an ABAP Managed Database Procedure?
The Left-Right approach
The Near-Far approach
The Top-Down approach
The Inside-Out approach
165. What is the main benefit of the SQL Performance Tuning Worklist?
It establishes a governance process for performance optimizations.
It automatically translates ABAP coding to SQLScript.
It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.
It allows you to simulate the impact of performance optimization patterns.
166. Which TADIR object type is used for the definition of a Core Data Services (CDS) view?
R3TR TABL
R3TR VIEW
R3TR DDLS
R3TR DDIC
167. What is Core Data Services (CDS)?
A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system
A collection of core features and services that provide data from the ABAP application server layer to the user interface D. A collection of
A collection of services that provide information about the data volumes of the SAP HANA core tables
A collection of domain-specific languages and services for definition and consumption of semantically rich data models
168. How can you exchange SQL Monitor data between two systems?
Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.
Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system.
Configure a secondary database connection to the target system and query the data in the SQL Monitor.
Create and release a transport request containing the SQL Monitor log files.
169. You follow the Code-to-Data paradigm in your ABAP coding. Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"?
Perform business logic and aggregations on database table content, then transfer the results to the application layer.
Perform join operations on database tables, then transfer the results to the application layer.
Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.
Perform text search operations on database table content, then transfer the results to the application layer.
170. Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans
SQLM
SWLT
ST22
SE3S
171. According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?
Perform regular performance scans on your ABAP custom coding as part of the development process.
Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.
Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.
Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.
172. What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?
The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie
The CDS views used in the FROM clause
The entire CDS view
The elements in the projection list of the CDS view
173. Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?
The filter condition for the association
The cardinality of the association
The alias for the association
The target entity of the association
174. How can you enhance an existing ABAP Search Help with a type-ahead fun
Use the enhanced options in transaction SE11.
Use the fuzzy-search exit in transaction SE11.
Modify the search help with the Native SQL command ALTER SEARCH HELP.
Enhance the lookup table with an additional ACCURACY field and insert an accuracy value.
175. Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid fun
Standard Web Dynpro checks
Search for DB operations across modularization units
SELECT statements that bypass the table buffer
Use of the ADBC interface
176. Which recent software innovations are applied in SAP HANA? 3 ans
Columnar data storage
Automated de-installation at system shutdown
Improved data compression algorithms
Insert Only approach
Random Undefined Multi-Memory Swapping (RUMMS)
177. You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?
All plug-ins provided by SAP Development Tools for Eclipse
SAP HANA Tools
ABAP Development Tools for SAP NetWeaver
None; everything is preconfigured
178. What can you include in the projection list of a Core Data Services (CDS) view? 3 ans
ABAP system fields such as sy-langu or sy-mandt \/ CI String constants and literal values
Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause
A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause
A field from the projection list of another CDS view used in the FROM clause
179. Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans
LEFT OUTER JOIN
CROSS JOIN
FULL OUTER JOIN
RIGHT OUTER JOIN
REFERENTIAL JOIN
180. Which of the following JOIN types are supported in Open SQL? 3 ans
CROSS JOIN
INNER JOIN
REFERENTIAL JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
181. You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method. Which additional steps are necessary to retrieve the result set into an internal table? 2 ans
Close the CL_SQL_STATEMENT object to release the resources.
Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.
Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
Fetch the result using the next_package method of class CL_SQL_RESULT_SET.
Fetch the result using the fetch method of class CL_SQL_EXECUTE.
182. Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans
FOR db (db = HDB...)
LANGUAGE dbjang (dbjang = SQLSCRIPT...)
BY DATABASE PROCEDURE
CLIENT SPECIFIED
AUTHORIZATION db_auth (db_auth = SYSTEM ...)
183. For which purpose can you use literal values in an Open SQL statement?
To perform a generic existence check
To provide a default value for a database table column
To alias the result of an arithmetic expression
To comment your development directly in the coding
184. You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?
Use Native SQL to perform the SELECT * statement.
Use the ABAP pragma ##OPTIMIZE_QUERY.
Use the Open SQL SELECT RELEVANT statement.
Use a field list containing only the relevant fields.
185. How can you consume a Core Data Services (CDS) view? 2 ans
Use the Data Preview in ABAP Development Tools for SAP NetWeaver.
Use it as a data source in the FROM clause of an Open SQL query.
Use the CDS maintenance transaction (SCDSV).
Use the ABAP language statement WRITE and the CDS view name as the argument.
186. Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans
CASE statements in the projection list
IF statements in the projection list
WHILE statements in the WHERE clause
COALESCE functions in the projection list
CASE statements in the HAVING clause
187. How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?
Use the static method use_features of class cl_abap_dbfeatures.
Perform a static code check using the FUNCTIONAL_DB variant.
Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).
Check the value of the ABAP system field sy-cdsfeatures.
188. You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 ans
In the Project Explorer view, right-click the program and choose Run As —► ABAP Application from the context menu.
Use the Open Development Object dialog (CTRL+SHIFT+A) and enter /Execute in the search field.
Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.
Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
Call transaction SRUN_ADT and enter the name of the ABAP program.
189. You apply static code checks on your ABAP coding to find potential fun
The ABAP Test Cockpit (ATC)
The ABAP Code Inspector (SCI)
The Runtime Check Monitor (SRTCM)
The ABAP runtime error information (ST22)
190. Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans
CL_SQL_EXECUTE_QUERY
CL_SQL_RESULT_SET
CL_SQL_STATEMENT
CL_EXEC_SQL
CL_ADBC_SQL_STATEMENT
191. In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential. Where can you find the result of the static code checks?
In the Problems view
In the Project Explorer view
In the Performance Analysis view
In the Outline view of the ABAP Performance perspective
192. You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential. Which Code Inspector check variant can you use?
PERFORMANCE_OPT
CHECK_PERFORMANCE
FUNCTIONAL_DB
PERFORMANCE_DB
193. Which character is used to escape host variables in the new Open SQL syntax?
* (asterisk)
@ (at)
: (colon)
~ (tilde)
194. What should you do to follow the code-to-data approach to programming? 2 ans
Perform expensive calculations on the database
Transfer all data from the database to the ABAP layer, and then aggregate the results.
Perform expensive calculations on the ABAP application server.
Aggregate data on the database, and transfer the results to the ABAP layer.
195. In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?
The CASE statement as provided in the SELECT list without its alias
The alias of the CASE construct used in the SELECT list
None; the GROUP BY list is added automatically
The name of the gross amount column that is used in the CASE statement
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers)
ABAP Dictionary views used in the procedure body
ABAP Dictionary table used in the procedure body
AMDP used in the procedure body
Function used in the procedure body
SAP HANA views used in the procedure body
197. Which system schema contains the column views of activated objects?
_SYS_BI
_SYS_REPO
_SYS_XS
_SYS_BIC
198. Which of the statements are true for SQLScript? (2 answers)
SQLScript is an open standard.
SQLScript is used to push down data intensive logic into the database.
SQLScript is a collection of extensions to SQL.
199. What are the advantages of column based tables? (3 correct answers)
Bigger Data Set
Better Compression
Better parallel Processing
Faster Data Access
201. Which SQL syntax is used to create a read only procedure?
READS SQL DATA
READS PROCEDURE
NO-SIDE-EFFECT
READ-ONLY
202. What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)
It provides access to all ABAP repository objects in an ABAP system.
It represents the connection to an ABAP system
It represents the connection to the SAP HANA server
It is used to transport ABAP repository objects
203. What are the types of schemas in HANA? (3 correct)
System Defined Schema
User Defined Schema
SLT Derived Schema
Dynamic Schema
204. What is the full form of HANA?
High-Performance Analytic Accelerator
High-Performance Analytic Application
High Accelerator Numeric Analytics
High-Performance Analytic Appliance
205. Which of the below has huge negative impact on performance? (2 answers)
Mixing up SQL statement and CE functions
Join on calculated column
Inner Join
206. Which of the following is true? (2 correct answers)
A read only procedure cannot call read-write procedure.
A Read-write procedure cannot call another read-write procedure.
A read-write procedure can call both read-write and read only procedures.
207. Which statement is true for SAP HANA?
SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners
SAP provides both hardware and software for SAP HANA.
208. Which of the following statements are true about "Content"?
It represents SAP HANA's data dictionary.
It contains the design-time artifacts.
All the physical tables and views can be found under the Catalog node.
209. Which SAP HANA engine executes Calculation view? (2 answers)
OLAP Engine
Calculation Engine
SQL Engine
JOIN Engine
210. What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)
Changes to Delta Container
You need to refresh the content of the container manually
Automatic release of units
Take snapshot manually before releasing of the container
211. What language one should know to work in SAP HAN A?
Java
ABAP
C#
SQL
212. What is the operating system supported by HANA? (2 correct answers)
Only Windows 8
Red Hat Enterprise Linux (RHEL)
SUSE Linux Enterprise Server
Both Linux and Window 8
213. Analytic Privilege can be applied to (3 Answers)
Calculation views
Attribute views
Analytic views
Table
SQL View
214. What are fun
It deletes obsolete versions of the database procedure synchronously
It deletes obsolete versions of the database procedure asynchronously
It creates the database procedure when the AMDP is first called.
It creates the database procedure when the AMDP is first activated.
215. What is the system privilege required to drop analytic privilege?
CREATE STRUCTURED PRIVILEGE
STRUCTUREDPRIVILEGE ADMIN
PRIVILEGE ADMIN
CREATE PRIVILEGE
216. Which of the following is true?
ABAP
OSQL
Oc#
Java
217. Which is better from performance point of view?
SQLScript Procedure
Modeling Views
218. You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?
Code completion options
Code formatting options
Statement template options
Editor shortcut key options
219. What are the different types of Calculation View? (2 answers)
OLAP Calculation View
Graphical Calculation View
Scripted Calculation View
Text-Based Calculation
220. In order to get language-specific data, which join is used in SAP HANA?
Referential Join
Language join
Text Join
It is not possible to fetch language-specific data in HANA
221. Which system schema/user is the owner of all the activated objects?
_SYS_XS
_SYS_BI
_SYS_REP0
_SYS_BIC
222. Which of the following is latest release of SAP HANA?
SAP HANA 1.0 SP06
SAP HANA 1.0
SAP HANA 1.6 SP03
SAP HANA 2.0 SPS 04
223. HANA modeling views can be created under
Catalog
Schema
File System
Content
224. SQLScript supports control logic like if/else, while traditional SQL does not support that.
True
False
225. Which of the statement is true for SAP HANA?
SAP HANA also uses disc memory to keep backup. In case of power failure the database can be restored to the last consistent state.
In SAP HANA all the data resides in RAM. Hence in case of power failure all the data will be lost.
226. While creating a Graphical Calculation view, what are the options available in Tools palette? (4 right answers)
Union
Cast
Aggregation
Projection
Join
Distinct
227. What is the language SAP HANA is developed in?
Assembly
O
C++
Java
228. Which components can be a part of a calculation view? (2 answers)
BAPIs
Analytic View
Tables
Attribute View
229. What are the different types of Variables in HANA? (3 right answers)
Range
Double
Single Value
Interval
230. Which of the below statements are true for SAP HANA Studio? (3 right answers)
SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc
SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.
SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.
SAP HANA Studio is integrated in SAP GUI > 7.40
231. Which of the following can be part of an analytic view? (3 answers)
Query transformation
Logical joins
Attributes
Data foundation
Unions
232. What is the main purpose of Analytic Privilege?
Restrict users to access database tables
Restrict row level access so that user will be able to see only certain portion of the data
Restrict user to access modeling view
233. What is the main advantage of SQLScript? (2 answers)
SQLScript can be better modularized than traditional SQL
SQLScript code can easily be translated into modeling view
SQLScript is faster than traditional SQL
234. Graphical calculation views can later be converted to Scripted calculation view if required.
No
Yes
235. Which engine is used to execute Analytic View?
SQL Engine
Calc Engine
OLAP Engine
Join Engine
236. Which system schema contains the information about Time data and Schema Mapping?
_SYS_REPO
_SYS_BIC
_SYS_BI
_SYS_XS
237. Which system schema contains the list of Activated and inactive Objects?
_SYS_BIC
_SYS_REPO
_SYS_XS
_SYS_BI
{"name":"HANA Exam", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Welcome to the HANA Exam Mastery Quiz! Test your knowledge on SAP HANA concepts, core data services, and ABAP applications with this comprehensive quiz featuring 236 questions. Perfect for beginners and experienced professionals alike, this quiz is designed to help you solidify your understanding and enhance your skills in SAP HANA.Multiple choice and checkbox questionsDetailed coverage of key HANA topicsIdeal for anyone seeking certification or improvement in SAP HANA expertise","img":"https:/images/course5.png"}