What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster?
There are 2 correct answers to this question(0/1 Points)
Shared file systems for only one se
...
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster?
There are 2 correct answers to this question(0/1 Points)
Shared file systems for only one server
High availability configuration
Active clusters for all servers
Services-Name and index server on all nodes
High availability configuration
Services-Name and index server on all nodes
What is the main function of Static Code Analysis?
Please choose the correct answer.(0/1 Points)
Integrates with SAP Solution Manager
To detect code that would lead to functional or performance issues When migrating to SAP HANA
ABAP source code with performance optimization potential
Integrated into ABAP Development Tools and ABAP Workbench
To detect code that would lead to functional or performance issues When migrating to SAP HANA
What are the features of New Open SQL?
There are 2 correct answers to this question.(0/1 Points)
Supports Code adjustment model
Supports specific units of database
Supports arithmetic and string expressions
Supports conditional expressions
Supports arithmetic and string expressions
Supports conditional expressions
4.Which is not a Golden Rule for Open SQL?
Please choose the answer.(0/1 Points)
Reduce the Database Load
Minimize the Number of Database Accesses
Keep the result set large
Minimize the Amount of Data Transferred
Keep the result set large
5.Which features does the source code editor provide in ABAP Development Tools for SAP NetWeaver?
There are 2 correct answers to this question.(0/1 Points)
Quickfix
Screen editing
Form-based class builder
Content assistance
Quickfix
Content assistance
6.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?
Please choose the correct answer(0/1 Points)
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 } 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 by so_id
7.Open SQL largely standardized, three sub-languages. What are these sub-languages?
There are 3 correct answers to this question(0/1 Points)
Data Evaluation Language(DEL)
Data Transferring Language(DTL)
Data Manipulation Language (DML)
The Data Definition Language (DDL)
The Data Control Language (DCL)
Data Manipulation Language (DML)
The Data Definition Language (DDL)
The Data Control Language (DCL)
8.What are the two main factors of SAP HANA Innovations and Challenges?
There are 2 correct answers to this question.(0/1 Points)
DBMS technology and innovations
HW technology and innovations
SAP SW technology and innovations
SAP BW innovations
HW technology and innovations
SAP SW technology and innovations
9.Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)?
Please choose the correct answer.(0/1 Points)
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.
Estimate the new total runtime of optimized code.
Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
Combine information from static ABAP code scans with runtime data from the SQL Monitor.
10.The source code editor in ADT provides many helpful features. What are these helpful features?
There are 2 correct answers to this question.(0/1 Points)
Creating Method Definitions from Implementation Parts
Creating interface from Method Calls
Creating Method Implementations from the Method Definition
Creating Parts for Interface Methods
Creating Method Definitions from Implementation Parts
Creating Method Implementations from the Method Definition
11.How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement?
Please choose the correct answer(0/1 Points)
As many result sets as there are table output parameters in the procedure
One result set
As many result sets as there are input parameters in the procedure
Two result sets
One result set
12.What is the central goal of using SAP HANA?
(0/1 Points)
Accelerate Performance
To set Priorities for system
Monitor database for record keeping
Positive Impact on Business
Accelerate Performance
13.Hybrid Data Management System - Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system?
There are 3 correct answers to this question.(0/1 Points)
Text indexing capabilities
Built-in support for planning
Traditional disk-based tables
Linguistic search capabilities
Text analysis and search
Built-in support for planning
Traditional disk-based tables
Text analysis and search
14.What all are the factors involved in Working with ADT
There are 3 correct answers to this question(0/1 Points)
ABAP interface
ABAP programs
ABAP Class
Workbench programs
Module interface
ABAP interface
ABAP programs
ABAP Class
15.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.(0/1 Points)
The net run time is greater than the gross run time
The net run time is equal to Zero
The net run time is less than the gross run time
The gross and net run times are identical
The net run time is less than the gross run time
16.What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling?
There are 2 correct answers to this question(0/1 Points)
Service-based profitability
Account-based Profitability
Product-based Profitability
Costing-based Profitability
Account-based Profitability
Costing-based Profitability
Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database?
There are 3 correct answers to this question.(0/1 Points)
Definition of full-text indexes
Changes of data class
Storage type for tables
De-pooling and de-clustering
Definition of an enhancement category
Definition of full-text indexes
Storage type for tables
De-pooling and de-clustering
Discuss different types of engines associated with The SAP HANA architecture?
There are 2 correct answers to this question(0/1 Points)
OPAX engine
Analytic engine
OLAP engine
Join engine
OLAP engine
Join engine
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view?
Please choose the correct answer.(0/1 Points)
Define the cardinality for the target entity
Include all fields used in the ON condition in projection list
Specify an alias for the target entity
SPECIFY THE OTHER VIEWS IN WHICH THE ASSOCIATION CAN BE USED
Include all fields used in the ON condition in projection list
Which of the following tasks can you perform with SQL monitor (transaction SQLM)?(0/1 Points)
Search for problematic SELECT* statements
Capture the SQL profile of an application
Combine static and dynamic performance analysis results
Display the execution plan of an SQL statement
Capture the SQL profile of an application
What are the two layers of ABAP system interacts with its database?
There are 2 correct answers to this question.(0/1 Points)
The Database independent interface
The Client database interface
The Data Storage interface
The Database specific library
The Database independent interface
The Database specific library
What are some of the features available SAP List Viewer with integrated data access (SALV IDA)?
There are 3 correct answers to this question.(0/1 Points)
Group rows
Search in content
Display diagrams
Double-click on rows
Edit cells
Group rows
Search in content
Display diagrams
When are referential joins executed in analytical views?
Choose the correct answer(0/1 Points)
When all the tables are optimized
When fields are optimized
When fields are selected
When fields from both the tables are requested
When fields from both the tables are requested
How to call the stored procedures in ABAP code?
Please choose the correct answer.(0/1 Points)
Native SQL
Only SQL
CDS view
Open SQL
Native SQL
You perform a static code check using the Code Inspector (SCI). In your SCI variant, you select the Search problematic SELECT * statements check. What does this check report?
Please choose the correct answer.(0/1 Points)
SELECT * statements on tables with more than a specified number of fields
SELECT * statements where fewer than a specified percentage of all fields are effectively used
SELECT * statements on tables with more than 100,000 records
SELECT * statements on tables with the Column Store storage type
SELECT * statements where fewer than a specified percentage of all fields are effectively used
Which tasks does the ABAP managed database (AMDP) framework perform?
There are 2 correct answers to this question.(0/1 Points)
Delete the obsolete versions of the database procedure synchronously
Create a new version of the database when the AMDP is first activated
Delete the obsolete versions of the database procedure asynchronously
Create a new version of the database when the AMDP is first called
Delete the obsolete versions of the database procedure asynchronously
Create a new version of the database when the AMDP is first called
What are best practices when programming in ABAP for SAP HANA?
There are 2 correct answers to this question(0/1 Points)
Calculate aggregations using ABAP code on the application server to limit database load
Use a column list in the SELECT clause to ensure that you only read a column if it is really required
Eliminate nested SELECT statements to reduce the overall number of database accesses
Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required
Use a column list in the SELECT clause to ensure that you only read a column if it is really required
Eliminate nested SELECT statements to reduce the overall number of database accesses
List down the elements involved in User Management and Security in SAP HANA?
There are 3 correct answers to this question(0/1 Points)
Work management
Manage users
Assign security
Assign job security
Create users
Manage users
Assign security
Create users
[Show More]
