VCEdump

C_TBW60_74 SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4

PDF question preview Back to product

Free preview

15 sample questions

The complete product contains 99 questions.

Question formats

Single choice4

Multiple choice11

Compare study plans

SAP · C_TBW60_74

C_TBW60_74 questions and answers

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

Question 1

Multiple choice

You are executing a process chain to load transaction data from an SAP source system via a standard DSO into an InfoCube but NO DATA arrives in the InfoCube.
What are possible reasons for this?
(2)

A
The data does NOT meet the selection criteria of the DTP
B
The data comprises an error and the error handling setting is set to "Cancel Request, Do Not Track Records, No Update"
C
The Data Flow object has NOT been activated
D
The Integrity check is NOT switched on in the transformations

Reveal answer details Close answer details

Correct answersA, B

Question 2

Single choice

You are not able to delete a request from a DSO. What best describes the situation? Select the correct answer

A
The request has been compressed.
B
The request is contained in an Aggregate.
C
The request is contained in a subsequent InfoProvider.
D
The request must be deleted selectively.

Reveal answer details Close answer details

Correct answerC

Question 3

Multiple choice

What is necessary for a VirtualProvider to display data? There are 3 correct answers.

A
A DTP for Direct Access
B
A DataSource for Direct Access
C
HybridProvider
D
MultiProvider
E
DTP that loads data
F
Transformation

Reveal answer details Close answer details

Correct answersA, B, F

Question 4

Multiple choice

Which of the following statements about aggregates is true? (2)

A
Aggregates can only be created for Basic Cubes
B
Aggregates are stored as a single transparent table, which houses the aggregated data
C
Aggregates can be created on dimension characteristics and navigational attributes
D
Several dimension characteristics used in an aggregate always have the same aggregation level
E
Aggregates reduce the number of key figures

Reveal answer details Close answer details

Correct answersA, C

Question 5

Multiple choice

When should you use the Generic Data Extractor tools to create a data source? There are 3 correct answers.

A
When Business Content does not contain a data source for your application.
B
When you use customer written programs in R/3 to populate your tables.
C
When the data to be extracted is highly granular.
D
When the application does not feature its own data extraction method.
E
If you want to extract data without delta extractions.

Reveal answer details Close answer details

Correct answersA, B, D

Question 6

Multiple choice

Which of the following record modes delivered by a DataSource can you directly upload to an InfoCube?
There are 3 correct answers.

A
Reverse Image
B
Before Image and After Image
C
Delete Image
D
Additive Image
E
After Image

Reveal answer details Close answer details

Correct answersA, B, D

Question 7

Multiple choice

What are the features of using the Operational Data Provisioning (ODP) Infrastructure in BW 7.4? There are 3 correct answers.

A
Extract once and deploy many times.
B
Relies on the proven Delta Queue technology.
C
High compression rate up to 90% of extracted data.
D
Single point of monitoring.
E
Makes complete use of mandatory PSA's.

Reveal answer details Close answer details

Correct answersA, B, D

Question 8

Single choice

Which of the following objects can you use as a source objects for a Transformation object? (2)

A
Transient Provider
B
InfoSet
C
Open Hub Destination
D
InfoSource
E
InfoSet

Reveal answer details Close answer details

Correct answerD

Question 9

Single choice

Which of the following initial tasks should you perform when designing an SAP BW data model? There are
2 correct answers.

A
Evaluate the volume of data to be loaded.
B
Derive the customer specific LSA.
C
Analyze relationships between the characteristics and their attributes.
D
Evaluate the format of data to be loaded.
E
Evaluate the volume of data to be loaded.

Reveal answer details Close answer details

Correct answerB

Question 10

Multiple choice

Partitioning can be used to either aid query response time or manage large amounts of InfoCube data.

Which of the following statements are true about InfoCube partitioning? There are 2 correct answers.

A
Logical and table partitioning cannot be combined.
B
The Analytic Engine can do partition pruning.
C
Table partitions are based either on 0CALMONTH or 0FISCPER.
D
The Repartitioning toolbox can be used with logical partitioning.

Reveal answer details Close answer details

Correct answersB, C, D

Question 11

Multiple choice

Which of the following process chain collector steps prevent multiple executions of a successor process?
There are 2 correct answers.

A
The Start process step triggered by a Meta Chain.
B
The Exclusive OR process step.
C
The OR process step.
D
The Attribute Change Run process step.
E
The AND process step.

Reveal answer details Close answer details

Correct answersB, E

Question 12

Multiple choice

What are the indications of a missing or inappropriate aggregate? There are 3 correct answers.

A
Percentage of total query time spent on the database exceeds 30%.
B
Ratio of number of rows selected to total query run time exceeds 10%.
C
Database time less than 2 seconds.
D
Ratio of number of rows transferred to the number of rows selected is greater than 10%.

Reveal answer details Close answer details

Correct answersA, C, D

Question 13

Multiple choice

what does SAP recommend you do to improve the overall reporting performance of a standard InfoCube in SAP BW 7.4? (3)

A
Create aggregates
B
Replace the InfoCube by a SPO
C
Use the process type "Fill OLAP cache" in a process chain
D
Use navigation attributes instead of dimension characteristics
E
Use several InfoCubes as PartProviders of a MultiProvider instead of a single standard InfoCube

Reveal answer details Close answer details

Correct answersA, B, E

Question 14

Single choice

You want to report on a MultiProvider containing a Standard DSO and an InfoCube. Data in the InfoCube has been archived to a SAP IQ near line storage system. Queries written for the MultiProvider do not display the archived data.What setting should you check? Select the correct answer.

A
Release OLE DB for OLAP
B
Read Mode
C
NLS Usage
D
Data Integrity

Reveal answer details Close answer details

Correct answerC

Question 15

Multiple choice

Your customer wants to model their SAP BW system according to best practices. You propose using a layered scalable architecture (LSA). Which of the following steps must you perform? There are 2 correct answers.

A
Model disjunct transaction and master data domains for application-specific reporting.
B
Implement the entire corporate information factory enterprise data warehouse architecture.
C
Define specific scenarios for data logistics shaped by the customer environment.
D
Determine which LSA layers are relevant based on the customer's requirement and objectives.

Reveal answer details Close answer details

Correct answersC, D