Free SAP Certified Application Specialist – SAP BW/4HANA 2.0 Delta Exam E_BW4HANA200 Exam Practice Test

you define a temporal condition for a temporal join in a calculation view.which column data types are suppored? there are 3 correct answers to this question.

• Timestamp
• Integer
• Date
• Boolean
• Decimal

What must you do first if you need to define help cells for formulas in the cell editor? Please choose the correct answer.

• Define two structures in a query.
• Define two selections in a structure.
• Define two formulas in a structure.
• Reuse a structure in a secondary query.

Which statements about process chains are true?

• Process chains have a graphical design GUI.
• Process chains have log, checking and planning views.
• Process chains have many process types to control your BI project.
• Collector process include AND and OR and EXOR.

What happens if a query with time-dependent attributes is executed but NO query key date is set? Please choose the correct answer.

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

Which kinds of data can you model with Open ODS views?Note: There are 2 correct answers to this question.

• Queries
• Language-dependent texts
• Unstructured data
• Master data

which of the following are strengths of SAP S/4HANA embedded analytics? there are 2 correct answers to this question.

• Historical dat for stretegic decisions is stored.
• Operational data is accessed in real time.
• Cross-system consistency is generated.
• Redundant data is reduced.

Which variables types allow filter values to be determined based on the user's authorizations? There are 2 correct answers to this question.

• Hierarchy variable
• Characteristic value variable
• Hierarchy node variable
• Formula variable

which source types can you select when you create an OPen ODS view? there are 3 correct answers to this question.

• SAP BW Data source
• Characteristic
• Infosource
• Transformation
• Virtual table using SAP HANA smart data access

Which query property do you set to minimize the initial run time for the query read mode? Please choose the correct answer.

• Read all data at once
• Cache is inactive
• Read data individually from info provider
• Read data when you navigate or expand hierarchies

What can you do in the graphical data flow modeler?Note: There are 2 correct answers to this question.

• Push down OLAP logic to SAP HANA.
• Create and schedule process chains.
• Navigate to object editors.
• Model new or explore existing data flows.