SAP HANA 300 301 100 Flashcards
1
Q
RANK
A
1
2
Q
MultiStore Table
A
A table that distributes acoss memory Tiers and extended storage tiers.
3
Q
HOT, WARM, COLD
A
HOT- DRAM, PMEM.
WARM- NATIVE STORAGE,EXTENSION NODE SOLUTION, DYNAMIC TIERING
4
Q
PAL NEEDS FOLLOWING
A
AFL
5
Q
GRAPH +TEXT
A
1
6
Q
RENAME A FIELD
A
DATA LENEAGE
7
Q
Temporal Join
A
- Inner Join Only
- Only Supported in Star Join.
- Need like Time Stamp , Date , Integer.
8
Q
Non Equi Join
A
- > 2.0 SP3.
- Inner , Left Outer, Right Outer, Full Outer.
Less then Greater then.
9
Q
Optimize Join Col
A
- Join Type-Ref, Outer,Text
- Only Col from A are requested
- Join Col from B are not requested.
- B Cardanility is :1
10
Q
Union
A
Empty Union Behaviour
Row with constant
11
Q
Procedures
A
R
SQL
12
Q
Procedures vs Functions
A
Scalar function can be in Select, but not in procedures.
13
Q
Join Pruning
A
Prequsite
- Join Type - Outer, ref or text.
- Join Cardanility :1
- Only Col A are requested.
14
Q
Cache
A
Prequsite
- Cache is selected
- View can be Unfolded.
- No Granulity Tracking
- Hint is selected.
Can be only used when Analytical Privileges are used.
15
Q
Parallezation
A
Table or (Synonym External Table)
