SAP HANA INTERVIEW QUESTIONS
TCS SAP HANA Inierview Questions :
1) what is multi-core saphana architecture?
sap hana is Multiple CPU architecture ,one motherboard contains mulitiple cores.its used for parallel processing.
do want sap hana training videos what sap hana?
2) how many types data store in sap hana database ?
Ans)Two types Data stores in sap HANA database
Column Store, Row Store
do u want sap hana jobs ?
3) Why the sap hana not required materialized aggregates ?
sap hana database scanning speed of several gigabytes per millisecond,
memory column stores make it possible calculate aggregates on large volumes of data on the fly with high
performance.
This should eliminate the need for aggregates materialized in many cases.
sap hana training videos
4) what is persistence layer in sap hana database?
Persistence Layer : In memory is great but it is volatile and data can be lost with power outage or hardware failures. To avoid this HANA has a Persistence Layer component which makes sure that all the data in memory is also store in a hard drive which is not volatile
how create hierarchy in sap hana database?
5) what is Session Management in sap hana database ?
Ans )component takes care of logon services
6) tell about modeling studio hana database?
Using Modeling Studio you can,
• Specify which tables are stored in HANA, first part is to get the meta data and then schedule data replication jobs
• Manage Data Services to load the data from SAP BW and other 3rd party systems.
• Manage connections to ERP instances, current release does not support connecting to several ERP instances
• Use Data services to for the modeling
• Do modeling in HANA itself (This is independent of Data services).
• You can also do modeling can also be done in Business Objects Universes which is nothing but joining fact and dimensional tables.
7)what is Request Processing and Execution Control in sap hana?·
Ans) SQL Script, MDX statements are passed to calculation models.
1) what is multi-core saphana architecture?
sap hana is Multiple CPU architecture ,one motherboard contains mulitiple cores.its used for parallel processing.
do want sap hana training videos what sap hana?
2) how many types data store in sap hana database ?
Ans)Two types Data stores in sap HANA database
Column Store, Row Store
do u want sap hana jobs ?
3) Why the sap hana not required materialized aggregates ?
sap hana database scanning speed of several gigabytes per millisecond,
memory column stores make it possible calculate aggregates on large volumes of data on the fly with high
performance.
This should eliminate the need for aggregates materialized in many cases.
4) what is persistence layer in sap hana database?
Persistence Layer : In memory is great but it is volatile and data can be lost with power outage or hardware failures. To avoid this HANA has a Persistence Layer component which makes sure that all the data in memory is also store in a hard drive which is not volatile
how create hierarchy in sap hana database?
5) what is Session Management in sap hana database ?
Ans )component takes care of logon services
6) tell about modeling studio hana database?
Using Modeling Studio you can,
• Specify which tables are stored in HANA, first part is to get the meta data and then schedule data replication jobs
• Manage Data Services to load the data from SAP BW and other 3rd party systems.
• Manage connections to ERP instances, current release does not support connecting to several ERP instances
• Use Data services to for the modeling
• Do modeling in HANA itself (This is independent of Data services).
• You can also do modeling can also be done in Business Objects Universes which is nothing but joining fact and dimensional tables.
7)what is Request Processing and Execution Control in sap hana?·
Ans) SQL Script, MDX statements are passed to calculation models.
·
Optimizer which is included in
calculation engine optimizes for better performance.
·
Calculation Engine :
o Modeler
can define data sources as inputs and different operations (aggregation, projection) on top of
them for data manipulation
o The
calculation engine will break up a model into sub processes for optimized
performance on cost based.
o System
will use maximum resources to achieve max through put
·
Planning Engine : Will
be included in next release. Will include planning functions like distribute
and copy functions.