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.
Seleccione una o más de una: A. ACID search B. Linguistic search C. Fuzzy search D. Freestyle search E. Isolation search.
What are the Guidelines for optimizing ABAP code running on HANA?
There are 3 correct answers to this question.
Seleccione una o más de una: A. High-speed data analysis B. Technical settings C. DB specific properties D. Column store E. Open SQL settings.
Explain The Authorization Concept and the types of privileges associated with it?
There are 3 correct answers to this question.
Seleccione una o más de una: A. Application privileges B. Analytic privileges C. Delta privileges D. Object privileges E. System privileges.
Which of the following is not an element of Analytical view?
Please choose the correct answer.
Seleccione una: A. Read Data from the joined database tables B. Join fact tables C. Used to Joined table D. Currency conversion is not applicable.
List down the three main concepts of the SAP HANA database?
There are 3 correct answers to this question.
Seleccione una o más de una: A. Compression B. Tools combinations C. Object store D. Partitioning E. Column Store.
Which features does the source code editor provide in ABAP Development Tools (ADT)?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Form-based Class Builder B. Screen Painter C. Quick Fix D. Content Assist.
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.
Seleccione una: A. Write only B. Read-update C. Read only D. Read-write.
You want to use a UNION to combine two information objects in a calculation view. Which steps do youhave to perform?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Sort the columns in the output structure B. Connect the information objects to the UNION node C. Define the mapping of columns of the information objects D. Define a constant column in the target.
You create a check variant in the Code Inspector which includes the check 'Search problematic Select *statements'.
SAP HANA is used as the database. In the check parameters, which value would you use for the percentageof fields that are effectively used?
Please choose the correct answer.
Seleccione una: A. A higher value than on a traditional, row-store only based database B. The same value as on a traditional, row-store only based database C. A lower value than on a traditional, row-store only based database D. A value that you calculate based on the number of tables.
What are the benefits of using the SQL Monitor (transaction SQLM)?
There are 2 correct answers to this question.
Seleccione una o más de una: A. It schedules ABAP programs to monitor and log all database accesses. B. It collects monitoring data asynchronously without additional database interaction. C. It displays the database execution plan for all SQL statements. D. It can be active in a production system with minimal performance overhead.
What are the ABAP development guidelines?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Improved hybrid components for SAP HANA B. Extensions to ABAP Language C. Improved tools for performance analysis D. Improved hybrid components for SAP HANA.
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated developmentenvironment?
There are 3 correct answers to this question.
Seleccione una o más de una: A. Monitor B. Configure C. Organizing D. Selecting E. Administer.
Discuss different types of engines associated with The SAP HANA architecture?
There are 2 correct answers to this question
Seleccione una o más de una: A. OLAP engine B. Analytic engine C. Join engine D. OPAX engine.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Screen editing B. Quickfix C. Form-based class builder D. Content assistance.
Which of the following tool is introduced as a holistic quality assurance tool?
Choose the correct answer
Seleccione una: A. BW system B. DBA Cockpit C. ABAP Test Cockpit (ATC) D. DBMS Cockpit.
You have a table of transactional data with different transaction types. You want to create an analytic viewfor only one of the transaction types. How can you ensure that only rows with the required transactiontype are displayed in the analytic view?
Please choose the correct answer.
Seleccione una: A. Create a filter on the table B. Create an input parameter C. Create a restricted column D. Create a calculated column.
When using ABAP Database Connectivity (ADBC) to issue native SQL calls to the database, which of thefollowing methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call?
Please choose the correct answer.
Seleccione una: A. SET_PARAM_TABLE B. NEXT_PACKAGE C. SET_PARAM D. GET_METADATA.
What are the features associated with ABAP CDS?
There are 3 correct answers to this question.
Seleccione una o más de una: A. Distribution B. Export C. Update D. Read E. Create.
The source code editor in ADT provides many helpful features. What are these helpful features?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Creating Method Definitions from Implementation Parts B. Creating interface from Method Calls C. Creating Method Implementations from the Method Definition D. Creating Parts for Interface Methods.
To upload data from flat files, SAP HANA offers several features. What are these important features?
There are 2 correct answers to this question
Seleccione una o más de una:
A. The new table always has a 2:2 mapping between the file and table columns B. The application suggests the column name and data type for the new tables, and it is possible to edit them C. When loading new data in the table, it gets appended to the existing data D. The supported file types for upload are: .cssv, .xlls, and .xlsxxx.
Open SQL largely standardized, three sub-languages. What are these sub-languages?
There are 3 correct answers to this question
Seleccione una o más de una: A. Data Transferring Language(DTL) B. The Data Definition Language (DDL) C. The Data Control Language (DCL) D. Data Evaluation Language(DEL) E. Data Manipulation Language (DML).
What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question
Seleccione una o más de una: A. Query Speed support B. Simplification of massive data C. High modeling flexibility D. Fast insights into business activity.
Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Move data-intensive calculations from the database to an application server. B. Avoid transferring large result sets between database and client applications. C. Define indexes on the columns that are used in calculations. D. Filter data in lower layers.
How will you select a preference for Validation rules?
Choose the correct answer
Seleccione una: A. Windows- SAP HANA-Modeler-Preferences-Validation Rules B. Windows- Modeler – Preferences-SAP HANA-Validation Rules C. Windows- SAP HANA-Preferences-Modeler-Validation Rules D. Windows- Preferences-SAP HANA-Modeler-Validation Rules.
DB-Specific Properties that allows switching between storage types when running on an SAP HANAdatabase. What are these storage types?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Column store B. Re-use component store C. Development Store D. Row store E. Technology store.
Which of the following SAP HANA schemas contains the runtime objects of activated views?
Choose the correct answer.
Seleccione una: A. _SYS_BIC B. _SYS_BI C. _SYS_REPO D. _SYS_STATISTICS.
What are the elements of ABAP Database Integration?
There are 3 correct answers to this question. A. DB client-server B. Other DB C. Application server D. DB For ABAP E. Client database handling.
What are the basic principles of ALV SAP HANA?
There are 2 correct answers to this question. A. To ensure that the user chooses the data on the selection screen is displayed B. The ALV Optimization for SAP HANA to display data on the screen C. Data described declaratively instead of passing big internal tables D. Only retrieve the database data which is to be displayed on screen.
Which of the following is not involved in database table of “The New ABAP SQL Monitor –Architecture”?
Choose the correct answer
Seleccione una: A. Selection data table B. Critical data table C. Runtime monitor data D. Performance data table.
What is a security concept in SAP HANA required?
There are 2 correct answers to this question A. Database administration should be restricted to skilled B. Access to ERP tables must be restricted C. Need to have selected users in SAP HANA for Information Management D. Editing of SAP HANA data models should only be possible for “Users.” of the model.
What made SAP HANA possible?
There are 2 correct answers to this question. A. RAM limitation B. Improved hardware technology C. Technology and innovations D. CPU with single core network.
What output does The SAP HANA provide as a unique combination of hardware and software innovations?
Choose the correct answer.
Seleccione una: A. The ability to create new complex processes with ABAP application cloud B. Huge potential to maximize the number of disk blocks in the application C. Huge potential to optimize AMDP application DATA Tables D. Huge potential to optimize business applications that are running on SAP HANA.
What are the benefits includes with SAP HANA Full Text Search?
There are 2 correct answers to this question A. Easy to use modeling tool B. Large number of toolkits are available C. Fewer data duplication and movement D. Exploit structured contents in SQL.
Explain how and when to create calculated columns - Using Graphical Modeling Tools?
There are 3 correct answers to this question A. The calculation will be opened in a read-only mode. B. It is possible to nest so that one calculated column, in turn, is based on other calculated columns. C. Time characteristics based calculation columns. D. The calculation could be an arithmetic or character manipulation. E. Calculated columns also support non-measure attributes as part of the calculation.
How to call the stored procedures in ABAP code?
Please choose the correct answer.
Seleccione una: A. Open SQL B. CDS view C. Native SQL D. Only SQL.
What all are the Types of Applications based on SAP HANA?
There are 2 correct answers to this question. A. Data Mart based on SAP HANA B. Innovation based on SAP HANA C. New or Native SAP HANA D. Server based on SAP HANA.
What are the supported joins in CDS view?
There are 2 correct answers to this question. A. Left outer join B. Upper join C. Operators joint D. Inner join.
Your customer wants to migrate to SAP HANA and you want to identify which business processes shouldbe 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. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. C. Activate the new SQL Monitor in a development system. D. Activate the new SQL Monitor in a productive system.
You want to run a report on data with multiple currencies. You want to allow end users to select the targetcurrency at runtime. Which options does SAP recommend for defining the currency conversion?
There are 2 correct answers to this question. A. A calculated column in an analytic view B. A CE_CONVERSION function in a calculation view C. Currency conversion during data load D. Measures enabled for conversion in an analytic view.
ANSI SQL owns features and adds languages these languages divided into three parts. What are they?
There are 3 correct answers to this question. A. Data Transferred Language B. The Data Definition Language C. Data Manipulation Language D. The Data Control Language E. The Database Language.
What are the two main factors of SAP HANA Innovations and Challenges?
There are 2 correct answers to this question. A. SAP SW technology and innovations B. SAP BW innovations C. DBMS technology and innovations D. HW technology and innovations.
What should you do to follow the code-to-data approach to programming?
There are 2 correct answers to this question. A. Transfer all data from the database to the ABAP layer, and then aggregate the results. B. Perform expensive calculations on the ABAP application server. C. Perform expensive calculations on the database. D. Aggregate data on the database, and transfer the results to the ABAP layer.
What are the two layers of ABAP system interacts with its database?
There are 2 correct answers to this question. A. The Database independent interface B. The Client database interface C. The Data Storage interface D. The Database specific library.
What is the central goal of using SAP HANA?
Please choose the correct answer.
Seleccione una: A. To set Priorities for system B. Positive Impact on Business C. Monitor database for record keeping D. Accelerate Performance.
Name some perspectives that are available in the SAP HANA Studio?
There are 3 correct answers to this question A. The Information perspective B. The SAP HANA Modeler perspective C. The Resources perspective D. The Administration Console perspective E. The technology & innovation perspective.
What all are the steps to perform -To enable type-ahead for an input field on a screen?
3 respuestas correctas A. Automatic updates of all the input fields B. Switch on proposal search for input fields C. Process on all the input fields D. Check Pre-Requisites E. Identify Elementary Search Help.
What is the Limitations of ALV for SAP HANA?
There are 3 correct answers to this question. A. Without currency /unit consideration B. Restricted to 5000 records / unit C. All unit/ currency restricted to 10,00,00 records D. Restricted to 10,000 records E. No unit/ currency split if aggregating amounts/ currency values.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have todo in the corresponding ABAP class?
Please choose the correct answer.
Seleccione una: A. Set the visibility of the corresponding class method in the declaration section to PUBLIC. B. Implement the interface IF_AMDP_MARKER_HDB C. Implement the ABAP AMDP_HDB Event Handler. D. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
What are the steps involved in supporting a database oriented programming model?
There are 2 correct answers to this question. A. Buffer system services B. A new and advanced Open SQL C. Advanced and specific models D. Core Data services.
Name the views that are available to administer and monitor one or several SAP HANA systems?
There are 2 correct answers to this question A. The Administration view B. The Landscape view C. The Security view D. The System Monitor view.
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the eventof a disaster?
There are 2 correct answers to this question
Seleccione una o más de una: A. Shared file systems for only one server B. High availability configuration C. Services-Name and index server on all nodes D. Active clusters for all servers.
Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace thiswith a native SQL SELECT statement. Which of the following changes to the SELECT statement can you useto retrieve the same data as before?
There are 2 correct answers to this question. A. Include the client field in the WHERE condition. B. Include the client field in the field list. C. Use the CLIENT SPECIFIED addition. D. Include the client field in the join condition.
What allows you to resolve errors quickly or warnings reported about the code?
Please choose the correct answer.
Seleccione una: A. Debug perspective B. Code execution C. Quick Fix D. ABAP debugger.
In which of the following situations could a row store table be more suitable than a column store table?
There are 2 correct answers to this question. A. The table contains mainly distinct values per column across rows. B. The table contains data that you want to aggregate. C. The table contains text that you want to search. D. The table contains only a small number of records.
|
