C-BW4H-214 by SAP Valid Free Exam Practice Test

Question 1

Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use? Note: There are 2 correct answers to this question.

A. Stored procedures B. Calculation views C. BAPIs (Business Application Programming Inetrface) D. AMDPs (ABAP Manged Database Procedures)

Correct Answer: A,B

Question 2

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows?

A. Only one result row with the sales revenue sum of all 100 customers B. Only one result row with the sales revenue sum of the top 10 customers C. One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 100 customers D. One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers

Correct Answer: A

Question 3

"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 not stored for InfoObject ADDRESS B. SID values are generated when data for infoObject ADDRESS is loadet C. SID values are generated when InfoObject CITY is activated D. SID values are generated when InfoObject ADDRESS is activated.

Correct Answer: A

Question 4

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.

A. AIM B. ABR C. AIE D. ADD

Correct Answer: C,D

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

Question 5

Which development object needs to be built to generate an HDI Container?

A. SQL script procedure B. HDB module C. Space D. Package

Correct Answer: B

Question 6

You are involved in an SAP BW/4HANA project focusin on General Ledger reporting and want to use the SAP ERP Estandar DataSource oFI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question.

A. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system B. Transaction ODQMON (Monitor Delta Queues) in the SAP Source system C. Transaction RS02 (Maintain Generic DataSource) in the SAP source system D. Transaction RSA1 (BI Content) in the SAP BW/4HANA system

Correct Answer: A,D

Question 7

What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?

A. Request is set to success, error stack is written, and valid records are updated B. Request is canceled, records are not tracked, and tarjet is not updated C. Request is set to failed, error stack is written, and valid records are updated D. Request is canceled, firt incorrect record is tracked, and target is not updated.

Correct Answer: B

Question 8

You create a DataStore Object(advanced) using the Data Mart DataStore Object modeling property. Which behaviors are specific to this modelling property? Note: There are 2 correct answers to this question.

A. The records are treated as if all characteristics are in the key. B. Query result are shown only when data has been activated C. Reporting is done based on a union of the inbound and active tables D. The change log table will be filled only after data activation

Correct Answer: A,C

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

Question 9

Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data?

A. Data acquisition layer B. Open operational data store layer C. Virtual data mart layer D. Flexible Enterprise Data Warehouse Core layer.

Correct Answer: D

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

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