[Q18-Q42] Real Exam Questions C_TBW50H_75 Dumps Exam Questions in here [May-2023]

Rate this post

Real Exam Questions C_TBW50H_75 Dumps Exam Questions in here [May-2023]

Get Latest May-2023 Conduct effective penetration tests using C_TBW50H_75

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

Compression

Data model

Web page design and Java scripting

Read mode

Q19. To model the tracking history scenarios of historical truth and current truth, two different star schemas are required. Determine whether this statement is true or false.

True

False

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

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

Data transfer process on SAP HANA Data source

Data transfer process on advanced Data store object

Data transfer process on standard Data store object

Data transfer process on operational data provisioning Data source

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

Q23. Which of the following statements are true regarding the difference between compounding and concatenation?

Compounding is easier to filter in queries because the objects are separate whereas with concatenation, the key string needs to be masked

Compounding is easier for users to understand because it is based on a 1:1 object mapping but concatenation is more complex for users to understand and decipher

Concatenation uses a single key value but compounding uses more than one

Adding key fields in concatenation is easier because only the transformation needs to be changed but in compounding structures need to be changed and data re-loaded

Compounding is supported in the definition of the lnfoObject whereas concatenation requires the creation of new database tables

Q24. Which of the following items are part of an InfoObject definition?

Attributes

Hierarchies

Text Information

Dimension

Transaction codes

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

Q26. If an InfoSource is used in front of an InfoProvider and an outbound InfoSource after an InfoProvider, the transformation logic is always located between the outbound InfoSource of the source InfoProvider and the inbound InfoSource of the target InfoProvider. Determine whether this statement is true or false.

True

False

Q27. Which objects can you use to trigger delta merge? There are 2 correct answers to this question.

Transformation

Infopackage

Process chain

Data transfer process

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

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

A daemon background process

A web service after the web service Data soured

An info package for the web service Data source

A PSA table after the web service Data source

Q30. Time-dependent and time independent attributes are stored in the same ‘X’ table which uses ‘Date From’ and
‘Date To’ as key fields. Determine Whether this statement is true or false.

True

False

Q31. SAP HANA provides a choice of row or column storage types. Determine whether this statement is true or false.

True

False

Q32. To create new objects to store data for BI, you would access Administration tab of the DWWB. Determine whether the statement is True or False.

True

False

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

Q34. Data Models in BW can be made available in SAP HANA using the manual pull mechanism or automatically using the push function which is set in the BW InfoProvider properties. Determine Whether this statement is true or false.

True

False

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

Web service

Universal Data Connect

Database Connect

File interface

Q36. The productive BW system is always defined as a closed system in which changes can only be made by importing a transport. Determine whether this statement is true or false.

True

False

Q37. In developing a logical data model, SAP Best Practice is to build the model using a top-down, key figure approach or a bottom-up DataSource approach. Determine Whether this statement is true or false.

True

False

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

Q39. Your customer requests a query that shows the sales revenue for materials. What do you use to only view materials with revenue? Please choose the correct answer.

The compact display on Rows option

The cumulative value Display option.

The posted values option

A charecteristic restriction

Q40. InfoSources are exactly the same in both the old and new ETL processes. Determine the statement is True or False.

True

False

Q41. What are the three predefined dimensions in SAP BW?

Date

DataPackage

Time

Unit

Q42. Currency translation types are control how exchange rate calculations are performed when data is either loaded in to BW once a query is executed. Determine whether this statement is true or false.

True

False

Loading …