option
My Daypo

E_HANAAW_16 - ABAP for SAP Hana 2.0 Example Questions

COMMENTS STADISTICS RECORDS
TAKE THE TEST
Title of test:
E_HANAAW_16 - ABAP for SAP Hana 2.0 Example Questions

Description:
SAP Development Specialist Tests - E_HANAAW_16

Author:
pixiu77
(Other tests from this author)

Creation Date:
21/07/2021

Category:
Others

Number of questions: 121
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
Which is better from performance point of view? Modelling Views SQLScript Procedure.
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.
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.
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. Take snapshot manually before releasing of the container Changes to Delta Container You need to refresh the content of the container manually Automatic release of units.
Where can you consume associations in a Core Data Services (CDS) view? 3 correct answers In the FROM clause In the projection list In the input parameter list In the name list In the WHERE and HAVING clauses.
Which engine is used to execute Analytic View? Calc Engine OLAP Engine SQL Engine Join Engine.
Which of the statements are true for SQLScript? (2 answers) SQLScript is used to push down data intensive logic into the database. SQLScript is a collection of extensions to SQL. SQLScript is an open standard.
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. Linguistic search Freestyle search Fuzzy search ACID search Isolation search.
Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 ans CROSS JOIN REFERENTIAL JOIN FULL OUTER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN.
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. Specify the database schema if it is not the user's default schema Use a Comma-separated column list Explicitly handle the client field Use the UP TO n ROWS addition Use the tilde symbol (~) to separate qualifier from column name.
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 data footprint To limit the need of indexes To limit the unpacking and reconstruction of rows.
What is the operating system supported by HANA? (2 correct answers) Red Hat Enterprise Linux (RHEL) SUSE Linux Enterprise Server Only Windows 8 Both Linux and Window 8.
What should you do to follow the code-to-data approach to programming? 2 ans Aggregate data on the database, and transfer the results to the ABAP layer. Perform expensive calculations on the database Perform expensive calculations on the ABAP application server. Transfer all data from the database to the ABAP layer, and then aggregate the results.
What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question. Only retrieve the database data which is to be displayed on screen Data described declaratively instead of passing big internal tables To ensure that the user chooses the data on the selection screen is displayed The ALV Optimization for SAP HANA to display data on the screen.
What is the main purpose of Analytic Privilege? Restrict user to access modeling view Restrict users to access database tables Restrict row level access so that user will be able to see only certain portion of the data.
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 Services-Name and index server on all nodes High availability configuration Active clusters for all servers Shared file systems for only one server.
Analytic Privilege can be applied to (3 Answers) Attribute views Analytic views Calculation views Table SQL View.
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 the Open SQL SELECT RELEVANT statement. Use a field list containing only the relevant fields. Use Native SQL to perform the SELECT * statement. Use the ABAP pragma ##OPTIMIZE_QUERY.
ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question. The Data Control Language The Database Language Data Manipulation Language Data Transferred Language The Data Definition Language.
HANA modeling views can be created under Content Catalog File System Schema.
What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. Without currency/unit consideration No unit/ currency split if aggregating amounts/ currency values Restricted to 5000 records / unit All unit/ currency restricted to 10,000,00 records Restricted to 10,000 records.
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. Database procedure proxy External view Core Data service (CDS) view Full-text index ABAP program containing new Open SQL.
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 Importing a Landscape Automatically By Resource console.
What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question. A set of Eclipse data pool and Client- Open platform An open platform for developing powerful database view An open platform for developing new ABAP-related tools A set of open, language- and platform-independent APIs A brand new ABAP development experience on top of the Eclipse platform.
What is an attribute view and what are its practices? There are 3 correct answers to this question. Used in diagrammatic Projections May contains flow charts May contain filters Used to join tables May use in calculation views.
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.
Which of the following is not involved in database table of "The NewABAP SQL Monitor-Architecture? Choose the correct answer Critical data table Selection data table Runtime monitor data Performance data table.
Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question The Data Definition Language (DDL) The Data Control Language (DCL) Data Manipulation Language (DML) Data Transferring Language(DTL) Data Evaluation Language(DEL).
You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 ans Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8. In the Project Explorer view, right-click the program and choose Run As - ABAP Application from the context menu. Call transaction SRUN_ADT and enter the name of the ABAP program. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
What made SAP HANA possible? There are 2 correct answers to this question. Improved hardware technology Technology and innovations CPU with single core network RAM limitation.
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 Value-based database technology Row-based database technology Object-based database technology Time-based database technology Column-based database technology.
What output does the SAP HANA provide as a unique combination of hardware and software innovations? Huge potential to optimize AMDP application DATA Tables 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 maximize the number of disk blocks in the application.
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. External view Database procedure proxy Core data services view ABAP program containing new open sql Full text index.
What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question. Technical settings DB specific properties High-speed data analysis Column store Open SQL settings.
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_DB CHECK_PERFORMANCE FUNCTIONAL_DB PERFORMANCE_OPT.
Which of the following JOIN types are supported in Open SQL? 3 ans INNER JOIN RIGHT OUTER JOIN LEFT OUTER JOIN CROSS JOIN REFERENTIAL JOIN.
Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question Join engine OLAP engine OPAX engine Analytic engine.
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 Group rows Edit cells.
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.
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.
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 fields in the GROUP BY clause must be separated by commas. All Keywords are case sensitive. All ABAP variables must be escaped with a proceeding @ sign. All arithmetic expressions can be used for all type of variables.
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"? 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 data-intensive calculations can be performed on SAP Netweaver Application Server ABAP when code-to-data mode is switched on The transfer of coding to the database reduces the memory consumption of associated ABAP Dictionary tables in the application layer The in-memory capabilities of SAP HANA allow calculations to be performed on the database layer, which helps to avoid unnecessary movement of data.
What are the elements of ABAP Database Integration? There are 3 correct answers to this question. Application server DB For ABAP Other DB Client database handling DB client-server.
Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer. Database oriented programming model Database for sophisticated analysis New SQL parser used in model SAP HANA specific features.
Which data provisioning methods can you use when you need real time replications? There are 2 correct answers to this question. SAP Replication server SAP Landscape transformation Replication server (SAP SLT) SAP Data services SAP HANA Direct extractor connection (SAP DXC).
ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA. What are these transparent optimizations? (3 ans) The consumption of SAP HANA artifacts was simplified The ABAP language and the Open SQL language have been extended Performance analysis tools have been improved Re-use components have been extended or optimized for SAP HANA Do all the data processing in Application server.
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 Columns of compatible types Columns of identical types All key fields.
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 Class ABAP programs ABAP interface Module interface Workbench programs.
Which TADIR object type is used for the definition of a Core Data Services (CDS) view? R3TR TABL R3TR VIEW R3TR DDIC R3TR DDLS.
What language one should know to work in SAP HANA? ABAP SQL Java C#.
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 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 Create a data definition in your ABAP package.
What is the full form of HANA? High-Performance Analytic Application High-Performance Analytic Accelerator High-Performance Analytic Appliance High Accelerator Numeric Analytics.
Which of the following is latest release of SAP HANA? SAP HANA 2.0 SPS 04 SAP HANA 2.0 SPS 05 SAP HANA 1.0 SP06 SAP HANA 1.0 SAP HANA 1.6 SP03.
Which SAP HANA engine executes Calculation view? (2 answers) Calculation Engine OLAP Engine SQL Engine JOIN Engine.
Which of the following tasks can you perform with SQL monitor (transaction SQLM) ? Search for problematic SELECT* statements Display the execution plan of an SQL statement Combine static and dynamic performance analysis results Capture the SQL profile of an application.
SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question. Left outer joins in open SQL statements Order by clause in open SQL statement Code that relies on implicit database sorting Native SQL statement Direct access to a cluster on the database.
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. An enhancement spot A BADI definition A BADI fallback implementation A database procedure A BADI simple implementation.
You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer. Read only Read-write Write only Read-update.
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).
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.
Explain Transitioning ABAP Code to SAP HANA - Performance Considerations? There are 3 correct answers to this question. Some codes transferred to other systems Some codes impacted positively and should be priorities Some shifts in priorities, examples, nested selects(higher) indices(lower) Classical performances recommendations for open SQL remain valid Some codes immediately run faster.
What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question. Detect redundant or identical select statements Display record of all database access Locate database performance issues Applying Code inspector Locate work base issues.
What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question Fewer data duplication and movement Easy to use modeling tool Exploit structured contents in SQL Large number of toolkits are available.
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. Client handling needs to be done explicitely in the Native SQL statement The ABAP system check the syntax of the Native SQL statements Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword The database independency of your report can be lost.
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question. Unit conversion Currency Conversion CASE expression CASTE Expression Nested CASE expression.
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 is used to transport ABAP repository objects It represents the connection to the SAP HANA server.
Which of the following is true? Oc# OSQL Java ABAP.
What is Core Data Services (CDS)? A collection of domain-specific languages and services for definition and consumption of semantically rich data models A collection of core features and services that provide data from the ABAP application server layer to the user interface 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 services that provide information about the data volumes of the SAP HANA core tables.
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 net run time is greater than the gross run time The net run time is less than the gross run time The gross and net run times are identical The net run time is equal to Zero.
The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question. Creating interface from Method Calls Creating Method Definitions from Implementation Parts Creating Method Implementations from the Method Definition Creating Parts for Interface Methods.
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. Fetch the result using the fetch method of class CL_SQL_EXECUTE. Fetch the result using the next_package method of class CL_SQL_RESULT_SET. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question. Perform all calculations and aggregations in the ABAP layer Use array variants of INSERT UPDATE MODIFY and DELETE Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES.
What are the supported joins in CDS view? There are 2 correct answers to this question. Upper join Injection Left outer join Operators join.
What are the features associated with ABAP CDS? (3 Ans) There are 3 correct answers to this question. Delete/Edit Table Update Create Read.
What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. Perform expensive calculations on the ABAP application server. Perform expensive calculations on the database. Use native SQL to access SAP HANA built-in functions. Aggregate data on the database, and transfer the results to the ABAP layer. Transfer all data from the database to the ABAP layer, and then aggregate the results.
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. Two result sets As many result sets as there are table output parameters in the procedure One result set As many result sets as there are input parameters in the procedure.
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? SAP HANA Tools All plug-ins provided by SAP Development Tools for Eclipse None; everything is preconfigured ABAP Development Tools for SAP NetWeaver.
Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question All SAP applications on one SAP HANA platform HANA Accelerators Business Suite on HANA/ BW on SAP HANA HANA Modeling All HANA Combinations on one platform.
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. Re-use component store Column store Row store Development Store Technology store.
What is the main purpose of SAML for SAP HANA Studio? Choose the correct answer To support scenarios where clients are not directly connected to the SAP HANA Database The SAP HANA database supports login of Owners only 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.
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers) AMDP used in the procedure body ABAP Dictionary table used in the procedure body ABAP Dictionary views used in the procedure body SAP HANA views used in the procedure body Function used in the procedure body.
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. Code inspector (transaction SCI) SQL monitor (transaction SQLM) ABAP test cockpit (transaction ATC) Data base performance monitor (transaction DB50) SQL Trace (transaction ST05).
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. Parallel processing Partitioning Database table compression Column data storage.
What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question. Innovate Optimize Detect Tuning Scaling.
What is an attribute view and what are its practices? There are 3 correct answers to this question May use in calculation views May contains flow charts Used in diagrammatic Projections Used to join tables May contain filters.
The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. Avoid CPU cache misses Avoid idling CPU cores Avoid optimizing data Avoid single network.
How SAP HANA supports SQL ? There are 3 correct answers to this question. As a means to define Read Manipulate data As a Data Calculator Transferring data.
What can you include in the projection list of a Core Data Services (CDS) view? 3 ans 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 ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values.
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.
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".
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.
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.
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.
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.
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.
Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 ans SQLM SE09 SWLT ST22 SE3S.
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.
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 fields in the GROUP BY clause must be separated by commas. All Keywords are case sensitive.
Which character is used to escape host variables in the new Open SQL syntax? * (asterisk) @ (at) : (colon) ~ (tilde).
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.
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.
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.
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.
What are the components of The Enterprise Procurement Model Demo Scenario? There are 3 correct answers to this question. Sales Procurement Stock Services Product.
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.
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.
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.
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.
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.
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 LOCAL TEMPORARY COLUMN.
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.
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.
Name some perspectives that are available in the SAP HANA Studio? (3 ans) The technology & innovation perspective The Administration Console perspective The SAP HANA Modeler Perspective The Resources perspective The Information perspective.
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.
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.
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.
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.
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for IT Certification Guaranteed, The Easy Way! 28 and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question. 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.
When to use Enhanced Open SQL? There are 2 correct answers to this question. To view scalar components To access system fields Need the query in one piece of code only At the time of Dictionary Views.
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 System Monitor view The Administration view The Landscape view The Security view.
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 are two joins in the table There is at least one join in the other table.
Report abuse Terms of use
HOME
CREATE TEST
COMMENTS
STADISTICS
RECORDS
Author's Tests