A developer is tasked with optimizing an ABAP report that fetches and processes large sets of data. The underlying database is SAP HANA. How should the developer approach this task to leverage HANA artifacts?
There are 2 correct answers to this question. Implement code pushdown techniques to leverage HANA's processing capabilities Use HANA views and CDS views to pre-process data at the database level Fetch all data to ABAP and then apply logic for processing Avoid using any HANA-specific features to ensure compatibility Convert all SQL statements to Native SQL for better performance.
Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources?
Please choose the correct answer. Security folder Provisioning folder Administration folder Content folder.
You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X?
Please choose the correct answer. The net run time is equal to Zero The gross and net run times are identical The net run time is greater than the gross run time The net run time is less than the gross run time.
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 A higher value than on a traditional, row-store only based database A value that you calculate based on the number of tables The same value as on a traditional, row-store only based 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. By using SQL application By using Open Catalog look Database user – also different from your ABAP user Password for the database user.
What allows you to resolve errors quickly or warnings reported about the code?
Please choose the correct answer. Code execution ABAP debugger Quick Fix Debug perspective.
What do you understand by The SAP HANA Software Optimization?
Please choose the correct answer. Provide combinations of Objects and Partitioning Bring logic to where the data is calculated first, then only move to results Speed up the processing within the database Huge potential for hybrid database.
What is the main purpose of SAML for SAP HANA Studio?
Please choose the correct answer. The assertion is issued by a user after the client was successfully authenticated To support scenarios where clients are not directly connected to the SAP HANA Database SAML may be selected as an Owner’s authentication method when creating users in the SAP HANA Studio The SAP HANA database supports login of Owners only.
What can you include in the projection list of a Core Data Services (CDS) view?
There are 3 correct answers to this question. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause. ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values. A field from the projection list of another CDS view used in the FROM clause.
What all are the Types of Applications based on SAP HANA?
There are 2 correct answers to this question. New or Native SAP HANA Server based on SAP HANA Data Mart based on SAP HANA Innovation based on SAP HANA.
What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question. Simplification of massive data Query Speed support High modeling flexibility Fast insights into business activity.
You want to develop an ABAP application for SAP HANA using the front-end image of your Amazon Web Service (AWS) trial system. Which plug-ins do you need to add to the existing Eclipse installation?
Please choose the correct answer. SAP HANA Tools ABAP Development Tools for SAP NetWeaver All plug-ins provided by SAP Development Tools for Eclipse None; everything is preconfigured.
Which of the following are prerequisites for exposing an association?
Please choose the correct answer. All fields mentioned in the ON condition are part of the field list. The association points to a table, not to another CDS View. The association points to a table, not to another CDS View. The association is the only association in this view definition.
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. 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 explicitly in the the Native SQL statement. The ABAP system checks the syntax of the Native SQL statements.
What are the uses of SQL Trace (ST05)?
There are 3 correct answers to this question. Locate database performance issues Applying Code inspector Detect redundant or identical select statements Display record of all database access Locate work base issues.
An ABAP developer notices that a particular transaction is taking longer than expected. They decide to use the Guided Performance Analysis tool. What outcomes can they expect?
Please select all the correct answers that apply. Detailed trace of SQL statements and their execution times Suggestions for database index optimizations Recommendations for code pushdown opportunities Identification of performance bottlenecks in the code Insights into user behavior and transaction frequency.
Which of the following JOIN types are supported in Open SQL?
There are 3 correct answers to this question. CROSS JOIN LEFT OUTER JOIN RIGHT OUTER JOIN REFERENTIAL JOIN INNER JOIN.
What views will be most efficient for General Modeling Principles?
There are 2 correct answers to this question. Attribute view Column view Analytical view Schema view.
Which TADIR object type is used for the definition of a Core Data Services (CDS) view?
Please choose the correct answer. R3TR VIEW R3TR DDLS R3TR DDIC R3TR TABL.
Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA?
There are 2 correct answers to this question. Minimize the amount of transferred data. Keep unnecessary load away from the database. Minimize the number of database accesses. Minimize the search overhead.
What is Core Data Services (CDS)?
Please choose the correct answer. A collection of core features and services that provide data from the ABAP application server layer to the user interface A collection of domain-specific languages and services for definition and consumption of semantically rich data models A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system A collection of services that provide information about the data volumes of the SAP HANA core tables.
What 2 deployment options are there for HTA?
There are 2 correct answers to this question. Implicit Automatic Explicit Manual.
What is the system privilege required to create analytic privilege?
Please choose the correct answer. CREATE STRUCTURED PRIVILEGE CREATE PRIVILEGE PRIVILEGE ADMIN STRUCTUREDPRIVILEGE ADMIN.
What is a powerful tool for capturing the SQL profile of a system or transaction?
Please choose the correct answer. Code Inspector SQL Monitor ABAP Test Cockpit SQL Database.
What new join type is now supported in SQL?
Please choose the correct answer. Left outer Join Full Join Inner Join Right Outer Join.
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 Monitor. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Estimate the new total runtime of optimized code.
User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated?
Please choose the correct answer. _SYS_BI SYSTEM _SYS_BIC STUDENT_A.
Which conditional expressions can be used in Core Data Services (CDS) views?
There are 2 correct answers for this question. WHILE statements in the WHERE clause IF statements in the projection list CASE statements in the HAVING clause COALESCE functions in the projection list CASE statements in the projection list.
Which of the following entities can be found under the Catalog node, and not under the Content node?
There are 2 correct answers to this question. Schema Table Calculation view Package.
Explain how and when to create calculated columns - Using Graphical Modeling Tools?
There are 3 correct answers to this question. The calculation could be an arithmetic or character manipulation. 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 The calculation will be opened in a read-only mode. Time characteristics based calculation columns.
What is the purpose of an ABAP project in ABAP Development tools for eclipse?
There are 2 correct answers to this question. It represents the connection to the SAP HANA server It represents the connection to an ABAP system It is used to transport ABAP repository objects. It provides access to all ABAP repository objects in an ABAP system.
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. Fuzzy search linguistic search freestyle search ACID search Isolation search.
How SAP HANA supports SQL?
There are 3 correct answers to this question. As a Data Calculator As a means to define Read Manipulate data Transferring data.
What all are the factors involved in Working with ADT?
There are 3 correct answers to this question. Module interface Workbench programs ABAP interface ABAP programs ABAP Class.
User STUDENT_A create and activates a design-time object. In which schema is the run object generated?
Please choose the correct answer. STUDENT_A _SYS_BI _SYS_BIC SYSTEM.
Which engine is used to execute Analytic View?
Please choose the correct answer. Calc Engine Join Engine SQL Engine OLAP Engine.
What differentiates SAP HANA from traditional databases?
Please choose the correct answer. It is only a relational database It uses disk-based storage exclusively It leverages in-memory computing It doesn't support SQL.
An import parameter that is annotated with @Environment.systemField: becomes optional in the following places:
Please choose the correct answer. In Data Preview in ADT In ABAP Open SQL In the definition of another CDS view In the Data Browser (SE16).
Which of the following are view annotations for a CDS view?
There are 3 correct answers to this question. Access control Environment Client handling Semantics Buffering type.
What are the types of schemas in HANA?
There are 3 correct answers to this question. Dynamic Schema User Defined Schema System Defined Schema SLT Derived Schema.
|
