What can you include in the projection list of a Core Data Services (CDS) view? 3 ans
- A . ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values
- B . Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause
- C . A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause
- D . A field from the projection list of another CDS view used in the FROM clause
Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question
- A . HANA Accelerators
- B . All HANA Combinations on one platform
- C . HANA Modeling
- D . All SAP applications on one SAP HANA platform
- E . Business Suite on HANA/ BW on SAP HANA
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
Open SQL largely standardized, three sub-languages.
What are these sub-languages? 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)
When would you use a column store table instead of a row store table? There are 2 correct answers to this question.
- A . When you require aggregation and analysis of values
- B . When the table has a small number of records
- C . When there are mainly distinct values in the table
- D . When you want to enable a full-text-search of the table
Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA? Note: There are 2 correct answers to this question.
- A . Keep unnecessary load away from the database.
- B . Minimize the number of database accesses
- C . Minimize the amount of transferred data
- D . Minimize the search overhead.
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.
- A . Column store
- B . Development Store
- C . Row store
- D . Technology store
- E . Re-use component store
You define and implement an ABAP Managed database procedure (AMDP).
What do you have to list after the USING clause? (3 right answers)
- A . ABAP Dictionary views used in the procedure body
- B . ABAP Dictionary table used in the procedure body
- C . AMDP used in the procedure body
- D . function used in the procedure body
- E . SAP HANA views used in the procedure body
Discuss the basic approach of classical ABAP programming. Two answers
- A . Collect all the data and perform parallel processing in ABAP
- B . Creating and consuming all the contents from network
- C . Get all the data you need on the application server and do your processing in ABAP
- D . Keep load from the database
According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?
- A . Perform regular performance scans on your ABAP custom coding as part of the development process.
- B . Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.
- C . Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.
- D . Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?
- A . Existence check for secondary indexes
- B . Use of Native SQL and DB Hints
- C . Missing ORDER BY or SORT after SELECT
- D . Direct access to table pools/cluster
Analytic Privilege can be applied to (3 Answers)
- A . Calculation views
- B . Attribute views
- C . Analytic views
- D . Table
- E . SQL View
The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.
- A . Avoid idiling CPU cores
- B . Avoid CPU cache misses
- C . Avoid optimizing data
- D . Avoid single network
Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 ans
- A . FOR db (db = HDB…)
- B . LANGUAGE dbjang (dbjang = SQLSCRIPT…)
- C . BY DATABASE PROCEDURE
- D . CLIENT SPECIFIED
- E . AUTHORIZATION db_auth (db_auth = SYSTEM …)
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.
- A . Display diagrams
- B . Double-click on rows
- C . Search in content
- D . Edit cells
- E . Group rows
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.
- A . Open the SAP HANA transport containerSelect take snapshot and Save Activate the SAP HANA Transport Container
- B . Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit
Activate the SAP HANA transport container - C . Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container
- D . Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container
What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.
- A . Use Schema for the Connections
- B . Maintain, Monitor and test secondary database connection
- C . Maintain only HANA specific objects
- D . Used to access local or remote database system
Which system schema contains the list of Activated and inactive Objects?
- A . Used to access local or remote database system
- B . Maintain, Monitor and test secondary database connection
- C . Use Schema for the Connections
- D . Maintain only HANA specific objects
How can you exchange SQL Monitor data between two systems?
- A . Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.
- B . Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system.
- C . Configure a secondary database connection to the target system and query the data in the SQL Monitor.
- D . Create and release a transport request containing the SQL Monitor log files.
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
- A . Calculation views
- B . ABAP managed database procedures
- C . Stored procedure
- D . Core data services views
Which is better from performance point of view?
- A . SQLScript Procedure
- B . Modeling Views
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.
- A . select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd
- B . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
- C . select from snwd_so {sojd, sum(net_amount) as sum_amount}
- D . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount
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
- A . Close the CL_SQL_STATEMENT object to release the resources.
- B . Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.
- C . Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
- D . Fetch the result using the next_package method of class CL_SQL_RESULT_SET.
- E . Fetch the result using the fetch method of class CL_SQL_EXECUTE.
Which of the statements are true for SQLScript? (2 answers)
- A . SQLScript is an open standard.
- B . SQLScript is used to push down data intensive logic into the database.
- C . SQLScript is a collection of extensions to SQL.
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.
- A . Release resources
- B . Update resources
- C . Update resources
- D . Update packages
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.
- A . Read-write
- B . Read only
- C . Write only
- D . Read-update
You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.
What could be the reason?
Note: There are 3 correct answers to this question.
- A . SQL Monitor was activated for a specific application server
- B . SQL monitor was activated with a filter that excludes database table Y
- C . The data has NOT yet been transferred to the SQL monitor database tables
- D . Program X was executed in the background.
- E . Database table Y is a buffered table.
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.
- A . Process on all the input fields
- B . Automatic updates of all the input fields
- C . Check Pre-Requisites
- D . Identify Elementary Search Help
- E . Switch on proposal search for input fields
Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA) and NOT the SAP HANA Transport Container (HTC).
Why would you choose HTA? Note: There are 2 correct answers to this question.
- A . Because you can manually re-deploy objects after a failed import
- B . Because you always transport entire SAP HANA content packages
- C . Because you use the technique that is recommended by SAP
- D . Because you automatically add changed objects to the transport request
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
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
Which statement is true for SAP HANA?
- A . 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
- B . SAP provides both hardware and software for SAP HANA.
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.
- A . ABAP Dictionary
- B . Open SQL
- C . Core data services (CDS) data definition
- D . Core data services (CDS) access control
Which system schema contains the column views of activated objects?
- A . _SYS_BI
- B . _SYS_REPO
- C . _SYS_XS
- D . _SYS_BIC
You developed an ABAP program using ABAP Development Tools for SAP NetWeaver.
How can you execute it? 2 ans
- A . In the Project Explorer view, right-click the program and choose Run As ― ABAP Application from the context menu.
- B . Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field.
- C . Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.
- D . Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
- E . Call transaction SRUN_ADT and enter the name of the ABAP program.
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.
- A . Returning
- B . Receiving
- C . Exporting
- D . Changing
- E . Importing
Which components can be a part of a calculation view? (2 answers)
- A . BAPIs
- B . Analytic View
- C . Tables
- D . Attribute View
What is the main advantage of SQLScript? (2 answers)
- A . SQLScript can be better modularized than traditional SQL
- B . SQLScript code can easily be translated into modeling view
- C . SQLScript is faster than traditional SQL
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.
- A . As many result sets as there are input parameters in the procedure
- B . Two result sets
- C . One result set
- D . As many result sets as there are table output parameters in the procedure
What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?
- A . The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie
- B . The CDS views used in the FROM clause
- C . The entire CDS view
- D . The elements in the projection list of the CDS view
What are the two types of editors available in ADT? There are 2 correct answers to this question.
- A . Eclipse (native)
- B . Client (native)
- C . SAP (GUI)
- D . ABAP (native)
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
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
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
What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers)
- A . It provides access to all ABAP repository objects in an ABAP system.
- B . It represents the connection to an ABAP system
- C . It represents the connection to the SAP HANA server
- D . It is used to transport ABAP repository objects
You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node.
This is the data that goes into the aggregation node:
- A . AT Vienna 11
AT Vienna 15
DE Berlin 13
DE Berlin 13 - B . AT Vienna 11
AT Vienna 15
DE Berlin 13 - C . AT Vienna 26
DE Berlin 26 - D . AT Vienna 11
DE Berlin 13
When are referential joins executed in analytical views? Choose the correct answer
- A . When all the tables are optimized
- B . When fields are selected
- C . When fields are optimized
- D . When fields from both the tables are requested
Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?
- A . Service Adaptation Description Language (SADL)
- B . Process Agent Framework (PAF)
- C . ABAP Messaging Channels (AMC)
- D . ABAP Managed Database Procedures (AMDP)
Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?
- A . Standard Web Dynpro checks
- B . Search for DB operations across modularization units
- C . SELECT statements that bypass the table buffer
- D . Use of the ADBC interface
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)