Introduction Flashcards
What are the 5 dimensions of requirements businesses typically have?
Broad Deep High speed Real time Simple
From an ABAP’ers view point, what are the two HANA scenarios?
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 is HANA presented
As an appliance, that is, hardware and software
What are the four components of HANA
The HANA database
The HANA client
The HANA studio
HANA XS
What does the HANA database provide
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)
What are the three main HANA lifecycle management tools?
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
HANA studio on Eclipse is more than just an IDE. What other things can be accomplished with it providing the user has authorization
Starting and stopping database services Monitoring the system Specifying system settings Maintaining users and authorizations Configuring the audit log
What is the extension of a CDS file.
.hdbdd
What three add on packages are available as of HANA SP09?
HANA Predictive
HANA Spatial
HANA Advanced Data Processing
SAP provides several tools for data replication. Name 4.
HANA real time replication
HANA Enterprise Information Management
Smart Data Access
Direct Extractor Connection
The book mentions four additional enhancement options. What are they?
HANA Smart Data Streaming
HANA Dynamic tiering
HANA Accelerator for ASE
HANA Data Warehouse Foundation
HANA has special instruction sets at the machine level and therefore can only run on certified hardware. Is the statement true?
Yes
For SAP HANA and BW HANA what are the maximum RAM sizes
For HANA 12tb, for HANA BW its 48tb
What three software optimizations does HANA employ?
Data layout in main memory
Partitioning
Compression
What are the two vectors employed for column store fields?
The dictionary vector (the actual value)
The attribute vector (the integer related to the dictionary vector)
There are 5 choices for attribute vector compressed encoding. What are they?
Prefix encoding Sparse encoding Cluster encoding Indirect encoding Run length encoding
Just fyi, dictionary encoding is not compressed
What are the two types of data partioning?
Row (horizontal)
Column (vertical)
What are four cases where partitioning should be used?
Load distribution
Parallelization
Partition pruning
Explicit partition handling
What three methods of partion assignment/management is used
Hash
Round robin
Range partitioning
What made SAP HANA possible?
Hardware and Software innovations
HANA can process a single request across multiple cores. Is this true?
Yes
A primary goal of HANA is to avoid CPU idle time?
True
All SQL requests will run faster on a column store?
False
What three Eclipse perspectives are available for HANA
Administration Console
Modeler
Open development
For ABAP developers which Eclipse perspective is most used?
The Modeler. It provides access to the views and database procedures that can be consumed by ABAP programs
What is the top level of the Modeler perspective?
System
What five things are needed to add a system in Eclipse for the Modeler perspective
Host name Instance number Description Database user Password
Under which Eclipse node will you find the information models?
Content node
What two view types of the information model are now considered obsolete and no longer should be created?
Attribute and Analytic
SAP HANA studio provides two search types. What are they?
Global (toolbar) and Local (right click on node)
“Full Text Index” can be used for HANA specific secondary indexes?
True
Name the three advantages for an ABAP’er using HANA
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
What are the three steps a programmer should take when innovating processes for HANA
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
The new programming approach has these two goals.
Move calculations to the database
Return only the results set to the program
One way of consuming HANA artifacts is to use native SQL statements?
True, but this should be a last resort as we can now use CDSs and AMDP
What three repository objects are exposed from the database into ABAP?
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
Creating database proxy procedures is always recommended?
No, it is never recommended
As of NW 7.4 SP05, what has replaced external views and Database procedure proxies
CDS now can deploy HANA views from ABAP
AMDP now can deploy Database procedures from ABAP
