Knowledge quiz

It’s time to put what you’ve learned to the test, get 7 questions right to pass this unit.

Choose the correct answer.

To aggregate measures by one or more attributes

To combine dimensions with a cube to form a star schema

To generate a view of master data from one or more tables

Choose the correct answer.

SAP Business Application Studio

SAP HANA Cloud Cockpit

SAP HANA Database Explorer

Choose the correct answer.

When you want to hide a column that is used in a calculation but is not required to display in a report.

When you do not want to expose a sensitive column to a consuming calculation view.

To ensure they can only be displayed along with other attributes and not used for drill-down navigation of filtering.

When you want to hide some of a calculation view data based on attribute values.

Choose the correct answer.

To define a calculation view that is valid for a specific period of time

To automatically generate time-related attributes from a base date

To generate historical views of master data

There are two correct answers.

They calculate live data on-the-fly

They can be defined using any database language

They adapt automatically to the requesting query

There are four correct answers.

Calculation views

Flat files

Virtual tables

Column tables

Row tables

Choose the correct answer.

Star Join

Projection

Aggregation

Choose the correct answer.

To aggregate measures without the need for dimensions

To project master data into a harmonized view

To develop a star schema for ad-hoc analysis