Question No. 1

Before you can use a DB connect data flow in SAP Business warehouse (SAP BW), which of the

following tasks must you perform?

AThere are 3 correct answers to this question.

BLoad the RDBMS meta base into a table in SAP BW that the data source can access.

CCreate a Data source on database tables and views with technical names in lowercase letters.

DInstall an SAP-specific Database shared library on the SAP BW application server.

ECreate a Data source on database tables and views with technical names in uppercase letters Install a date base-specific client for the source RDBMS on the SAP BW application server.

Show Answer

Correct Answer: A, C, E

Question No. 2

You want to create a workbook that shows turnover per material group. Materials are organized hierarchically on three levels. Business users want to view the level 3. They also want to be able to aggregate on lower hierarchy levels.

How can they do this?

There are 2 correct answers to this question.

AOpen the hierarchy options of the material from hore bar and deselect the required level in the show levels option.

BOpen the hierarchy options of the material & the ment bar and select the required level in the show levels option.

COpen the context menu of tee in the analysis and expand the hierarchy of the required level.

DOpen the hierarchy options of the material from the ment bar and expand the hierarchy to the required level.

Show Answer

Correct Answer: B, D

Question No. 3

Which sources are available when you create on each ODS view? There are 3 correct answers to this question.

ASAP Business warehouse info sources

BSAP Business warehouse transformations

CVirtual tables using SAP smart data access.

DSAP HANA Procedures

ESQL views of the SAP HANA database

Show Answer

Correct Answer: B, C, E

Question No. 4

You use the query monitor transaction (RSRTI) to investigate the poor performance of a query. Which actions do you perform when you use this transaction? There are 3 correct answers to this question.

ADebug the query

BMaintain the read mode and the cache mode of the query.

CExecute the query without using the cache

DMaintain the technical info of the query.

EChange the query definition

Show Answer

Correct Answer: A, B, C

Question No. 5

What do Database connect, universal date connect, and the SAP business warehouse service API

have in common?

Please choose the correct answer.

AThe Data source must be created directly in SAP Business warehouse.

BUsing the persistent staging Area is mandatory

CThe delta queue exists

DThe direct access is available

Show Answer

Correct Answer: B

Free SAP C_TBW50H_75 Exam Actual Questions

The questions for C_TBW50H_75 were last updated On Nov 22, 2024