What can you define when you model hierarchies for a characteristic? (3 correct answer in this question) The table structures of the hierarchies External Characteristics The maximum level of the hierarchy nodes Version-dependent hierarchies Time-dependent hierarchy structures.
How can you speed up an SAP BW implementation project? SAP BI Content SAP BW statistics SAP BW Accelerator (BWA) SAP BW Data Warehousing Workbench.
How can you prevent a process chain from starting immediately after activation? (2 correct answers) Maintain your process chain as a sub-process chain without startup process. Set the startup process to a specific time and date using the scheduling options "Direct scheduling" and "Change selections" Set the startup process using the scheduling option Metakette or AIP. Set a startup process for the process chain with default parameters.
You have created a HybridProvider with a DataStore object for realtime data acquisition (RDA). Which of the following must be done in SAP BW to load the data. The daemon has been assigned to the real-time InfoPackage New data is loaded into the delta queue of the SAP source system The data transfer process The Realtime InfoPackage.
What happens when you enable a request in a standard data store (DSO) object? (3 correct answers) Records are updated in the Active Data table. Records are aggregated in the Change Log table. Records are deleted from the activation queue. The records are compressed in the Active Data table Records are updated in the Change Log table.
Which of the following options does the data propagation layer of your SAP BW system offer? (2 correct answers) Homogenized data Fast processing of mass data (Fast load of mass data) The ability to extract once and reuse many times. Only version of the truth (single version of the truth).
What happens when creating an infocube? (3 correct answers) Navigation attributes are mapped to a separate dimension. Compounded characteristics of selected characteristics are selected Dimensions that contain multiple characteristics are set as line item dimensions. The characteristic 0REQUID (Request ID) is the data packet dimension The unit of measure or currency for each key figure is assigned in the dimension unit.
Which SAP BW InfoProviders can serve as data targets? (2 answers) Standard DataStore object. MultiProviders InfoSet InfoCube.
Which of the following tasks should you perform first if you want to design an SAP BW data model (2 answers) The amount of data to load Evaluate. Analyze the relationships between the features and their attributes Rate the number and type of users. Rate the data format.
What can you do before loading the motion data to improve performance? Update database statistics Roll up the aggregates Create additional indexes for the data targets Load master data.
In a customer hierarchy, customers are organized in regions and regions are assigned to different regional managers. A region must be assigned to two regional leaders. How do you model the hierarchy? Use link nodes Use two different hierarchy versions. Use a double Node. (Duplicate-nodes) Use temporal join hierarchy.
Why use transformation rules? (2 answers) To use an info pack as a source object. To enrich and change the extracted data. To enrich and change the extracted data. To harmonize data from different source systems.
When is a surrogate ID (SID) created in the SAP BW system? When first loading master data into a characteristic. When loading data into an Infocube for the first time. When a characteristic is first activated. When first activating an Infocube.
Which of the following standard aggregations can you select when modeling key figures in SAP BW? (3 answers) Last Value (LAS) Minimum (MIN) Summation (SUM) Average (AVG) Maximum (MAX).
What can you use to ensure that the daemon that triggers the Real-time Data Acquisition (RDA) for your sell orders ends at the end of a workday? (See note!) (2 answers) The data load monitor The Demon Monitor Transaction (RSRDA) Info Package Options A process chain.
Which of the following source system types enables real-time data acquisition? Universal data connect Web service Database connect File Interface.
What are the advantages of Enterprise Data Warehouse (EDW) layers? (2 answers) You can load delta data without overwriting older versions You can publish data in the SAP Enterprise Portal without creating queries You can extract the data once and use it on multiple data marts You can load data via process chains without InfoPackages.
You want to compare the order based on all existing and unchanged merchandise categories for a specific period of time. How should you model the material characteristic to achieve this? Characteristic Material and two selectable users Time attributes as time-dependent navigation attributes of the Merchandise category. Department and two selectable users Time attributes as time-dependent navigation attributes of the characteristic Material. Department and two selectable users Time attributes as a time-dependent display attribute of the material characteristic. Department as a time-dependent navigation attribute of the material characteristic.
What are the properties of a standard InfoCube? (2 answers) It can contain a maximum of 233 key figures It has at least four dimension tables It can combine several InfoProviders It is a write-optimized provider.
You load cost centers from different source systems with different data formats into SAP BW. You want to update the data in a single info provider with a source system How can SAP plan the data flow? Use a set of transformations and data transfer processes (DTPs) for each DataSource Data source-specific transformations bound to and InfoSource to an InfoProvider-specific transformation Design a real-time Data-Acquisition dataflow for an SAP BW InfoProvider Use a transformation for all data sources and InfoSource to an InfoProvider-specific transformation.
Your customer wants to save material data (InfoObject 0MATERIAL) and material proposal data (infoObject ZMAT_PROP). Both infoObjects should be based on the same material master data As reference characteristic to 0MATERIAL As navigation attribute of 0MATERIAL As a compounded characteristic for 0MATERIAL As display attribute of 0MATERIAL.
You have loaded data into a standard data store object. This data has not yet been activated. What can you do to speed up the activation process? In the settings of the default data store object, select SID generation on activation Create additional indexes for the default data store object Select the override option for the key figures transformation rule In the settings of the default Data Store object, select the unique records option.
In an SAP BW report, you want to display the Merchandise group of a material for a specific key date. What do you have to do to achieve this? Characteristic Material with the two additional attributes Valid from and Valid to Characteristic Merchandise as time-dependent attribute of the characteristic material Material and Merchandise group as Info Provider characteristics Material characteristic as a time-dependent attribute of the characteristic Merchandise Group.
When does the SAP BW system create a replacement ID table (SID)? When you first activate a characteristic When loading data into an Infocube for the first time When first loading master data into a characteristic When first activating an Infocube.
Which action can you perform for a SAP BW characteristic Info-Object? Add additional attributes. Change the reference characteristic. change the attribute type Add hierarchies.
Which of the following InfoProviders do you use to model the operational data store layer in SAP BW? (2 answers) Direct access to data store object HybridProvider TransienteProvider Write-optimized data store object.
Which of the following layers are part of an architecture data mart layer? (3 answers) Reporting Quality and Harmonization Data propagation Virtualization Business transformation.
Which tool can you use to perform maintenance and administration tasks in SAP BW? SAP Change and Transport Organizer SAP Business Explorer SAP BW statistics SAP Data Warehousing Workbench.
Your customer migrates his SAP BW 3.x data flows to SAP BW 7.x data flows. Which of the following new objects does the customer need to use now? DataSource Data transfer process (DTP) InfoSource Info package.
You want to transfer data from an infocube in an SAP BW system A to an infocube in the SAP BW system B. Which sets of objects can you use? (2 answers) - Target Infocube as Open Hub Destination
- Transformation
- Data transfer process - Operational Data Provisioning (ODP) Source System
- DataSource for the InfoProvider of SAP BW System A
- Transformation
- Data Transfer Process - Generic DataSource
- Replicated Generic DataSource
- InfoPackage
- Transformation
- Data Transfer Process - Export DataSource
- Replicated Export DataSource
- InfoPackage
- Transformation
- Data Transfer Process.
You have created a new data flow in SAP BW by copying a data flow template. What do you need to do to use the new data flow? Validate non-persistent SAP BW objects Do not copy persistent SAP BW objects Replace non-persistent SAP BW objects with active SAP BW objects Activate non-persistent SAP BW objects.
Which of the following sources can the SAP Landscape Transformation Replication Server (SLT) use for data collection in SAP BW? (2 answers) Delta Queue tables from SAP ERP DataSources Customer-specific tables from SAP ERP Extractors with a delta mechanism for SAP ERP tables Tables from non-SAP sources.
All data updates in a standard DataStore object succeed, but the report does not show the correct results. You want to run the DTP again. What do you need to do before reloading to investigate this problem? Set up caching in the data transfer process Define filters in the data transfer process track every record in the persistent staging area (PSA) define semantic groups in the data transfer process.
You load material master data from two different source systems. In system A, the material '123' is a hammer, but in system B, the material '123' is a food. How should you model the feature 0MATERIAL in SAP BW to keep the material IDs unique? With the time-independent navigation attribute 0SOURSYSTEM With the time-dependent navigation attribute OSOURSYSTEM Compounded with the characteristic 0SOURSYSTEM With the time-independent display attribute OSOURSYSTEM.
Which InfoProvider type do you typically use for the virtualization layer in an enterprise data warehouse architecture? TransientProvider CompositeProvider HybridProvider MultiProviders.
You want to migrate the 3.x version of an SAP BW dataSource to a 7.x version with the option to restore the original version Create a transformation to replace the transfer rules. Version 3.x DataSource with their mapping and transfer structures export. Replace the 3.x SAP BW InfoSource with a 7.x version SAP BW InfoSource. Delete all entries from the Persistent Staging Area (PSA).
Which of the following objects can you use as a source for a transformation? (2 answers) VirtualProvider infoset Open Hub destination InfoSource.
Which of the following SAP BW objects can you use to build aggregates? (2 answers) Characteristic Surrogate IDs (SIDs) KPI values hierarchical levels.
In which shift structure (LSA) of SAP BW do you model business requirements? Enterprise Data Warehouse Quality and Harmonization Architected Data Mart Data propagation.
When loading data from a data source into an InfoCube, your customer wants to add the person responsible for a cost center to the transaction data. The responsible person is an attribute of a characteristic. Which SAP BW transformation rule types should you use to achieve this? (2 answers) routine Direct assignment constant Read master data.
What happens if you compress the data of an InfoCube? The granularity for a feature is reduced The Request Identifier (ID) is set to zero The star schema is redefined Default dimensions are changed to line-item dimensions.
Some queries based on the SALES InfoCube take too much time. What actions can you take to improve the performance of these queries? (2 answers) Load master data before the transaction data Schedule attribute change run after loading the data Partition SALES InfoCube Create aggregate for these queries.
What are the requirements for adding a new characteristic in a DataStore object (DSO) with the Remodeling Toolbox? (2 replies) The cache memory has been deleted Change-log table is empty Request Service, which load data into the DSO, has been stopped A system handling was carried out.
What do you need to create to use Data Transfer Process (DTP) error handling? A DTP with extraction mode FULL A process chain with the DTP A DTP with extraction mode INITIAL A DTP with (the transmission method) Persistent Staging Area (PSA).
Which archiving strategy would reduce the SAP BW database size and still enable ad hoc reports? Nearline storage archiving for InfoProvider data Load the archived data back into the InfoProvider Classic archiving for data management and log data XML-based archiving to a Web DAV system for InfoProvider data.
You want to use SAP Operational Data Provisioning (ODP) to load daily changes to sales data from a legacy system to SAP BW. What is the correct sequence of tasks that you need to perform in SAP BW? 1. Create ODP DataSource
2. Create Transformation
3. Create and load a delta initialization info pack without a persistent staging area (PSA)
4. Create and load a data transfer process (DTP) in delta mode 1.Create a Data Store Object (DSO)
2. Create an ODP DataSource
3. Create and load a Delta Initialization Info Package without a Persistent Staging Area (PSA)
4. Create and load a data transfer process (DTP ) in delta mode 1. Create an ODP DataSource
2. Create a Data Store Object (DSO)
3. Create a transformation
4. Create and load an InfoPackage for delta initialization without a persistent staging area (PSA) 1. Create ODP DataSource
2. Create Data Store object (DSO)
3. Create transformation
4. Create and load a data transfer process (DTP) for delta initialization without a persistent staging area (PSA).
What can you do if you model a MultiProvider to ensure optimal query performance? Select the nominal key figures for the multiprovider Select parts of the compounded characteristics for the MultiProvider Select Characteristics for Reports (Report), which are available in all components Assign the characteristics for uniform reporting between the dimensions.
What are features of the Hierarchy Extraction Transformation and Loading (ETL) concept of SAP BW 7.3 or higher? (3 answers) It provides Hierarchy DataSources for all types of source systems He uses the Application Link Enabling (ALE) Inbox The InfoPackage controls the file format of the hierarchy data It uses transformations and data transfer processes (DTPs) It can use start, end and expert routines within transformations.
Which of the following can you do with the metadata repository? Activate activated installed SAP BI Content objects Install SAP BI Content Objects Customizing SAP BI Content Objects Search for installed SAP BI content objects.
Your DataSource only offers After Image Delta. Which InfoProvider can be loaded directly via this DataSource? Infocube InfoSet DataStore object (DSO) VirtualProvider.
What can you define in a BW currency type? (2 answers) Exchange rate type Transformation rule type target currency currency table.
Which of the following objects in SAP BW can you use as the target of a transformation? (2 answers) DataSource DataStore Object MultiProviders InfoCube.
You want to reuse the same transformation program to harmonize customer master data in different data formats from multiple source systems and transfer rules or transformations. Which routine can you use? Begin Global Local Expert.
Which of the following SAP BW InfoProviders are used in the report layers of a Layered Scalable Architecture (LSA)? (2 answers) Infosource Datasource MultiProviders DataStoreObject (DSO).
What can you do with the hierarchy framework when loading hierarchies into SAP BW? (2 answers) You can identify the details of the nodes that are built from characteristics You can expand the hierarchy if the field length is changed You can use multiple Persistent Staging Area (PSA) for each segment of the hierarchy You can expand the hierarchy by using star, end, and expert routines in the transformation.
When loading data from a data source into an InfoCube, your customer wants to add the person responsible for a cost center to the transaction data. The responsible person is an attribute of a characteristic. Which SAP BW transformation rule types should you use to achieve this? (2 answers) Read master data Direct assignment routine constant.
Which of the following actions do you need to take to design the dimension of an Infocube if you want to accelerate Query Performance? (3 answers) Distribute the characteristics evenly across all dimensions Assign two characteristics that have an N: M relation to different dimensions Use the line Item dimension for high cardinality characteristics Assign two compound characteristics to different dimensions Place the most selective characteristics first in the dimension.
You must load sales data from a flat file store in a legacy system on a daily basis. The flat file always contains the last value of the sales data. Which Info Provider do you need to load the flat file into SAP BW? VirtualProvider MultiProviders DataStore Object Standard InfoCube.
You work in SAP BW projects and SAP ERP projects. Which functions are unique for the SAP BW projects? (2 answers) How to deal with multiple currencies How do you manage master data from different source systems? How to handle the delta queue How do you handle user permissions.
Which of the following layers are part of the Enterprise Data Warehouse EDW layer? (3 answers) Data Acquisition Business transformation Quality and Harmonization Reporting Data propagation.
You have updated (DSO) in an InfoCube via a delta data transfer process. Reports (report) with the same definition are written and executed to infocube and datastore object, but the data is not the same. There is a break in the data. What could be the reason for these report inconsistencies? The data was compressed in Infocube with zero elimination Data was not rolled up in the aggregates The data was deleted on request from the DSO, but not from the Infocube The data in the DSP activation queue has not been activated.
Which of the following SAP BW InfoProviders is typically used in the Enterprise Data Warehouse EDW layer? Infoset Infocube Multiprovider Stardard DataStore object.
What can you do during Data Activation of a DataStore object (DSO)? (2 answers) Upload data to the DSO Update other InfoProviders from the DSO Execute queries on the DSO Delete the contents of the DSO.
For which of the following reports do you have to use non-cumulative key figures? Earnings Transactional analysis on a daily basis Acquisition of open order analysis on a daily basis Cost of sales analysis on a daily basis Stock analysis daily.
What are the benefits of using a lineItem dimension when modeling an InfoCube? (2 answers) Aggregates on this Infocube do NOT need to be built A high cardinality of the data is reduced in the Infocube The primary key of the Infocube fact table is shorter The data is loaded into the Infocube without creating DIM IDs for this dimension.
You have created a new source system in SAP BW to load data using SAP Data Services. What is the correct order you need to perform to load this data into SAP BW? 1. Create an InfoPackage
2. Execute the SAP BW InfoPackage
3. Create a DataSource in SAP BW
4. Create a Data Services job in SAP Data Services 1. Create a DataSource in SAP BW
2. Create an InfoPackage
3. Create a Data Services job in SAP Data Services
4. Execute the SAP BW InfoPackage 1. Create an InfoPackage
2. Create a DataSource in SAP BW
3. Create a Data Services job in SAP Data Services
4. Execute the SAP BW InfoPackage 1. Create a DataSource in SAP BW
2. Create an InfoPackage
3. Execute the SAP BW InfoPackage
4. Create a Data Services job in SAP Data Services.
Your customer wants to migrate SAP BW 3.x data flows to SAP BW 7.x data flows. What can you do to mitigate the risks of migration? First use emulation to model the data flow with update rules and a data transfer process Manually create the data flow to create transformations and a data transfer process. First use emulation to model the data flow with transformations and a data transfer process Manually create the data flow to create update rules and a data transfer process.
Plant 01 for company code 100 in the SAP ERP system of your customer is a large refrigerator and plant 01 for company code 200 is a warehouse. You want plant 01 to be unique for both companies. How do you model the asset characteristic to achieve this? Define the company code characteristic as a compound characteristic for the asset Set the company code characteristic as the navigation attribute for the asset Define the company code characteristic as a time-dependent navigation attribute for the asset Set the company code characteristic as the reference characteristic for the asset.
Which of the following tables contains the attribute values of the ZMATERIAL characteristic? / BIC / TZMATERIAL / BIC / JZMATERIAL / BIC / PZMATERIAL / BIC / HZMATERIAL.
What transaction do you need to use to change statistics reporting? Query Monitor (RSRT) SAP BW Workload Statistics (ST03) ABAP Dictionary Maintenance (SE11) Maintaining Statistics Properties (RSDDSTAT).
Your customer wants to model his SAP BW system using proven methods. They suggest using a layered scalable architecture (LSA). Which of the following steps do you need to take? (2 answers) Determine which LSA layers are relevant based on the customer's requirements and goals. Implement the entire corporate information factory enterprise data warehouse architecture. Model disjoint transaction and master data domains for application-specific reporting. Define specific scenarios for the customer-driven data logistics.
What does SAP recommend to improve the overall reporting (reporting) of a standard InfoCube in SAP BW 7.4? (3 answers) Split the standard InfoCube data into several InfoCubes contained in a MultiProvider Create aggregates. Run a preload OLAP cache process in a process chain. Insert the InfoCube into a semantically partitioned object (SPO). Create one or more line item dimensions.
What actions can you perform with a process chain? (2 answers) Delete InfoObjects You create aggregates Enable DataStore object data Delete indexes.
With the Remodeling Toolbox in SAP BW, which of the following InfoProvider objects can you fill via a customer exit? (2 replies) New Key figures New Characteristic New navigation attributes New dimensions.
Which of the following info providers do you use to model the operational data store layer in SAP BW? (2 answers) Write-optimized data store objects Direct Access Data Store Objects Transient Provider Hybrid provider.
In a report based on a Sales InfoCube, you want to display the material and the merchandise category that was valid at the time the sales order was created. How do you model the characteristics material and merchandise category to achieve this? merchandise category as a time-dependent attribute of the material merchandise category as a time-independent attribute of the material merchandise category grouped to the material Material and the merchandise category in the dimensions of Infocube.
What can you do in the Remodeling Toolbox? (3 answers) Add a characteristic Convert an InfoCube dimension to a line-item dimension Add attributes to an existing characteristic Add a Key figure by mapping it to an existing Key figure Delete a characteristic in an infocube.
Which source systems can you use as a provider in Operational Data Provisioning? (2 answers) SAP IQ (formerly SAP Sybase IQ) SAP BW SAP Data Services SAP LT Replication Server (SLT).
Your customer wants to analyze transaction data from the sales document at the calendar level. Which InfoProvider does SAP recommend that you load this type of data? MultiProviders VirtualProvider InfoCube DataStore Object.
Which of the following settings can you make for troubleshooting the data transfer process? (2 answers) Invalid records in the destination InfoProvider. Process correct data records, suppress reporting (DO NOT allow) Process correct data records, allow reporting All new data in the source job on request (request by request).
You want to analyze the sales data for your customers and materials for the past five years. The customer analysis must be based on the current customer group. And the Mechandise category on the day of sale. How can you model the characteristics and the sales infocube to achieve this? Customer group as a time-dependent navigation attribute of the customer characteristic.
Mechandise category as characteristic in your Infocube Customer group as feature in your Infocube.
Mechandise category as a time-independent navigation attribute of the material characteristic. Customer group as a time-independent navigation attribute of the customer characteristic.
Mechandise category as characteristic in your Infocube. Customer group as a time-dependent navigation attribute of the customer characteristic.
Mechandise category as a time-dependent navigation attribute of the material characteristic.
You want to receive the following information:
- Duration of data loads
- Report runtimes
- Details of how SAP BW InfoProviders, InfoObjects, InfoSources, source systems, and aggregates are used.
What can you use to get this information? Workload monitoring Database statistics SAP BW Administration Cockpit Query Monitor.
Which of the following recording modes of a DataSource can you upload directly to an InfoCube? (3 answers) After Image Before Image and After Image Reverse image Delete Image Additive Image.
You want the transaction data to be sent from an SAP ERP source system to SAP BW. Which of the following objects do you need to use? (2 answers) MultiProviders Data Sources Open Hub destination InfoPackages.
What is a prerequisite for scheduling flat-file data in SAP BW? The fields are selected to set the selection criteria For each application, a flat-file source system is created The flat files (flat files) are located on the application server. Template InfoObjects are assigned to source system fields.
You want to load data from a legacy system into a data store object (DSO) using an SAP BW 7.x DataSource. Which additional SAP BW object do you need to use? InfoSource Transition rule update rule transformation.
What are the performance benefits of using an InfoCube instead of a DataStore object? (2 answers) Surrogate IDs (SIDs) replace the master data values in dimension tables. Navigation attributes can be used. Surrogate ID (SID) and DIM_ID are generated automatically. Reporting access to granular data with dimension tables is faster.
Your customer requires an analysis of historical data AND current data from an SAP ERP system in a report. Which of the following SAP BW objects does SAP recommend for this analysis? VirtualProvider InfoSet Hybridprovider Write-optimized DataStore object.
|
