Labour Day Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

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

Demo: 13 questions
Total 88 questions

SAP Certified Application Associate - Modeling and Data Acquisition with SAP BW 7.5 powered by SAP HANA Questions and Answers

Question 1

Your customer migrates to SAP Business warehouse (SAP BW) Powered by SAP HANA and wants to enrich reporting with native SAP HANA features. What data modelling approach SAP recommend? Please choose the correct answer.

Options:

A.

Create SAP HANA Calculation views on SAP BW data flow.

B.

Create SAP HANA views and discard the existing SAP BW models

C.

Create external SAP HANA views on SAP BW infoproviders and SAP BW queries.

D.

Create main data modeling in SAP HANA and combine it SAP BW planning infoproviders

Question 2

You use an API to trigger a process chain in streaming mode. Which process type do you use? Please choose the correct answer.

Options:

A.

Data transfer process on SAP HANA Data source

B.

Data transfer process on advanced Data store object

C.

Data transfer process on standard Data store object

D.

Data transfer process on operational data provisioning Data source

Question 3

Which of the following data provisioning tools are provided by SAP HANA smart integration? There are 2 correct answers to this question.

Options:

A.

SAP Data services software

B.

Adapter software development kit

C.

Data provisioning Agent configuration

D.

SAP Business warehouse Data source adapter

Question 4

What objects must you create when you load external appar aged fo SAP Business warehouse with a

web service Data source?

There are 2 correct answers to this question.

Options:

A.

A daemon background process

B.

A web service after the web service Data soured

C.

An info package for the web service Data source

D.

A PSA table after the web service Data source

Question 5

Our customer wants to create a composite provider to combine data form two advanced Data store objects(DSO). Which operation does the system propose, by default to combine the data of both advanced DSOs? Please choose the correct answer.

Options:

A.

Left Outer join

B.

Union

C.

Join

D.

Inner join

Question 6

In accordance with the layered scalable architecture, which layers represent the architected data mart layer?

Please choose the correct answer.

Options:

A.

Data propagation layer.reporting layer.Virtualization layer

B.

Business transformation layer.reporting layer.Virtualization layer

C.

Harmonization layer.Business transformation layer.Virtualization layer

D.

Harmonization layer.Reporting layer.reporting later.Virtualization layer

Question 7

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

Options:

A.

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

B.

you can create only two structures in a query.

C.

you can use only one characteristic structure in a query.

D.

you can create only two characteristic structures in a query.

Question 8

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.

Options:

A.

SLT stops the load process when a subscriber is cancelled.

B.

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

C.

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

D.

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

Question 9

You want to build a query in the BEx Query Designer to display the ten customers with the highest sales revenue. Which activity do you need to perform? There are 2 correct answers to this question.

Options:

A.

Use the All characteristics in Drilldown independently option.

B.

Create a condition using the TOP N ranked list operator.

C.

Use an exception aggregation on the customer number.

D.

Define an alert level on the sales revenue.

Question 10

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

Options:

A.

in the query properties, in the general tab.

B.

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

C.

in the query properties, in the Extended tab.

D.

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

Question 11

Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse?

Please choose the correct answer.

Options:

A.

Database Connect

B.

Web service

C.

File interface

D.

Universal Data Connect

Question 12

Which sources are available when you create on each ODS view? There are 3 correct answers to this question.

Options:

A.

SAP Business warehouse info sources

B.

SAP Business warehouse transformations

C.

Virtual tables using SAP smart data access.

D.

SAP HANA Procedures

E.

SQL views of the SAP HANA database

Question 13

You need to remodel a characteristic infobject and the remodeling toolbox. Which activities can you perform?

There are 2 correct answers to this question.

Options:

A.

Add attributes to a characteristic.

B.

Change a refernce characteristic.

C.

Add or delete a compounding charecteristic

D.

Change the attribute type.

Demo: 13 questions
Total 88 questions