SAP C_BW4H_214 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.

Answer : B

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

Question 2

Which join types can you use in a CompositeProvider? Note: There are 3 correct answers to this question.

AFull outer join

BReferential join

CHierarchy join

DText join

EInner join

Answer : A, B, E

Question 3

InfoObject CITY is defined as a display attribute for InfoObject CUSTOMER, and InfoObject COUNTRY is defined as a display attribute for InfoObject CITY. In a master data report you want to display the COUNTRY of a CUSTOMER. Which options do you have to realize the scenario? Note: There are 3 correct answer to this question."

ACombine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.

BGenerate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.

CCombine CUSTOMER, CITY and COUNTRY in a Composite Provider using a sequence of left outer join operators.

DInclude CUSTOMER to rows in the BW Query on CUSTOMER and activate the Universal Display Hierarchy setting.

EAdd COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.

Answer : A, B, E

Question 4

You use InfoObject B as a display attribute for InfoObject

AWhich object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A? Note: There are 3 correct nswers to this question.'

AHigh Cardinality is set in InfoObject B

BAttribute Only is set in InfoObject B

CData Type 'Character String' is set in InfoObject A

DConversion Routine 'ALPHA' is set in InfoObject A

EInfoObject B is defined as a Key Figure.

Answer : A, A, B, D

* A. High Cardinality is set in InfoObject B: This is an object property that prevents you from changing InfoObject B into a navigational attribute for InfoObject A. A characteristic with high cardinality cannot be used as a navigation attribute for another characteristic, and therefore it cannot have navigation attributes itself12.

* B. Attribute Only is set in InfoObject B: This is an object property that prevents you from changing InfoObject B into a navigational attribute for InfoObject A. A characteristic that is marked as an exclusive attribute can only be used as a display attribute for another characteristic, but not as a navigational attribute. In addition, the characteristic cannot be transferred into InfoCubes34.

* D. Conversion Routine ''ALPHA'' is set in InfoObject A: This is an object property that prevents you from changing InfoObject B into a navigational attribute for InfoObject A. A characteristic that has a conversion routine cannot have navigational attributes, because the conversion routine would have to be applied to the navigational attributes as well, which is not possible5 .

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

* 2 https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/f8/51415842154e59a5f038e458b97a0b/content.htm

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

* 4 https://answers.sap.com/questions/1149854/difference-display-attribute-and-navigational-attr.html

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

* https://answers.sap.com/questions/10121838/infoobjects-attributes.html

Question 5

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 6

Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this

question.

AInfoSource

BOpen Hub Destination

CDataStore Objetc (advanced)

DCompositeProvider

ESAP HANA Analysis Process

Answer : C, D, E

Question 7

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.

AABR

BADD

CAIM

DAIE

Answer : B, D

* B. ADD: This delta method indicates that the DataSource provides consistent information for this target. It means that the DataSource delivers additive delta records with after images, which are updated directly in the delta queue. This can support sum aggregation for key figures12.

* D. AIE: This delta method indicates that the DataSource provides consistent information for this target. It means that the DataSource delivers additive delta records with after images, which are updated in the extraction queue and then transferred to the delta queue. This can support sum aggregation for key figures13.

* 1 https://wiki.scn.sap.com/wiki/display/BI/Delta+type+in+BW+Extractors

* 2 https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/4f/18f6aa3fca410ae10000000a42189d/content.htm

* 3 https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/4f/18f6b13fca410ae10000000a42189d/content.htm

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