C_BW4HANA_20 by SAP Valid Free Exam Practice Test

Question 1

You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type?

A. Referential join with Temporal Join properties B. Inner join with Dynamic Join properties C. Referential join with Dynamic Join properties D. Inner join with Temporal Join properties

Correct Answer: A

Question 2

You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags are set?
Note: There are 2 correct answers to this question.

A. Unique Data Records B. Write Change Log C. Activate Data D. All Characteristics are Key

Correct Answer: B,C

Question 3

You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider. What must you do first?

A. Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema. B. Set The CompositeProvider Can Be Added to Another CompositeProvider flag. C. Connect an export DataSource from the exisiting CompositeProvider to the new CompositeProvider. D. Assign consumption properties to the new SAP HANA calculation view.

Correct Answer: B

Question 4

Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSources?
Note: There are 2 correct answers to this question.

A. Serialization B. Delta type C. Parallelization D. Record mode E. Record type

Correct Answer: A,D

Question 5

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. -3 B. -12 C. -1 D. -4

Correct Answer: B

Question 6

What happens when you execute the Trigger Delta Merge operation for a given data target?

A. The data from the delta queue is extracted and merged into the data target. B. The before and after images of the delta queues are merged. C. Data is transferred from the delta store to the main store. D. The delta between the new data and the already loaded data is removed.

Correct Answer: C

Question 7

Which objects of an SAP HANA calculation view of DIMENSION data category can you re-use if you define an SAP calculation view of CUBE data category with star join? Note: There are 2 correct answers to this question.

A. Hierarchy assignment B. Aggregation method C. Attribute assignment D. Measure assignment

Correct Answer: C,D

Question 8

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

A. The system displays only NON-time-dependent attributes. B. The valid from date of the attribute is used as key date. C. The system displays an error message. D. The current date is used as key date.

Correct Answer: D

SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x - C_BW4HANA_20 Exam Practice Test