SAP Certified Application Specialist - SAP BW/4HANA 2.0 Delta

Question 1

Which of the following are advantages of column tables?

A. Elimination of materialized aggregates

B. Higher data compression rates

C. Elimination of parallel execution

D. Elimination of additional indexe

Correct Answer: A,B,D

Question 2

which source types can you use for a generic Datasource? There are 2 correct answers to this question.

A. SAP HANA Calculation view

B. DB View or table

C. Core data service view

D. Function module

Correct Answer: A,B

Question 3

Where should queries be modeled when the ADSO is partitioned semantically?

A. Queries should be modeled based on the CompositeProvider on top of the semantic group.

B. Queries should be modeled based on the Open ODS view.

C. Queries should be modeled based on the individualDataStore objects (advanced).

D. Queries should be modeled based on A-tables in an SAP HANA calculation view.

Correct Answer: A

Question 4

WHICH objects of an SAP HANA calculation view of DIMENSION data category can you re-use if you define an SAP Calculation view of CUBE data category with star join? there are 2 correct answers to this question.

A. Measure assignment

B. hierarchy assignment

C. Aggregation method

D. attribute assignment

Correct Answer: A,D

Question 5

Whatmust you do to define an inventory infoprovider in SAP BW/4HANA? there are 3 correct answers to this question.

A. Select the Inventory model property.

B. Select the Unique Data Records model property.

C. Select the All characteristics are key model property.

D. Assign at least one cumulative key figure

E. Assign at least one-cumulative key figure

Correct Answer: A,C,D

Question 6

what can you do when you use process chains? There are 2 correct answers to this question.

A. Trigger delta merge.

B. Activate requests in DataStore objects (advanced).

C. Activate data transfer processes(DTPs).

D. Generate transformations.

Correct Answer: A,B

Question 7

You need to determinethe number of customers in each country that have revenue in 2018. What is the reference info object in an exception aggregation? Please choose the correct answer.

A. Year

B. Counter

C. Customer

D. Country

Correct Answer: C

Question 8

You create a transformation from aDataSource to a standard DataStore object.
The DataSource provides an after-image delta. Which key figure aggregation type do you select?

A. Maximum

B. Minimum

C. Overwrite

D. Summation

Correct Answer: C

Question 9

Which of the following objects are supported in SAP BW/4HANA?
Note: There are 2 correct answers to this question.

A. CompositeProvider

B. InfoSet

C. InfoCube

D. MultiProvider

E. DataStore object (advanced)

Correct Answer: A,E

Question 10

in which sequence does SAP recommend collecting the information for the data model design concept? Please choose the correct answer.

A. Transformations .reporting requirements .sources of data .storage requirements

B. reporting requirements .sources of data .Transformations .storage requirements

C. storage requirements .Transformations .sources of data .reporting requirements

D. Transformations .sources of data .reporting requirements .storage requirements

Correct Answer: B

Question 11

What key functionality does SAP Data Hubinclude?
Note: There are 2 correct answers to this question.

A. Data pipelines across data lakes.

B. Orchestration of complex processes and workflows across system boundaries.

C. State-of-the-art deep learning algorithms for data scientists.

D. New ETL tools for building a data warehouse solution

Correct Answer: A,B

Question 12

Which properties determine the delta process within the operational Data provisioning(ODP)delta management for Datasources?
There are 2 correct answers to this question.

A. Recors type

B. Paralleization

C. Record mode

D. Delta type

E. Serialization

Correct Answer: C,E

SAP Certified Application Specialist - SAP BW/4HANA 2.0 Delta - E-BW4HANA200 Exam Practice Test

Latest Update

Useful Links

Contact Us