VCEdump

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

PDF question preview Back to product

Free preview

15 sample questions

The complete product contains 94 questions.

Question formats

Single choice9

Multiple choice6

Compare study plans

SAP · C_TBW50H_75

C_TBW50H_75 questions and answers

Review the question wording, option layout, and available explanations before choosing a study plan.

Question 1

Single choice

You create a transformation from a DataSource to a standard DataStore object. The DataSource provides an after-image delta.

Which key figure aggregation type do you select?

A
Summation
B
Maximum
C
Minimum
D
Overwrite

Reveal answer details Close answer details

Correct answerD

Question 2

Single choice

Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse layer.

What action do you take?

A
Reduce the number of persistent InfoProviders.
B
Apply the SAP Business Warehouse workspace layer
C
Migrate all SAP Business Warehouse objects to SAP HANA optimized objects
D
Apply the Open ODS layer.

Reveal answer details Close answer details

Correct answerA

Question 3

Single choice

Open ODS Views enable you to define SAP BW data models for objects like database tables, database views or BW DataSources (for direct access). Determine Whether this statement is true or false.

A
True
B
False

Reveal answer details Close answer details

Correct answerA

Question 4

Multiple choice

Which of the following are ways in which joins can be made using SAP BW on SAP HANA?

A
A BW lnfoSet can be used to create a temporal join
B
A native SAP HANA calculation view can perform inner and outerjoins
C
An Advanced DSO can create joins between master data and transaction data
D
BW Composite Provider can provide inner and outer joins
E
Transformations can perform joins of multiple DataSources

Reveal answer details Close answer details

Correct answersA, B, D

Question 5

Single choice

XML would be good for: Choose the correct answer(s):

A
Loading a shopping cart from an Internet application.
B
Efficiently loading 10,000 records.
C
Extracting from a SAP R/3 system.
D
Extracting from another BI system.

Reveal answer details Close answer details

Correct answerA

Question 6

Single choice

In the SAP BW data model, master data is stored separately in attribute, text and hierarchy tables that are linked together using surrogate ID (SID). Determine Whether this statement is true or false.

A
True
B
False

Reveal answer details Close answer details

Correct answerA

Question 7

Multiple choice

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

A
SAP HANA information view
B
Function module
C
SAP HANA remote source table
D
DB view or table
E
SAP query (InfoSet)

Reveal answer details Close answer details

Correct answersB, D, E

Question 8

Single choice

Database statistic is the same thing as BI Statistics. Determine whether the statement is True or False.

A
True
B
False

Reveal answer details Close answer details

Correct answerB

Question 9

Multiple choice

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

A
Store the bulk of the data on disk for retrieval when required (warm data)
B
Store the most relevant data in a compressed column store (hot data)
C
Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data)
D
Store all data in compressed column stores to maximize performance (hot data)
E
Move less important data into an external storage system (cool data)

Reveal answer details Close answer details

Correct answersA, B, E

Question 10

Multiple choice

Why are DataStore Objects so important? Choose the correct answer(s).

A
They can overwrite data.
B
They store detailed data leaving Infocubes to store aggregated data.
C
They allow for raw uncleansed data to be stored for 3 months.
D
They easily integrate in the data flow.

Reveal answer details Close answer details

Correct answersA, B, D

Question 11

Single choice

How many dimension tables can the SAP BW system administrator create per Infocube?

A
13
B
16
C
233
D
248

Reveal answer details Close answer details

Correct answerB

Question 12

Single choice

By using a MultiProvider on top of each InfoCube to control query access, you significantly reduce the effort required, for example, to copy queries after remodeling takes place. Determine Whether this statement is true or false.

A
True
B
False

Reveal answer details Close answer details

Correct answerA

Question 13

Multiple choice

Which of the following activities are part of the realization phase of an SAP Business Warehouse (SAP BW) project? Note: There are 3 correct answers to this question.

A
Design the data layer concept based on the LSA++ architecture.
B
Create functional and technical documentation.
C
Define a service level agreement.
D
Build SAP HANA views and define their properties.
E
Create and activate SAP BW objects.

Reveal answer details Close answer details

Correct answersB, D, E

Question 14

Multiple choice

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

A
Attributes
B
Hierarchies
C
Text Information
D
Dimension
E
Transaction codes

Reveal answer details Close answer details

Correct answersA, B, C

Question 15

Single choice

Unlike the classic star schema where facts are stored in the fact table, in SAP HANA, multiple views may

be used to represent the central fact view in a virtual data model. Determine Whether this statement is true or false.

A
True
B
False

Reveal answer details Close answer details

Correct answerA