C_TBW60_74 Online Practice Questions and Answers

Your InfoCube contains the following Key Figures: Planned Amount, Budgeted Amount, Forecasted Amount, Planned Quantity, Budgeted Quantity and Forecasted Quantity. You want to reduce the number of Key Figures to only Amount and Quantity and still retain the uniqueness of key figure values? How can you accomplish this? There are 2 correct answers.

A. Create a new Dimension table containing a Characteristic to distinguish the key figure types.

B. Create three InfoCubes; one each for Planned, Budgeted and Forecasted key figure values.

C. Create Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types.

D. Use the Select option "Unique for Every Cell" in the distinguishing Characteristic.

What are the differences between the Reporting and Operational Data Store (ODS) layers in LSA if both are reportable? (2)

A. They can use different InfoProvider types

B. The ODS layer is typically used for archiving

C. They differ in data refresh requirements

D. They differ in the granularity of data

E. They can use different InfoProvider types

You have created a new Data Flow object in the graphical sAP BW data Flow tool by copying a Data Flow template. What must you do to use the new Data Flow? (1)

A. Copy non-persistent SAP BW Objects

B. Validate non-persistent SAP BW Objects

C. Activate non-persistent SAP BW Objects

D. Replace non-persistent SAP BW objects with active SAP BW objects

Which of the following does the data propagation layer of your SAP BW system offer? There are 2 correct answers.

A. Complete data history.

B. Fast load of mass data.

C. A single version of the truth.

D. Ability to extract once and deploy many times.

E. A single version of the truth.

You want postable nodes in a hierarchy to appear in multiple hierarchy branches. What action could you take to accomplish this? (2)

A. Enter the postable nodes as Link Nodes

B. Configure the hierarchy as time-dependent

C. Create multiple similar hierarchies

D. Configure the hierarchy with a time-dependent structure

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

A. You can inspect the contents of the fact table only

B. Repair and rebuild indices

C. Gain an overview of SID values

D. Roll-up requests into aggregates regardless of the activation status of the aggregate

E. Repair and rebuild indices

Which of the following are true regarding navigational attributes? There are 3 correct answers.

A. They are directly linked to the InfoCube Dimension tables.

B. They must be switched on for specific InfoProviders.

C. They do not generate additional tables outside the InfoProvider.

D. Behave like Characteristics in a Dimension table.

E. Must be part of the definition of the Characteristic InfoObject definition.

You have configured an extraction of master data from an SAP ERP source system. After the first extraction, all of the previously extracted data is being loaded. What could be the possible cause? There is one correct answer.

A. The DataSource extraction type has been set to "Full."

B. The InfoPackage has been set to "Full" update.

C. The subsequent Transformation has rules set to "Addition."

D. There is no delta data in the PSA table.

E. The DataSource has been configured with interim storage.

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.

Which is the best way to model the object "Price?" There are 2 correct answers.

A. If the price of an object changes slowly, model it as a navigational attribute.

B. If the desired result is the price paid by a customer at the time of the Transaction, model price as a calculated Key Figure.

C. Leave it out of the data model.

D. If the price of an object changes slowly, model it as a display attribute.