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

What is the maximum number of key fields that an advanced data store objects can contain? Please choose the correct answer.

• 16 Key fields
• 64 Key fields
• 120 key fields
• 256 Key fields

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

Your customer has an existing cube calculation view of global sales in various currencies. What should you do to convert all revenues to th currency? Please choose the correct answer.

• Add an additional cube calculation view for the currency conversion.
• Add a calculation view including a calculated column on a measure.
• Join the cube calculation view to an additional dimension view.
• Join the cube calculation view to a calculation view a restricted column for each currency.

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

For which data source does SAP recommend using SAP Data services to load data into SAP Business warehouse (SAP BW)? Please choose the correct answer.

• SAP HANA data
• Non-SAP data
• SAP ERP data
• SAP BW data

Which objects are mandatory when you create a transactional data flow in operational data provisioning? There are 2 correct answers to this question.

• InfoPackage
• Data transfer process
• Transformation
• Real-time daemon

Your customer wants to integrated streaming data into SAP HAN

• A database connect Data source SAP Business warehouse modeling tools of the SAP HANA studio.
• An SAP smart data integration remote source in the administration console of the SAP HANA studio.
• An SAP Business warehous dats o urce for smart data integration in the administration console u of the SAP HANA studio.
• An SAP HANA Source system in the SAP HANA modeler of the SAP HANA studio.

The result of a calculation: Si Business Warehouse is incorrect, but the formula is correct. What options do you have to correct the calculation? There are 3 correct answers to this question.

• Set an exception aggregation to change the calculation behavior
• Create the formula again to receive a new time stamp.
• Change the formula collision property to use result of concurrent formula
• Change the formula collision property to use result of this formula.
• Create a new structure to receive a new time stamp.

You use the query monitor transaction (RSRTI) to investigate the poor performance of a query. Which actions do you perform when you use this transaction? There are 3 correct answers to this question.

• Debug the query
• Maintain the read mode and the cache mode of the query.
• Execute the query without using the cache
• Maintain the technical info of the query.
• Change the query definition

Why is graphical date flow modeling preferred over classical data flow modeling? There are 2 correct answers to this question.

• it helps you define your own templates to set standards for your customer.
• You can execute it to load date
• It provides a better overview of the data flows.
• you can view it using the SAP Business warehouse modelling tools of the SAP HANA Studio.