Knowledge quiz

It's time to put what you've learned to the test, get 6 right to pass this unit.

Unlike the classic star schema where facts are stored in the fact table, in SAP HANA, multiple views may be used to represent the central fact view in a virtual data model.

Choose the correct answer.

True

False

To create a runtime object from a design time object, you must choose Activate in SAP Web IDE for SAP HANA.

Choose the correct answer.

True

False

Which of the following is required to perform currency conversion in an SAP HANA information model?

There are three correct answers.

An inner join is required between the Open ODS View measures and the exchange rate table.

A set of technical tables are required to store currencies and exchange rate types and rates.

Setting a semantic type to a measure so the amount always includes a currency.

Storing the currency and the exchange rate on the day of the transaction improves performance.

An interface to define how the currency conversion must be processed.

For the SAP BW/4HANA system, you can specify the SAP HANA content package in which the generated external SAP HANA views are located.

Choose the correct answer.

True

False

Which of the following contain the correct terminology about hierarchies?

There are three correct answers.

An entity in a hierarchy is called a node.

Nodes that have no parents are called orphan nodes.

Nodes that have no children nodes are called leaf nodes or leaves.

A relationship between a node and its parent node is called a family tree.

A hierarchy with leaves on different levels is an unbalanced hierarchy.

What are typical examples of Mixed Scenarios?

There are three correct answers.

Data Acquisition in SAP BW/4HANA and applying SQL logic in modeled SAP HANA Views on top of generated SAP HANA Views

Data Acquisition in SAP HANA and applying SAP BW/4HANA logic in CompositeProviders, which contain only SAP HANA Calculation views.

Data Acquisition in SAP BW/4HANA and applying SAP BW/4HANA logic in CompositeProviders, which contain only DataStore Objects (advanced) and InfoObjects.

Data Acquisition in SAP BW/4HANA and SAP HANA and applying SAP BW/4HANA logic in CompositeProviders, which contain only DataStore Objects (advanced) and SAP HANA Calculation views.

In a calculation view with data category Cube at least one measure is required.

Choose the correct answer.

True

False