HANA Architecture

Question 1

What are the components of Storage Separation in the HANA Column Store

Answer 1

Delta & Main

Question 2

Which of the following processes must be running to view SAP HANA diagnosis files in the SAP HANA

Answer 2

sapstartsrv

Question 3

What is the standard SQL level of isolation in the SAP HANA studio?

Answer 3

Statement Level

Question 4

In SAP HANA database, while creating a column table we can define a null value for a Primary key

Answer 4

False

Question 5

What are the 5 Components of the SAP HANA DB

Answer 5

XS Server, Index Server, Statistics Server, Name Server, Pre-Process Server

*Hint: all servers

Question 6

What kind of partitioning can we use to distribute values

Answer 6

Round Robin & Hash

Question 7

During data merge, data is moved from…

Answer 7

Delta store to main store on storage level

Question 8

Which of the following events occur while the merge operation is running

Answer 8

1. The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage
2. All write operations go to the second delta storage

Question 9

When start-up occurs, how is the sequence of the start-up determined

Answer 9

Run Level

Question 10

Where is the name server running in a multitenant database container system?

Answer 10

SystemDB

Question 11

In a scale out system 1 Master Node, 2 Slave Nodes and 1 Standby Node. How many active Indexservers are there

Answer 11

The master and 2 slave index servers are active - 3

Question 12

You create a column store table with 2 million records and execute a “SELECT *” to load all columns into memory. You notice that the tables size is larger in a memory than the size it occupied on disk before you executed the query. What may be the reason for this

Answer 12

Certain indexes related to the table only exist in memory

Question 13

A customer has a BW system with large daily loading of data into some of their BW tables. Which of the following statements is true in terms of the recommended merge configuration the customer should apply to the target tables

Answer 13

Smart merge will prevent a merge during data loading

Question 14

You execute a transaction followed by a commit that inserts 1,000,000 new records into a column store table on a HANA DB with default values set. 10 minutes later an auto merge happens on the table. Which of the following are true in respect of this sequence of events

Answer 14

1. During the write operation, log entries were written to log buffers in memory
2. During the commit operations, the log entries were flushed to disk synchronously
3. A save point occurred and HANA moved all changed data from memory to the data volume

Question 15

You open a SAP Incident after noticing high memory consumption for allocated memory in the HANA studio following execution of critical reports. SAP Support replies stating there is no concern because used memory is low and the remainder of allocated memory is in the pool. How do you interpret this reply

Answer 15

You understand the pool is just memory allocated from the OS and is not necessarily fully consumed by HANA processes

Question 16

What happens when the global allocation limit is almost met and a big memory request is made that would exceed the limit

Answer 16

1. HANA uploads table partitions and columns from main memory according to a least recently used (LRU) algorithm
2. Out of memory (OOM) dump occurs when HANA is not able to free any chunk of main memory with sufficient size anymore