[Jun 12, 2023] C-TBW50H-75 Exam Dumps, C-TBW50H-75 Practice Test Questions [Q11-Q32]

4.5/5 - (2 votes)

[Jun 12, 2023] C-TBW50H-75 Exam Dumps, C-TBW50H-75 Practice Test Questions

Free C-TBW50H-75 Study Guides Exam Questions and Answer

NO.11 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.

NO.12 What are some of the advantages of SAP HANA smart data integration? There are 3 correct answers to this question.

A Methodology for streaming data into SAP Business warehouse

A Methodology to bypass the use of SAP Business Warehouse data transfer processes

A Methodology to efficiently transform data in SAP Business warehouse

DA Methodology to efficiently integrate external data into SAP Business warehouse

A replacement for the Universal Data connect and database connect data a on technologi

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

Attributes

Variables

Characteristics

Filters

None of above

NO.14 What functions has Data Warehousing Workbench (DWWB.?

Modeling

Reporting

Scheduling

Monitoring

NO.15 Your customer’s sales department wants to combine spins warehouse (SAP BW) data with from a flat file in an SAP BW workspace. Which tool do you used? Please choose the correct answer.

SAP BW designer

SAP Lumira

SAP Business objects Analysis for Microsoft office

SAP HANA Studio

NO.16 Where can you set a variable offset to a time-based characteristic? Please choose the correct answer

In the info provider definition in the data warehousing workbench in the SAP HANA

In the key figure’s characteristic variable restrictions in the SAP business warehouse query

Designer in the SAP HANA studio.

In the characteristic definition in the data warehousing workbench in the SAP A studio

In the calculated key figure dialog in the SAP business warehouse query Designer in the HANA studio

NO.17 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.

NO.18 Which of the following objects can you associate when you create an open ODS view? Please choose the correct answer.

SAP HANA calculation view

Infobject

Compostie provider

Advanced datastore object

NO.19 You need to delete data for a company code from an advanced Datastorg ghieet where do you do this?

Please choose the correct answer.

Select the request->delete

Environment menu->Selective Deletion

Environment menu->Delete content

Environment menu->remove inbound table

NO.20 Exception aggregation has no eect on the saving of data in the fact table because it is only eective for reporting. Determine whether this statement is true or false.

True

False

NO.21 Based on BW 7.5, which of the following should be considered when modeling master data and transaction data?

If master data does not need to replicated, an Open ODS View for texts and attributes could be used.

If transaction data should be stored, an Advanced Data Store Object (ADSO) should be used.

To load transaction data eciently, an Open ODS View of type facts should be used.

Replicate the data into a classic InfoCube

If master data is to be persisted, then characteristics should be used

NO.22 What do Database connect, universal date connect, and the SAP business warehouse service API have in common?
Please choose the correct answer.

The Data source must be created directly in SAP Business warehouse.

Using the persistent staging Area is mandatory

The delta queue exists

The direct access is available

NO.23 You need to load data from a data from a Datasource directly to an info-cube. Which of the following delta processes can you use for the data source? There are 2 correct answers to this question.

ADD Additive Exteraction Via Extractor

AIM After-image via Delta queue

AIMD After-image with delection flag via delta queue.

ABR Complete Dela with deletion flag via delta Queue.

NO.24 InfoProviders are technical tables joined in some way. They are constructed using fields in BI that we call
_______. Choose the correct answer(s).

Business fields.

InfoObects.

Special fields.

InfoItems.

NO.25 You want to copy an SAP Business warehouse query from a source info provider to a target info provider. Which prerequisite must be fulfilled? Please choose the correct answer.

The query to be copied must NOT contain reusable query components.

The type of the source info provider and the target info provider must be the same

The target info provider must contain at least all the info objects

NO.26 Which of the following are Best Practice options for storing data in a BW system running on SAP HANA?

Store the bulk of the data on disk for retrieval when required (warm data)

Store the most relevant data in a compressed column store (hot data)

Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data)

Store all data in compressed column stores to maximize performance (hot data)

Move less important data into an external storage system (cool data)

NO.27 Which of the following restrictions apply to the usage of structures in a query? There are 2 correct answers to this question.

you can create only two key figure structure in a query.

you can create only two structures in a query.

you can use only one characteristic structure in a query.

you can create only two characteristic structures in a query.

NO.28 Which advantage you have if you use universal Data connect(UD Connect)instead of Database connect(DB Connect) Please choose the correct answer.

UD connect uses the SAP Specific Database shared Library(DBSL)

UD connect provides the ABAP software development kit(SDK)

UD connect is based on SAP Netweaver Application server for ABAP.

DUD connect provides connectivity to external multidimensional data sources.

NO.29 Which the following objects can you create when you use the SAP Business Warehouse modeling tools in the SAP HANA studio?
There are 3 correct answers to this question.

Key figures

global filters

Process chains

Local composite providers

Restricted key figures

NO.30 Which of the following are benefits of the DSO?

Overwrite capability.

Reporting.

Data Compression.

Store data on the document level.

None of the above

NO.31 Which of the following objects is not provided in business content?

Infocube

InfoSource

KPIs

Queries

SAP ECC Extractor program

None of the above

NO.32 A transformation can contain multiple rule groups, and rule groups allow you to combine various rules. Determine the statement is True or False.

True

False