SAP SAP Certified Application Associate C_BW4HANA_20 Questions & Answers

• Question 1:

  What must you do if you want to use an object from BI Content?

  A. Copy the BI Content object into the customer name space.

  B. Convert the object from A version to D version.

  C. Activate the object in the Data Warehousing Workbench.

  D. Identify the BI Content objects in SAP HANA studio.

  Correct Answer: C

• Question 2:

  You define a new generic DataSource in SAP ERP with A time stamp as the delta characteristic A value for the Safety interval Lower Limit A new status for changed records.

  How does this impact how you model the data target in SAP BW/4HANA? Note: There are 2 correct answers to this question.

  A. The data target must be able to manage duplicate records.

  B. The data target can be a DataStore object (advanced) of the Standard DataStore Object model template.

  C. The data target can be a DataStore object (advanced) of the InfoCube model template.

  D. The data target must be modeled with a characteristic for the safety interval.

  Correct Answer: AB

• Question 3:

  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

  Correct Answer: A

• Question 4:

  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.

  Correct Answer: C

• Question 5:

  You need to load data from a generic DataSource using Operational Data Provisioning (ODP). In which sequence do you perform the activities?

  A. 1. Create a DataSource.

  2.

  Replicate the DataSource.

  3.

  Activate the DataSource.

  4.

  Run job RODPS_OS_EXPOSE.

  B. 1. Create a DataSource.

  2.

  Replicate the DataSource.

  3.

  Run job RODPS_OS_ EXPOSE.

  4.

  Activate the DataSource.

  C. 1. Create a DataSource.

  2.

  Run job RODPS_OS_EXPOSE.

  3.

  Replicate the DataSource.

  4.

  Activate the DataSource.

  D. 1. Create a DataSource.

  2.

  Activate the DataSource.

  3.

  Run job RODPS_OS_EXPOSE.

  4.

  Replicate the DataSource.

  Correct Answer: C

• Question 6:

  Your main BW query contains a characteristic value variable with a replacement path from a query. When is the pre-query executed?

  A. Each time the main query is executed, before the filter values are applied.

  B. Each time the main query is executed, after the filter values are applied.

  C. Directly after a predefined broadcasting event was triggered to calculate the pre-query.

  D. Directly after data is loaded to the InfoProvider of the pre-query.

  Correct Answer: A

• Question 7:

  For which activity do you use the key figure matrix?

  A. Structure the information from the requirement analysis.

  B. Provide information on the relations between characteristics.

  C. List properties of the data sources.

  D. Allocate project resources.

  Correct Answer: A

• Question 8:

  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.

  Correct Answer: ADE

• Question 9:

  Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server?

  A. View-based data result sets must be kept persistent first until data replication can take place.

  B. An SAP HANA source system must be defined to consume the view.

  C. Each table of the view requires a defined trigger to enable data replication.

  D. One table as part of the view has to be defined as primary table and is used to trigger data replication.

  Correct Answer: B

• Question 10:

  You need to use an SAP ERP standard DataSource to load data into SAP BW/4HANA.

  Which prerequisite must be fulfilled to use the DataSource in the Operational Data Provisioning context?

  A. lt must exist in table ROOSATTR.

  B. It must be delta-enabled.

  C. It must be in-memory-optimized.

  D. It must have a queue entry in transaction ODQMON.

  Correct Answer: A