Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse layer. What action do you take?

A. Reduce the number of persistent InfoProviders.

B. Apply the SAP Business Warehouse workspace layer

C. Migrate all SAP Business Warehouse objects to SAP HANA optimized objects

D. Apply the Open ODS layer.

Navigational attributes behave in a query like which of the following?

A. Attributes

B. Variables

C. Characteristics D. Filters

E. None of above

Why are DataStore Objects so important? Choose the correct answer(s).

A. They can overwrite data.

B. They store detailed data leaving Infocubes to store aggregated data.

C. They allow for raw uncleansed data to be stored for 3 months.

D. They easily integrate in the data flow.

The concept of storage separation in SAP HANA means that delta data is stored on disk to minimize the demand on main memory. Determine whether this statement is true or false.

A. True

B. False

Which of the following statements are true regarding the difference between compounding and concatenation?

A. Compounding is easier to filter in queries because the objects are separate whereas with concatenation, the key string needs to be masked

B. Compounding is easier for users to understand because it is based on a 1:1 object mapping but concatenation is more complex for users to understand and decipher

C. Concatenation uses a single key value but compounding uses more than one

D. Adding key fields in concatenation is easier because only the transformation needs to be changed but in compounding structures need to be changed and data re-loaded

E. Compounding is supported in the definition of the lnfoObject whereas concatenation requires the creation of new database tables

Which of the following are ways in which joins can be made using SAP BW on SAP HANA?

A. A BW lnfoSet can be used to create a temporal join

B. A native SAP HANA calculation view can perform inner and outerjoins

C. An Advanced DSO can create joins between master data and transaction data

D. BW Composite Provider can provide inner and outer joins

E. Transformations can perform joins of multiple DataSources

Which of the following are the correct terminology about hierarchies? Choose the correct answers.

A. An entity in a hierarchy is called a node

B. Nodes that have no parents are called orphan nodes

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

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

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

In the SAP BW data model, master data is stored separately in attribute, text and hierarchy tables that are linked together using surrogate ID (SID). Determine Whether this statement is true or false.

A. True

B. False

Which of the following statements describe the advantages of CompositeProviders over the classic MultiProviders/lnfoSets?

A. CompositeProviders provide joins and unions with a single object.

B. CompositeProviders can also include joins to classic MultiProviders.

C. CompositeProviders integrate with all the BW lnfoProviders.

D. A CompositeProvider can be consumed by another CompositeProvider.

E. Classic MultiProviders have to be recreated as CompositeProviders.

When used for planning, Real Time InfoCubes contain a single table and Advanced Data Store Objects comprise two tables for storing compressed and uncompressed data. Determine Whether this statement is true or false.

A. True

B. False