C_BW4HANA_20 Online Practice Questions and Answers

Which tables belong to the hierarchy for characteristic OCOUNTRY? Note: There are 3 correct answers to this question.

A. /BIC/QCOUNTRY

B. D/BIC/KCOUNTRY

C. /BIC/ICOUNTRY

D. /BIC/PCOUNTRY

E. D/BIC/HCOUNTRY

Which object is a target of an SAP BW transformation?

A. InfoObject of type Characteristic

B. CompositeProvider

C. InfoObject of type Key Figure

D. Open ODS view

In which sequence can you create a reusable key figure structure? Note: There are 2 correct answers to this question.

A. 1. Create a new structure in the context menu of a calculated key figure. 2. Save the structure as a global structure.

B. 1. Apply filters to a key figure structure in SAP Analysis for Microsoft Office. 2. Save the structure as a global structure.

C. 1. Create a new structure in the context menu of an InfoProvider. 2. Add key figures, selections, and formulas.

D. 1. Create a new structure with key figures, selections, and formulas in a que 2. Save the structure as a global structure.

Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.

A. The table will be integrated into a native SAP HANA calculation view.

B. Aggregation and fast search is required for query execution.

C. When the table is accessed, all columns of a single record are processed.

D. The values in the columns are different. Therefore, data compression would NOT have much effect.

What happens if a query with time-dependent attributes is executed but NO query key date is set?

A. The current date is used as key date.

B. The system displays only NON-time-dependent attributes.

C. The valid from date of the attribute is used as key date.

D. The system displays an error message.

You define a temporal condition for a temporal join in a calculation view. Which column data types are

supported?

Note: There are 3 correct answers to this question.

A. Integer

B. Date

C. Decimal

D. Boolean

E. Timestamp

Which settings can you define in a data transfer process (DTP) if you load data into a DataStore object

(advanced)?

Note: There are 3 correct answers to this question.

A. Extraction mode

B. Error handling

C. Activation handling

D. Data tiering

E. Semantic groups

Which SAP tool do you suggest to create a pixel-precise formatted report?

A. SAP Lumira, discovery edition

B. SAP Analysis for OLAP

C. SAP Crystal Reports for Enterprise

D. SAP Analytics Cloud

You create a BW query. How can you check the navigational attributes of a basic characteristic?

A. Add the basic characteristic to a BW query and check the display properties.

B. Open the editor for the basic characteristic and check the Attribute tab.

C. Select Attributes from the context menu of the basic characteristic in the rows section.

D. Open the InfoProvider view and check the Attribute folder below the basic characteristic.

For which business requirements do you suggest an SAP BW/4HANA modeling focus rather than an SAP

HANA modeling focus?

Note: There are 2 correct answers to this question.

A. Report on a harmonized set of master data.

B. Load snapshots or deltas on a periodic basis.

C. Use existing HANA content models.

D. Leverage SQL in-house knowledge.

You set up the 2LIS_02_ITM (Purchasing Line Item) data source in SAP ERP using the logistics cockpit. Afterward, you successfully run the initialization into SAP BW/4HAN

A. Your delta load into SAP BW/4HANA shows zero records even though new purchase orders were created. How do you explain that the delta records do NOT appear in SAP BW/4HANA?

B. A reinitialization for sales orders in SAP ERP was triggered using the logistics cockpit, which deleted the purchase order item initialization.

C. All old purchase orders in SAP ERP were archived overnight before the delta loads.

D. Purchasing extractors in SAP ERP were set up with Queued Delta update mode and the collective run job was NOT scheduled.

E. Another SAP BW/4HANA system already picked up the new purchase orders using a delta load

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.

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.

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.

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.