E_HANAAW142 + E_HANAAW151

INFO
STADISTICS
RECORDS
Title of test:
E_HANAAW142 + E_HANAAW151

Description:
Mix of questions from 142 and 151

Author:

(Other tests from this author)

Creation Date:
31/03/2016

Category:
Computers
Click 'LIKE' to follow the bests test of daypo at facebook
Last comments
No comments about this test.
Content:
Which of the following are characteristics of an external view? (3 answers) It can be used as a data type in ABAP programs It is an ABAP Dictionary object type It allows access to an SAP HANA information view with Open SQL It defines the underlying SAP HANA information view It can be used in Open SQL statements for database updates.
Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement (2 answers) Include the client field in the WHERE condition. Use the CLIENT SPECIFIED addition. Include the client field in the join condition. Include the client field in the field list.
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? Release packages Update packages Release resources Update resources.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Implement the interface IF_AMDP_MARKER_HDB. Implement the ABAP AMDP_HDB Event Handler. Set the visibility of the corresponding class method in the declaration section to PUBLIC.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? 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 Monitor Combine information from static ABAP code scans with runtime data from the SQL Trace tool Estimate the new total runtime of optimized code.
What are the benefits of using the SQL Monitor (transaction SQLM)? (2 Answers) It collects monitoring data asynchronously without additional database interaction It can be active in a production system with minimal performance overhead It displays the database execution plan for all SQL statements It schedules ABAP programs to monitor and log all database accesses.
Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver? (2 Answers) Screen editing Quickfix Form-based class builder Content assistance.
In which of the following situations could a row store table be more suitable than a column store table? (2 answers) The table contains data that you want to aggregate. 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.
Which of the following are performance recommendations when using SAP HANA? 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.
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? Write only Read only Read-update Read-write.
You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database. In the check parameters, which value would you use for the percentage of fields that are effectively used? Please choose the correct answer. A lower value than on a traditional, row-store only based database The same value as on a traditional, row-store only based database A value that you calculate based on the number of tables A higher value than on a traditional, row-store only based database.
What should you do to follow the code-to-data approach to programming? (2 Answers) Perform expensive calculations on the database. Transfer all data from the database to the ABAP layer, and then aggregate the results. Aggregate data on the database, and transfer the results to the ABAP layer. Perform expensive calculations on the ABAP application server.
What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 answers) It deletes obsolete versions of the database procedure asynchronously It creates the database procedure when the AMDP is first called. It creates the database procedure when the AMDP is first activated. It deletes obsolete versions of the database procedure synchronously.
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 answers) The logic for aggregations, grouping records, and filtering groups of the CDS view The join conditions of the CDS view The name of the representation of the CDS view in the ABAP dictionary The client dependency of the CDS view The extent to which records of the CDS view should be buffered on the application server.
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? {it_books} :it_books @it_books it_books.
Which of the following are characteristics of an external view? (3 answers) It can be used as a data type in ABAP programs. It is an ABAP Dictionary object type It allows access to an SAP HANA information view with Open SQL. It defines the underlying SAP HANA information view It can be used in Open SQL statements for database updates.
Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement. Which of the following changes to the SELECT statement can you use to retrieve the same data as before? (2 answers) Include the client field in the WHERE condition Use the CLIENT SPECIFIED addition. Include the client field in the join condition Include the client field in the field list.
Which of the below statements are true for SAP HANA? SAP HANA is a combination of hardware and software made to process massive real time data using In-Memory computing. SAP HANA combines row-based, column-based database technology. SAP HANA is best suited for performing real-time analytics, and developing and deploying real-time applications.
What is the language SAP HANA is developed in? C C++ Java Assembly.
What is the operating system supported by HANA? Only Windows 8 Both Linux and Window 8 SUSE Linux Enterprise Server Red Hat Enterprise Linux (RHEL).
Which statement is true for SAP HANA? SAP provides both hardware and software for SAP HANA. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners.
What are the benefits of SAP HANA? SAP HANA provides real time analysis capability, which helps to take fast and real time access to business reports. SAP HANA manages growing data volume and complexity with lower cost of ownership SAP HANA provides in-memory technology lets users explore and analyze all business data in real time from virtually any data source.
What is the full form of HANA? High-Performance Analytic Accelerator High Accelerator Numeric Analytics High-Performance Analytic Appliance High-Performance Analytic Application.
Which of the following is latest release of SAP HANA? SAP HANA 1.0 SAP HANA 1.6 SP03 SAP HANA 1.0 SP08 or SP10 SAP HANA 1.0 SP06.
What is SAP HANA Appliance? It is a combination of software from SAP and certified hardware from vendors like Dell, IBM, Cisco, Fujitsu. It is a piece of hardware from vendors like Dell, IBM, Cisco, Fujitsu. Is solely produced by SAP AG only. It is a combination of BI, BOBJ and HANA.
What language one should know to work in SAP HANA? SQL Java C# ABAP.
What are the benefits of implementing ERP with HANA? Performance optimization Processing of large volumes of data Provision of real-time analytics.
What are the tables that SAP HANA supports? Row Based Table Column Based Tables.
What are the advantages of column based tables? Better Compression Better parallel Processing Faster Data Access.
Suppose we are creating an analysis application in SAP HANA which will be used to check business reports on huge data volume. Which type of table should we use? Row Based Table Column Based Table.
After creating a table, can we change it from row based to column based and vice-versa? yes no.
Which of the statement is true for SAP HANA? In SAP HANA all the data resides in RAM. Hence in case of power failure all the data will be lost. SAP HANA also uses disc memory to keep backup. In case of power failure the database can be re-stored to the last consistent state.
You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL communication for client access? 30015 8015 35115 8000.
Can we change the table type from COLUMN to ROW in SAP HANA? yes no.
What are the types of modeling views in HANA? (3 answers) Attribute View Analytic View Calculation View Schema View.
Which of the below statements are true? Attributes are Non-measurable, Descriptive data Measures are quantifiable data, which can be measured. Measures are always numeric values. Examples of Attributes are Country, Product, Customer etc.
Which of the following are types of calculation view? (2 answers) Multidimensional Scripted Graphical Reading.
Which components can be a part of a calculation view? (3 answers) Tables BAPIs Attribute View Analytic View.
Can we include Attribute views in Analytic view definition? yes no.
While creating a Graphical Calculation view, what are the options available in Tools palette? Union Join Projection Aggregation.
Is it mandatory to specify measures in Analytic view? yes no.
Which SAP HANA engine executes Calculation view? (2 answers) SQL Engine OLAP Engine Calculation Engine JOIN Engine.
Graphical calculation views can letter be converted to Scripted calculation view if required. yes no.
Which of the following can be part of an analytic view? (3 answers) Query transformation Unions Logical joins Data foundation Attributes.
Attribute View types are Standard Time Derived.
HANA modeling views can be created under Schema Catalog Content File System.
Which of the below statements are true for SAP HANA Studio? 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 a client tool, which can be used to access local or remote HANA system. 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.
What are the operating systems that support SAP HANA Studio? Microsoft Windows SUSE Linux Enterprise Server Mac OS.
Which of the below perspectives are present in SAP HANA Studio? Modeler SAP HANA Development Administration Console.
Which of the following statements are true about “Catalog”? Which of the following statements are true about “Catalog”? It represents SAP HANA’s data dictionary It contains the design-time artifacts.
Which of the following statements are true about “Content”? 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.
Which of the export mechanism is not available in HANA? Archive File Delivery Unit Developer Mode SAP Support Mode.
What are the SAP Business Objects tools that supports reporting on SAP HANA? SAP BusinessObjects Analysis SAP Lumira SAP BusinessObjects Explorer SAP Business Objects Crystal Reports.
Which of the following drivers are supported by SAP HANA? JDBC ODBC ODBO.
Which of the following API is used by Excel to connect to SAP HANA? MDX SQL BICS.
Which SAP HANA engine executes Calculation view? SQL Engine OLAP Engine Calc Engine Join Engine.
What are the different types of Variables in HANA? Single Value Interval Range.
Which engine is used to execute Analytic View? SQL Engine OLAP Engine Calc Engine Join Engine.
Which of the following statements are true about Input Parameter? Input parameters can be used inside the modeling view for implementing business logic. Data type must be defined for the Input Parameters Input parameter of type “Attribute Value” is almost same as Variable.
Which of the following statements are true about Variable? (2 answers) Variables are used for filtering Variables are always bound to columns It is always mandatory to pass the value of Variable.
What are the joins SAP HANA supports? Inner Join Left Outer Join Right Outer Join Full Outer Join Referential Join Text Join.
In order to get language-specific data, which join is used in SAP HANA? Language join Text Join Referential Join It is not possible to fetch language-specific data in HANA.
What are the different types of Calculation View? (2 answers) Text-Based Calculation Graphical Calculation View OLAP Calculation View Scripted Calculation View.
Which SQL operator is used to pass Input Parameter? PLACEHOLDER WHERE.
Which SQL operator is used to pass Variable? PLACEHOLDER WHERE.
Analytic Privilege can be applied to (3 Answers) Attribute views Analytic views Calculation views Table SQL View.
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.
What is the system privilege required to create analytic privilege? CREATE STRUCTURED PRIVILEGE CREATE PRIVILEGE STRUCTUREDPRIVILEGE ADMIN PRIVILEGE ADMIN.
What is the system privilege required to drop analytic privilege? PRIVILEGE ADMIN CREATE STRUCTURED PRIVILEGE CREATE PRIVILEGE STRUCTUREDPRIVILEGE ADMIN.
Which system schema contains the list of Activated and inactive Objects? _SYS_BIC _SYS_BI _SYS_REPO _SYS_XS.
What are the types of schemas in HANA? User Defined Schema System Defined Schema Dynamic Schema SLT Derived Schema.
Which system schema/user is the owner of all the activated objects? _SYS_BIC _SYS_BI _SYS_REPO _SYS_XS.
Which system schema contains the information about Time data and Schema Mapping? _SYS_BIC _SYS_BI _SYS_REPO _SYS_XS.
Which system schema contains the column views of activated objects? _SYS_BIC _SYS_BI _SYS_REPO _SYS_XS.
Which of the statements are true for SQLScript? (2 answers) SQLScript is a collection of extensions to SQL. SQLScript is used to push down data intensive logic into the database. SQLScript is an open standard.
What is the main advantage of SQLScript? (2 answers) SQLScript is faster than traditional SQL SQLScript can be better modularized than traditional SQL SQLScript code can easily be translated into modeling view.
SQLScript supports control logic like if/else, while traditional SQL does not support that. True False.
SAP HANA CE functions are optimized for HANA and perform better. True False.
Which engine executes the CE functions? Calc engine SQL engine OLAP engine Joine Engine.
SAP HANA only supports Read-Only Procedure true false.
Which of the below statements are true for procedure? Procedures are reusable processing blocks, and describe a sequence of data transformations. Procedures can have multiple input and output parameters A procedure can be created as read only (without side-effects) or read-write (with side-effects).
Which SQL syntax is used to create a read only procedure? READS SQL DATA READS PROCEDURE NO-SIDE-EFFECT READ-ONLY.
Which of the following is true? A Read-write procedure cannot call another read-write procedure. A read-write procedure can call both read-write and read only procedures. A read only procedure cannot call read-write procedure.
Which is better from performance point of view? SQLScript Procedure Modeling Views.
Which of the below has huge negative impact on performance? (2 answers) Join on calculated column Inner Join Mixing up SQL statement and CE functions.
Inner join is always better than Left Outer join. Hence we should always prefer inner join instead of left outer. true false.
Aggregation and filter should be used as early as possible to reduce data amount. true false.
Which of the below is better in terms of performance? Normal SQL statement CE Functions.
Report abuse Terms of use
We use cookies to personalize your experience. If you continue browsing you will be accepting its use. More information.