最新的SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 - C_TBW60_74免費考試真題

A. Aggregates on this InfoCube do NOT need to be built

B. The primary key of the InfoCube fact table is shorter

C. the number of joins that must be executed during query runtime is reduced

D. Data is loading into the InfoCube without generating DIM IDs for this dimension

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

B. Leave it out of the data model.

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

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

A. For a query to use data in an aggregate with a time-dependent component, the query's key date does not have to match the key date of the aggregated

B. The key date for an aggregate with a time-dependent component is always a fixed date

C. When aggregates with a time-dependent component are filled the key date is retrieved

D. Aggregates with time-dependent components are calculated for a key date

A. Too many key figures in the Columns area of the query default view.

B. Overlapping filters.

C. Too many characteristics in the Rows area of the query definition.

D. Too many characteristics in the Free Characteristics of the query definition.

E. Overuse of filter exclusions on the Filter tab of the query definition.

A. The DataSource has a delta process of FIL0.

B. The DTP, however, is having trouble loading the data into an InfoCube. What could be the possible solution? Select the correct answer.

C. The BW DTP is set to Full extraction.

D. The BW DTP is set to Full extraction.

E. The Transformation does not have rules for all destination fields.

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

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. Create a new Dimension table containing a Characteristic to distinguish the key figure types.

A. SAP BW Data Warehousing Workbench

B. SAP BW Statistics

C. SAP BI Content

D. SAP BW Accelerator (BWA)

A. They are designed in Business Explorer queries

B. Their calculation is accomplished in Transformations

C. They can utilize a virtual Key Figure to combine inflows and outflows

D. They can utilize two virtual Key Figures to represent inflows and outflows

E. They can utilize a virtual Key Figure to combine inflows and outflows

A. Business Content does not need to be activated.

B. Reporting requirements are the necessary starting point.

C. Reference to BW Business Content should be conducted during the development of the data model.

D. Reporting requirements are the necessary starting point.

E. BW objects are created with reference to administrative needs.

F. Different types of reporting end-users can be ignored.

A. Create more than 13 custom-defined Dimensions.

B. Associate unrelated Characteristics in a single dimension.

C. Reduce the number of Characteristics down to 13.

D. Use more than one InfoCube in the design.

E. Add the extra ones as Key Figures.