SAP C_BW4H_211 Exam Practice Test Instant Access

Question 1

"How does SAP position SAP Data Warehouse Cloud in supporting business users?"

ABusiness users can maintain process chains from SAP BW/4HANA dataflows

BBusiness users can create agile models from different sources

CBusiness users can allocate system resources without IT involvement

DBusiness users can generate SQL code that is pushed to SAP BW/4HANA.
SAP Data Warehouse Cloud is a cloud-based data service that enables business users to create agile models from different sources and access data in real time. Business users can use the graphical user interface or the SQL editor to create data models, join data from various sources, and enrich data with business semantics. Business users can also use SAP Analytics Cloud to visualize and analyze data from SAP Data Warehouse Cloud. SAP Data Warehouse Cloud supports business users by providing self-service capabilities, pre-built business content, and flexible consumption options. Reference: 123

Answer : B

Question 2

"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?

ASID values are not stored for InfoObject ADDRESS

BSID values are generated when data for infoObject ADDRESS is loadet

CSID values are generated when InfoObject CITY is activated

DSID values are generated when InfoObject ADDRESS is activated.

Answer : A

Question 3

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 4

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 5

"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 6

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 7

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.
* 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.

Answer : A, C

* 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/

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