SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA (C_BW4H_214) Free Practice Test

Question 1

What are some of the variable types n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.

A. Charateristic value

B. Hierarchy node

C. Text

D. Formula

Correct Answer: A,B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

What are benefits of using an InfoSource in a data flow? Note: There are 2 correct answers to this question.

A. Reducing the numer of transformations for scenarios with many sources and targets

B. Connecting sequetial trnsformartions in the data flow without storing the data again

C. Reducing the numer od data transfer processes (DTP)

D. Storing the extraction delta information of the data source file

Correct Answer: C,D

Question 3

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

A. Navigation attributes

B. Conditions

C. Hierachies

D. Key figures

E. Display attributes

Correct Answer: A,C,E

Question 4

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

A. Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.

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

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

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

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

Correct Answer: 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.

A. There must be no hierarchy for the cost centers

B. There must be no BW analysis authorizations defined thta use any of the cost centers

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

D. There must be no transaction data referring to the cost centers

Correct Answer: A,D

Question 6

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

A. Business users can generate SQL code that is pushed to SAP BW/4HANA.

B. Business users can create agile models from different sources

C. Business users can maintain process chains from SAP BW/4HANA dataflows

D. Business users can allocate system resources without IT involvement

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

"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 generated when InfoObject CITY is activated

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

C. SID values are not stored for InfoObject ADDRESS

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

Correct Answer: C

Question 8

In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question.

A. Call an ABAP function module

B. Split datasets

C. Execute a stored procedure

D. Combine datasets

E. Execute an SAP HANA analysis process

Correct Answer: B,C,D

Question 9

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

A. BW SHEL Migration

B. BW Remote migration

C. SAP BW/4HANA Model Transfer.

D. SAP ABAP Connection

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA (C_BW4H_214) Free Practice Test