SAP C_TBW45_70 Online Practice Questions and Exam Preparation

SAP C_TBW45_70 Online Questions & Answers

• Question 51:

  Which of the following statements about the size of a dimension is true?

  A. The absolute number of entries in a dimension should be as small as possible.
  B. The relative number of entries in a dimension in relation to the fact table is the only factor that influences the performance of the system in the future.
  C. If a dimension has almost as many entries as the fact table, it and all of its characteristics must be categorized as a line item dimension.
  A. The absolute number of entries in a dimension should be as small as possible.

• Question 52:

  Which of these statements about the line item dimensions of an InfoCube are correct? (Choose two)

  A. Line item dimensions are recommended when few characteristic values are contained in a dimension (low cardinality).
  B. The creation of a line item dimension is a modeling technique to improve reading performance from InfoCubes.
  C. When a line item dimension is used, the dimension table is omitted.
  D. A line item dimension can contain more than one characteristic.
  B. The creation of a line item dimension is a modeling technique to improve reading performance from InfoCubes.
  C. When a line item dimension is used, the dimension table is omitted.

• Question 53:

  What extraction methods are available for generic DataSources in the SAP source system?(Choose three)

  A. InfoSets / SAP Queries
  B. Function modules
  C. DB views and tables
  D. Delta queue in the delta extraction
  A. InfoSets / SAP Queries
  B. Function modules
  C. DB views and tables

• Question 54:

  Which of the following statements about navigation attributes is correct?

  A. You can add navigation attributes to the data model of an InfoCube, without having to reload the data that is already contained there.
  B. The read mode of the query can be used to compensate for the loss in performance which arises from the additional read step in the selection using time-dependent navigation attributes.
  C. The time-dependent navigation attribute Material Group for characteristic Material can only be activated as a navigation attribute in an InfoCube if Material Group is also assigned to a dimension of the InfoCube.
  A. You can add navigation attributes to the data model of an InfoCube, without having to reload the data that is already contained there.

• Question 55:

  The new filter can be used in queries as well as in planning. Which of the following statements are correct? (Choose three)

  A. The default values determine the initial filter status of the query.
  B. The default values are ignored when using the filter for data selection in a planning sequence.
  C. 'Changeable upon execution' determines whether the value selection can be changed during query execution.
  D. Filters can be used in queries but they can only be created or changed in the planning modeler.
  A. The default values determine the initial filter status of the query.
  B. The default values are ignored when using the filter for data selection in a planning sequence.
  C. 'Changeable upon execution' determines whether the value selection can be changed during query execution.

• Question 56:

  Which of these statements about BI Content are correct? (Choose three)

  A. Industry-specific BI Content is developed.
  B. BI Content speeds up BI implementation.
  C. BI Content includes DataSources in SAP source systems.
  D. Before activating BI Content for SAP source systems, BI Content DataSources have to be activated manually in transaction SBIW in the SAP source system.
  A. Industry-specific BI Content is developed.
  B. BI Content speeds up BI implementation.
  C. BI Content includes DataSources in SAP source systems.

• Question 57:

  With the BEx Web Application Designer Chart Designer, a tool is provided that allows you to quickly and easily create different chart types for Web Applications based on the data of BI queries or query views. The features of the Chart Designer include... (Choose two)

  A. ... an integrated Chart Wizard.
  B. ... geographical analysis.
  C. ... chart editing features.
  D. ... suggest best chart type automatically.
  A. ... an integrated Chart Wizard.
  C. ... chart editing features.

• Question 58:

  Which of the following statements about a DataStore Object can be made with respect to the overall architecture of the BI system? (Choose two)

  A. A DataStore Object can be used to transfer changed data records to other InfoProviders even for non-delta-enabled DataSources.
  B. The DataStore Object is an important component of the DataWarehouse architecture in BI systems. It can serve as both a Target- and a Source-InfoProvider.
  C. Data from the DataStore object can only be updated into InfoCubes.
  D. Queries can be defined based on DataStore Objects of type "Standard" only.
  A. A DataStore Object can be used to transfer changed data records to other InfoProviders even for non-delta-enabled DataSources.
  B. The DataStore Object is an important component of the DataWarehouse architecture in BI systems. It can serve as both a Target- and a Source-InfoProvider.

• Question 59:

  What is the functionality of Real-time Data Acquisition (RDA) in SAP NetWeaver BI? With Realtime Data Acquisition: (Choose two)

  A. InfoPackages directly load to VirtualProviders where data is aggregated and calculated for Real- time Reporting in SAP NetWeaver BI Web Applications.
  B. Data is transferred into SAP NetWeaver BI at regular frequent intervals. This data is then updated to DataStore objects, where it is directly available for (operational) reporting.
  C. Data is transferred at query runtime (real-time) to VirtualProviders. No additional data storage is needed in SAP NetWeaver BI.
  D. Background processes (daemons) in the SAP NetWeaver BI system initiate at regular time intervals the InfoPackages and Data Transfer Processes assigned to them.
  B. Data is transferred into SAP NetWeaver BI at regular frequent intervals. This data is then updated to DataStore objects, where it is directly available for (operational) reporting.
  D. Background processes (daemons) in the SAP NetWeaver BI system initiate at regular time intervals the InfoPackages and Data Transfer Processes assigned to them.

• Question 60:

  Please evaluate the following statements on source and targets for Transformations in SAP NetWeaver BI. Transformations: (Choose two)

  A. Must use an intermediate InfoSource in order to connect a DataSource to an InfoProvider.
  B. Can connect a DataSource to an InfoProvider or an InfoProvider to another InfoProvider.
  C. Can only use one intermediate InfoSource between a DataSource and an InfoProvider.
  D. Can connect an InfoSource to an InfoProvider.
  B. Can connect a DataSource to an InfoProvider or an InfoProvider to another InfoProvider.
  D. Can connect an InfoSource to an InfoProvider.