Quiz

Modeling Views - Quiz

1. Which SAP HANA engine executes Calculation view?
a. SQL Engine
b. OLAP Engine
c. Calc Engine
d. Join Engine

2. In order to get language-specific data, which join is used in SAP HANA?
a. Language join
b. Text Join
c. Referential Join
d. It is not possible to fetch language-specific data in HANA

3. Which of the following statements are true about Variable?
a. Variables are used for filtering
b. Variables are always bound to columns
c. It is always mandatory to pass the value of Variable
d. All of the above

4. What are the different types of Calculation View?
a. Text-Based Calculation
b. Graphical Calculation View
c. OLAP Calculation View
d. Scripted Calculation View

5. Which of the following statements are true about Input Parameter?
a. Input parameters can be used inside the modeling view for implementing business logic.
b. Data type must be defined for the Input Parameters
c. Input parameter of type “Attribute Value” is almost same as Variable.
d. All of the above

6. What are the different types of Variables in HANA?
a. SingleValue
b. Interval
c. Range
d. All of the above

7. Which engine is used to execute Analytic View?
a. SQL Engine
b. OLAP Engine
c. Calc Engine
d. Join Engine

8. Which SQL operator is used to pass Input Parameter?
a. PLACEHOLDER
b. WHERE

9. What are the joins SAP HANA supports?
a. Inner Join
b. Left Outer Join
c. Right Outer Join
d. Full Outer Join
e. Referential Join
f. Text Join
g. All of the above

10. Which SQL operator is used to pass Variable?
a. PLACEHOLDER
b. WHERE

Answer:
1. a
2. b
3. a,b
4. b,d
5. d
6. d
7. b
8. a
9. g
10. b

Click here to go to next chapter. 2.1. Analytic Privileges – Overview and Importance