SAP Certified Application Associate - Modeling and Data Acquisition with SAP BW 7.5 on HANA (C-TBW50H-75) Free Practice Test

Question 1

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

A. Environment menu->remove inbound table

B. Environment menu->Selective Deletion

C. Select the request->delete

D. Please choose the correct answer.

E. Environment menu->Delete content

Correct Answer: C

Question 2

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. H Query to read when you navigate or expand hierarchies

B. X Query to read data during navigation

C. A Query to read all data at once

Correct Answer: A

Question 3

Your customer wants to activate SAP HANA-Optimized business content to store historical data Which layer do you use?

A. Virtual data mart layer

B. Corporate memory layer

C. Please choose the correct answer.

D. ODS layer

Correct Answer: A

Question 4

Your customer wants near-real-time reporting and considers either using real-time data acquisition (RDA )or acquiring data in real time using SAP landscape transformation Replication Replication server (SLT) with operational data provisioning (ODP).
What advantages does SLT with ODP have over RDA? There are 2 correct answers to this question.

A. SLT stops the load process when a subscriber is cancelled.

B. SLT allows multiple info providers as subscribe to the same data.

C. SLT uses an RDA-enabled data transfer process to load directly into SAP Business warehouse.

D. SLT uses the persistent storage area (PSA) as a backup

Correct Answer: B,C

Question 5

Your customer requires a query with a formula variables in which objects can you use a formula variable?
There are 2 correct answers to this question.

A. Threshold value in conditions

B. Calculated key figures

C. Formulas in a transformation

D. Restricted key figures

Correct Answer: A,B

Question 6

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 7

You want to fill variables automatically by using the Replacement path more. Which of the following variables types are supported?
There are 3 correct answers to this question.

A. Hierarchy node

B. Text

C. Formula

D. Hierarchy

E. Characteristic value

Correct Answer: B,C,E

Question 8

In the SAP business Warehouse Query Designer in the SAP HANA studio, what can you define using the cell editor? Please choose the correct answer.

A. Additional filters restrictions that apply to a complete column or row of the result set

B. Formulas and selections for cells to override the cell values

C. Help cells that serve as containers for help selections or formulas to display in the query

D. Cell references that can pass their results to variables processed with a replacement path

Correct Answer: B

Question 9

Which object type performs the delta merge check automatically? Please choose the correct answer.

A. Write-optimized Datastore object

B. Standard info cube

C. SAP HANA optimized info cube

D. Persistent staging Area

Correct Answer: D

Welcome to TestSimulate

SAP Certified Application Associate - Modeling and Data Acquisition with SAP BW 7.5 on HANA (C-TBW50H-75) Free Practice Test