SAP E_HANAAW_14 ACTUAL EXAM QUESTIONS
174 Total Questions
$45 3 Months Free Updates
$65 3 Months Free Updates
174 Total Questions
$55 3 Months Free Updates
Experience the quality of our SAP SAP Certified Development Specialist - ABAP for SAP HANA 2.0 E_HANAAW_14 exam with free practice questions and answers. At Pass4Exams, we take pride in being a trusted source for SAP E_HANAAW_14 exam preparation. Download our reliable and up-to-date E_HANAAW_14 dumps today and prepare to pass your exam with complete confidence backed by our money-back guarantee.
Question # 1
What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question.
A. Applying Code inspector
B. Locate database performance issues
C. Display record of all database access
D. Detect redundant or identical select statements
E. Locate work base issues
Question # 2
Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question
A. Analytic privileges
B. Package privileges
C. Application privileges
D. Object privileges
E. System privileges
Question # 3
How to call the stored procedures in ABAP code? Please choose the correct answer.
A. Open SQL
B. Only SQL
C. Native SOL
D. CDS view
Question # 4
What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question.
A. Sales
B. Procurement
C. Stock
D. Services
E. Product
Question # 5
Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.
A. Core Data Services
B. ITe services
C. Conditional services
D. Modell-ll services
Question # 6
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.
A. Full-text index
B. Database procedure proxy
C. ABAP program containing new Open SQL
D. Core Data service (CDS) view
E. External view
Question # 7
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.
A. Combine the results of the SQL Monitor with the results of a static source code analysis.
B. Activate the new SQL Monitor in a development system.
C. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis.
D. Activate the new SQL Monitor in a productive system.
Question # 8
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.
A. The join conditions of the CDS view
B. The logic for aggregations, grouping records, and filtering groups of the CDS view
C. The client dependency of the CDS view
D. The name of the representation of the CDS view in the ABAP dictionary
E. The extent to which records of the CDS view should be buffered on the application server
Question # 9
What are the ABAP development guidelines? There are 2 correct answers to this question.
A. Consuming Only ABAP contents for SAP HANA
B. Improved tools for performance analysis
C. Improved hybrid components for SAP HANA
D. Extensions to ABAP Language
Question # 10
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.
A. Documented checks
B. Enhanced distribution of results
C. Configuration of check variants
D. Flexible schedule of check runs
Question # 11
What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question
A. Manually
B. By Resource console
C. By Importing a Landscape
D. Automatically
Question # 12
Open SQL largely standardized, three sub-languages. What are these sublanguages? There are 3 correct answers to this question
A. Data Evaluation Language(DEL)
B. The Data Definition Language (DDL)
C. Data Transferring Language(DTL)
D. The Data Control Language (DCL)
E. Data Manipulation Language (DML)
Question # 13
What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.
A. Calculate aggregations using ABAP code on the application server to limit database load
B. Eliminate nested SELECT statements to reduce the overall number of database accesses
C. Use a column list in the SELECT clause to ensure that you only read a column if it is really required
D. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required
Question # 14
Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.
A. Use the DDL statement DEFINE VIEW and SQL like Syntax
B. Create a data definition in your ABAP package
C. Create a proxy object for the defined view.
D. Specify the name of the SQL view in ABAP Dictionary
E. Define the type mapping between ABAP and SAP HANA
Question # 15
What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question
A. Simplification of massive data
B. Fast insights into business activity
C. Query Speed support
D. High modeling flexibility
Question # 16
Which of the following are characteristics of an external view? There are 3 correct answers to this question.
A. It can be used as a data type in ABAP programs.
B. It defines the underlying SAP HANA information view.
C. It can be used in Open SQL statements for database updates.
D. It is an ABAP Dictionary object type.
E. It allows access to an SAP HANA information view with Open SQL.
Question # 17
What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.
A. A new and advanced Open SQL
B. Core Data services
C. Buffer system services
D. Advanced and specific models
Question # 18
What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.
A. Open system properties
B. Administration console
C. Development properties
D. System Properties
Question # 19
In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer
A. Code completion option
B. Statement Template options
C. Editor shortcut options
D. Code formatting option
Question # 20
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.
A. Data base performance monitor (transaction DB50)
B. Code inspector (transaction SCI)
C. SQL Trace (transaction ST05)
D. SQL monitor (transaction SQLM)
E. ABAP test cockpit (transaction ATC)
Question # 21
Which of the following tasks can you perform with SQL monitor (transaction SQLM)? There are 1 correct answer to this question.
A. Display the execution plan of an SQL statement
B. Capture the SQL profile of an application
C. Combine static and dynamic performance analysis results
D. Search for problematic SELECT* statements
Question # 22
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
A. Active clusters for all servers
B. Shared file systems for only one server
C. Services-Name and index server on all nodes
D. High availability configuration
Question # 23
What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer
A. The SAP HANA database supports login of Owners only
B. To support scenarios where clients are not directly connected to the SAP HANA Database
C. The assertion is issued by a user after the client was successfully authenticated
D. SAML may be selected as an Owner's authentication method when creating users in the SAP HANA Studio
Question # 24
You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.
A. Use the UP TO n ROWS addition
B. Use the tilde symbol (-) to separate qualifier from column name
C. Use a Comma-separated column list
D. Specify the database schema if it is not the user's default schema
E. Explicitly handle the client field
Question # 25
What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.
A. Use native SQL to access SAP HANA built-in functions.
B. Perform expensive calculations on the database.
C. Aggregate data on the database, and transfer the results to the ABAP layer.
D. Perform expensive calculations on the ABAP application server.
E. Transfer all data from the database to the ABAP layer, and then aggregate the results.
Question # 26
Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment?
A. Please choose the correct answer.
B. Catalogue outlook
C. Modeler Perspective
D. System Perspective
E. Open Content outlook
Question # 27
Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question
A. OLAP engine
B. Analytic engine
C. OPAX engine
D. Join engine
Question # 28
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.
A. SELECT * statements where fewer than a specified percentage of all fields are effectively used
B. SELECT * statements on tables with more than a specified number of fields
C. SELECT * statements on tables with more than 100,000 records
D. SELECT * statements on tables with the Column Store storage type
Question # 29
An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question
A. View restrictions
B. Analytic restrictions
C. Validity restrictions
D. Activity restrictions
E. Cube restrictions
Question # 30
What is the main function of Static Code Analysis? Please choose the correct answer.
A. Integrates with SAP Solution Manager
B. To detect code that would lead to functional or performance issues When migrating to SAP HANA
C. Integrated into ABAP Development Tools and ABAP Workbench
D. ABAP source code with performance optimization potential
Question # 31
What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.
A. It collects monitoring data asynchronously without additional database interaction.
B. It schedules ABAP programs to monitor and log all database accesses.
C. It displays the database execution plan for all SQL statements.
D. It can be active in a production system with minimal performance overhead.
Question # 32
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.
A. Analytical DBMS features
B. Support for system tables
C. High Performance and Scalability
D. Hybrid data and management system
Question # 33
Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.
A. CDS View
B. Database procedure
C. External view
D. Database Table
E. Internal table
Question # 34
List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question
A. Manage users
B. Assign Job security
C. Assign security
D. Work Management
E. Create users
Question # 35
What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question
A. Account-based Profitability
B. Costing-based Profitability
C. Product-based Profitability
D. Service-based profitability
Question # 36
What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question.
A. Open SQL settings
B. Technical settings
C. High-speed data analysis
D. DB specific properties
E. Column store
Question # 37
Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question
A. Convert crosstab cells to formula
B. Analyze data with the design pane
C. Suggests style sets for crosstabs
D. Sort data by characteristics
Question # 38
What are the supported joins in CDS view? There are 2 correct answers to this question.
A. Injection
B. Upper join
C. Left outer join
D. Operators join
Question # 39
Which form of services is responsible for defining and consuming semantically rich data models? (1 ans)
A. It services
B. Model-ll services
C. Conditional services
D. Core Data Services (CDS)
Question # 40
What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.
A. Huge potential to optimize business applications that are running on SAP HANA
B. The ability to create new complex processes with ABAP application cloud
C. Huge potential to optimize AMDP application DATA Tables
D. Huge potential to maximize the number of disk blocks in the application
Question # 41
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.
A. Tools analyzing performance at run-time, to determine if critical constructs
B. A new tool called SQL Monitor to determine the priority if different programs access the database intensively
C. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
D. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption
Question # 42
What are the features associated with ABAP CDS? There are 3 correct answers to this question.
A. Create
B. Export
C. Update
D. Read
E. Distribution
Question # 43
What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question.
A. Read
B. Create
C. Delete/Edit Table
D. Update
Question # 44
What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question
A. Delimited identifiers
B. Limited identifiers
C. Undelimited Identifiers
D. Numeric identifiers
Question # 45
What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.
A. Server based on SAP HANA
B. Innovation based on SAP HANA
C. New or Native SAP HANA
D. Data Mart based on SAP HANA
Question # 46
Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question.
A. Define indexes on the columns that are used in calculations.
B. Move data-intensive calculations from the database to an application server.
C. Filter data in lower layers.
D. Avoid transferring large result sets between database and client applications.
Question # 47
What is an attribute view and what are its practices? There are 3 correct answers to this question.
A. May contain filters
B. Used in diagrammatic Projections
C. May use in calculation views
D. Used to join tables
E. May contains flow charts
Question # 48
Which of the following is not an element of Analytical view? Please choose the correct answer.
A. Currency conversion is not applicable
B. Join fact tables
C. Read Data from the joined database tables
D. Used to Joined table
Question # 49
What are the two layers of ABAP system interacts with its database? There are 2 correct answers to this question.
A. The Data Storage interface
B. The Database specific library
C. The Database independent interface
D. The Client database interface
Question # 50
Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.
A. SAP HANA specific features
B. Database oriented programming model
C. New SQL parser used in model
D. Database for sophisticated analysis
Question # 51
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.
A. :it_books
B. it_books
C. {it.books}
D. @it_books
Question # 52
What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question.
A. Import of Transport Request
B. To create Transport container of delivery unit
C. Automatic update for all export methods
D. Release of Transport request
E. Takes a 'snapshot' of all SAP HANA objects of delivery unit
Question # 53
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
A. Include the client field in the field list.
B. Include the client field in the WHERE condition.
C. Include the client field in the join condition.
D. Use the CLIENT SPECIFIED addition.
Question # 54
What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to his question
A. To reduce main memory consumption and to improve insert performance
B. to keep all the loads away from the DB
C. It is beneficial to move data-intensive calculations into the database
D. It is beneficial for maximizing your search into database
Question # 55
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.
A. The same number of columns
B. All key fields
C. Columns of compatible types
D. Columns of identical types
Question # 56
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer
A. Create data by members and tables
B. Insert filter components
C. Swap axes
D. Create Presentations
Question # 57
What is the central goal of using SAP HANA? Please choose the correct answer
A. Positive Impact on Business
B. Accelerate Performance
C. To set Priorities for system
D. Monitor database for record keeping
Question # 58
Which of the following tool is introduced as a holistic quality assurance tool? Choose the correct answer
A. BW system
B. DBA Cockpit
C. ABAP Test Cockpit (ATC)
D. DBMS Cockpit
Question # 59
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Choose the correct answer
A. Administration folder
B. Content folder
C. Security folder
D. Provisioning folder
Question # 60
Why is not a key factor of ALV for HAN A? Please choose the correct answer.
A. The data display is restricted to a maximum of 2 billion cell
B. To supply suitable values for any input parameters
C. To activate and execute the program in the application
D. Derived column headings from the data element
Question # 61
Explain how and when to create calculated column - Using graphical Modeling Tools? There are 3 correct answers to this question
A. The calculation could be an arithmetic of character manipulation
B. It is possible to nest so that one calculated column, in turn, is based on other calculated columns
C. Calculated column also support non-measure attributes as a part of the calculation
D. Time calculation will be opened in a read-only mode ] Time characteristics based calculation columns
Question # 62
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
A. Then in-memory architecture of SAP HANA prevents the transfer of large datasets between the database layer and the application layer
B. The transfer of coding to the database reduces the memory consumption of associated ABAP Dictionary tables in the application layer
C. The data-intensive calculations can be performed on SAP Netweaver Application Server ABAP when code-to-data mode is switched on
D. The in-memory capabilities of SAP HANA allow calculations to be performed on the database layer, which helps to avoid unnecesary movement of data
Question # 63
How will you hide the attributes that are not required for client consumption? Choose the correct answer
A. By setting the hidden property flag of the attribute in the View
B. By setting the hidden property flag of the attribute provider
C. By setting the hidden property flag of the attribute column
D. By setting the hidden property flag of the attribute in the Semantics screen
Question # 64
List down the three main concepts of the SAP HANA database There are 3 correct answers to this question
A. Column Store
B. Tools combinations
C. Object store
D. Partitioning
E. Compression
Question # 65
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question.
A. Scaling
B. Optimize
C. Detect
D. Innovate
E. Tuning
Question # 66
Why is a security concept in SAP HANA required? There are 2 correct answers to this question
A. Need to have selected users in SAP HANA for Information Management
B. Access to ERP tables must be restricted
C. Editing of SAP HANA data models should only be possible for "Users" of the model
D. Database administration should be restricted to skilled
Question # 67
Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.
A. Create a new version of the database when the AMDP is first activated
B. Delete the obsolete versions of the database procedure synchronously
C. Delete the obsolete versions of the database procedure asynchronously
D. Create a new version of the database when the AMDP is first called
Question # 68
How will you select a preference for Validation rules? Choose the correct answer
A. Windows- SAP HANA-Modeler-Preferences-Validation Rules
B. Windows- Preferences-SAP HANA-Modeler-Validation Rules
C. Windows- Modeler- Preferences-SAP HANA-Validation Rules
D. Windows- SAP HANA-Preferences-Modeler-Validation Rules
Question # 69
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.
A. Create an input parameter for the ADDRESS field
B. Exclude the ADDRESS field from the union
C. Create a restricted column for the ADDRESS field
D. Map the ADDRESS field to a constant value
Question # 70
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.
A. ABAP dictionary tables used in procedure body
B. ABAP dictionary views used in procedure body
C. CE function used in procedure Body
D. AMDP Used in Procedure Body
E. SAP HANA views used in procedure body