SAP Certified Associate - Data Engineer - SAP BW/4HANA

Question 1

Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question.

A. Dereference reusable filters

B. Use mandatory characteristic value variables

C. Use the include mode within filter restrictions

D. Create linked components

E. Include fewer drill-down characteristics in the initial view

Correct Answer: B,C,E

Question 2

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

A. To combine the query cache from different executions

B. To improve the read performance of InfoProviders

C. To move the most recent data from disk to memory

D. To decrease memory consumption

Correct Answer: B,D

Question 3

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

A. Generated external SAP HANA Calculation Views

B. SAP Agile Data Preparation

C. SAP HANA optimized business content

D. ABAP CDS view based virtual data model

Correct Answer: D

Question 4

What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 3 correct answers to this question.

A. Avoiding generation of SID values

B. Providing language-dependent master data texts

C. Reducing the number of database tables

D. Ensuring referential integrity on your transactional data

E. Allowing different data load frequency

Correct Answer: B,D,E

Question 5

What are some of the variable types in a BW query that can use the processing type SAP HANA Exit? Note: There are 2 correct answers to this question.

A. Formula

B. Text

C. Hierarchy node

D. Characteristic value

Correct Answer: A,D

Question 6

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue.
Using key figure properties in the BW query, which two scenarios regarding result presentation can be achieved? Note: There are 2 correct answers to this question.

A. One result row with the sales revenue sum of the top 10 customers

B. One result row with the sales revenue sum of all 100 customers

C. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of all 100 customers

D. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers

Correct Answer: A,D

Question 7

For a report, you would like to highlight the deviation from predefined threshold values for a key figure. Which BW query feature do you use?

A. Exception

B. Formula cell

C. Key figure property

D. Condition

Correct Answer: A

Question 8

For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus? Note: There are 2 correct answers to this question.

A. Leveraging SQL in-house knowledge

B. Reporting on a harmonized set of master data

C. Loading snapshots or deltas from different sources on a periodic basis

D. Finding the best match using a fuzzy search

Correct Answer: A,D

Question 9

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

A. By using the SAP BW/4HANA data load monitor

B. By setting a specific flag in the data transfer process

C. By using a specific process type in a process chain

D. By setting a specific flag in the transformation

Correct Answer: B,C

SAP Certified Associate - Data Engineer - SAP BW/4HANA - C-P2WBW-2505 Exam Practice Test

Latest Update

Useful Links

Contact Us