What can you include in the projection list of a Core Data Services (CDS) view? 3 answers A field from the projection list of another CDS view used in the FROM clause A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values.
What is the full form of HANA? 1 answer High-Performance Analytic Accelerator High-Performance Analytic Application High Accelerator Numeric Analytics High-Performance Analytic Appliance.
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? 1 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.
Analytic Privilege can be applied to __________. 3 Answers Table Analytic views SQL View Attribute views Calculation views.
AMDP can detect 3 types of syntax errors in active or inactive source code. What are these errors? 3 Answers UNION specific syntax errors Database platform syntax errors Database independent syntax errors HANA specific syntax errors SQLScript errors.
Which of the following are core capabilities of SAP HANA? 3 Answers Data compression Columnar storage Batch processing Real-time analytics.
You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench? 1 Answer Statement template options Code completion options Code formatting options Editor shortcut key options.
An organization wants to create a complex dashboard that showcases sales data, forecasts, and hierarchical relationships between products. They are using SAP HANA as their database. How should they approach the data modeling to achieve this? 2 Answers Use only basic attribute views for simplicity Fetch all data to the application layer and process using ABAP Utilize advanced view modeling techniques like hierarchies and calculated columns Avoid using any HANA-specific modeling features for broader compatibility Leverage calculation views with star join for optimal performance.
Which of the following is a core technical concept of SAP HANA? 1 Answer Row-based storage Columnar storage Secondary indexing Traditional disk-based storage.
You created and activated database procedure. How can you call this procedure? 2 Answers By using Sap Analysis for Microsoft office By a script-based calculation view By a core data services view By another database procedure.
You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? 2 Answers It supports exception handling It supports where-used list It has syntax check at compile time It supports locking and commit handling.
Which task can you perform with the SQL Monitor (transaction SQLM)? 1 Answer Display the execution plan of an SQL statement Combine stat c and dynamic performance analysis results Search for problematic SELECT statements Capture the SQL profile of an application.
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? 3 Answers SQL Trace (transaction ST05) ABAP test cockpit (transaction ATC) Code inspector (transaction SCI) Data base performance monitor (transaction DB50) SQL monitor (transaction SQLM).
What are the steps involved in SAP HANA Evolution? 3 Answers ABAP can access SAP HANA ABAP can run on SAP HANA Optimized ABAP on SAP HANA ABAP applications on SAP HANA ABAP as accelerator on SAP HANA.
A company is migrating its traditional SAP system to SAP HANA. The ABAP developer needs to optimize the existing ABAP code to leverage SAP HANA's capabilities. Which of the following steps should the developer consider? 3 Answer Replace all SQL statements with HANA CDS views Utilize the power of code pushdown to move data-intensive calculations to the HANA database Convert all transparent tables to columnar storage Avoid using native SQL to maintain database independence Implement ALV with IDA to leverage HANA's processing capabilities.
What are the steps involved in supporting a database oriented programming model? 2 Answers Buffer system services Advanced and specific models A new and advanced Open SQL Core Data services.
Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 Answers REFERENTIAL JOIN LEFT OUTER JOIN FULL OUTER JOIN RIGHT OUTER JOIN CROSS JOIN.
Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? 2 Answers Enhanced distribution of results Documented checks Configuration of check variants Flexible schedule of check runs.
What are the Parameters for Analytical and Calculation view? 3 Answers To store data for critical analysis Create a copy of a report Setting a filter for columns Passing other values to be used in calculations Specifying unit of measurement.
Which of the following tools can be used for performance analysis in SAP HANA? 2 Answers SQL Trace ABAP Test Cockpit PlanViz SE93 Transaction Codes.
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA. What do you have to do in the corresponding ABAP class? 1 Answer 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.
When executing a native SQL query via ABAP Database Connectivity (ADBC), which of the following steps is optional? 1 Answer Create an instance of CL_SQL_RESULT_SET Create an instance of CL_SQL_CONNECTION None, all three are mandatory Create an instance of CL_SQL_STATEMENT.
Which of the following tool is introduced as a holistic quality assurance tool? 1 Answer DBMS Cockpit BW system ABAP Test Cockpit (ATC) DBA Cockpit.
Which of the following tools is primarily used for ABAP development in the context of SAP HANA? 1 Answer SAP HANA Studio Eclipse with ABAP Development Tools (ADT) SAP GUI SAP Web IDE.
What is the primary purpose of guided performance analysis in SAP HANA? 1 Answer To identify performance bottlenecks in the application layer To optimize database indexes To guide developers through performance optimization tasks To reduce the use of nested loops in ABAP code.
Explain how and when to create calculated columns - Using Graphical Modeling Tools? 3 Answers 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.
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? 1 Answer Choose the Run --> Debug options in the menu Create a debug configuration for the ABAP application and run the program Choose the debug as option in the context menu of the ABAP program Set a breakpoint in the ABAP program and execute the program.
Which of the following patterns are known to potentially cause performance issues when accessing an SAP HANA database? 3 Answers Use of SELECT ... FOR ALL ENTRIES Use of SELECT statements in loops Use of joins with more than 3 tables Use of SELECT * for tables with many fields.
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID). Which SELECT statement would you use in the definition? 1 Answer select from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id select from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount select from snwd_so { so_id, sum(net_amount) as sum_amount } select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id.
Which SAP HANA engine executes Calculation view? 2 Answers JOIN Engine Calculation Engine SQL Engine OLAP Engine.
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? 1 Answer {it_books} :it_books @it_books it_books.
The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... 3 Answers Fuzzy search linguistic search freestyle search ACID search Isolation search.
Which of the following object types in ABAP repository are proxy objects for SAP HANA artefacts? 2 Answers SQL View Database View Procedure Proxy External View.
You follow the Code-to-Data paradigm in your ABAP coding. Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"? 1 Answer The data-intensive calculations can be performed on SAP Netweaver Application Server ABAP when code-to-data mode is switched on The in-memory capabilities of SAP HANA allow calculations to be performed on the database layer, which helps to avoid unnecessary movement of data Then in-memory architecture of SAP HANA prevents the transfer of large datasets between the database layer and the application layer The transfer of coding to the database reduces the memory consumption of associated ABAP Dictionary tables in the application layer.
Discuss the conditions required to ensure the Referential Integrity? 2 Answers There are two joins in the table There are three joins in the table There is at least one join in the other table Referential integrity holds true in both the directions.
Which of the following SAP HANA-based scenarios involve ABAP applications? 2 Answers Native SAP HANA applications Data marts based on SAP HANA SAP HANA as Business Accelerator AS ABAP with SAP HANA as primary database.
You want to implement business logic on the database layer. Which approach do you follow when implementing an ABAP Managed Database Procedure? 1 Answer The Left-Right approach The Near-Far approach The Inside-Out approach The Top-Down approach.
Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view? 1 Answer "Map to Data source" "Consume CDS view" "Read from DDL source" "Relate to Business Entity".
In which cases does the call trigger the creation of the database procedure in SAP HANA? 2 Answers X is an SAP HANA view X is an AMDP method X is an ABAP Dictionary table X is a stored procedure.
|
