Knowledge quiz

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

To model the tracking history scenarios of historical truth and current truth, two different star schemas are required.

Choose the correct answer.

True

False

In the SAP BW/4HANA data model, master data is stored separately in attribute, text, and hierarchy tables that are linked together using the surrogate ID (SID).

Choose the correct answer.

True

False

As long as the InfoObject contains data, it's not possible to remove compounded fields.

Choose the correct answer.

True

False

You use Customer and Booking Date as characteristics together with the key figure Amount in a DataStore Object (advanced). The customer has a time-dependent attribute Customer Class, which is not part of this model. What can you do to see the historical truth in a report that shows Customer, Customer Class, Booking Date, and Amount?

There are two correct answers.

You do not need to change anything: the historical truth is shown.

Add Customer Class as a navigation attribute of Customer.

Remodel the DataStore Object (advanced) and add a characteristic Customer Class in the DataStore Object (advanced) model. Fill the new column with a lookup from the InfoObject Customer, based on Booking Date.

Create a CompositeProvider with a temporal join for characteristic Customer, with reference to Booking Date. Make sure that Customer Class is added to the target structure.

You have created a reference characteristic 0SOLD_TO based on referenced characteristic 0BPARTNER. You can change the description of reference characteristic 0SOLD_TO.

Choose the correct answer.

True

False

Time-dependent and time-independent attributes are stored in the same X table which uses Date From and Date To as key fields.

Choose the correct answer.

True

False

Why would you recommend a separation of master data and transactional data?

There are two correct answers.

No joins are needed for reporting.

This usually reduces the size of the physical storage.

You improve consistency in the enterprise data warehouse.

This is a prerequisite for currency conversion.

Which of the following statements regarding internal and external hierarchies are true?

There are three correct answers.

Internal hierarchies have no link to master data tables.

Internal hierarchies are used to display characteristics without using an external hierarchy.

External hierarchies are defined in BW Modeling Tools on the Hierarchy tab of a Query.

External hierarchies are stored in SAP BW/4HANA master data tables.