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

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

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

C. Repair and rebuild indices

D. Gain an overview of SID values

E. Repair and rebuild indices

A. Surrogate IDs (SIDs) replace master data values in dimension tables.

B. Navigational attributes can be used.

C. Surrogate ID (SID) keys and DIM_ID keys are generated automatically.

D. Reporting access to granular data using standard dimensions is faster.

A. The Attribute Change Run process step.

B. The Exclusive OR process step.

C. The Start process step triggered by a Meta Chain.

D. The OR process step.

E. The AND process step.

A. Replace the InfoCube by a SPO

B. Use navigation attributes instead of dimension characteristics

C. Use the process type "Fill OLAP cache" in a process chain

D. Use several InfoCubes as PartProviders of a MultiProvider instead of a single standard InfoCube

E. Create aggregates

A. Ability to extract once and deploy many times.

B. Complete data history.

C. A single version of the truth.

D. Fast load of mass data.

E. A single version of the truth.

A. Compression leads to a reduction in storage space and an increase in read performance

B. The compressed data is retained in the F Table of the InfoCube

C. Once compression takes place it is still possible to manage individual request separately

D. During compression the Request ID in the Data Packet Dimension is ignored

A. Model Material and Group in the same InfoCube Dimension Table

B. Model Material Group as a time-dependent hierarchy of Material

C. Model Material Group as a time-dependent navigation attribute of Material

D. Model Material Group as a time-independent navigation attribute of Material

A. Extract once and deploy many times.

B. Relies on the proven Delta Queue technology.

C. Single point of monitoring.

D. Makes complete use of mandatory PSA's.

E. High compression rate up to 90% of extracted data.

A. DB Connect with a Microsoft Access database.

B. UD Connect with JDBC connectors to SQL Server.

C. Flat files.

D. SAP Data Services with the Service API.

E. BI Content with the Service API.

A. Configure the hierarch as version-dependent

B. Configure the hierarchy with link nodes

C. Configure the hierarch as version-dependent

D. Configure the hierarchy as time-dependent

E. Configure the hierarchy to have a time-dependent structure