SAP Certified Application Associate - Reporting-Modeling and Data Acquisition with SAP BW/4HANA (C-BW4HANA-14) Free Practice Test

Question 1

Users create reports for customers and their sales volumes. Sometimes, they need to drill down to the material level to analyze what exactly customers have bought. With which query layout can you optimize the query performance?

A. Customer and material in the free characteristics

B. Customer and material in the rows with rows hierarchy expanded initially to customer

C. Material in the rows and customer in the free characteristics

D. Customer in the rows and material in the free characteristics

E. Customer and material in the rows

Correct Answer: A

Question 2

Which of the following are true regarding the PSA?

A. PSA tables are created per DataSource and source system.

B. PSA tables store data that has been transformed during extraction from the source system

C. Every data load creates a new request in the PSA table

D. BW queries read detailed data from PSA tables

E. PSA tables are transparent database tables

Correct Answer: A,C,E

Question 3

Which of the following statements are true about InfoProviders?

A. They can only store data from a single source system

B. They can be physical objects or logical views that are relevant for reporting

C. They are objects for which queries can be created or executed

D. They are required if you want to permanently store data and report on it

E. An InfoCube is an InfoProvider that stores data at a detailed level

Correct Answer: B,C,D

Question 4

Which of the following are advantages of separating master data and transactional data?

A. Storage costs are reduced because data is only stored once

B. Harmonization of master data with multiple source systems can be achieved with system- specific master data tables

C. Texts can be stored in multiple languages

D. Time-dependent data can be modeled simply

E. Referential integrity of transaction data can be assured because records without matching master data will not be loaded

Correct Answer: D

Question 5

A characteristic value variable for the characteristic OCALQUARTER that shows the current quarter, will show the same quarter of the last year if you enter an offset of -12.
Determine whether this statement is true or false.

A. False

B. True

Correct Answer: A

Question 6

Calculated columns can be created as calculation views,
attribute views or as an analytic view. Determine Whether
this statement is true or false.

A. False

B. True

Correct Answer: B

Question 7

Which of the following statements describe the advantages of
CompositeProviders over the classic MultiProviders/lnfoSets?

A. CompositeProviders integrate with all the BW lnfoProviders.

B. CompositeProviders provide joins and unions with a single object.

C. Classic MultiProviders have to be recreated as CompositeProviders.

D. CompositeProviders can also include joins to classic MultiProviders.

E. A CompositeProvider can be consumed by another CompositeProvider.

Correct Answer: A,B,E

Question 8

Modelers use the Advanced DataStoreObject for modeling
the persistence of new scenarios in SAP BW HANA.
Determine whether this statement is true or false.

A. False

B. True

Correct Answer: A

Question 9

For which of the following scenarios can conditions be used?
Choose the correct answers.

A. Filter for business partners for which the number of the open order
items is greater than 100.

B. Filter for business partners which contribute to the upper 75 % of
sales revenue.

C. Filter for business partners located in Germany.

D. Filter for business partner numbers beginning with "1".

Correct Answer: D

Question 10

InfoObjects contain the technical and business information
for master data and transaction data within BW. Determine
whether this statement is true or false.

A. False

B. True

Correct Answer: B

Welcome to TestSimulate

SAP Certified Application Associate - Reporting-Modeling and Data Acquisition with SAP BW/4HANA (C-BW4HANA-14) Free Practice Test