hana test 9

What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. Without currency /unit consideration. Restricted to 5000 records / unit. All unit/ currency restricted to 10,00,00 records. Restricted to 10,000 records. No unit/ currency split if aggregating amounts/ currency values.

Which is not a Golden Rule for Open SQL? Please choose the correct answer. Keep the result set large. Minimize the Amount of Data Transferred. Minimize the Number of Database Accesses. Reduce the Database Load.

What are the two Profitability Analysis available with CO-PAScenario in SAP HANA Modeling? There are 2 correct answers to this question. Service-based profitability. Costing-based Profitability. Account-based Profitability. Product-based Profitability.

You analyze SQL Monitor data in transaction SQLMD. You know that program Xaccesses database table Y. You made sure that program X was executed whilethe SQL Monitor collected its data. But the relevant database access is NOT listedin SQLMD. What could be the reason? There are 3 correct answers to this question. SQL Monitor was activated for a specific application server. Database table Y is a buffered table. SQL Monitor was activated with a fitter that excludes database table Y. Program X was executed in the background. The data has NOT yet been transferred to the SQL Monitor database tables.

Explain the Enterprise Information System of - SAP HANA ImplementationScenarios? There are 3 correct answers to this question. Business Suite on HANA / BW on SAP HANA. All HANA Combinations on one platform. All SAP applications on one SAP HANA platform. HANA Accelerators. HANA Modeling.

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question. Transfer all data from the database to the ABAP layer, and then aggregate theresults. Perform expensive calculations on the database. Use native SQL to access SAP HANA built-in functions. Perform expensive calculations on the ABAP application server. Aggregate data on the database, and transfer the results to the ABAP layer.

Which of the following features were added to the ABAP dictionaryto support the SAP HANA database? There are 3 correct answers to this question. Change of data class. Storage type for tables. De-pooling and de-clustering. Definition of full-text indexes. Definition of enhancement category.

You want to define an ABAP Core Data Services (CDS) view that totals theNET_AMOUNT column for each sales order (column SO_ID). Which SELECT statement would you use in the definition? Please choose the correct 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 so_id. 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 bynet_amount.

Which features does the source code editor provide in ABAPDevelopment Tools for SAP NetWeaver? There are 2 correct answers to this question. Screen editing. Quickfix. Form-based class builder. Content assistance.

Which data provisioning methods can you use when you need realtime replications? There are 2 correct answers to this question. SAP HANA Direct extractor connection (SAP DXC). SAP Replication server. SAP Data services. SAP Landscape transformation Replication server (SAP SLT).

Which code-to-data capability is responsible for the Optimizations& Translation of “Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL? Please choose the correct answer. Transparent Optimizations. Database Optimization. HANA Specific features. Buffer system Optimization.

You implement an ABAP-managed database procedure (AMDP). Within thisAMDP, you want to query data from calculation view CA_BOOKINGS_COUNT inSAP HANA content package ha400.primdb. How can you address the calculation view? There are 2 correct answers to this question. "ha400.primdb::CA_BOOKINGS_COUNT". "ha400.pr mdb/CA_BOOKINGS_COUNT". _SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT". _SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT".

Which of the following tool is introduced as a holistic quality assurance tool? Choose the correct answer. DBA Cockpit. ABAP Test Cockpit (ATC). BW system. DBMS Cockpit.

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 ABAPtrace results for method X? Please choose the correct answer. The net run time is less than the gross run time. The net run time is equal to Zero. The net run time is greater than the gross run time. The gross and net run times are identical.

What are the principles of Using HANA Transport Containersproperly? There are 3 correct answers to this question. Automatic update for all export methods. Takes a ‘snapshot’ of all SAP HANA objects of delivery unit. Release of Transport request. Import of Transport Request. To create Transport container of delivery unit.

You made changes to an object (X) used by an ABAP manageddatabase procedure (AMDP). You did NOT changes the AMDP itself. Now youexecute a program that calls this AMDP. In which cases does the call trigger the creation of the database procedure inSAP HANA? There are 2 correct answers to this question. X is an SAP HANA view. X is an AMDP method. X is an ABAP Dictionary table. X is a stored procedure.

When to use Enhanced Open SQL? There are 2 correct answers to this question. Need the query in one piece of code only. To access system fields. At the time of Dictionary Views. To view scalar components.

Which of the Golden Rules for Open SQL Performance have becomemore important with SAP HANA? There are 2 correct answers to this question. Keep unnecessary load away from the database. Minimize the search overhead. Minimize the amount of transferred data. Minimize the number of database accesses.

When would you use a column store table instead of a row store table? There are 2 correct answers to this question. When you require aggregation and analysis of values. When the table has a small number of records. When you want to enable a full-text search of the table. When there are mainly distinct values in the table.

Discuss different types of engines associated with The SAP HANAarchitecture? https://www.erpprep.com/node/9095/take 9/9 There are 2 correct answers to this question. Join engine. OLAP engine. Analytic engine. OPAX engine.