Data Optimization in SAP BW HANA

1 / 10

Which one is a regular system maintenance activity ?

Job Scheduling

Data Loading

Index Rebuilding

None of the Above

2 / 10

Why Analytic indexes are required ?

To save storage by represting data in the compressed form

To improve performance of large composite providers only

To partition the data on the basis of time characterstics

It helps in pre-aggregating & storing results & improve the performance of complex queries

3 / 10

What is the purpose of partition pruning ?

To load data in parallel for ADSOs and Multiproviders

It reduce the amount of data processed during the query execution by selectively choosing the relevant partitions.

To aggregate key figures by summing them up

None of the above

4 / 10

Which point is correct about Indexing ?

A data structure called index is being created.

There are two type of indexes, bitmap & balanced tree index.

Bitmap is suitable for high cardinality columns

Bitmap is suitable for low cardinality columns

5 / 10

Which data optimization technique is used to speed up the retrieval of rows from a column ?

Aggregation

Compression

Data Tiering

Indexing

6 / 10

On what basis, the partitioning is done in SAP BW for data optimization ?

On the basis of columns

On the basis of tables (large datasets are divided into smaller sets)

On the basis of rows

All of the above

7 / 10

What all type of partitioning are available in SAP BW HANA ?

List Partitioning

Round Robin Partitioning

Range Partitioning

Hash Partitioning

8 / 10

What pointers are correct for parallelization optimization techniques ?

It distributes the workload across multiple processes

Reduces overall processing time

Decreases the speed of data loading process

Increases the size of data packages in DTP

9 / 10

What is wrong about aggregation technique ?

It summarize data at higher level of granularity

Aggregation includes summation, Average, Min/Max

Count() is one of the most common used aggregate

All of the above

10 / 10

How the storage space is saved in compression technique ?

By parallel processing of data loads

By representing data in the compressed form

Both A and B

None of the these

Your score is

The average score is 51%

Data Optimization in SAP BW HANA

Data Optimization in SAP BW HANA

Features

Learn More

Support