Learn, Practice, and Improve with SAP C_BW4H_211 Practice Test Questions

You create a transformation from a DataSource to a DataMart Data Store object (advanced) All key figures are updated as Sum. Which Delta methods indicate that the DataSource provides consistent information for this target? Note: There are 2 correct answers to this question.

A. ABR

B. ADD

C. AIM

D. AIE

You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question.

A. Create restricted columns

B. Provide default time characteristics

C. Persist transactional data

D. Combine master data and transactional data

E. Aggregate measures as a sum

Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question

A. Use fewer drill-down characteristics in the initial view

B. Use characteristic filters that overlap

C. Use exclude functions in the restricted key figures

D. Use mandatory characteristic value variables

E. Use include functions in the restricted key figures.

"For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the high Cardinality flag." What is the effect on SID values in this scenario?

A. SID values are not stored for InfoObject ADDRESS

B. SID values are generated when data for infoObject ADDRESS is loadet

C. SID values are generated when InfoObject CITY is activated

D. SID values are generated when InfoObject ADDRESS is activated.

What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.

A. By using a transformation and data transfer process

B. By entering the values manually

C. By referencing a table

D. By using a query

E. By accessing an SAP HANA Calculation View of data category Dimension

How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question.

A. By setting a specific flag in the data transfer process

B. By using a specific process type in a process chain

C. By setting a specific flag in the transformation

D. By using the SAP BW/4HANA data load monitor.

You create a DataStore Object(advanced) using the Data Mart DataStore Object modeling property. Which behaviors are specific to this modelling property? Note: There are 2 correct answers to this question.

A. The change log table will be filled only after data activation

B. Reporting is done based on a union of the inbound and active tables

C. Query result are shown only when data has been activated

D. The records are treated as if all characteristics are in the key.