SAP C_BW4H_214 Exam Practice Test Instant Access

Question 1

You have an existing field-based data flow that follows the LSA++ concept. To meet a new urgent business requirement for a field you want to leverage a hierarchy of an existing characteristic without changing the transformation. How can you achieve this? Note: There are 2 correct answers to this question.

AAssociate the field with the characteristic in the CompositeProvider

BAdd the characteristic to the DataStore object (advanced)

CAssociate the field with the characteristic In the Open ODS View

DAssign hierarchy properties to the field in the SW Query

Answer : B

Question 2

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 3

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

Question 4

"You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HAN

AReal-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objects are created when using the ''Generate Data Flow'' function in the Open ODS View editor? Note: There are 3 correct answers to this question.'

AData source

BComposite Provider

CTransformation

DData Store object (advanced)

ESAP HANA calculation view.

Answer : A, A, C, D

Question 5

What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA? Note: There are 2 correct answers to this question.

AThere must be no BW analysis authorizations defined thta use any of the cost centers

BThere must be no transaction data referring to the cost centers

CThere must be no hierarchy for the cost centers

DThere must be no BW query that uses cost cenetr as a free characteristics.

Answer : B, C

Question 6

Which disadvantages should you keep in mind when you set the High Cardinality flag for a characteristic? Note: There are 2 correct answers to this question.

AYou cannot use navigation attributes for this characteristic

BYou cannot load more than 2 billion master data records for this characteristic

CSID numbers are created at runtime which might negatively affetct the reporting performance

DYou cannot use this characteristic as a navigation attribute for another characteristic.

Answer : A, C

* A. You cannot use navigation attributes for this characteristic: This is a disadvantage of setting the High Cardinality flag for a characteristic. A characteristic with high cardinality cannot be used as a navigation attribute for another characteristic, and therefore it cannot have navigation attributes itself12.

* C. SID numbers are created at runtime which might negatively affect the reporting performance: This is a disadvantage of setting the High Cardinality flag for a characteristic. A characteristic with high cardinality has no persistent SID values and no SID table, which means that the SID numbers are generated on the fly during query execution. This can have a negative impact on the reporting performance, especially if the characteristic is used in filters or aggregations13.

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

* 2 https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/88a51330c046426091f3730d0c42c0de.html

* 3 https://blogs.sap.com/2019/01/14/high-cardinality-characteristics-in-bw4hana/

Question 7

"You have already loaded data from a non-sap system into SAP Data Wharehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system" What do you need to use to combine data?

ABW SHEL Migration

BBW Remote migration

CSAP ABAP Connection

DSAP BW/4HANA Model Transfer.

Answer : C

* C. SAP ABAP Connection: This is what you need to use to combine data from a non-sap system and an InfoCube of your SAP BW powered by SAP HANA system using SAP Data Warehouse Cloud. You can use an SAP ABAP connection to connect to your SAP BW system and access the InfoCube data as a remote table. You can then join this remote table with the data from the non-sap system that you have already loaded into SAP Data Warehouse Cloud using a graphical view12.

* 1 https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/0c9d6f0a6c4a4b8e8b3f7e5c0a3d6f9d.html

* 2 https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/5c9a6c8b6c4a4b8e8b3f7e5c0a3d6f9d.html

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