SAP BW- DATA ENGINEER - DATA FABRIC CERTIFICATION EXAM QUESTIONS AND ANSWERS WITH RATIONALES NEWLY MODIFIED EXAM CURRENTLY TESTED AND APPROVED!!!

SAP BW- DATA ENGINEER - DATA FABRIC
CERTIFICATION EXAM QUESTIONS AND
ANSWERS WITH RATIONALES NEWLY
MODIFIED EXAM CURRENTLY TESTED AND
APPROVED!!!


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

There are 3 correct answers to this question.



a) Extraction Grouped by

b) Data tiering

c) Activation handling

d) Parallel processing

e) Extraction Mode

--CORRECT ANSWER--a) Extraction Grouped by

d) Parallel processing

e) Extraction Mode




In SAP BW/4HANA, what is a critical security feature for protecting data during user
queries?

Please choose the correct answer.

Page 1 of 85

,a) Predefined query templates

b) Analysis authorizations

c) Client-side caching

d) SQL injection protection

--CORRECT ANSWER--b) Analysis authorizations




You are allowed to run a BW query, but the data selection of characteristic values is only
partially covered by your authorizations. What happens related to the BW query in this
scenario?

Please choose the correct answer.



a) The BW query starts and shows an error message.

b) The BW query starts and the unauthorized values are 0.

c) The BW query starts and only the authorized data is displayed.

d) The BW query does not start running.

--CORRECT ANSWER--a) The BW query starts and shows an error message.




How can the delta merge process be initiated in SAP BW/4HANA ?

2 correct answers.




Page 2 of 85

,a) By using a specific process type in a process chain

b) By using the SAP BW/4HANA data load monitor

c) By setting a specific flag in the transformation

d) By setting a specific flag in the data transfer process

--CORRECT ANSWER--a) by using a specific process type in a process chain

d) by setting a specific flag in the data transfer process



Remarks:

- the flag is "Trigger Database Merge".

- the process type is "Load Process and Postprocessing - Trigger Delta Merge"




What are some of the benefits of using an InfoSource in a data flow?

Note: There are 2 correct answers to this question.



a) Splitting a complex transformation into simple parts without storing intermediate data

b) Providing the delta extraction information of the source data

c) Enabling a data transfer process (DTP) to process multiple sequential transformations

d) Realizing direct access to source data without storing them

--CORRECT ANSWER--a) Splitting a complex transformation into simple parts without storing
intemediate data

d) Realizing direct access to source data without storing them




Page 3 of 85

, What are the possible ways to fill a pre-calculated value set (bucket)?

Note: There are 3 correct answers to this question.



a) By using a BW query (update value set by query)

b) By accessing an SAP HANA HDI Calculation View of data category Dimension

c) By using a transformation data transfer process (DTP)

d) By entering the values manually

e) By referencing a table

--CORRECT ANSWER--a) By using a BW query (update value set by query)

d) By entering the values manually

e) By referencing a table




You use InfoObject B as a display attribute for InfoObject A. Which object properties
prevent you from changing InfoObject B into a navigational attribute for InfoObject A?

Note: There are 3 correct answers to this question.

a) Data Type "Character String" is set in InfoObject A.

b) Attribute Only is set in InfoObject B.

c) High Cardinality is set in InfoObject B.

d) InfoObject B is defined as a Key Figure.

--CORRECT ANSWER--e) Conversion Routine "ALPHA" is set in InfoObject A.

b) Attribute Only is set in InfoObject B.



c) High Cardinality is set in InfoObject B.

Page 4 of 85