SAP Certified Application Associate - Modeling and Data Acquisition with SAP BW 7.5 on HANA

QUESTION NO: 1
What are the efforts if you open and the BEx Query Designer query in the SAP Business warehouse query Designer in the SAP HANA Studio? There are 2 correct answers to this question.

A. You CANNOT reopen the query in BEx query Designer B. you can expect the same result in query exception C. You can edit the query after migration. D. you can edit the query without migration

Correct Answer: B,D

QUESTION NO: 2
You create an advanced DataStore object (DSO) and select the standard DSO template. Which of the following settings are applied automatically? There are 2 correct answers to this question.

A. Activate data B. Write change log C. Unique data records D. All characteristics are key

Correct Answer: A,B

QUESTION NO: 3
Which infoprovider do you use for SAP Business waclonse7.s Powered by SAP HANA to replace the multi providers for reporting? Please choose the correct answer.

A. Info object as info provider B. Virtual provider C. Advanced Data store object D. Composite provider

Correct Answer: D

QUESTION NO: 4
Which sources are available for a generic SAP Business Warehouse DataSource? There are 3 correct answers to this question.

A. SAP HANA remote source table B. Function module C. SAP query (InfoSet) D. DB view or table E. SAP HANA information view

Correct Answer: C,D,E

QUESTION NO: 5
Besides Datasource objects and advanced Datastore objects, which other objects are required to create a transaction data flow for loading an advanced Datastore objects? Please choose the correct answer.

A. Infopackage.transformation B. Data flow objects.transformation. C. Data transfer process.transformation D. Info source.Data flow objects

Correct Answer: C

QUESTION NO: 6
You run a query containing many free characteristics and some external hierarchies should be as fast as possible. Which of the following read modes do you choose? Please choose the correct answer.

A. A Query to read all data at once B. X Query to read data during navigation C. H Query to read when you navigate or expand hierarchies

Correct Answer: C

QUESTION NO: 7
Which of the following statements are true regarding the differences between compounding and concatenation?
There are 4 correct answers to this question.

A. Concatenation uses a single key value but compounding uses more than one B. Compounding is easier for users to understanding because it is based on a 1:1 object mapping but concatenation is more complex for users to understand and decipher C. Adding key fields in concatenation is easier because only the transformation needs to be changed but in compounding structres need to be changed and date re-loaded D. Concatenation is supported in the definition of the InfoObject whereas compoubding is only relevant for transectional data. E. Compounding is easier to filter in queries because the objects are seperate whereas with concatenation, the key string needs to be marked

Correct Answer: A,B,C,E

QUESTION NO: 8
You need to delete data for a company code from an advanced Datastorg ghieet where do you do this?

A. Environment menu->Selective Deletion B. Environment menu->Delete content C. Select the request->delete D. Environment menu->remove inbound table E. Please choose the correct answer.

Correct Answer: C

QUESTION NO: 9
What can you define in the BEx Query Designer cell editior? There are 3 correct answers to this question.

A. Formulas and selection conditions for cells to solve formula collision. B. Additional filter restrictions that apply to a complete column or row of the result set. C. Help cells thet serve as containers for help selections or help formulas. D. Variables with the replacement path option to pass values to reference cells.

Correct Answer: A,C,D

SAP Certified Application Associate - Modeling and Data Acquisition with SAP BW 7.5 on HANA - C-TBW50H-75 Exam Questions