SAP Certified Associate - Data Engineer - SAP BW/4HANA Sample Questions:
1. Which objects' values can be affected by the key date in a BW query? Note: There are 3 correct answers to this question.
A) Time characteristics
B) Hierarchies
C) Basic key figures
D) Display attributes
E) Navigation attributes
2. 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) Reporting on a harmonized set of master data
B) Leveraging SQL in-house knowledge
C) Loading snapshots or deltas from different sources on a periodic basis
D) Finding the best match using a fuzzy search
3. What does a CompositeProvider allow you to do in SAP BW/4HANA? Note: There are 3 correct answers to this question.
A) Create new calculated fields
B) Join two ABAP CDS views
C) Integrate SAP HANA calculation views
D) Define new restricted key figures
E) Combine InfoProviders using Joins and Unions
4. In a BW query with cells, you need to overwrite the initial definition of a cell Which cell types can you use? Note: There are 2 correct answers to this question.
A) Help cell
B) Selection cell
C) Reference cell
D) Formula cell
5. In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?
A) Any not activated request in the inbound table
B) Any request in the active data table
C) Only the most recent not activated request in the inbound table
D) Only the most recent request in the active data table
Solutions:
| Question # 1 Answer: B,D,E | Question # 2 Answer: B,D | Question # 3 Answer: A,C,E | Question # 4 Answer: B,D | Question # 5 Answer: C |

We're so confident of our products that we provide no hassle product exchange.


By Humphrey


