Free SAP Certified Application Associate – Modeling and Data Acquisition with SAP BW 7.5 powered by SAP HANA C_TBW50H_75 Exam Practice Test

Which sources can you select when you model a composite provider? There are 3 correct answers to this question.

• SAP HANA analysis processes
• Other composite providers
• SAP HANA analytic views
• SAP HANA Calculation views
• Multiproviders

You run a query containing many free characteristics and some external hierarchies should be as fast as possible. Which of the following read modes do you choose? Please choose the correct answer.

• A Query to read all data at once
• H Query to read when you navigate or expand hierarchies
• X Query to read data during navigation

Which object type performs the delta merge check automatically? Please choose the correct answer.

• Persistent staging Area
• SAP HANA optimized info cube
• Write-optimized Datastore object
• Standard info cube

You instantiate a non-persistent characteristic info object. Which options do you have? There are 2 correct answers to this question.

• Change existing in object
• Create new in object
• Use existing in object
• Generate in object

You want to create a workbook that shows turnover per material group. Materials are organized hierarchically on three levels. Business users want to view the level 3. They also want to be able to aggregate on lower hierarchy levels. How can they do this? There are 2 correct answers to this question.

• Open the hierarchy options of the material from hore bar and deselect the required level in the show levels option.
• Open the hierarchy options of the material & the ment bar and select the required level in the show levels option.
• Open the context menu of tee in the analysis and expand the hierarchy of the required level.
• Open the hierarchy options of the material from the ment bar and expand the hierarchy to the required level.

You need to create an SAP Business Warehouse data flow that combines data from two sources in an advanced Datastore object (DSO) There are different and value for the same entry in the source. Which approach does SAP recommend? Please choose the correct answer.

• Create an open ODS as a non-persistent intermediate layer to perform a join from the source dependent parts need to be implemented in the same transformation.
• Create a composite provider as a non-persistent intermediate layer to perform a join from the source the source-dependent parts need to be implemented in the same transformation.
• Create an infosource as a non-persistent intermediate layer.the source-dependent parts of the a transformation need to be implemented before the info source.
• Create an infoset as a non-persistent intermediate layer.the source-dependent parts of the transformation need to be implemented before the info set.

You want to fill variables automatically by using the Replacement path more. Which of the following variables types are supported? There are 3 correct answers to this question.

• Text
• Hierarchy
• Characteristic value
• Formula
• Hierarchy node

You use SAP Landscape Transformation Replication sees th operational data provisioning. Which of the following data acquisition features are provided? There are 3 correct answers to this question.

• Ability to use complex coded mapping rules
• Direct update to SAP Business warehouse info providers
• Removal of restrictions for extractors.
• Real-time replication to SAP Business warehouse
• Ability to use simple coded mapping rules

You create an advanced Data store (aDSO) Based on a standard DSO template to store consolidation data. Which options do you have to define the object model? There are 3 correct answers to this question.

• Write change log
• Unique Data Records
• Activate/compress Data
• Delete change log
• Aggregate Data

Your customer requires a query with a formula variables in which objects can you use a formula variable? There are 2 correct answers to this question.

• Formulas in a transformation
• Threshold value in conditions
• Restricted key figures
• Calculated key figures