SAP C_BW4HANA_20 SAP Certified Application Associate – Reporting, Modeling and Data Acquisition with SAP Online Training
SAP C_BW4HANA_20 Online Training
The questions for C_BW4HANA_20 were last updated at Jan 06,2025.
- Exam Code: C_BW4HANA_20
- Exam Name: SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP
- Certification Provider: SAP
- Latest update: Jan 06,2025
What can you do when you use process chains? Note: There are 2 correct answers to this question.
- A . Trigger delta merge.
- B . Activate requests in DataStore objects (advanced).
- C . Generate transformations.
- D . Activate data transfer processes (DTPs).
What can you do when you use process chains? Note: There are 2 correct answers to this question.
- A . Trigger delta merge.
- B . Activate requests in DataStore objects (advanced).
- C . Generate transformations.
- D . Activate data transfer processes (DTPs).
Replicate the DataSource.
You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter.
Which offset do you need to retrieve the corresponding quarter of the previous year?
- A . -12
- B . -4
- C . -1
- D . -3
When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.
- A . The hierarchical structure will be time-dependent.
- B . The structure will contain formulas.
- C . The structure will depend on the order of the row characteristics.
- D . The structure exists in the source system.
- E . The query data will be restricted to a hierarchy node.
You need to create a CompositeProvider to combine data from an SAP HANA calculation view with a DataStore object (advanced).
Which of the following Eclipse perspectives do you use?
- A . JavaScript perspective
- B . BW modeling perspective
- C . ABAP perspective
- D . SAP HANA modeler perspective
You load a DataStore object (advanced) every night. Where can you delete the request you loaded two nights ago without deleting the last request?
- A . From a DataStore object (advanced) based on the model template InfoCube if the request is NOT v u activated.
- B . From a DataStore object (advanced) based on the model template InfoCube if the request is activated.
- C . From a DataStore object (advanced) based on the model template Standard DataStore object if the request is activated and you execute a full load.
- D . From a DataStore object (advanced) based on the model template Standard DataStore object if the request is activated.
Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.
- A . SAP HANA models as part providers in CompositeProviders
- B . ABAP Managed Database Procedures in an SAP BW/4HANA transformation
- C . Query settings fo read near-line storage data
- D . Activation of a DataStore object (advanced)
- E . Global transfer routines for master data harmonization
For which of the following revenue reporting requirements do you create restricted key figures?
- A . Convert revenue into a number without currency.
- B . Identify the top five countries by revenue for each month.
- C . Determine the average revenue per customer.
- D . Compare this year’s planned revenue with last year’s actual revenue.
You want to validate your SAP HANA data model.
What must you ensure to use the data preview functionality?
- A . The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICS.
- B . You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user.
- C . The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.
- D . Your content package is assigned with sufficient repository privileges to the SYS REPO user.
fyi