SAP C_TBW45_70 Online Practice Questions and Exam Preparation

SAP C_TBW45_70 Online Questions & Answers

• Question 1:

  If two queries are inserted into the same worksheet in a workbook, which of the following is a potential conflict?

  A. The results for one query could affect the results for the other query.
  B. The first query on the worksheet is the only query accessible by the user.
  C. If the user drills down in the first query, the query result could possibly extend into the area occupied by the second query.
  D. The security settings of the first query would override the security settings of the second query.
  C. If the user drills down in the first query, the query result could possibly extend into the area occupied by the second query.

• Question 2:

  You are explaining to your customer some of the key features of the web-based Planning Modeler. Which of the following comments are correct? In the web-based Planning Modeler, you can: (Choose two)

  A. View and edit InfoObjects.
  B. Select a key date for time dependent master data determination on the aggregation level tab.
  C. View and change master data with the 'input template' in a planning sequence.
  D. Create and test planning functions.
  B. Select a key date for time dependent master data determination on the aggregation level tab.
  D. Create and test planning functions.

• Question 3:

  Which InfoProviders are available for queries that provide master data lists? (Choose two)

  A. InfoCubes
  B. InfoSets which contain InfoObjects
  C. All InfoObjects
  D. Characteristic InfoObjects with master data
  B. InfoSets which contain InfoObjects
  D. Characteristic InfoObjects with master data

• Question 4:

  Which of the following benefits can be realized when SAP NetWeaver Exchange Infrastructure is used to integrate SAP NetWeaver BI with multiple sources systems? (Choose two)

  A. SAP NetWeaver Exchange Infrastructure reduces the number of peer-to-peer connections to the BI system.
  B. SAP NetWeaver Exchange Infrastructure can load data directly into InfoCubes and DataStore Objects.
  C. SAP NetWeaver Exchange Infrastructure provides a central place to manage protocols and communications.
  D. SAP NetWeaver Exchange Infrastructure functionality replaces transformation capabilities from SAP NetWeaver BI.
  A. SAP NetWeaver Exchange Infrastructure reduces the number of peer-to-peer connections to the BI system.
  C. SAP NetWeaver Exchange Infrastructure provides a central place to manage protocols and communications.

• Question 5:

  Which of the following are true concerning conceptual layers in Data Warehousing? (Choose two)

  A. The Operational Data Store layer consists of the processes that manage data within and across the data warehouse and data marts. It is mainly used for backup and recovery, and reloading data.
  B. The Persistent Staging Area layer is the central point of data integration in the Data Warehouse. It delivers a common and historic view of enterprise data.
  C. The Data Warehouse layer is a subject-oriented, integrated and non-volatile collection of data. It is the source of data for the data marts, delivering a common view of enterprise data.
  D. The Data Mart layer is customized and/or summarized data derived from the data warehouse and tailored to support the specific analytical requirements of a business unit or function.
  A. The Operational Data Store layer consists of the processes that manage data within and across the data warehouse and data marts. It is mainly used for backup and recovery, and reloading data.
  C. The Data Warehouse layer is a subject-oriented, integrated and non-volatile collection of data. It is the source of data for the data marts, delivering a common view of enterprise data.

• Question 6:

  The Remodeling Toolbox allows you to define:

  A. Several subsequent remodeling steps for your most important BI Objects like Queries, InfoProviders and Process Chains.
  B. A single remodeling step for InfoCubes or DataStore Objects. Before executing the remodeling process the corresponding InfoProviders have to be emptied.
  C. Several remodeling steps for an InfoCube without the need to empty this InfoCube. Remodeling steps can, for example, include adding key figures, or replacing characteristics.
  D. A remodeling rule for a process chain, including an integrated batch process consumption check and rescheduling.
  C. Several remodeling steps for an InfoCube without the need to empty this InfoCube. Remodeling steps can, for example, include adding key figures, or replacing characteristics.

• Question 7:

  The APD (Analysis Process Designer) in SAP NetWeaver BI provides a mechanism for reading data from a source and then transferring the analytical results back out to a data target. In this scenario, which of the following are possible data targets of the APD? (Choose two)

  A. Standard DataStore Objects
  B. VirtualProviders
  C. Meta Data Repository
  D. DataStore Objects for direct update
  E. InfoObject master data tables
  D. DataStore Objects for direct update
  E. InfoObject master data tables

• Question 8:

  The star schema in SAP NetWeaver BI is an enhancement upon the classic star schema due to the following... (Choose two) A. ... aggregated key figures are stored in fact tables.

  B. ... master data is stored outside the star schema.
  C. ... external hierarchies are used.
  D. ... the usage of dimensions.
  B. ... master data is stored outside the star schema.
  C. ... external hierarchies are used.

• Question 9:

  Which of the following capabilities are included in SAP NetWeaver 7.0 BI Document Integration? (Choose three)

  A. Mail merge
  B. Online editing and creation of documents
  C. Uploading documents via BEx Web
  D. Document archiving
  E. Knowledge Management and Collaboration Services for documents
  B. Online editing and creation of documents
  C. Uploading documents via BEx Web
  E. Knowledge Management and Collaboration Services for documents

• Question 10:

  What data handling options exist when using Universal Data Connect (UDC)? (Choose two)

  A. Persistent data handling: Data is extracted to SAP NetWeaver BI using UDC DataSources and stored in InfoProviders.
  B. Operational data handling: UDC DataSources always push current delta data to PSA tables.
  C. Hierarchical data handling: UDC DataSources extract data in one header segment and different data segments.
  D. Transient data handling: UDC DataSources are used within VirtualProviders which allow direct access to UDC source systems.
  A. Persistent data handling: Data is extracted to SAP NetWeaver BI using UDC DataSources and stored in InfoProviders.
  D. Transient data handling: UDC DataSources are used within VirtualProviders which allow direct access to UDC source systems.