SAP C_BW4H_211 Exam Practice Test Instant Access

Question 1

You want to add a Source System of type Big Data in SAP BW/4HAN

AWhich adapters can you use to reference the remote source system? Note: There are 2 correct answers to this question.

AIQ (ODBC) adapter

BSAP HANA Adapter

CSpark SQL Adapter

DSAP Vora ODBC adapter

Answer : C, D

Question 2

Which interface do you use to create a BW InfoObjet with access type "SAP HANA view!?

ABW moedling perspective in SAP HANA studio

BSAP HANA modeler perspective in SAP HANA studio

CEmbedded SAP GUI in SAP HANA studio

DSAP Web IDE for SAP HANA

Answer : A

Question 3

Which objetcs can be affected by the key date in a BW query? Note: There are 3 correct answers to this question.

ANavigation attributes

BHierachies

CKey figures

DConditions

EDisplay attributes

Answer : A, B, E

Question 4

What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct Answers to this question.

ACombine Infoprovider using Join and Unions

BJoin two ABAP CDS views

CDefine new restricted key figures

DCreate new calculated fields Integrate

ESAP HANA HDI calculation views.
* A. Combine InfoProviders using Join and Unions: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider is an InfoProvider that combines data from several analytic indexes or from other InfoProviders (by union or inner join or left outer join), and makes this data available for reporting and analysis. Storing the data in BW Accelerator or in an SAP HANA database also ensures faster access to data in the query12.
* C. Define new restricted key figures: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can define new restricted key figures based on the existing key figures of the underlying InfoProviders. Restricted key figures are key figures that are restricted by one or more characteristics13.
* E. Integrate SAP HANA HDI calculation views: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can integrate SAP HANA HDI calculation views as part of its data sources, using a virtual table or an external SAP HANA view. This can enable mixed modeling scenarios that leverage both SAP BW/4HANA and SAP HANA capabilities14.

Answer : A, C, E

* 1 https://help.sap.com/doc/saphelp_scm700_ehp02/7.0.2/en-US/63/f3c416bcbf4730bb86e62ef8a54e17/content.htm

* 2 https://blogs.sap.com/2018/12/14/implementing-mixed-modeling-in-bw4hana-using-composite-provider/

* 3 https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/42/f93a83ae5546d3a7cfd7ff09e25a2b/content.htm

* 4 https://help.sap.com/doc/SAP_BW4HANA_CONTENT/06e872f914a44d77b6c692b0273ca400/20b4b01f5baf46af8fbd439c741adf00.html

Question 5

What are some of advantages of using SAP BW/4HANA business content? Note: There are 2 correct answers to this question.

AAutomatic generation of Analysis Authorizations during SAP BW/4HANA content activation

BAutomatic content activation during installation of SAP BW/4HANA

CAccelerated SAP BW/4HANA implementation using ready-made models

DAbility to combine business content objects with custom-defined objects.
* C. Accelerated SAP BW/4HANA implementation using ready-made models: This is an advantage of using SAP BW/4HANA business content. Business content provides a preconfigured set of application-specific information models based on consistent metadata in SAP BW/4HANA. It can be used without adjustment, be adjusted or enhanced by the customer, or serve as a template to help the customer create his own data models. This can speed up the implementation process and reduce the development effort12.
* D. Ability to combine business content objects with custom-defined objects: This is an advantage of using SAP BW/4HANA business content. Business content objects can be integrated with custom-defined objects using CompositeProviders or other modeling tools. This can enable flexible and agile data modeling and analysis according to the customer's specific needs13.

Answer : C, D

* 1 https://www.sap.com/documents/2020/06/3cbbd4de-9a7d-0010-87a3-c30de2ffd8ff.html

* 2 https://help.sap.com/docs/SAP_BW4HANA_CONTENT/06e872f914a44d77b6c692b0273ca400/20b4b01f5baf46af8fbd439c741adf00.html

* 3 https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/f851415842154e59a5f038e458b97a0b.html

Question 6

Which data deletion options are offered for a standard DataStore object (advanced)? Note: There are 3 correct answers to this question.

ADeletion of all data from active table only

BRequest-based data deletion

CSelective deletion of data

DDeletion of data from all tables

ESelection deletion incluiding data of subsequent targets

Answer : A, B, C

Question 7

You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different atribute values assigned. How do you desing the model?

ACompound characteristic 'COSTOBJ' with the characteristic for Controlling Area

BCompound the characteristic for Controlling Area with the characteristic 'COSTOBJ'

CDefine Controlling Areas as a navigation attribute for the characteristic 'COSTOBJ'

DDefine characteristic 'COSTOBJ' as a navigation attribute for Controlling Area

Answer : B

SAP C_BW4H_211 SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA Exam Practice Test