Webmethods online training

1

• SAP HANA
• INTERVIEW QUESTIONS ANSWERS

For Free Demo Ph1 [phone]For Details
Folkstrain.com
2
1. Define what is SAP HANA? SAP HANA stands for
prime Performance Analytical Appliance- in-memory
computing engine. HANA is connected to ERP
systems, Frontend modeling studio are often used
for replication server management and cargo
management.
For Free Demo Ph1 [phone]For Details
Folkstrain.com
3

• 2. Mention the 2 varieties of relative Data
  stored in HANA?
• The two varieties of relative knowledge keep in
  HANA includes
• Row Store
• Column Store

For Free Demo Ph1 [phone]For Details
Folkstrain.com
4
3. Mention what's the role of the persistence
layer in SAP HANA? SAP HANA has associate
degree in-memory computing engine and access the
info straightaway with none backup. To avoid the
danger of losing knowledge just in case of
hardware failure or power cutoff, persistence
layer comes as a savior and stores all the info
within the drive that isn't volatile.
For Free Demo Ph1 [phone]For Details
Folkstrain.com
5

• 4. Mention what are the various compression
  techniques?
• There are 3 completely different compression
  techniques
• Run-length coding
• Cluster coding
• Dictionary coding

For Free Demo Ph1 [phone]For Details
Folkstrain.com
6
5.Justify what are transformation rules?
Transformation rule is that the rule laid out in
the advanced replication setting dealing for the
supply table specified knowledge is reworked
throughout the replication method.
For Free Demo Ph1 [phone]For Details
Folkstrain.com
7
6.Mention what's the role of master controller
job in SAP HANA? The job is organized on demand
and is answerable for Making information triggers
and work table into the supply system. Making
Synonyms. Writing new entries in admin tables in
SLT server once a table is replicated/loaded.
For Free Demo Ph1 [phone]For Details
Folkstrain.com
8
7. Justify however you'll avoid un-necessary work
info from being stored? You can avoid
un-necessary work info from being keep by pausing
the replication by stopping the schema-related
jobs.
For Free Demo Ph1 [phone]For Details
Folkstrain.com
9
8.Justify however SQL statement is processed?
In the HANA information, every SQL statement is
enforced within the reference of the dealing. New
session is assigned to replacement dealing.
For Free Demo Ph1 [phone]For Details
Folkstrain.com
10

• 9.Name varied parts of SAP HANA?
• SAP HANA dB
• SAP HANA Studio
• SAP HANA Appliance
• SAP HANA Application Cloud

For Free Demo Ph1 [phone]For Details
Folkstrain.com
11
10. Mention what is the role of the transaction
manager and session? The transaction manager
co-ordinates database transactions and keep a
record of running and closed transactions. When
transaction is rolled back or committed, the
transaction manager notifies the involved storage
engines about the event so they can run necessary
actions.
For Free Demo Ph1 [phone]For Details
Folkstrain.com
12
For Free Demo Ph1 [phone]For Details
Folkstrain.com