ADSO

ADSO

1 / 15

In SAP BW HANA, ADSOs are used for which of the following purpose ?

Data Modelling

Data Storage

Data Consolidation

None of the Above

2 / 15

What is the purpose of Change Log Table in ADSO ?

To copy the inboud table data to active data table

To load the data at the beginning

To trace the single record history using 0RECORDMODE

All of the Above

3 / 15

What are the views created at the background with ADSO Tables ?

Views for external access

Views for reporting

Views for Analysis

All of the above

4 / 15

In which modelling property for standard ADSO, the load request is not taken into consideration for the data source ?

Write Change Log

Snapshot Support

Unique Data Records

Inbound Queue Only

5 / 15

ADSO is present in which layer of SAP BW4HANA ?

Presentation Layer

Data Acquisition Layer

Persistence Layer

Transformation Layer

6 / 15

With which ADSO, the data is loaded directly to the ADSO without going through the traditional ETL Process ?

Data Mart ADSO

Write Change Log ADSO

Direct Update ADSO

Standard ADSO

7 / 15

Which two tables are generated when you choose to design inventory enabled ADSO ?

Reference Point Table

Time Dependent Table

Validity Table

Compound Table

8 / 15

Which of the one points are correct for direct update ADSO ?

It does not require deparate activation step

Suitable for scenerios where quick data access is required

Suitable for scenerios where only changed records are required

Data load directly without going through traditionsl ETL Process

9 / 15

In which ADSO, the aggregation functionality took place ?

Standard ADSO

Data Mart ADSO

Inbound ADSO

Planning Enabled ADSO

10 / 15

The data aggregation & active data table are decided by what, in inbound ADSO?

By Aggregation

By Indexes

By Semantic Keys

None of these

11 / 15

How is data usually loaded in an ADSO ?

Using batch processing

Using Parallel processing

Using ETL Process

All of the above

12 / 15

What is the job of data propogation layer in an ADSO ?

to activate the data for reporting

to distribute the data to different systems

to store the raw data

to make data available for reporting

13 / 15

To load large volume of historical data in ADSO, which approach to follow ?

Delta Loading

Parallel processing

batch processing with parallelization

real time loading

14 / 15

What is the purpose of Hybrid ADSO ?

Storing only master data

designing real time reporting

combining data from different source type

none of the above

15 / 15

Which property in ADSO lead to auto save of delta in change log ?

write change log

inbound queue only

planning enabled

inventory enabled

Your score is

The average score is 47%

ADSO

Features

Learn More

Support