ERASED TEST, YOU MAY BE INTERESTED ON
DAYPO LOALEO SAP exam a estudiar pronto y a pasar
COMMENTS |
STATISTICS |
RECORDS
|
|---|
TAKE THE TEST
|
Title of test:
DAYPO LOALEO SAP exam a estudiar pronto y a pasar Description: DAYPO LOALEO SAP exam a estudiar pronto y a pasar Author: richiesaenz Other tests from this author Creation Date: 04/04/2019 Category: Others Number of questions: 40 |
Share the Test:
New Comment
No comments about this test.
Content:
|
Which of the following tool is introduced as a holistic quality assurance tool?
Choose the correct answer
Response: ABAP Test Cockpit (ATC) BW system DBA Cockpit DBMS Cockpit. Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL? Please choose the correct answer. New SQL parser used in model Database for sophisticated analysis SAP HANA specific features Database oriented programming model. 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. Release packages Update resources Release resources Update packages. When to use Enhanced Open SQL? There are 2 correct answers to this question. To view scalar components At the time of Dictionary Views To access system fields Need the query in one piece of code only. An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question Analytic restrictions Activity restrictions Validity restrictions View restrictions Cube restrictions. Your customer wants to migrate to SAP HANA and you want to identify which business processes should be optimized. Which of the following steps must you perform to get this information? There are 2 correct answers to this question. Activate the new SQL Monitor in a development system. Activate the new SQL Monitor in a productive system. Combine the results of the SQL Monitor with the results of an ABAP runtime analysis. Combine the results of the SQL Monitor with the results of a static source code analysis. Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question There is at least one join in the other table There are two joins in the able There are three joins in the table Referential integrity holds true in both the directions. What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? There are 3 correct answers to this question. 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 logic for aggregations, grouping records, and filtering groups of the CDS view The join conditions of the CDS view The client dependency of the CDS view. What are the three best approach for Transitioning and optimizing ABAP applications to SAP HANA? There are 3 correct answers to this question. Innovate Scaling Tuning Optimize Detect. SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals? There are 2 correct answers to this question. Support for system tables Analytical DBMS features High Performance and Scalability Hybrid data and management system. Which of the following is not an element of Analytical view? Please choose the correct answer. Used to Joined table Read Data from the joined database tables Currency conversion is not applicable Join fact tables. 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. Client handling needs to be done explicitely in the the Native SQL statement. Hashed or sorted tables must be used with the INTO CORESPONDING FIELDS keyword. Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system? There are 3 correct answers to this question. Text indexing capabilities Built-in support for planning Linguistic search capabilities Traditional disk-based tables Text analysis and search. What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question By Importing a Landscape Manually By Resource console Automatically. What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. To Keep all the loads away from the DB It is beneficial for maximizing your search into database To reduce main memory consumption and to improve insert performance It is beneficial to move data-intensive calculations into the database. Which is not a Golden Rule for Open SQL? Please choose the correct answer. Minimize the Amount of Data Transferred Keep the result set large Reduce the Database Load Minimize the Number of Database Accesses. What are the features associated with ABAP CDS? There are 3 correct answers to this question. Distribution Create Update Read Export. How will you select a preference for Validation rules? Choose the correct answer Windows- Preferences-SAP HANA-Modeler-Validation Rules Windows- SAP HANA-Preferences-Modeler-Validation Rules Windows- SAP HANA-Modeler-Preferences-Validation Rules Windows- Modeler – Preferences-SAP HANA-Validation Rules. The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. Avoid CPU cache misses Avoid single network Avoid optimizing data Avoid idling CPU cores. 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. When would you use a column store table instead of a row store table? There are 2 correct answers to this question. When you want to enable a full-text search of the table When you require aggregation and analysis of values When the table has a small number of records When there are mainly distinct values in the table. Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question Analytic engine OPAX engine OLAP engine Join engine. 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 Huge potential for hybrid database Speed up the processing within the database Provide combinations of Objects and Partitioning. What are the basic principles of ALV SAP HANA? There are 2 correct answers to this question. Data described declaratively instead of passing big internal tables Only retrieve the database data which is to be displayed on screen The ALV Optimization for SAP HANA to display data on the screen To ensure that the user chooses the data on the selection screen is displayed. 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 Raw store Development Store Re-use component store Column store. What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question Column view Schema view Analytical view Attribute view. Which is not a key factor of ALV for HANA? Please choose the correct answer. Derived Column headings from the data element To supply suitable values for any input parameters To Activate and execute the program in the application The data display is restricted to a maximum of 2 billion cells. The source code editor in ADT provides many helpful features. What are these helpful features? There are 2 correct answers to this question. Creating interface from Method Calls Creating Parts for Interface Methods Creating Method Implementations from the Method Definition Creating Method Definitions from Implementation Parts. What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. DBMS technology and innovations SAP SW technology and innovations HW technology and innovations SAP BW innovations. Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment? Please choose the correct answer. Modeler Perspective Open Content outlook Catalogue outlook System Perspective. 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 Column-based database technology Time-based database technology Object-based database technology Row-based database technology Value-based database technology. Explain how and when to create calculated columns - Using Graphical Modeling Tools? There are 3 correct answers to this question The calculation will be opened in a read-only mode The calculation could be an arithmetic or character manipulation. Time characteristics based calculation columns It is possible to nest so that one calculated column, in turn, is based on other calculated columns Calculated columns also support non-measure attributes as part of the calculation. What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question Services-Name and index server on all nodes Active clusters for all servers Shared file systems for only one server High availability configuration. What is the central goal of using SAP HANA? Please choose the correct answer. Accelerate Performance Monitor database for record keeping Positive Impact on Business To set Priorities for system. 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 The supported file types for upload are: .cssv, .xlls, and .xlsxxx When loading new data in the table, it gets appended to the existing data. Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question Analyze data with the design panel Convert crosstab cells to formula Sort data by characteristics Suggests style sets for crosstabs. 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 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. 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. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Create a graph comparing the runtimes of ABAP code before and after optimization. Estimate the new total runtime of optimized code. Explain Transitioning ABAP Code to SAP HANA – Performance Considerations? There are 3 correct answers to this question. Some codes impacted positively and should be priorities Some codes transferred to other systems Classical performances recommendations for open SQL remain valid Some codes immediately run faster Some shifts in priorities, examples, nested selects(higher) indices(lower). 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 Read only Read-update Write only Read-write. |
Report abuse