Discuss the conditions required to ensure the Referential Integrity (2Corrects) Referential Integrity holds true in both the directions There are two joins in the table There is at last are join in other table There are three joins in the table.
What must you do when you define and implement an ABAP management Database Procedure (3Corrects) List all ABAP Dictionary tables used in the procedure body in the USING table Specify the database system and languaje Use scalor types for all AMDP method parameters mark the AMDP method as a READ-ONLY database procedure Define all method parameters to be passed by value.
When are referential joins executed in analytical views? When all the tables are optimized When fields from both the tables are requested When fields are selected When fields are optimized.
What all are the Types of Applicationes based on SAP HANA? (2Corrects) Innovation based on SAP HANA Data Mart based on SAP HANA New or Native SAP HANA Served based on SAP HANA.
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?(2Corrects) Because you automatically add changed objects to the transport request Because you use the technique that is recommended by SAP Because you can manually re-deploy objects after a failed import. Because you always transport entire SAP HANA content packages.
Which code-to-data capability is responsible for the Optimizations & Translations of "Open SQL SELECT FOR ALL ENTRIES" clauses into native SQL? HANA Specific features Buffer system Optimization Transparent Optimizations Database Optimization.
The SAP HANA state-of-the-art search experience include full-text search with advance features like...(3Corrects) linguistic search freestyle search Fuzzy search Isolation search ACID search.
When usign an SAP HANA full text search, what do you have to keep in mind? SAP HANA has to be yhe primary database to create a full text search The SCORE() function is required to ensure the best hits of your search appear on top The LIKE operator is required in your SELECT statement to implement fuzzy logic The full-text is always update asynchronously.
What are the purpose of tools in SAP HANA system that is on Eclipse-based integrated development enviroment?(3Corrects) Monitor Configure Administer Organizing Selecting.
AMDP can detect 3 types of syntax error in active or inactive source code.
What are these error? (3Corrects) UNION specific syntax errors SQLScrips errors Database platform syntax errors HANA specific syntax errors Database independent syntax errors.
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 AMDP.
In which cases does the call trigger the creation of the database procedure in SAP HANA?(2Corrects) X is an ABAP Dictionary table X is a stored procedure X is an SAP HANA view X is an AMDP method.
What is the main purpose of SAML for SAP HANA Studio? SAML may be selected as an Owner´s authentication method when creating users in the SAP HANA Studio The SAP HANA database supports login Owners only The assertion is issued by a user after the client was succesfully authenticated To support scenarios where clients are not directly connected to the SAP HANA database.
What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database(2Corrects) Client handling needs to be done explicitely in the Native SQL statement The ABAP system checks the syntax of the Native SQL statements The database independency of your report can be lost Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS key words.
What are the Parameters for Analytical and calculation view?(3Corrects) Create a copy of a report Specifing unit of measurement To store data for critical analysis Passing other values to be used in calculations Setting a filter for columns.
Which of the following folder is essential to relate to Smast Data Access and also combines data from remote sources? Security folder Administration folder Provisioning folder Content folder.
How will you hide the attributes that are not requiered for client consumption? By setting the hidden property flag of the attribute provider By setting the hidden property flag of the attribute in the Semantics screen By setting the hidden property flag of the attribute column By setting the hidden property flag of the attribute in the view.
An Analytic Priviledge consist of several restrictions. what are they?(·3Corrects) View restrictions Validity restrictions Activity restrictions Cube restrictions Analytic restrictions.
Which of the following task can you perform with SQL monitor(tx SQLM)? Search for problematic SELECT* statement Combine static and dynamic performance analysis results capture the SQL profile of an application Display the execution plan of an SQL statement.
The new bottlenecks avoided by addressing two challenges, what are they?(2Corrects) Avoid CPU cache misses Avoid single network Avoid idling CPU cores Avoid optimizing data.
You are programming a report that reads data from a secondary HANA database (DB). What do you need consider in your SQL statement?(2Corrects) You have to specific the DB schema explicity in your statement You have to use native SQL when reading data from the secondary DB You have to specify the DB connection explicity in your statement All tables and fields you are using must exist in the ABAP Dictionary of the Secondary DB.
Which of the following is not involved in database table of "The new ABAP SQL Monitor-Architecture"? Critical data table Selection data table Performance data table Runtime monitor data.
Which step of the Guide Performance Analysis should you perform in the product on system? Building a work list with SQL Performance Tuning work list (SWLT) Collecting data with SQL Monitor (SQLM) Performing an inspection with code Inspector (SCI) Executing a check run with ABAP Test Cockpit (ATC).
Which of the following tools and programming technique use the SQL data definition language?(2Corrects) Open SQL Core Data Services (CDS) data definitio Core Data Services (CDS) access control ABAP Dictionary.
You want to debug an ABAP Program using ABAP development tools(ADT)
How do you launch the debugger? Choose the debug as option in the context menu of the ABAP program Choose the Run-->Debug options in the menu Create a debug configuration for the ABAP application and run the program Set a breakpoint in the ABAP programa and execute the program.
You implement an ABAP managed database procedure (AMDP) whiting this AMDP you want to query data from calculation view CA_BOOKING_COUNT in SAP HANA content package ha400.primdb
HOW can you address the calculation view?(2Corrects) "ha400.pr mdb/CA_BOOKING_COUNT" "ha400.primdb::CA_BOOKING_COUNT" _SYS_BIC. "ha400.primdb/CA_BOOKING_COUNT" _SYS_BIC. "ha400.primdb::CA_BOOKING_COUNT".
Which features does the source code editor provide in ABAP Development Tools (ADT)?(2Corrects) Screen painter Form-based class builder Quick Fix Content Assist.
You hace created a CDS view and used alias names for same of its elements.
In which of the following cases is the alias name mandatory?(3Corrects) Case order type WHEN 'A' THEN ELSE 0 end as order_type ASSOCIATION TO sflight AS_flights SUM(revenue) AS total_revenue Catdby AS created_by CAST ('USO' AS abap.cuky) AS currency_key.
Which ot the following feature were added to the ABAP Dictionary to support the SAP HANA database?(3corrects) Change of data class Definition of full-text indexes Definition of an enhacement category De-pooling and de-clustering Storage type for tables.
In a Graphical calculation view you want to implement a union between two results sets that differ only in the fact that one of the two has one additional field names ADDRESS
How can you achieve this in a union mode?(2 corrects) Exclude the ADDRESS field from the union. Create an import parameter for the ADDRESS field. Create a restricted column for the ADDRESS field. Map the ADRESS field to a constant value.
You are using ABAP Development Tools, and you have placed your cursor on a method name in class. What key do you use to navigate between a method definition and its implementation? F3 F4 F1 F2.
To connect with the SAP HANA system and see the corresponding catalogo content etc, use the system view How will you add a system to this view?(2Corrects) Password for the database user By using SQL application By using Open Catalog look Database user-also different from ABAP user.
The SAP HANA database is a hybrid in memory database that combines Few technologies within.
What are these tehnologies?(3Corrects) Row-based database technology Time based database technology Value-based database technology Object-based database technology Column-based database technology.
What are the steps involved in supporting a database oriented programming model?(2Corrects) Buffer system service Advanced and specific models Core Data services A new and advance Open SQL.
What are the two different kinds of identifiers used to represent names used in SQL statement?(2Corrects) Limited identifiers Delimited identifiers Undelimited identifiers Numeric identifiers.
Which of the following are view annotations for a CDS view?(3Corrects) Semantics Buffering types Client handling Access control Enviroment.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order(Column SO_ID)
Which SELECT statement would tou use in the definition? Select from snwd_so { so_id, sum (net_amount) as sum_amount } Select from snwd_so { so_id, sum (net_amount) as sum_amount } group by net_amount Select from snwd_so { so_id, sum (net_amount) as sum_amount } group by so_id Select from snwd_so { so_id, sum (net_amount) as sum_amount } order by so_id.
User STUDENT_A creat and activates a design time object. In which schema is the run object generated? STUDENT_A System _Sys_BIC _SYS_BI.
You have defined the following SQL Script procedure:
CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA
Which type of database procedures can be called in this SQL Script procedure? Read only Read-write Read-update Write only.
How to call the stored procedured in ABAP code? Open SQL Native SQL Only SQL CDS View.
What do you understand by the SAP HANA Software Optimization? Huge potencial for hybrid database Provide combinations of Object and Partitioning Speed up the procesing within the database Bring logic to where the data is calculated first, then only move to results.
You want to excecute a native SQL statement in your program. Why should you use ABAP Database connectivity (ADBC)?(2Corrects) It suppports locking and commit handling It has syntax check at compile time It supports where-usedlist It supports exception handing.
What are the components of the Enterprise Procurement Model Demo Scenario?(3Corrects) Stock Sales Product Services Procurement.
Which task does the ABAP managed database (AMDP) framework perform?(2Corrects) Create a new version of the database when the AMDP is first called Delete the obsolete versions of the database procesure asynchronously Delete the obsolet versions of the database procedure synchronously Create a new version of the database when the AMDP is first activated.
What are the Performance Rules and Guidelines for ABAP an SAP HANA?(2Corrects) It is beneficial to move data-intensive calculations into the database To reduce main memory consuption and to improve insert performance it is beneficial for maximizing your search into database To keep all the loads away from the DB.
Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA? Parallel processing Dictionary encoding Database table compression Columnar data storage.
What must take into consideration when use the new open SQL sytanx (available as of SAP Net Weaver 7.4 SP05) (2Corrects) All fields in the Group by clause must be separated by commas All arithmetic expressions can be used for all type of variables All ABAP variables must be escaped with a proceding@sign All keywords are case sensitive.
You analize 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 access is NOT listed in SQLMD.
What could be the reason?(3Corrects) Program X was executed in the background Database table Y is a buffered table The data has NOT yet been transfered to the SQL Monitor database tables SQL Monitor was activated with a filter that excludes database table Y SQL Monitor was activated for a specific application server.
Which of the following tool is introduced as a holistic quality assurance tool? ABAP Test Cockpit (ATC) DBMS Cockpit BW system DBA Cockpit.
Which task does the ABAP Managed Database Procedure (AMDP) framework perform? Deploy a new version of the database procedure when the AMDP is first called Deploy the database procedure whenever the AMDP is activated Deploy the database procedure when the AMDP is first activated Deploy the database procedure whenever the AMDP is called.
What all the factors involved in working with ADT (3Corrects) ABAP class ABAP interfase Module interfase Workbench programs ABAP programs.
Which data sources can you use for SAP list viewer with integrated data access?(3Corrects) External view Internal table Database table Database procedure CDS view.
What are the two layers of ABAP system interacts with its database?(2Corrects) The Data Storage interfase The Database specific library The Database independence interfase The client database interfase.
What are the uses of SQL Trace (ST05). (3Corrects) Applying Code inspector Detect redundant or identical select statements Locate database performance issues Display record of all database access Locate work base issues.
What are the three best approach for Transitioning and Optimizing ABAP applications to SAP HANA? (3Corrects) Tuning Detect Innovate Optimize Scaling.
What is an attribute view and what are it practices?(3Corrects) Used in diagrammatic Projections May contains flow charts Used to join tables May use in calculation views May contain filters.
Which of the following are characteristic of an external view?(3Corrects) It can be used as a data type in ABAP programs It allows access to an SAP HANA information view with Open SQL It defines the underlying SAP HANA information view It is an ABAP dictionary object type It can be used in Open SQL statements for database updates.
List down the elements involved in User Management and Security in SAP HANA? (3Corrects) Assign security Create users Work management Manage users Assign job security.
What are the benefits includes with SAP HANA Full text Seach?(2Corrects) Exploit structured contents in SQL Easy to use modeling tool Fewer data duplication adn movement Large number of toolkits are available.
Which data provisioning methods can you use when you need real time replications?(2Corrects) SAP Replication server SAP HANA Direct extractor connection (SAP DXC) SAP Data services SAP Landscape transformation Replication server (SAP SLT).
List down the four main concepts of the SAP HANA database?(3Corrects) Partitioning Column Store Object Store Tools combinatios Compression.
What are the features of New Open SQL?(2Corrects) Supports arithmetic and string expressions Supports conditional expressions Supports specific unit of database Supports Code adjustment model.
Which of the following are perfomance recommendations when using SAP HANA?(2Corrects) Avoid transfering large results sets between database and client applications Filter data un lower layers Move-data-intensive calculations from the database to can applications server Define indexes on the columns that are used in calculations.
What are the basic principles of ALV SAP HANA?(2Corrects) Daly 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.
DB-Specific Properties that allows switching between storage types when running on an SAP HANA database.
What are these storage type?(2Corrects) Re-use component store Technology store Development store Column store Row Store.
What are the beneficits of using the SQL Monitor (tx.SQLM)?(2Corrects) It collects monitoring data asynchronously without additional database interaction It can be active in production system with minimal performance overhead It schedules ABAP program to monitor and log all database accesses It displays the database execution plan for all SQL statements.
Which of the following options provider access to the views and database procedures that you can consume in the ABAP enviroment? open content Outlook Modeler Perspective Catalogue outlook System Perspective.
Which rules does SAP recommended to improve the perfomance of ABAP report on SAP HANA?(2Corrects) Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES Use array variants of INSERT UPDATE MODIFY and DELETE Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement Perform all calculation and aggregations in the ABAP layer.
ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA.
What are these Transparent Optimizations?(3Corrects) Performance analysis tools have been improved Do all the data processing in Application server The ABAP language and the Open SQL language have been extended Re-use components have been extended or optimized for SAP HANA The consumption of SAP HANA artifacts was simplified.
What output does The SAP HANA provide as a unique combination of hardware and software innovations? Huge potential to maximize the number of disk blocks in the application Huge potencial to optimize AMDP application DATA tables The ability to create new complex processes with ABAP application cloud Huge potential to optimize bussines applications that are running on SAP HANA.
Name thw views that are available to administer and monitor one or several SAP HANA systems?(2Corrects) The Security view The Administration view The System Monitor view The landscape view.
Which of the following option is not the main capability of SAP Bussiness Objects Analysis for OLAP? Create Presentations Swap axes Insert filter componets Create data by members and tables.
How to create a core data services view?(3Corrects) Use DDL statement DEFINE VIEW and SQL LIKE syntax to define the view Use additional annotations masked with the @ sign Use the ABAP Development Tools for SAP Netweaver Use SQL capabilities for Netweaver Use data services tools for updates.
What all are the steps to perform - to enable type - ahead for an input field on a screen?(3Corrects) Check Pre-Requisites Process on all the input fields Switch on proposal search for input fields Identify Elementary search help Automatic updates of all the inputs fields.
Which of the following objects can you use in the ABAP layer when using the top-down approach to bring codde to data?(2Corrects) ABAP managed database procedures Store procedures Calculation views Core data services views.
Which is the new concept that is introduced and improved by using SAP HANA specific features? New advanced SQL syntax procedures ABAP Managed Database Procedures Table buffering Programming model.
What are some of the features available SAP List viewer with integrated data access (SALV IDA)? (3Corrects) Search in content Double-click on rows Display diagrams Edit Cells 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? Open the SAP HANA transport container
Select 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.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL? Database for sophisticated analysis New SQL parser used in model Database oriented programming model SAP HANA specific features.
In which of the following situations could a row store table be more suitable than a column store table?(2Corrects) The table contains mainly distinct values por column accross row The table contain only a small number of records The table contain data that you want to aggregate The table contains text that you want to search.
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?(2Corrects) Include the client field in the field list Use the CLIENT SPECIFIED addition Include the client field in the join condition Include the client field in the WHERE condition.
You are usign a calculated column COUNTS within you DIMENSION Calculation views and an aggregation node. This is the data that goes into the aggregation node:
|COUNTY | CITY | COUNTS |
| AT | Viena | 11 |
| AT | Viena | 15 |
| DE | Berlin | 13 |
| DE | Berlin | 13 |
What does the result of the aggregation look like?
a)
|COUNTY | CITY | COUNTS |
| AT | Viena | 26 |
| DE | Berlin | 26 |
b)
|COUNTY | CITY | COUNTS |
| AT | Viena | 11 |
| AT | Viena | 15 |
| DE | Berlin | 13 |
| DE | Berlin | 13 |
c)
|COUNTY | CITY | COUNTS |
| AT | Viena | 11 |
| AT | Viena | 15 |
| DE | Berlin | 13 |
d)
|COUNTY | CITY | COUNTS |
| AT | Viena | 11 |
| DE | Berlin | 13 | Option A Option C Option B Option D.
What are the two main factors of SAP HANA innovations and challenges?(2Corrects) DBMS technology and innovations SAP BW innovations SAP SW technology and innovations HW technology and innovations.
When to use Enhacend Open SQL?(2Corrects) To access system fields To view scalar components At the time of Dictionary views Need the query in are piece of code only.
You define a core data services (CDS) view. For which of the following expressions and built in functions must your provide alias?(3Corrects) CASTE Expressions Currency Conversion Unit Conversion Nested CASE Expression CASE Expression.
What are the benefits associated with the SAP HANA real-time Operationalanalytics?(2Corrects) Simpplification of massive data Query Speed support High modeling flexibility Fast insight into business activity.
What views will be most efficient for general modeling Principles?(2Corrects) Analitical view Column view Attribute view Schema view.
You developed an ABAP manage database procedure (AMDP). You want to allow the enhacement of this AMDP using bussiness addin (BADI).
Which of the following objects must you create?(3corrects) A BADI simple implementation A BADI definitios A BADI fallback implementation An enhacement spot A database procedure.
Which ot the Golden Rules for Open SQL Perfomance have become more important with SAP HANA?(2Corrects) Minimize the amount of transferred data keep unnecessary load away from the database Minimize the number of database access Minimize the search overhead.
How will you select a preference for validation rules? Windows - Modeler - Preferences - SAP HANA - Validation Rules Windows - SAP HANA - Modeler - Preferences - Validation Rules Windows - Preferences - SAP HANA - Modeler - Validation Rules Windows - SAP HANA - Preferences - Modeler - Validation Rules.
You are implemanting an ABAP Managed database Procedure (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Set the visibility of the corresponding class method in the declaration section to Public Implement the ABAP AMDP_HDB Event Handdler Implement the interface IF_AMDP_MARKER_HDB Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
In SAP HANA SQL, you want to create table whose definition should NOT be visible in the catalog. Which of the following table types fulfill this requirement? LOCAL TEMPORARY COLUMN ROW GLOBAL TEMPORARY.
Which is not a key factor of ALV for HANA? To activate and execute program in the application Derived column heading from the data element The data display is restricted to a maximum of 2 billion cells To supply suitable value for any input parameters.
Whare made SAP HANA possible?(2Corrects) CPU with single core network Technology and innovations Improved hardware technology Ram limitation.
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 and if necessary replace in the existing custom ABAP code?(3Corrects) Native SQL statements ORDER BY Clauses in open SQL statements Direct access to a cluster on the database Code that relies on implicit database sorting Left outer joins in open SQL statements.
What are the two layers of ABAP system interacts with its database?(2Corrects) The database independent interface The client database interface The database specific library The Data storage interface.
Which of the following is a limitation when you create an external view? You must use the ABAP Development tools (ADT) TO CREATE 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 include the name of the SAP HANA view in the name of the external view.
Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offers?(2Corrects) Configuration of check variants Enhanced distribution of results Flexible schedule of check runs Documented checks.
What are the features of NEW Open SQL?(2Corrects) Supports specific unit of database Supports arithmeticand string expressions Supports conditional expressions Supports code adjustment model.
What are two profitability analisis available with CO-PA scenario in SAP HANA Modeling?(2Corrects) Produc-base Profitability Account-base Profitability Costing-base Profitability Service-base Profitability.
Why is a security concept in SAP HANA required?(2Corrects) Database administration should be restricted to skilled Editing of SAP HANA data models should only be possible for "Users" of the model Access to ERP tables must be restricted Need to have selected users in SAP HANA for Information Management.
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Create Presentations Insert filter components Create data by members and tables Swap axes.
How SAP HANA supports SQL?(3Corrects) As a data Calculator Transfering data As a means to define Manipulate data Read.
Which of the following tools and programming techniques use the SQL data definition language?(2Corrects) Core data service (CDS) access control ABAP dictionary Core data services (CDS) data definition Open SQL.
Explain Transitioning ABAP Code to SAP HANA - Performance Considerations?(3Corrects) Some codes impacted positively and should be priorities Some codes transferred to other systems Some codes inmediately run faster Some Shifts in priorities, examples, nested selects(higher) indices(lower) Classical performances recommendations for open SQL remain valid.
ANSI SQL owns features and adds languages these languages divided into three parts. What are they?(3Corrects) Data Transferred Language The Data Definition Language The Data Control Language The Database Language Data manipulation Language.
You have am SQLScript procedure with a table input parameter it_books. You want to use the parameters on the right-hand side of an assignment operator within the procedure.
How do you refer to the parameters? it_books {it_books} @it_books :it_books.
What are the Performance Rules and Guidelines for ABAP on SAP HANA?(2Corrects) It is beneficial to move data-intensive calculation into the database It is beneficial for maximizing your search into database To reduce main memory consumption and to improve insert performance To keep all the loads away from the DB.
List down the four main concepts of the SAP HANA database(3Corrects) Tools combinations Partitioning Object store Comprenssion Column Store.
You are working with ABAP Development Tools (ADT) for Eclipse. which of the following options belongs to the setting of a specific ABAP project rather than the entire Eclipse workbench? Code formatting options Editor shortcut key options Code completion options Statement template optiones.
Which is not a Golden Rule for Open SQL? Reduce the Database load Minimize the Amount of Data Transferred Minimize the Number of Database Accesses Keep the result set large.
What are the ABAP development guidelines?(2Corrects) Improved tools for perfomance analysis Consuming only ABAP contents for SAP HANA Extensions to ABAP Language Improved hybrid components for SAP HANA.
What are the elements of ABAP Database Integration?(3Corrects) Application Server Other DB DB for ABAP DB client-server Client database handling.
In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view? Include all field used in the ON condition in the project list Specify the other views in which the association can be use Define the cardinality for the target entity Specify an alias for the target entity.
Which of the following is not an element of Analytical view? Currency conversion is not applicable Use to joined table Join fact tables Read data from the joined database tables.
What is the limitations of ALV for SAP HANA?(3Corrects) No unit/currency split if agregating amount/currency values All unit/currency restricted to 10800 records Without currency/unit consideration Restricted to 10.000 records Restricted to 5.000 records/unit.
Hybrid Data Management System- Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system?(3Corrects) Traditional disk-based tables Built-in support for planning Text indexing capabilities Linguistic search capabilities Text analysis and search.
Explain the Enterprise Information System of - SAP HANA Implementation Scenarios?(3Corrects) HANA Accelerators All SAP applications on one SAP HANA platform Bussiness Suite on HANA/BW on SAP HANA All HANA combinations an one platform HANA Modeling.
Discuss the basic approach of clasiccal ABAP Programing? (2Corrects) Get All the data you need on the application server and do your processing in ABAP Collect all the data and perform parallel processing in ABAP Creating and consuming all the contents from Network Keep load from the database.
Discuss the main capabilities of SAP BussinessObjects Analysis for Office?(2corrects) Convert crosstab cells fo formula Analyze data with the design panel Sort data by characteristics Suggests style sets for crosstabs.
You created and activated dabase procedure. How can you call this procedure?(2Corrects) By a script-base calculation view By using Sap Analysis for Microsoft office By another database procedure By a core data services view.
Which steps do you have to perform when defining a view using core data services (CDS)?(3Corrects) Use the DDL statement DEFINE VIEW and SQL like Syntax Define the type mapping between ABAP and SAP HANA Specify the name of the SQL view in ABAP Dictionary Create a proxy object fot the define view Create a data definition in your ABAP package.
Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?(3Corrects) Full-text index External view Code Data service (CDS) view Database procedure proxy ABAP program containing new Open SQL.
You are debuggin in ABAP Development Tools in Eclipse. What features are available?(2Corrects) Conditional breakpoints Memory usage analysis Watch points Debugger scripting.
How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement? One result set As many result sets as there are input parameters in the procedure As many result sets as there are table output parameters in the procedure Two result sets.
You use ABAP database connectivity (ADBC) to issue native SQL calls to the database. Which of the following methods of class CL_SQL_RESULT_SET retrieves the result set of the native SQL call? NEXT_PACKAGE SET_PARAM EXECUTE_QUERY SET_PARAM_TABLE.
You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL (3Corrects) Replace ORDER BY additions Replace CORRESPONDING FIELDS additions Add explicit client handling Replace UP TO n ROWS additions Specify the schema for every table.
To upload data from flat files, SAP HANA offers several features. What are these important features (2Corrects) When loading new data in the table, it gets appended to the existing data 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.
What are best practices when programming in ABAP for SAP HANA? (2Corrects) Calculate aggregations using ABAP code on the application server to limit database load Use a column list in the SELECT clause to ensure that you only read a column if it is relly required Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required Eliminated nested SELECT statements to reduce the overall number of database accesses.
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2Corrects) Changes to Delta Container Automatic releases of units Take snapshot manually before releasing of the container You need to refresh the content of the container manually.
Explain how and when to create calculated columns - Using Graphical Modeling Tools? (3Corrects) Calculated columns also support non-measure attributes as part of the calculation Time Characteristics based calculations columns The calculation could be an arithmetic or character manipulation It is possible to nest so that one calculated column, in turn, is based on other calculated columns The calculation will be opened in a read-only mode.
What are the two types of editor available in ADT? (2Corrects) ABAP (native) SAP (GUI) Client (native) Eclipse (native).
What are the principles of Using HANA Transport Containers properly? (3Corrects) To create Transport container of delivery unit Automatic update for all export methods Import of Transport Request Releases of Transport request Take a 'snapshot' of all SAP HANA objects of delivery unit.
What are the Functions of Transaction DBACOCKPIT? (2Corrects) Maintain, Monitor and test secondary database connection Use Schema for the Connections Maintain only HANA specific objects Uses to access local or remote database system.
What all are the advantages provides by ABAP Development Tools? (3Corrects) A set of Eclipse data pool and Client- Open platform A set of open, language- and platform-independet APIS An open platform for developing new ABAP-related tools An open platform for developing powerlful database view A brand new ABAP development experience on top of the Eclipse platform.
What are the steps involved in SAP HANA Evolution?(3Correct) ABAP applications on SAP HANA ABAN can access SAP HANA ABAP can run on SAP HANA Optimized ABAP on SAP HANA ABAP as accelerator on SAP HANA.
Discuss different types of engines associated with The SAP HANA architecture?(2Correct) Analytics engine OPAX engine OLAP engine join engine.
You import an ABAP workbench request into an SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_00.
WHICH PREREQUISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database?(2Correct) View CA_CUSTOMER has deployment mode A SYSTEM P81 has SAP HANA as primary database Package ZHA400_00 is listed in table SNHI_DUP_PREWORK Package ZHA400_00 HAS deployment Mode A.
What should you do to follow code-to-data approach to programming?(3Correct) Transfer all data from the database to the ABAP layer, and then aggregate the results Aggregate data on the database, and transfer the results to the ABAP layer Perform expensive calculations on the database Use native SQL to access SAP HANA built-in functions Perform expensive calculations on the ABAP application server.
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the even of a disaster?(2Correct) Service-Name and index server on all nodes Shared file systems for only one server High availability configuration Active cluster for all servers.
|
