Quiz

SAP HANA Modeling Quiz

1. Can we change the table type from COLUMN to ROW in SAP HANA?
a. Yes
b. No

2.What are the types of modeling views in HANA?
a. Attribute View
b. Analytic View
c. Calculation View
d. Schema View

3. Which of the below statements are true?
a. Attributes are Non-measurable, Descriptive data
b. Measures are quantifiable data, which can be measured.
c. Measures are always numeric values.
d. Examples of Attributes are Country, Product, Customer etc.

4. Which of the following are types of calculation view?
a. Multidimensional
b. Scripted
c. Graphical
d. Reading

5.Which components can be a part of a calculation view?
a. Tables
b. BAPIs
c. Attribute View
d. Analytic View

6. Can we include Attribute views in Analytic view definition?
a. Yes
b. No

7. While creating a Graphical Calculation view, what are the options available in Tools palette?
a. Union
b. Join
c. Projection
d. Aggregation
e. All of the above

8. Is it mandatory to specify measures in Analytic view?
a. Yes
b. No

9. Which SAP HANA engine executes Calculation view?
a. SQL Engine
b. OLAP Engine
c. Calculation Engine
d. JOIN Engine

10. Graphical calculation views can letter be converted to Scripted calculation view if required.
a. Yes
b. No

11.Which of the following can be part of an analytic view?
a. Query transformation
b. Unions
c. Logical joins
d. Data foundation
e. Attributes

12. Attribute View types are
a. Standard
b. Time
c. Derived
d. All of the above

13. HANA modeling views can be created under
a. Schema
b. Catalog
c. Content
d. File System

Answer:
1. a
2. a,b,c
3. a,b,c,d
4. b,c,d
5. a,c
6. a
7. d
8. a
9. a,c
10.b
11. c,d,e
12. d
13. c

Click here to go to Next Chapter.  4.14 Exercise