C-BW4H-214 Exam Training Practice Tests (SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA)]

Question 1

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?

A. Compound characteristic "COSTOBJ" with the characteristic for Controlling Area B. Define characteristic "COSTOBJ" as a navigation attribute for Controlling Area C. Define Controlling Areas as a navigation attribute for the characteristic "COSTOBJ" D. Compound the characteristic for Controlling Area with the characteristic "COSTOBJ"

Correct Answer: D

Question 2

You want to define a restricted column in an SAP HANA calculation view. What do you need to define? Note: There are 2 correct answers to this question.

A. An aggregation method B. A condition criterium C. An SAP HANA data type D. A reference to an existing measure

Correct Answer: A,B

Question 3

"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. SAP ABAP Connection B. BW SHEL Migration C. BW Remote migration D. SAP BW/4HANA Model Transfer.

Correct Answer: A

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

Question 4

SAP provides three data warehouse solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned?

A. To support business user with a new self-service tool to model their own data flows B. To empower business users to create an dmaintain process chain from SAP BW/4HANA dataflows C. To support business user who want to simplify theris own ABAP routines D. To empower business users to generate SQL code that ispushed to SAP BW/4HANA

Correct Answer: A

Question 5

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 RS02 (Maintain Generic DataSource) in the SAP source system B. Transaction ODQMON (Monitor Delta Queues) in the SAP Source system C. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system D. Transaction RSA1 (BI Content) in the SAP BW/4HANA system

Correct Answer: C,D

Question 6

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

A. Full outer join B. Inner join C. Text join D. Hierarchy join E. Referential join

Correct Answer: A,B,E

Question 7

You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system for test purposes. Which approach should you consider for rapid prototyping?

A. Generate Data Flow B. Business content activation C. InfoObject base modeling D. Field-based modeling

Correct Answer: D

Question 8

Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?

A. Forecasting B. Smart Predict C. Search to insight D. Smart Discovery

Correct Answer: D

Question 9

The Database Explorer in the Web IDE for SAP HANA proveides a data file improt wizard to create a table in SAP HANA from a flat file. What are possible actions adter the system suggests the target structure?? Note: There are 3 correct answers to this question.

A. Adjust the suggested data type of the target table fileds B. Change the order of the fields in the target table C. Define sorting properties for a target table field D. Map InfoObjetcs to fields in the target tavle E. Switch the table type between row store and column store

Correct Answer: A,B,E

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