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

How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question.

• By setting a specific flag in the data transfer process
• By using a specific process type in a process chain
• By setting a specific flag in the transformation
• By using the SAP BW/4HANA data load monitor.

You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HAN

• Which options do you hacve to analyze a potential extractor issue? Note: There are 2 correct answers to this question.
• Use the ODQ maintance in SAP BW/4HANA
• Use transaction RSA3 (Extractor checker) in SAP ERP
• Check entries in table RSDDSTATEXTRACT in SAP ERP
• Use program RODPS_REPL_TEST in SAP ERP

You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question.

• Create restricted columns
• Provide default time characteristics
• Persist transactional data
• Combine master data and transactional data
• Aggregate measures as a sum

You have an existing field-based data flow that follows the LSA++ concept. To meet a new urgent business requirement for a field you want to leverage a hierarchy of an existing characteristic without changing the transformation. How can you achieve this? Note: There are 2 correct answers to this question.

• Associate the field with the characteristic in the CompositeProvider
• Add the characteristic to the DataStore object (advanced)
• Associate the field with the characteristic In the Open ODS View
• Assign hierarchy properties to the field in the SW Query

When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? Note: There are 2 correct answers to this question.

• When you define the attributes of material, select the "Time Dependent" setting
• When you define the data transfer process, select the "Load records wit new key only" setting
• When you define the data transfer process, choose the "Set Manually" setting for "Overrall status of request"
• When you define the material characteristic, select the "Enhanced Master data update" setting

Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.

• To combine the query cache from different executions
• To move the most recent data from disk to memory
• To decrease memory consumption
• To improve the read performance of InfoProviders

Why is the start process a special type of process in a process chain? Note: There are 2 correct answers to this question.

• Open ODS view of type Facts
• Calculation View of type Dimension
• Open ODS view of type Master Data
• InfoObjetc of type Characteristic

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

• Package
• HDB module
• SQL script procedure
• Space

What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct Answers to this question.Combine Infoprovider using Join and UnionsJoin two ABAP CDS viewsDefine new restricted key figuresCreate new calculated fields IntegrateSAP HANA HDI calculation views.

• Combine InfoProviders using Join and Unions: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider is an InfoProvider that combines data from several analytic indexes or from other InfoProviders (by union or inner join or left outer join), and makes this data available for reporting and analysis. Storing the data in BW Accelerator or in an SAP HANA database also ensures faster access to data in the query12.
• Define new restricted key figures: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can define new restricted key figures based on the existing key figures of the underlying InfoProviders. Restricted key figures are key figures that are restricted by one or more characteristics13.
• Integrate SAP HANA HDI calculation views: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can integrate SAP HANA HDI calculation views as part of its data sources, using a virtual table or an external SAP HANA view. This can enable mixed modeling scenarios that leverage both SAP BW/4HANA and SAP HANA capabilities14.

What foundation is necessary to use SAP S/4HANA embedded analytics?

• SAP HANA optimized business content
• SAP Agile Data Preparation
• Generated external SAP HANA Calculation Views
• ABAP CDS view based virtual data model.