Introduction

Question 1

What are the 5 dimensions of requirements businesses typically have?

Answer 1

Broad
Deep
High speed
Real time
Simple

Question 2

From an ABAP’ers view point, what are the two HANA scenarios?

Answer 2

Scenarios in which the HANA DB functions as the DB for AS ABAP
Scenarios based on a stand alone HANA server (HANA as an accelerator)

Question 3

How is HANA presented

Answer 3

As an appliance, that is, hardware and software

Question 4

What are the four components of HANA

Answer 4

The HANA database
The HANA client
The HANA studio
HANA XS

Question 5

What does the HANA database provide

Answer 5

Support for SQL-92 and extension set SQL-99
Provides services for back up and recovery
Insures consistency thru ACID compliance (atomic, consistent, isolated, durable)

Question 6

What are the three main HANA lifecycle management tools?

Answer 6

HANA Lifecycle Manager Tool - used for adapting the HANA system
HANA Application LifeCycle manager - used to install or modify native HANA applications
SAP Host Agent - used to monitor individual hosts

Question 7

HANA studio on Eclipse is more than just an IDE. What other things can be accomplished with it providing the user has authorization

Answer 7

Starting and stopping database services
Monitoring the system
Specifying system settings
Maintaining users and authorizations
Configuring the audit log

Question 8

What is the extension of a CDS file.

Answer 8

.hdbdd

Question 9

What three add on packages are available as of HANA SP09?

Answer 9

HANA Predictive
HANA Spatial
HANA Advanced Data Processing

Question 10

SAP provides several tools for data replication. Name 4.

Answer 10

HANA real time replication
HANA Enterprise Information Management
Smart Data Access
Direct Extractor Connection

Question 11

The book mentions four additional enhancement options. What are they?

Answer 11

HANA Smart Data Streaming
HANA Dynamic tiering
HANA Accelerator for ASE
HANA Data Warehouse Foundation

Question 12

HANA has special instruction sets at the machine level and therefore can only run on certified hardware. Is the statement true?

Answer 12

Yes

Question 13

For SAP HANA and BW HANA what are the maximum RAM sizes

Answer 13

For HANA 12tb, for HANA BW its 48tb

Question 14

What three software optimizations does HANA employ?

Answer 14

Data layout in main memory
Partitioning
Compression

Question 15

What are the two vectors employed for column store fields?

Answer 15

The dictionary vector (the actual value)

The attribute vector (the integer related to the dictionary vector)

Question 16

There are 5 choices for attribute vector compressed encoding. What are they?

Answer 16

Prefix encoding
Sparse encoding
Cluster encoding
Indirect encoding
Run length encoding

Just fyi, dictionary encoding is not compressed

Question 17

What are the two types of data partioning?

Answer 17

Row (horizontal)

Column (vertical)

Question 18

What are four cases where partitioning should be used?

Answer 18

Load distribution
Parallelization
Partition pruning
Explicit partition handling

Question 19

What three methods of partion assignment/management is used

Answer 19

Hash
Round robin
Range partitioning

Question 20

What made SAP HANA possible?

Answer 20

Hardware and Software innovations

Question 21

HANA can process a single request across multiple cores. Is this true?

Answer 21

Yes

Question 22

A primary goal of HANA is to avoid CPU idle time?

Answer 22

True

Question 23

All SQL requests will run faster on a column store?

Answer 23

False

Question 24

What three Eclipse perspectives are available for HANA

Answer 24

Administration Console
Modeler
Open development

Question 25

For ABAP developers which Eclipse perspective is most used?

Answer 25

The Modeler. It provides access to the views and database procedures that can be consumed by ABAP programs

Question 26

What is the top level of the Modeler perspective?

Answer 26

System

Question 27

What five things are needed to add a system in Eclipse for the Modeler perspective

Answer 27

``` Host name Instance number Description Database user Password ```

Question 28

Under which Eclipse node will you find the information models?

Answer 28

Content node

Question 29

What two view types of the information model are now considered obsolete and no longer should be created?

Answer 29

Attribute and Analytic

Question 30

SAP HANA studio provides two search types. What are they?

Answer 30

``` Global (toolbar) and Local (right click on node) ```

Question 31

"Full Text Index" can be used for HANA specific secondary indexes?

Answer 31

True

Question 32

Name the three advantages for an ABAP'er using HANA

Answer 32

Accelerate- Create faster programs Extend - Move programs that before needed to be run in the background back to the foreground Innovate - Create new processes that could not have been created in the past

Question 33

What are the three steps a programmer should take when innovating processes for HANA

Answer 33

Detect - Look for places in existing code to employ HANA advantages. Look at current performance. Analyze and prioritize Optimize - Use HANA capabilities to improve existing processes Innovate - See new possibilities

Question 34

The new programming approach has these two goals.

Answer 34

Move calculations to the database | Return only the results set to the program

Question 35

One way of consuming HANA artifacts is to use native SQL statements?

Answer 35

True, but this should be a last resort as we can now use CDSs and AMDP

Question 36

What three repository objects are exposed from the database into ABAP?

Answer 36

HANA views are exposed as external views Stored procedures are exposed as Database procedure proxies Delivery units are exposed as HANA transport containers These are as of NW 7.4 SP02

Question 37

Creating database proxy procedures is always recommended?

Answer 37

No, it is never recommended

Question 38

As of NW 7.4 SP05, what has replaced external views and Database procedure proxies

Answer 38

CDS now can deploy HANA views from ABAP | AMDP now can deploy Database procedures from ABAP