TEST BORRADO, QUIZÁS LE INTERESE:
SAP HANA 2.0
COMENTARIOS |
ESTADÍSTICAS |
RÉCORDS
|
|---|
REALIZAR TEST
|
Título del Test:
SAP HANA 2.0 Descripción: Certificación Autor: Fabian OTROS TESTS DEL AUTOR Fecha de Creación: 26/04/2023 Categoría: Otros Número Preguntas: 65 |
COMPARTE EL TEST
COMENTAR
No hay ningún comentario sobre este test.
Temario:
|
Discuss the conditions required to ensure the Referential Integrity?
(2 right answers)
There are two joins in the able There is at least one join in the other table Referential integrity holds true in both the directions There are three joins in the table
. You created and activated database procedure. How can you call this procedure? (2 right answers) By a script-based calculation view By using Sap Analysis for Microsoft office By another database procedure By a core data services view. Which of the following is a limitation when you create an external view? You must know the underlying tables and join conditions of the SAP HANA view. You can only use native SQL to consume the external view You must use the ABAP Development tools (ADT) TO CREATE the external view You must include the name of the SAP HANA view in the name of the external view. What are the features associated with ABAP CDS (3 right answers) Read Create Update Export Distribution. You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Implement the interface IF_AMDP_MARKER_HDB. Implement the ABAP AMDP_HDB Event Handler. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Which of the below statements are true for SAP HANA Studio? (3 right answers) SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server. SAP HANA Studio is integrated in SAP GUI > 7.40 SAP HANA Studio is a client tool, which can be used to access local or remote HANA system. How will you select a preference for Validation rules? Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- Modeler ¢ Preferences-SAP HANA-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules Windows- SAP HANA-Preferences-Modeler-Validation Rules. What are the different types of Variables in HANA? (3 right answers) Double Single Value Range Interval. In order to get language-specific data, which join is used in SAP HANA? Text Join Language join It is not possible to fetch language-specific data in HANA Referential Join. What are the Performance Rules and Guidelines for ABAP on SAP HANA? (2 right answers) It is beneficial for maximizing your search into database reduce main memory consumption and to improve insert performance Keep all the loads away from the DB It is beneficial to move data-intensive calculations into the database. What is the main purpose of Analytic Privilege? Restrict users to access database tables Restrict user to access modeling view Restrict row level access so that user will be able to see only certain portion of the data. Why is a security concept in SAP HANA required? (2 right answers) Access to ERP tables must be restricted Need to have selected users in SAP HANA for Information Management Editing of SAP HANA data models should only be possible for Users. of the model Database administration should be restricted to skilled. You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statements check. What does this check report? SELECT * statements on tables with the Column Store storage type SELECT * statements on tables with more than a specified number of fields SELECT * statements where fewer than a specified percentage of all fields are effectively used SELECT * statements on tables with more than 100,000 records. What made SAP HANA possible? (2 right answers) RAM limitation CPU with single core network Technology and innovations Improved hardware technology. Which features does the source code editor provide in ABAP Development Tools (ADT)? (2 right answers) Content Assist Quick Fix Form-based Class Builder Screen Painter. Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP Swap axes Create data by members and tables Insert filter components Create Presentations. You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers) SAP HANA views used in the procedure body CE function used in the procedure body ABAP Dictionary table used in the procedure body ABAP Dictionary views used in the procedure body AMDP used in the procedure body . What is the system privilege required to drop analytic privilege? PRIVILEGE ADMIN CREATE STRUCTURED PRIVILEGE STRUCTUREDPRIVILEGE ADMIN CREATE PRIVILEGE. Which SQL syntax is used to create a read only procedure? READS PROCEDURE READS SQL DATA NO-SIDE-EFFECT READ-ONLY. What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? (3 right answers) The join conditions of the CDS view The name of the representation of the CDS view in the ABAP dictionary The extent to which records of the CDS view should be buffered on the application server The client dependency of the CDS view The logic for aggregations, grouping records, and filtering groups of the CDS view. What all are the steps to perform -To enable type-ahead for an input field on a screen? (3 right answers) Switch on proposal search for input fields Automatic updates of all the input fields Process on all the input fields Identify Elementary Search Help Check Pre-Requisites. What are the features of New Open SQL? (2 right answers) Supports arithmetic and string expressions Supports specific units of database Supports conditional expressions Supports Code adjustment model . 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? (2 right answers) PACKAGE ZHA400_00 HAS deployment Mode A SYSTEM P81 has SAP HANA has primary database Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK View CA_CUSTOMER has deployment mode A. What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? (3 right answers) Mark the AMDP method as a READ-ONLY database procedure. List all ABAP Dictionary tables used in the procedure body in the USING clause. Specify the database system and the language. Use scalar types for all AMDP method parameters. Define all method parameters to be passed by value. What is the purpose of an ABAP project in ABAP Development tools for eclipse? (2 right answers) It is used to transport ABAP repository objects It represents the connection to the SAP HANA server It represents the connection to an ABAP system It provides access to all ABAP repository objects in an ABAP system. Discuss the main capabilities of SAP BusinessObjects Analysis for Office? (2 right answers) Analyze data with the design panel Suggests style sets for crosstabs Sort data by characteristics Convert crosstab cells to formula . What are best practices when programming in ABAP for SAP HANA? (2 right answers) Calculate aggregations using ABAP code on the application server to limit database load Eliminate nested SELECT statements to reduce the overall number of database accesses Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required Use a column list in the SELECT clause to ensure that you only read a column if it is really required. Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Programming model New advanced SQL syntax Procedures ABAP-Managed Database Procedures Table buffering. 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. Because you automatically add changed objects to the transport request. Because you can manually re-deploy objects after a failed import Because you use the technique that is recommended by SAP Because you always transport entire SAP HANA content packages. What are the benefits of using the SQL Monitor (transaction SQLM)? (2 right answers) It displays the database execution plan for all SQL statements. It collects monitoring data asynchronously without additional database interaction. It schedules ABAP programs to monitor and log all database accesses. It can be active in a production system with minimal performance overhead. What is the main function of Static Code Analysis? ABAP source code with performance optimization potential To detect code that would lead to functional or performance issues When migrating to SAP HANA Integrated into ABAP Development Tools and ABAP Workbench Integrates with SAP Solution Manager. What is the system privilege required to create analytic privilege? CREATE PRIVILEGE CREATE STRUCTURED PRIVILEGE PRIVILEGE ADMIN STRUCTUREDPRIVILEGE ADMIN. Which data sources can you use for SAP list viewer with integrated data access? (3 right answers) Database Procedure Database Table Internal table CDS View External view. If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available? (3 right answers) Point base ranking Fuzzy search Freestyle search Index search Weights for ranking. Which is not a key factor of ALV for HANA? The data display is restricted to a maximum of 2 billion cells To supply suitable values for any input parameters To Activate and execute the program in the application Derived Column headings from the data element. What all are the factors involved in Working with ADT (3 right answers) Workbench programs ABAP interface ABAP Class ABAP programs Module interface. What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA database? (2 right answers) The ABAP system checks the syntax of the Native SQL statements. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. The database independency of your report can be lost. Client handling needs to be done explicitely in the the Native SQL statement. 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. (3 right answers) ORDER BY Clauses in Open SQL statements Native SQL statements Direct access to a cluster on the database Left outer joins in open SQL statements Code that relies on implicit database sorting. You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? There are 2 correct answers to this questions. _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT" "ha400.primdb/CA_BOOKINGS_COUNT" _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT" "ha400.primdb::CA_BOOKINGS_COUNT". Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Content folder Security folder Provisioning folder Administration folder. Which system schema contains the list of Activated and inactive Objects? _SYS_REPO _SYS_XS _SYS BIC _SYS_BI. In which of the following situations could a row store table be more suitable than a column store table? (2 right answers) The table contains data that you want to aggregate. The table contains mainly distinct values per column across rows. The table contains text that you want to search. The table contains only a small number of records. When to use Enhanced Open SQL? (2 right answers) Need the query in one piece of code only To view scalar components To access system fields At the time of Dictionary Views. The new bottlenecks avoided by addressing two challenges, what are they? (2 right answers) Avoid idling CPU cores Avoid single network Avoid optimizing data Avoid CPU cache misses. Explain how and when to create calculated columns - Using Graphical Modeling Tools? (3 right answers) The calculation could be an arithmetic or character manipulation. Time characteristics based calculation columns The calculation will be opened in a read-only mode Calculated columns also support non-measure attributes as part of the calculation. It is possible to nest so that one calculated column, in turn, is based on other calculated columns. You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? (3 right answers) Unit conversion Nested CASE expression CASE expression CAST Expression Currency Conversion. How SAP HANA supports SQL? (3 right answers) As a Data Calculator Manipulate data Transferring data As a means to define Read. What all are the Types of Applications based on SAP HANA? (2 right answers) Innovation based on SAP HANA New or Native SAP HANA Server based on SAP HANA Data Mart based on SAP HANA. What are the two main methods to add a system to the SAP HANA Studio? (2 right answers) By Resource console Manually Automatically By Importing a Landscape. Which of the statements are true for SQLScript? (2 answers) SQLScript is used to push down data intensive logic into the database. SQLScript is an open standard. SQLScript is a collection of extensions to SQL. Explain the Enterprise Information System of - SAP HANA Implementation Scenarios? (3 right answers) All SAP applications on one SAP HANA platform Business Suite on HANA / BW on SAP HANA HANA Accelerators All HANA Combinations on one platform HANA Modeling. What are the steps involved in SAP HANA Evolution? (3 right answers) Optimized ABAP on SAP HANA ABAP can access SAP HANA ABAP can run on SAP HANA ABAP applications on SAP HANA ABAP as accelerator on SAP HANA. What are the supported joins in CDS view? (2 right answers) Inner join Upper join Operators joint Left outer join. What is the main purpose of SAML for SAP HANA Studio? The assertion is issued by a user after the client was successfully authenticated The SAP HANA database supports login of Owners only SAML may be selected as an Owners authentication method when creating users in the SAP HANA Studio To support scenarios where clients are not directly connected to the SAP HANA Database. What are the steps involved in supporting a database oriented programming model (2 right answers) Core Data services A new and advanced Open SQL Buffer system services Advanced and specific models. What allows you to resolve errors quickly or warnings reported about the code? Debug perspective Code execution ABAP debugger Quick Fix. What are the components of The Enterprise Procurement Model Demo Scenario? (3 right answers) Sales Product Procurement Services Stock. What are the two layers of ABAP system interacts with its database? (2 right answers) The Data Storage interface The Database independent interface The Client database interface The Database specific library. What is the central goal of using SAP HANA? Accelerate Performance Positive Impact on Business To set Priorities for system Monitor database for record keeping. Which of the following statements are true about ¢Catalogé? All the physical tables and views can be found under the Catalog node. It represents SAP HANA§s data dictionary. It contains the design-time artifacts. What are the Possible Approaches with AS ABAP < 7.4 SP02? (2 right answers) SQL units Stored Procedures Consume using native SQL Interaction with Database. 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? Read-update Write only Read only Read-write. What are the different views provided by the ABAP Profiling? (2 right answers) Metadata accesses A Hitlist of the most time-consuming programs or methods Database accesses Performance Check methods. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Display the execution plan of an SQL statement Capture the SQL profile of an application Search for problematic SELECT* statements Combine static and dynamic performance analysis results. Explain Transitioning ABAP Code to SAP HANA ¢ Performance Considerations? (3 right answers) Some codes immediately run faster Classical performances recommendations for open SQL remain valid Some codes impacted positively and should be priorities Some codes transferred to other systems Some shifts in priorities, examples, nested selects(higher) indices(lower). |
Denunciar Test