ERASED TEST, YOU MAY BE INTERESTED ON
SAP Certified Development Specialist - ABAP for SAP HANA
COMMENTS |
STATISTICS |
RECORDS
|
|---|
TAKE THE TEST
|
Title of test:
SAP Certified Development Specialist - ABAP for SAP HANA Description: SAP Certified Development Specialist - ABAP for SAP HANA Author: PK Other tests from this author Creation Date: 09/11/2020 Category: Others Number of questions: 40 |
Share the Test:
New Comment
No comments about this test.
Content:
|
Which of the following is not an element of Analytical view? Currency conversion is not applicable Used to Joined table Read Data from the joined database tables Join fact tables. You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? There are 3 correct answers to this question. ABAP Dictionary table used in the procedure body SAP HANA views used in the procedure body AMDP used in the procedure body CE function used in the procedure body ABAP Dictionary views used in the procedure body. 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? Please choose the correct answer. Editor shortcut key options Code completion options Statement template options Code formatting options. What are the ABAP development guidelines? There are 2 correct answers to this question. Improved tools for performance analysis Extensions to ABAP Language Consuming Only ABAP contents for SAP HANA Improved hybrid components for SAP HANA. 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. Technology store Column store Development Store Raw store Re-use component store. What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database? There are 2 correct answers to this question. The database independency of your report can be lost. The ABAP system checks the syntax of the Native SQL statements. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. Client handling needs to be done explicitely in the the Native SQL statement. 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. Name some perspectives that are available in the SAP HANA Studio? There are 3 correct answers to this question The Administration Console perspective The SAP HANA Modeler perspective The technology & innovation perspective The Information perspective The Resources perspective. To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question The application suggests the column name and data type for the new tables, and it is possible to edit them The new table always has a 2:2 mapping between the file and table columns When loading new data in the table, it gets appended to the existing data The supported file types for upload are: .cssv, .xlls, and .xlsxxx. 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 Object-based database technology Time-based database technology Column-based database technology Value-based database technology Row-based database technology. What do you understand by The SAP HANA Software Optimization? Choose the correct answer Bring logic to where the data is calculated first, then only move to results Provide combinations of Objects and Partitioning peed up the processing within the database Huge potential for hybrid database. You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question. By a script-based calculation view By using Sap Analysis for Microsoft office By another database procedure By a core data services view. Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question Analytic engine OLAP engine OPAX engine Join engine. What are the uses of SQL Trace (ST05)? There are 3 correct answers to this question. Applying Code inspector Display record of all database access Locate database performance issues Locate work base issues Detect redundant or identical select statements. 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 Core Data service (CDS) view External view Full-text index ABAP program containing new Open SQL. What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question. Innovation based on SAP HANA Data Mart based on SAP HANA Server based on SAP HANA New or Native SAP HANA. 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. The table contains only a small number of records. The table contains mainly distinct values per column across rows. The table contains text that you want to search. The table contains data that you want to aggregate. Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer. Create a graph comparing the runtimes of ABAP code before and after optimization. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Estimate the new total runtime of optimized code. Combine information from static ABAP code scans with runtime data from the SQL Monitor. In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? There are 2 correct answers to this question. Create an input parameter for the ADDRESS field Map the ADDRESS field to a constant value Create a restricted column for the ADDRESS field Exclude the ADDRESS field from the union. 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. Receiving Exporting Returning Importing Changing. What is the main function of Static Code Analysis? Please choose the correct answer. To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrates with SAP Solution Manager Integrated into ABAP Development Tools and ABAP Workbench ABAP source code with performance optimization potential. Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question. Storage type for tables De-pooling and de-clustering Changes of data class Definition of an enhancement category Definition of full-text indexes. 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 Data Transferred Language Data Manipulation Language The Database Language The Data Definition Language. What made SAP HANA possible? There are 2 correct answers to this question. Technology and innovations Improved hardware technology RAM limitation CPU with single core network. 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 gross and net run times are identical The net run time is equal to Zero The net run time is less than the gross run time The net run time is greater than the gross run time. 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 ZHA400_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. SYSTEM P81 has SAP HANA has primary database View CA_CUSTOMER has deployment mode A. PACKAGE ZHA400_00 HAS deployment Mode A Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK. Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question. Documented checks Enhanced distribution of results Flexible schedule of check runs Configuration of check variants. What are the features associated with ABAP CDS? There are 3 correct answers to this question. Read Export Create Update Distribution. You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer. Create a debug configuration for the ABAP application and run the program Choose the Run --> Debug options in the menu Set a breakpoint in the ABAP program and execute the program Choose the debug as option in the context menu of the ABAP program. When are referential joins executed in analytical views? Choose the correct answer When fields are selected When fields are optimized When all the tables are optimized When fields from both the tables are requested. AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question. HANA specific syntax errors Database platform syntax errors SQLScript errors Database independent syntax errors UNION specific syntax errors. Which is not a key factor of ALV for HANA? Please choose the correct answer. To Activate and execute the program in the application To supply suitable values for any input parameters Derived Column headings from the data element The data display is restricted to a maximum of 2 billion cells. Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question. Create a data definition in your ABAP package Specify the name of the SQL view in ABAP Dictionary Define the type mapping between ABAP and SAP HANA Use the DDL statement DEFINE VIEW and SQL like Syntax Create a proxy object for the defined view. In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer. define the cardinality for the target entity SPECIFY THE OTHER VIEWS IN WHICH THE ASSOCIATION CAN BE USED specify an alias for the target entity Include all fields used in the ON condition in projection list. What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question. Passing other values to be used in calculations Create a copy of a report To store data for critical analysis Setting a filter for columns Specifying unit of measurement. Which of the following tool is introduced as a holistic quality assurance tool? Choose the correct answer DBMS Cockpit ABAP Test Cockpit (ATC) DBA Cockpit BW system. What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question. System and Properties Development properties Open system properties Administration console. Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question. Quick Fix Content Assist Screen Painter Form-based Class Builder. Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Avoid transferring large result sets between database and client applications. Move data-intensive calculations from the database to an application server. Filter data in lower layers. Define indexes on the columns that are used in calculations. What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? There are 3 correct answers to this question. Define all method parameters to be passed by value. List all ABAP Dictionary tables used in the procedure body in the USING clause. Mark the AMDP method as a READ-ONLY database procedure. Specify the database system and the language. Use scalar types for all AMDP method parameters. |
Report abuse