C-TBW50H-75 Exam Practice Questions prepared by SAP Professionals [Q16-Q38]

Diesen Beitrag bewerten

C-TBW50H-75 Exam Practice Questions prepared by SAP Professionals

Use Valid New C-TBW50H-75 Questions – Top choice Help You Gain Success

Q16. Where can a characteristic be restricted in the BEx query definition? Please choose the correct answer.

in the query properties, in the general tab.

In the characteristic’s context menu in the default value section

in the query properties, in the Extended tab.

In the characteristic’s context menu in the info provider section

Q17. Which of the following are golden rules for modelers using SAP HANA? Choose the correct answers.

Save less important data outside of memory

Use column stores for analytical tasks

Virtual data sources should use SAP HANA as the database

Be economical and re-use SAP HANA Views when possible

Modularize the data model and maximize performance using parallelization

Q18. Your customer wants to link a query to an external URL. Which of the following steps are required for a report-report interface setting?
Hinweis: Es gibt 3 richtige Antworten auf diese Frage.

Insert the parameter for the Web address in the assignment details.

Select the Web address from the list of report types.

Select Receiver Object and enter the Web address.

Select a system from the Source Systems tab.

Insert the Web address in the assignment details.

Q19. What can you define in the BEx Query Designer cell editior? There are 3 correct answers to this question.

Variables with the replacement path option to pass values to reference cells.

Additional filter restrictions that apply to a complete column or row of the result set.

Formulas and selection conditions for cells to solve formula collision.

Help cells thet serve as containers for help selections or help formulas.

Q20. Your customer wants near-real-time reporting and considers either using real-time data acquisition (RDA )or acquiring data in real time using SAP landscape transformation Replication Replication server (SLT) with operational data provisioning (ODP).
What advantages does SLT with ODP have over RDA? There are 2 correct answers to this question.

SLT stops the load process when a subscriber is cancelled.

SLT allows multiple info providers as subscribe to the same data.

SLT uses an RDA-enabled data transfer process to load directly into SAP Business warehouse.

SLT uses the persistent storage area (PSA) as a backup

Q21. 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.

Q22. Which sources are available for a generic SAP Business Warehouse DataSource? There are 3 correct answers to this question.

SAP HANA remote source table

SAP query (InfoSet)

DB view or table

SAP HANA information view

Function module

Q23. Identify issue affecting query performance that you, as a BI administrator, are responsible for officially.

Query design

CPU selection

Aggregates

Memory utilization and availability

Q24. What functions has Data Warehousing Workbench (DWWB.?

Modeling

Reporting

Scheduling

Monitoring

Q25. Navigational attributes behave in a query like which of the following?

Attributes

Variables

Characteristics

Filters

None of above

Q26. Which advanced Datastore object modeling templates are available in SAP Business Warehouse? There are 2 correct answers to this question.

Compositeprovider

Open ODS view

Corporate memory with compression.

Data acquisition layer

Q27. Using the formula rule type, you can develop custom transformation logic without the need to know ABAP syntax. Determine the statement is True or False.

True

False

Q28. Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse layer. What action do you take?

Reduce the number of persistent InfoProviders.

Apply the SAP Business Warehouse workspace layer

Migrate all SAP Business Warehouse objects to SAP HANA optimized objects

Apply the Open ODS layer.

Q29. 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.

Q30. The error stack can help you in which areas? Choose the correct answer(s).

Identifying erroneous records.

Automatically fixing bad records.

Reducing your dependence on temporary storage.

Improving load times.

Q31. Multiple source systems can be assigned to an InfoSource. Determine the statement True or False.

True

False

Q32. 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

Q33. A reference lnfoObject is a ‘template’ of an lnfoObject that is then used as a reference or other objects when the characteristic properties are the same. Determine Whether this statement is true or false.

True

False

Q34. A business content Datasource does NOT provide all required fields. What activity does SAP recommend you perform to enrich the extraction? Please choose the correct answer.

Expose the Data source as operational data provider and use th ermation component of SAP Landscape Transformation.

Define an append structure, add it to the extract structure and write a function exit to call the relevent information.

Create an additional generic Data source to extract the missing nformeg nd combine the data in SAP business warehouse.

Neglect the business content data source and define a new generic Data our OE a function module.

Q35. 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.

Q36. Which infoprovider do you use for SAP Business waclonse7.s Powered by SAP HANA to replace the multi providers for reporting? Please choose the correct answer.

Advanced Data store object

Virtual provider

Composite provider

Info object as info provider

Q37. 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

Q38. Which tool do you use to monitor streaming process chains? Please choose the correct answer.

Subscription monitor

Queued Task manager monitor

Operational Delta Queue monitor

Real-time Data acquisition monitor