Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ONTest 1 HANA

COMMENTS STATISTICS RECORDS
TAKE THE TEST
Title of test:
Test 1 HANA

Description:
Test 1 HANA

Author:
HANA
(Other tests from this author)

Creation Date:
01/04/2018

Category:
Others

Number of questions: 20
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question Delimited identifiers Undelimited Identifiers Numeric identifiers Limited identifiers.
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 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 The application suggests the column name and data type for the new tables, and it is possible to edit them.
What are the two main factors of SAP HANA Innovations and Challenges? There are 2 correct answers to this question. SAP SW technology and innovations SAP BW innovations DBMS technology and innovations HW technology and innovations.
Which is not a Golden Rule for Open SQL? Please choose the correct answer. Reduce the Database Load Minimize the Number of Database Accesses Minimize the Amount of Data Transferred Keep the result set large.
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. freestyle search linguistic search Isolation search Fuzzy search ACID search.
What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question. Tools analyzing performance at run-time, to determine if critical constructs The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption A new tool called SQL Monitor to determine the priority if different programs access the database intensively A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer. ABAP-Managed Database Procedures Table buffering Programming model New advanced SQL syntax Procedures.
What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question. Interaction with Database Stored Procedures Consume using native SQL SQL units.
Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Filter data in lower layers. Move data-intensive calculations from the database to an application server. Define indexes on the columns that are used in calculations. Avoid transferring large result sets between database and client applications.
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 join conditions of the CDS view The client dependency of the CDS view The logic for aggregations, grouping records, and filtering groups 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.
What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question By Resource console Manually By Importing a Landscape Automatically.
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. Combine information from static ABAP code scans with runtime data from the SQL Monitor. Estimate the new total runtime of optimized code.
What are the ABAP development guidelines? There are 2 correct answers to this question. Consuming Only ABAP contents for SAP HANA Extensions to ABAP Language Improved tools for performance analysis Improved hybrid components for SAP HANA.
What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question Analytical view Schema view Attribute view Column view.
Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question Analytic engine Join engine OLAP engine OPAX engine.
How SAP HANA supports SQL? There are 3 correct answers to this question. Read As a means to define Manipulate data As a Data Calculator Transferring data.
Why is a security concept in SAP HANA required? There are 2 correct answers to this question Access to ERP tables must be restricted Editing of SAP HANA data models should only be possible for “Users.” of the model Need to have selected users in SAP HANA for Information Management Database administration should be restricted to skilled.
What are the supported joins in CDS view? There are 2 correct answers to this question. Left outer join Upper join Operators join Inner join.
Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question The Administration view The Landscape view The Security view The System Monitor view.
What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question. Release of Transport request Import of Transport Request Takes a ‘snapshot’ of all SAP HANA objects of delivery unit Automatic update for all export methods To create Transport container of delivery unit.
Report abuse Consent Terms of use