Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

HANA 400 > Introduction > Flashcards

Introduction Flashcards

1
Q

What are the 5 dimensions of requirements businesses typically have?

A 
Broad
Deep
High speed
Real time
Simple
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How is HANA presented

A

As an appliance, that is, hardware and software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the four components of HANA

A

The HANA database
The HANA client
The HANA studio
HANA XS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does the HANA database provide

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the three main HANA lifecycle management tools?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A 
Starting and stopping database services
Monitoring the system
Specifying system settings
Maintaining users and authorizations
Configuring the audit log
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the extension of a CDS file.

A

.hdbdd

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

HANA Predictive
HANA Spatial
HANA Advanced Data Processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

SAP provides several tools for data replication. Name 4.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

For HANA 12tb, for HANA BW its 48tb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What three software optimizations does HANA employ?

A

Data layout in main memory
Partitioning
Compression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are the two vectors employed for column store fields?

A

The dictionary vector (the actual value)

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A 
Prefix encoding
Sparse encoding
Cluster encoding
Indirect encoding
Run length encoding

Just fyi, dictionary encoding is not compressed

17
Q

What are the two types of data partioning?

A

Row (horizontal)

Column (vertical)

18
Q

What are four cases where partitioning should be used?

A

Load distribution
Parallelization
Partition pruning
Explicit partition handling

19
Q

What three methods of partion assignment/management is used

A

Hash
Round robin
Range partitioning

20
Q

What made SAP HANA possible?

A

Hardware and Software innovations

21
Q

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

A

Yes

22
Q

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

A

True

23
Q

All SQL requests will run faster on a column store?

A

False

24
Q

What three Eclipse perspectives are available for HANA

A

Administration Console
Modeler
Open development

25
Q

For ABAP developers which Eclipse perspective is most used?

A

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

26
Q

What is the top level of the Modeler perspective?

A

System

27
Q

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

A 
Host name
Instance number
Description
Database user
Password
28
Q

Under which Eclipse node will you find the information models?

A

Content node

29
Q

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

A

Attribute and Analytic

30
Q

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

A 
Global (toolbar)
and Local (right click on node)
31
Q

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

A

True

32
Q

Name the three advantages for an ABAP’er using HANA

A

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

33
Q

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

A

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

34
Q

The new programming approach has these two goals.

A

Move calculations to the database

Return only the results set to the program

35
Q

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

A

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

36
Q

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

A

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

37
Q

Creating database proxy procedures is always recommended?

A

No, it is never recommended

38
Q

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

A

CDS now can deploy HANA views from ABAP

AMDP now can deploy Database procedures from ABAP

HANA 400 (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions