HANA Modeling

Question 1

When you activate design-time artefacts in the SAP HANA Repository it becomes a runtime objectin

Answer 1

SAP HANA Catalog

Question 2

The database persitence model defines which artefacts

Answer 2

Schema,
Views,
Tables

Question 3

When implementing the data persitence model in XS classic you can use

Answer 3

Core Data Services (CDS) syntax

HDBtable syntax

Question 4

True or False: A CDS document resides in the Repository and can be transported to other systems in a Delivery Unit

Answer 4

True

Question 5

As of SP11 Attribute views have been deprecated and replaced with

Answer 5

Graphical Calculation Views of type DIMENSION

Question 6

True or False, SAP HANA reports directly on physical tables and persists the results also known as materilization

Answer 6

False

Question 7

In Data Modeling terms, Facts are also known as

Answer 7

Metrics, Measures, Key figures

Question 8

The business reuirements is to model a long complex join path with only Attributes/Master Data. Choose the type of Calculation View to use

Answer 8

Calculation View with type DIMENSION

Question 9

A Union node allows the data modeller to

Answer 9

Combine data from two or more data sources

Question 10

Input parameters can be used

Answer 10

To filter data

Within expressions of calculated columns

Question 11

Input and output parameters are not optional with procedures

Answer 11

True

Question 12

Analytical Privileges are designed to

Answer 12

Restrict users access to different portions of the data from the same Information View