C_TBW45_70 - SAP Certified Application Associate- Business Intelligence with SAP NetWeaver 7.0
Go back to SAP
What data handling options exist when using Universal Data Connect (UDC)? (Choose two)
Persistent data handling: Data is extracted to SAP NetWeaver BI using UDC DataSources and stored in InfoProviders.
Transient data handling: UDC DataSources are used within VirtualProviders which allow direct access to UDC source systems.
Hierarchies can... (Choose two)
..be evaluated flexibly at query runtime by using hierarchy variables.
..be restricted using fixed hierarchy nodes or a hierarchy node variable.
Universal Data Connect (UD Connect) supports data access seamlessly across both SAP and non-SAP systems. Which of the following are components of UD Connect? (Choose two)
The IT Scenario 'Enterprise Data Warehousing' in SAP NetWeaver BI includes which of the following features? (Choose three)
Open Hub Service
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 DataStore Object can be used to transfer changed data records to other InfoProviders even for non-delta-enabled DataSources.
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.
The design mode of the BEx Analyzer allows you to: (Choose two)
Add your own navigation controls such as drop down lists and check boxes.
Insert results from other data providers into the same workbook.
Please evaluate the following statements on source and targets for Transformations in SAP NetWeaver BI. Transformations: (Choose two)
Can connect a DataSource to an InfoProvider or an InfoProvider to another InfoProvider.
Can connect an InfoSource to an InfoProvider.
Regarding currency translation, which of the following statements are true? (Choose two)
Translating currency during query execution provides for maximum flexibility in the choice of target currency.
Translating currency as data is loaded using transformations can improve query performance by avoiding currency translation at query execution time.
Which aspects should guide you most when designing the meta data for your SAP NetWeaver BI Objects? (Choose two)
Coherence with business requirements
Consistency with already existing meta data models at customer site
Which of these statements about the line item dimensions of an InfoCube are correct? (Choose two)
The creation of a line item dimension is a modeling technique to improve reading performance from InfoCubes.
When a line item dimension is used, the dimension table is omitted.
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)
DataStore Objects for direct update
InfoObject master data tables
Web services enable data integration through XML. Which of the following BI objects provide XML data? (Choose two)
Web Service DataSources
XMLA Java Connector
Characteristic value variables...
..are created for a characteristic in the query definition and are available for all query definitions of InfoProviders containing this characteristic.
Your client is interested in the various formats used to distribute BI information. Which of the following formats are available? (Choose three)
Precalculated BEx Analyzer Workbooks.
Precalculated MHTML file.
Online links to current data.
A BEx Analyzer workbook can be based on which of the following? (Choose three)
A Query view created with the BEx Analyzer
Which of the following statements about the size of a dimension is true?
The absolute number of entries in a dimension should be as small as possible.
Regarding web analysis, which of the following statements are true? (Choose three)
You can navigate to a web-based output from a BEx Analyzer view of the query result.
From a web-based presentation of the query results, you can generate a Microsoft Excel workbook output.
One or more queries can feed a single Microsoft Excel workbook or a single Web Application.
Your client is interested in the general features related to the SAP NetWeaver Portal. Which of the following are correct features that you could communicate back to the client? (Choose two)
The SAP NetWeaver Portal enables you to access applications from other systems and sources, such as the Internet or intranet.
Using one entry point, you can reach both structured and unstructured information.
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)
SAP NetWeaver Exchange Infrastructure reduces the number of peer-to-peer connections to the BI system.
SAP NetWeaver Exchange Infrastructure provides a central place to manage protocols and communications.
DataSources in SAP NetWeaver 7.0 BI: (Choose three)
Can include a PSA table. The PSA table is the persistent inbound layer for all data that is transferred from the source system to SAP NetWeaver BI for a given DataSource.
Can support preview features allowing you to test the data transfer from the source system without the need for transformations.
Define the Delta Process, the Direct Access and the Real-Time Data Acquisition (RDA) capabilities for the transfer of business specific data from a source system to SAP NetWeaver BI.
Which of the following are valid variable Processing Types? (Choose four)
Manual Entry / Default Value
Which of the following statements about navigation attributes is correct?
You can add navigation attributes to the data model of an InfoCube, without having to reload the data that is already contained there.
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)
Select a key date for time dependent master data determination on the aggregation level tab.
Create and test planning functions.
Which of the following tasks can be performed in or can be called from the Data Warehousing Workbench? (Choose three)
Creation of DataStore Objects
Process Chain Maintenance
Creation of SAP Transports for BI Objects
Displaying query results in various formats is a necessary requirement for the reporting requirements of an enterprise. To enhance the end-users access to BI queries, the BEx Web Analyzer offers... (Choose three)
.. graphical display and interactive analysis of data.
.. access to any authorized query or query view.
.. access to BEx Broadcaster.
Your customer has requested that the list of steps required to build a planning web application be used exclusively for manual planning. Which of the following are required? (Choose three)
Create a data provider and select an input ready query, or query view of an input ready query.
Drag and drop an Analysis item into the web template.
Bind the items in the web application to the appropriate data providers.
A Key Figure InfoObject ... (Choose two)
.. can have, amongst others, the data type Amount, Quantity or Number.
.. can have an exception aggregation. This field sets how the key figure is aggregated in the Business Explorer in relation to a given reference characteristic. Example: AVG (average).
The Remodeling Toolbox allows you to define:
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.
Which definition best describes a "Bookmark"?
A URL which links to a predefined navigation state of a BI Web Application.
Which of the following terms exist in the definition of the delta method? (Choose three)
For a query definition... (Choose two)
..a DataStore Object can be selected as the InfoProvider
..a MultiProvider can be chosen as the InfoProvider.
Which InfoProviders are available for queries that provide master data lists? (Choose two)
InfoSets which contain InfoObjects
Characteristic InfoObjects with master data
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)
.. an integrated Chart Wizard.
.. chart editing features.
Which of these statements about InfoCubes and aggregates are correct? (Choose two)
The attribute change run guarantees synchronization between the aggregate and the new or modified master data to which the InfoCube is linked.
Aggregates that contain navigation attributes or that link to hierarchies are influenced by changes to the attributes and hierarchies.
In the BEx Web Analyzer, when creating an exception for an analysis using the Exception Wizard, which of the following features are available? (Choose three)
You can specify that the exception is either a 'Status' exception for absolute numbers, or a 'Trend' exception for relative numbers.
You can specify that the exception is shown for the evaluated structure element, a different structure element, or all structure elements of the query.
You can limit the data that is evaluated for the exception using the characteristic restriction settings.
What is the functionality of Real-time Data Acquisition (RDA) in SAP NetWeaver BI? With Real-time Data Acquisition: (Choose two)
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.
Background processes (daemons) in the SAP NetWeaver BI system initiate at regular time intervals the InfoPackages and Data Transfer Processes assigned to them.
Which of the following statements are true concerning direct access by queries to data in source systems? (Choose two)
Direct access is possible for transaction data (using VirtualProviders) as well as for master data.
Direct access is possible for DB Connect, UD Connect, File and selected SAP source system DataSources only.
For which purposes are process chains used? (Choose two)
For central scheduling of BI loading and administration jobs
For pro-active monitoring of BI loading and administration jobs (connected to basis monitors (CCMS), e-mail notifications, etc.)
A Section in the Report Designer is assigned to a:
In reports, the sales volumes should be analyzed according to profit center managers. Over time, the assignment of managers to different profit centers changes. The revision department requests that the sales volumes in the reports are correctly totaled for the manager who was responsible at the time of the transaction. How can you map these reporting requirements in the data model?
With a characteristic "profit center" and a characteristic "manager" that are used in the same InfoCube.
Which of the following statements are true regarding sections in the Report Designer? (Choose two)
A static section is based on a data provider that has an underlying query containing two structures.
A dynamic section is based on a data provider that has an underlying query containing one structure.
Which of these objects can be used to define a MultiProvider? (Choose four)
Characteristic InfoObjects (with attributes or texts)
Your customer needs a way to make the Integrated Planning more flexible. You have suggested using variables. Which of the following comments regarding variables are correct? (Choose three)
They parameterize characteristic values in filters, queries, functions, characteristic relationships, and data slices.
Variables created in filters can also be used in queries. Therefore, they are shareable objects, and result in less configuration.
Users can personalize their variable values and save them as variants.
Where can variables be created? (Choose two)
In the query definition where they are needed.
When defining exceptions and conditions.
If two queries are inserted into the same worksheet in a workbook, which of the following is a potential conflict?
If the user drills down in the first query, the query result could possibly extend into the area occupied by the second query.
One of your customers needs to know the BEx Broadcaster options for sending static snap-shots of data. What would you tell them? (Choose three)
For workbooks, send as E-Mail as a Zip File.
For a web template, send as 'Independent HTML File'.
For a web template, send as 'HTML with Separate MIME Files' as a Zip File.
In your planning project you have a basic InfoCube containing the actual data and a Real Time InfoCube containing the plan data. You want to use actual and plan data at the same time in your Integrated Planning scenario. Which of the following statements are correct? (Choose two)
You can include the actual InfoCube and the plan InfoCube in a MultiProvider, create an aggregation level on the MultiProvider, and create a distribution function that distributes plan data according to the actual data.
You can create an aggregation level on the Real Time InfoCube and combine it with the actual InfoCube in a MultiProvider. On the MultiProvider you can create a plan query that shows actual and plan data.
Organizations that are 'data rich, but information poor' might gain from the business knowledge discovered through data mining. Which of the following are true regarding data mining? (Choose three)
Clustering is a data mining method.
Data mining is an analytical approach that looks for hidden information patterns in large databases.
Regression analysis is a data mining method.
Which of these statements about the delta queue are correct? (Choose two)
The delta queue extraction can be repeated after problems in the data loading process.
Delta intialization of a DataSource is required before the delta queue can be used.
Which of the following statements regarding BEx Query Designer are correct? (Choose three)
You can save a query that contains errors.
If a query contains errors, the system provides information to help you correct them, including menu options that may be suitable.
You can maintain many of the properties of multiple characteristics or key figures simultaneously.