Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ONTest 3 HANA

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

Description:
Test 3 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:
Which is not a key factor of ALV for HANA? Please choose the correct answer. 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 Derived Column headings from the data element.
You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer. {it_books} :it_books @it_books it_books.
Which of the following is not an element of Analytical view? Please choose the correct answer. Read Data from the joined database tables Join fact tables Used to Joined table Currency conversion is not applicable.
What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question. A new and advanced Open SQL Buffer system services Advanced and specific models Core Data services.
List down the elements involved in User Management and Security in SAP HANA? There are 3 correct answers to this question Assign job security Create users Work management Manage users Assign security.
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question. Administer Configure Organizing Monitor Selecting.
What are the supported joins in CDS view? There are 2 correct answers to this question. Operators join Inner join Upper join Left outer join.
ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations? There are 3 correct answers to this question. The ABAP language and the OpenSQL language have been extended Performance analysis tools have been improved Do all the data processing in Application server The consumption of SAP HANA artifacts was simplified Re- use components have been extended or optimized for SAP HANA.
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. Catalogue outlook Open Content outlook Modeler Perspective System Perspective.
What is the central goal of using SAP HANA? Please choose the correct answer. Monitor database for record keeping Positive Impact on Business To set Priorities for system Accelerate Performance.
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 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. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption.
What do you understand by The SAP HANA Software Optimization? Choose the correct answer Speed up the processing within the database Provide combinations of Objects and Partitioning Bring logic to where the data is calculated first, then only move to results Huge potential for hybrid database.
To connect with the SAP HANA system and see the corresponding catalog content etc., use the Systems view. How will you add a system to this view? There are 2 correct answers to this question. Database user – also different from your ABAP user Password for the database user By using SQL application By using Open Catalog look.
Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question Suggests style sets for crosstabs Sort data by characteristics Analyze data with the design panel Convert crosstab cells to formula.
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 Database Language Data Manipulation Language The Data Definition Language The Data Control Language Data Transferred Language.
Which code-to-data capability supports- Extended view definitions and Better SQL- 92 standard support in open SQL? Please choose the correct answer. Database for sophisticated analysis Database oriented programming model SAP HANA specific features New SQL parser used in model.
Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Choose the correct answer Performance data table Selection data table Runtime monitor data Critical data table.
The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question. Avoid single network Avoid optimizing data Avoid CPU cache misses Avoid idling CPU cores.
Discuss different types of engines associated with The SAP HANA architecture? There are 2 correct answers to this question Join engine OLAP engine Analytic engine OPAX engine.
Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Define indexes on the columns that are used in calculations. Move data-intensive calculations from the database to an application server. Avoid transferring large result sets between database and client applications. Filter data in lower layers.
Report abuse Consent Terms of use