Quiz
Sertification
This quiz has a time limit, so it opens in the usual player.
Questions in this quiz (90)
1You created a new source system in SAP BW to load data via SAP Data Services What is the correct sequence of task you must perform to load this data into SAP BW?
- A1.Create and InfoPackage
2.Execute the SAP BW InfoPackage
3.Create a DataSource in SAP BW
4.Create a Data Services job in SAP Data Services - B1.Create a datasource in SAP BW
2.Create and InfoPackage
3.Create a Data Services job in SAP Data Services
4.Execute the SAP BW InfoPackage - C1.Create and InfoPackage
2.Create a DAtaSource in SAP BW
3.Create a Data Services job in SAP Data Services
4.Execute the SAP BW InfoPackage - D1.Create a datasource in SAP BW
2.Create and InfoPackage
3.Execute the SAP BW InfoPackage
4.Create a Data Services job in SAP Data Services
- A1.Create and InfoPackage
2Which of the following SAP BW objects can you use to build aggregates?
There are 2 correct answers to this question.- ASurrogate IDs (SIDs)
- BCharacteristics
- CKey figure values
- DHierarchy levels
3You have Built a HybridProvider using a DataStore object for realtime data acquisition (RDA) Which of the following must you execute in SAP BW to load the data?
- AThe deamon assignet to the realtime InfoPackage
- BThe realtime InfoPackage
- CThe data transfer Process
- DNew data loads into the SAP source system delta queue
4Which of the following layers are part of the Enterprise Data Warehouse (EDW) layer?
There are 3 correct answers to this question.- ABusiness Transformation
- BReporting
- CQuality and Harmonization
- DData Propagation
- EData Acquisition
5Which of the following objects can you use as source objects for a transformation object?
There are 2 correct answers to this question- AOpen Hub destination
- BInfoset
- CInfoSource
- DVirtualProvider
6You notice that some queries based on the SALES InfoCube are taking too much time Which actions can you perform to improve the performance of these queries?
There are 2 correct answers to this question.- ACreate an aggregate for these queries
- BSchedule the attribute change run after the data load
- CPartition the SALES infoCube
- DLoad the master data before the transaction data
7What is a prerequisite for scheduling data loads from flat files into SAP BW?
- AA flat file source system is created for each application
- BTemplate infoObjects are assigned to source system fields.
- CThe flat files are located on the application server.
- DFields are chosen to set the selection criteria
8You want to re-use the same transformation program to harmonize customer master data in different data formats coming from several source systems and transfer rules or transformations.
Which routine can you use?- AStart
- BLocal
- CGlobal
- DExpert
9What can you do before a transaction data load to improve the performance of the data load?
- ARoll up the aggregates
- BBuild additional indexes on the data targets
- CUpdate database statistics
- DLoad master data
10What happens when you compress the data of an InfoCube?
- AThe star schema is redefined
- BThe data load request indentifier (ID) is set to zero
- CThe granularity for a characteristic is reduced
- DStandard dimensions are switched to lineitem dimensions
11You want to migrate the 3.x version of an SAP BW dataSource to a 7.x version with the capability to restore the original version What should yo do during the migration to achieve this?
- ACreate a transformation to replace the transfer rules
- BReplace the 3.x SAP BW InfoSource with a 7.x version SAP BW InfoSource
- CExport the 3.x DataSource version with its mapping and transger structures
- DDelete all entries from the Persistent Staging Area (PSA).
12What are prerequisites for adding a new characteristic in a dataStore Object (DSO) using the remodeling toolbox?
There are 2 correct answers to this question- AThe change log table is empty
- BThe cache memory has been cleared
- CA system handling has been performed
- DRequest service that load data into the DSO have been stopped
13You want to load data from a legacy system into a datastore object (DSO) using a SAP BW 7.x DataSource Which additional SAP BW object do you have to use?
- ATransformation
- BInfoSource
- CTransfer rule
- DUpdate rule
14Which of the following standard aggregation options can you choose when you model key figures in SAP BW?
There are 3 correct answers to this question.- ALast value (LAS)
- BMinimum (MIN)
- CMaximum (MAX)
- DSummation (SUM)
- EAverage (AVG)
15What does SAP recommend you do to improve the overall reporting performance of a standard InfoCube in SAP BW 7.4?
There are 3 correct answers to this question.- AInclude the InfoCube into a semantically partitioned object (SPO).
- BCreate one or more lineitem dimensions.
- CSplit the standard InfoCube data into several InfoCubes contained in a MultiProvider.
- DExecute a preload OLAP cache process in a process chain.
- ECreate aggregates.
16You are loading material master data from two different source systems. In system A, material ‘123’ is a hammer, but in system B, material ‘123’ is a food.
How should you model the 0MATERIAL characteristic in SAP BW to keep the material identifiers unique?- AWith the timeindependent display attribute 0SOURSYSTEM
- BWith the timeindependent navigation attribute 0SOURSYSTEM
- CWith the timedependent navigation attribute 0SOURSYSTEM
- DCompounded with the 0SOURSYSTEM characteristic
17Which of the following settings can you make for error handling in the data transfer process?
There are 2 correct answers to this question.- AProcess the correct records and allow reporting on them.
- BWrite invalid records into the target InfoProvider.
- CProcess the correct records and do NOT allow reporting on them.
- DGet all new data in source request by request.
18For which of the following reports must you use noncumulative key figures?
- AStock level analysis on a daily basis
- BRevenues transaction analysis on a daily basis
- CPurchasing open order analysis on a daily basis
- DCost of sales analysis on a daily basis
19What can you define when you model hierarchies for a characteristic?
There are 3 correct answers to this question.- AExternal characteristics
- BThe tables structures of the hierarchies
- CTime dependent hierarchy structures
- DThe maximum level of hierarchy nodes
- EVersion dependent hierarchies
20Your customer wants to model their SAP BW system according to best practices. You propose using a layered scalable architecture (LSA).
Which of the following steps must you perform?
There are 2 correct answers to this question.- AImplement the entire corporate information factory enterprise data warehouse architecture.
- BDetermine which LSA layers are relevant based on the customer’s requirements and objectives.
- CModel disjunct transaction and master data domains for application specific reporting.
- DDefine specific scenarios for data logistics shaped by the customer environment.
21Which of the following sources can SAP Landscape Transformation Replication Server (SLT) use for data acquisition into SAP BW?
There are 2 correct answers to this question.- ACustomer specific tables from SAP ERP
- BExtractors with a delta mechanism for SAP ERP tables
- CDelta queue tables from SAP ERP DataSources
- DTables from nonSAP sources
22Your customer wants to migrate SAP BW 3.x Data Flows to SAP BW 7.x Data Flows. What can they do to mitigate the risks of the migration?
- AUse emulation first to model the Data Flow with transformations and a data transfer process.
- BUse emulation first to model the Data Flow with update rules and a data transfer process.
- CCreate the Data Flow manually to create transformations and a data transfer process.
- DCreate the Data Flow manually to create update rules and a data transfer process.
23Your DataSource provides only After Image delta Which InfoProvider can be loaded directly via this DataSource?
- AInfocube
- BDataStore Object (DSO)
- CInfoSet
- DVirtual Provider
24What are advantages of using a line item dimension when modelling an InfoCube?
There are 2 correct answers to this question.- AA high cardinality of data is reduced in the infocube
- BAggregates on this infocube do NOT need to be built
- CData is loaded into the infocube whithout generating DIM IDs for this dimension
- DThe primary key of the infocube fact table is shorter
25Which InfoProvider type do you typically use for the Virtualisation layer in an Enterprise Data Warehouse architecture?
- ATransientProvider
- BCompositeProider
- CMultiProvider
- DHybridProvider
26Which of the following layers are part of an architected data mart layer?
There are 3 correct answers to this question.- AReporting
- BQuality and Harmonization
- CData Propagation
- DVirtualization
- EBussiness Transformation
27What can you do in the remodeling toolbox?
There are 3 correct answers to this question- AAdd a charasteristic
- BAdd a key figure by mapping it to an existing key figure
- CConvert an infocube dimension to a lineitem dimension
- DAdd attributes to an existing characteristic
- EDelete a characteristic in an infocube
28You want to load daily changes of sales data from a legacy system into SAP BW, using SAP Operational Data Provisioning (ODP).
What is the correct sequence of task you must perform in SAP BW?- A1.Create an ODP DataSource
2.Create a datastore object (DSO)
3.Create a TRanformation
4.Create and load a data transfer process (DTP) for delta initialization without a persistent staging area (PSA) - B1.Create an ODP DataSource
2.Create a TRanformation
3.Create and load an infopackage for delta inizialization without a persistent staging area (PSA)
4.Create and load a data transfer process (DTP) in delta mode - C1.Create a datastore object (DSO)
2.Create an ODP DataSource
3.Create and load an infopackage for delta inizialization without a persistent staging area (PSA)
4.Create and load a data transfer process (DTP) in delta mode - D1.Create an ODP DataSource
2.Create a datastore object (DSO)
3.Create a TRanformation
4. Create and load an infopackage for delta inizialization without a persistent staging area (PSA)
- A1.Create an ODP DataSource
29What are benefits of the Enterprise Data Warehouse (EDW) layers?
There are 2 correct answers to this question.- AYou can load delta data without overwriting older versions
- BYou can schedule data loads via process chains without using InfoPackages
- CYou can extract data once and deploy it to several data marts
- DYou can publish data on the SAP Enterprise Portal without creating queries
30You have loaded data into a standard DataStore object. This data has NOT yet been activated. What can you do to accelerate the activation process?
- AChoose the Overwrite option for the key figures in the transformation rules
- BChoose the unique data records option in the settings of the standard DataStore object
- CChoose the SID Generation During Activation option in the settings of the standard DataStore Object
- DCreate additional indexes for the standard DataStore object
31Your customer is migrating their SAP BW 3.x Data Flows to SAP BW 7.x Data Flows Which of the following new objects must the customer now use?
- ADataSource
- BInfoSource
- CInfoPackage
- DData Transfer Process
32Which source systems can you use as a provider in Operational Data Provisioning?
There are 2 correct answers to this question.- ASAP IQ (formerly SAP Sybase IQ)
- BSAP Data Services
- CSAP BW
- DSAP LT Replication Server (SLT)
33Which of the following objects in SAP BW can you use as the target of a Transformation object?
There are 2 correct answers to this question.- ADataSource
- BDataStore Object
- CInfoCube
- DMultiProvider
34Which of the following initial tasks should you perform when designing an SAP BW data model?
There are 2 correct answers to this question.- AEvaluate the number and types of users.
- BEvaluate the format of data to be loaded.
- CEvaluate the volume of data to be loaded.
- DAnalyze relationships between the characteristics and their attributes.
35You want to compare purchase order based on all existing and unchanged material groups for a certain time period How should you model the material characteristic to achieve this?
- AModel the material group and two selectable user date attributes are time dependent navigation attributes of the material characteristic
- BModel the material group and two selectable user data attributes as a time dependent display attribute of the material characteristic
- CModel the material characteristic and two selectable user data attributes as time dependent navigation attributes of the material group
- DModel the material group as a timeindependent navigation attribute of the material characteristic
36What can you use transformation rules for?
There are 2 correct answers to this question.- ATo harmonize the data from different source systems
- BTo enrich and change extracted data
- CTo store the source data in the Persistent Staging Area (PSA)
- DTo use an InfoPackage as a source object
37You want to transfer data from an infocube in an SAP BW system A to an Infocube in SAP BW system B Which sets of Objects can you use?
There are 2 correct answers to this question- A- operational data provisioning (ODP) source system
- Datasource for the infoprovider of SAP BW System A
- transformation
- data transfer process - B- target infocube as open hub destination
- transformation
- data transfer process - C- Generic data source
- replicated generic datasource
- infopackage
- trasformation
- data transfer process - D- export datasource
- replicated export datasource
- infopackage
- transformation
- data transfer process
- A- operational data provisioning (ODP) source system
38Which of the following infoproviders do you use to model the operational data store layer in SAP BW?
There are 2 correct answers to this question- Adirect access datastore objects
- Bwrite-optimized datastore objects
- Chybrid providers
- DTransient Providers
39Which transaction must you use to change the level of reporting for statistics data?
- AQuery Monitor (RSRT)
- BSAP BW Workload Statistics (ST03)
- CABAP Dictionary Maintenance (SE11)
- DMaintenance of Statistics Properties (RSDDSTAT)
40Which actions can you accomplish using a process chain?
There are 2 correct answers to this question.- ADelete InfoObjects
- BCreate aggregates
- CActivate DataStore objects data
- DDelete indexes
41Your customer requires an analysis of historical data and current data from one SAP ERP system in one single report.
Which of the following SAP BW objects does SAP recommend using for this analysis?- AHybridProvider
- BVirtualProvider
- CInfSet
- DWriteoptimized DatStore object
42You have created a new Data Flow object in SAP BW by copying a Data Flow template. What must you do to use the new Data Flow?
- AValidate nonpersistent SAP BW objects
- BCopy nonpersistent SAP BW objects
- CActivate nonpersistent SAP BW objects
- DReplace nonpersistent SAP BW objects with active SAP BW objects
43What happens when you activate a request in a standard DataStore object (DSO)?
There are 3 correct answers to this question.- ARecord are updated in the Active Data table
- BRecords are compressed in the Active Data table
- CRecords are deleted from the activation queue
- DRecords are updated in the Change Log table
- ERecords are aggregated in the Change Log table
44Your customer wants to analyze sales document transactional data at a calendar day level. Which InfoProvider does SAP recommend that they use to load this type of data?
- ADataStore object
- BMultiProvider
- CVirtualProvider
- DInfoCube
45Which tool do you use to perform maintenance and administration tasks in SAP BW?
- ASAP Change and Transport Organizer
- BSAP Business Explorer
- CSAP BW Statistics
- DSAP Data Warehousing Workbench
46What are performance advantages when using an InfoCube instead of a DataStore object?
There are 2 correct answers to this question.- ANavigational attributes can be used.
- BSurrogate IDs (SIDs) replace master data values in dimension tables.
- CReporting access to granular data using standard dimensions is faster.
- DSurrogate ID (SID) keys and DIM_ID keys are generated automatically.
47What can you use to accelerate an SAP BW implementation project?
- ASAP BW Accelerator (BWA)
- BSAP BW Statistics
- CSAP BW Data Warehousing Workbench
- DSAP BI Content
48Using the remodelling toolbox, which action can you perform for an SAP BW characteristic InfoObject?
- AAdd additional attributes
- BChange the reference characteristic.
- CAdd hierarchies.
- DChange the attribute type
49Which of the following does the data propagation layer of your SAP BW system offer?
There are 2 correct answers to this question.- AA single version of the truth
- BFast load of mass data
- CAbility to extract once and deploy many times
- DHomogenized data
50Which of the following record modes delivered by a DataSource can you directly upload to an InfoCube?
There are 3 correct answers to this question.- ABefore Image and After Image
- BAfter Image
- CAdditive Image
- DReverse Image
- EDelete Image
51Which of the following info-providers do you use to model the operational data store layer in SAP BW?
There are 2 correct answers to this question- AWrite-optimized datastore objects
- BTransient Providers
- CDirect access datastore objects
- DHybrid providers
52What are features of the Hierarchy Extraction Transformation and Loading (ETL) concept of SAP BW 7.3 or higher?
There are 3 correct answers to this question.- AIt uses the Application Link Enabling (ALE) inbox
- BIt provides Hierarchy DataSources for all types of source systems
- CIt uses transformations and data transfer processes (DTPs)
- DIt can use start, end, and expert routines within transformations
- EThe InfoPackage controls the file format of the hierarchy data
53Which of the following connection types supports SAP BW real time data acquisition (RDA)?
- AUniversal data connect
- BWeb Service
- CDatabase connect
- DFlat file interface
54You want transaction data to be sent from a SAP ERP source system to SAP BW. Which of the following objects must you use?
There are 2 correct answers to this question.- AMultiProviders
- BOpen hub destinations
- CDataSources
- DInfoPackages
55What can you define in a currency translation type in SAP BW?
There are 2 correct answers to this question- ATarget currency
- BTransformation Rule type
- CCurrency Table
- DExchange rate type
56What can you do when you model a MultiProvider to ensure optimal query performance?
- ASelect nomcumulative key figures for the multiprovider
- BSelect characteristics for reporting that are available in all the components
- CSelect parts of compound characteristics for the MultiProvider
- DAssign the characteristics for reporting evenly among the dimensions
57In your customer’s SAP ERP system, plant 01 for company code 100 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 plant characteristic to achieve this?- ASet the company code characteristic as a navigation attribute for the plant
- BSet the company code characteristic as timedependent navigation attribute for the plant
- CSet the company code characteristic as a reference characteristic for the plant
- DSet the company code characteristic as compounding characteristic for the plant
58Which of the following activities can you perform with the Metadata Repository?
- AActivate installed SAP BI content objects
- BCustomize SAP BI content objects
- CInstall SAP BI content objects
- DSearch for installed SAP BI content objects
59When 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 person responsible is an attribute of a characteristic. Which SAP BW transformation rule types should you use to achieve this?
There are 2 correct answers to this question.- ARoutine
- BRead master data
- CDirect assignment
- DConstant
60Which of the following SAP BW InfoProviders is typically used in the Enterprise Data Warehouse (EDW) layer?
- AStardard DataStore object
- BInfoSet
- CInfoCube
- DMultiProvider
61In an SAP BW report you want to display the material group for a material for a specific key date. What do you need to do to achieve this?
- AModel the material group characteristic as a timedependent attribute of the material characteristic
- BModel the material characteristic with the two additional attributes Valod from and Valid to
- CModel the material and material group as InfoProvider characteristics
- DModel the material characteristic as a timedependent attribute of the material group characteristic.
62How can you prevent a process chain from starting immediately after activation?
There are 2 correct answers to this question.- ASet a start process for the process chain using default parameters
- BSet the start process using the “Meta chain or AIP” scheduling option
- CMaintain your process chain as a subprocess chain without a start process
- DSet the start process to a specific data and time using the “Direct scheduling” and “change Selections” scheduling options
63Which archiving strategy would use to reduce the SAP BW database size and still allow reporting on an ad-hoc basis?
- AReload of archived data back into the InfoProvider
- BNearline storage archiving for InfoProvider data
- CClassic archiving for data load request administration and log data
- DXMLbased archiving to a WebDAV system for InfoProvider data
64What are the properties of a standard InfoCube?
There are 2 correct answers to this question.- AIt can combine several InfoProviders
- BIt has a minimum of four dimension tables
- CIt is a writeoptimized provider
- DIt can contain a maximum of 233 key figures
65What happens during the creation of an Info-cube?
There are 3 correct answers to this question.- ACompounded characteristics of select characteristics are chosen
- BThe unit of measure or currency of each key figure in assigned in the unit dimension
- CThe charactesristic 0REQUID (Request ID) is assigned to the Data Package dimension
- DDimension that contain multiple characteristics are set as line item dimensions
- ENavigational attributes are assigned to a separate dimension
66All of your data updates into a standard DataStore object are successful but the report does not show the correct results.
You want to rerun the DTP. What must you do before the reload to investigate this issue?- ATrace every record in the Persistent Staging Area (PSA)
- BSet up temporary storage in the data transfer process
- CDefine semantic groups in the data transfer process
- DDefine filters in the data transfer process
67What can you do with the hierarchy framework when you load hierarchies into SAP BW?
There are 2 correct answers to this question- AYou can expand the hierarchy if the field length is changed
- BYou can identify the details of nodes that are built from characteristics
- CYou can expand the hierarchy by using Star, end and expert routines in the transformation
- DYou can use multiple persistent Staging area (PSA) one for each segment of the hierarchy
68When does the SAP BW system build a surrogate ID (SID) table?
- AWhen you first load master data into a characteristic
- BWhen you first load data into an infocube
- CWhen you first activate a characteristic
- DWhen you first activate an infocube
69You load costcenter data from different source systems with different data formats into SAP BW.
You want to update the data into a single info-provider with a Source system How does SAP recommend you design the data flow?- AUse a set of Transformations and data transfer processes (DTPs) for each dataSource
- BUse Data Source specific transformations bound by and InfoSource to an Info-Provider specific transformation
- CDesign a realtime data adquisition data flow for a n SAP BW Infoprovider
- DUse one transformation for all data Sources bound by and infoSource to an infoProviderspecific transformation
70Using Remodeling Toolbox in SAP BW, which of the following InfoProvider objects can you fill using a customer exit?
There are 2 correct answers to this question- ANew Key figures
- BNew Characteristics
- CNew Navigation attributes
- DNew Dimensions
71In a report based on a sales InfoCube, you want to show the material and the material group that was valid at the time of sales order creation.
How do you model the characteristics material and material group to achieve this?- AModel the material group as a timeindependent attribute of the material
- BModel the material group as a timedependent attribute of the material
- CModel the material group compounded to the material
- DModel the material and the material group in the dimentions of the infocube
72You are working in SAP BW projects and SAP ERP projects What functions are unique to the SAP BW projects?
There are 2 correct answers to this question- AHow to handle user authorizations
- BHow to manage master data coming from different source systems
- CHow to handle multiple currencies
- DHow to handle queue delta loads
73Which of the following tables contains the attribute values of the ZMATERIAL characteristic?
- A/BIC/TZMATERIAL
- B/BIC/PZMATERIAL
- C/BIC/HZMATERIAL
- D/BIC/JZMATERIAL
74You have updated datastore object (DSO) data into an infocube via a delta data transfer process.
Reports with the same definition are written and execute to infocube and datastore object but the data is not the same.
There is a break in a data. What could be the reason for these report inconsistencies?- AData has been compressed in the infocube with zere elimination
- BData was not rolled up into the aggregates
- CData has been deleted by request from the DSO but not fron the infocube
- DData in the DSP activation queue has not been activated
75What must you create to use data transfer process (DTP) error handling?
- AA DTP with extraction mode FULL
- BA DTP with the transfer method Persistent Staging Area (PSA)
- CA process chain using the DTP
- DA DTP with extraction mode INITIAL
76Which of the following actions must you perform to design the dimension of an infocube when you want to accelerate query performance?
There are 3 correct answers to this question- ADistribute the characteristics equally over all dimensions
- BAssign two characteristics that have an N:M relantionship to different dimensions
- CAssign two compounded characteristics to different dimensions
- DUse line item dimensions for characteristics with high cardinality
- EPlace the most selective characteristics first in the dimension
77In which layered architecture (LSA) layer of SAP BW do you model business requirements?
- AEnterprise data warehouse
- BQuality and Harmonization
- CArchitected Data Mart
- DData Propagation
78What can you use to ensure that the daemon that triggers the realtime data acquisition (RDA) for your sales orders stops at the end of a workday?
There are 2 correct answers to this question.- AThe Data Load Monitor
- BThe Daemon Monitor transaction (RSRDA)
- CA process chain
- DInfoPackage settings
79What can you do during the data activation of a DataStore object (DSO)?
There are 2 correct answers to this question.- AUpdate other InfoProviders from the DSO
- BExecute queries on the DSO
- CDelete the contents of the DSO
- DUpload data into the DSO
80Which SAP BW InfoProviders can serve as data targets?
There are 2 correct answers to this question.- AInfoSet
- BMultiProvider
- CStandard DataStore Object
- DInfoCube
81You have to load sales data from a flat file stores 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 have to use to load the flat file into SAP BW?- AVirtualProvider
- BDataStore Object
- CMultiProvider
- DStandar InfoCube
82Which of the following SAP BW infoProviders are used in the reporting layers of a layered scalable architecture (LSA)?
There are 2 correct answers to this question- AInfoSource
- BDataSource
- CMultiProvider
- DDataStoreObject (DSO)
83You want to get the following information:
- Duration of data loads
- Report runtimes
- Details about how SAP BW InfoProviders, InfoObjects, InfoSources, source systems and aggregates are used.
What can you use to get this information?- AQuery monitor
- BWork load monitor
- CSAP BW administration cockpit
- DDatabase statistics
84You want to load daily changes of sales data from a legacy system into SAP BW, using SAP Operational Data Provisioning (ODP). What is the correct sequence of task you must perform in SAP BW?
- A1. Create an ODP DataSource
2. Create a datastore object (DSO)
3. Create a TRanformation
4. Create and load an infopackage for delta inizialization without a persistent staging area (PSA) - B1. Create a datastore object (DSO)
2. Create an ODP DataSource
3. Create and load an infopackage for delta inizialization without a persistent staging area (PSA)
4. Create and load a data transfer process (DTP) in delta mode - C1. Create an ODP DataSource
2. Create a datastore object (DSO)
3. Create a TRanformation
4. Create and load a data transfer process (DTP) for delta initialization without a persistent staging area (PSA) - D1. Create an ODP DataSource
2. Create a TRanformation
3. Create and load an infopackage for delta inizialization without a persistent staging area (PSA)
4. Create and load a data transfer process (DTP) in delta mode
- A1. Create an ODP DataSource
85Your customer wants to store material data (infoObject 0MATERIAL) and material proposed data (infoObject ZMAT_PROP).
Both infoObjects should be based on the same material master data.- AAs a navigation attribute of 0MATERIAL
- BAs a compounding characteristic for 0MATERIAL
- CAs a Display attribute of 0MATERIAL
- DAs a referencing characteristic to 0MATERIAL
86You want to analyze the sales data for your customers and materials for the last five years. The customer analysis must be based on the current customer group.
And the Material group of the day of sales. How can you model the characteristics and the sales infocube to achieve this?- ACustomer group as a timeindependent navigation attribute of the customer characteristic. Material group as a characteristic in your infocube
- BCustomer group as a timedependent navigation attribute of the customer characteristic. Material group as a characteristic in your infocube.
- CCustomer Group as a characteristic in your infocube. Material group as a time independent navigation attribute of the material characteristic
- DCustomer group as a timeindependent navigation attribute of the customer characteristic. Material group as a timedependent navigation attribute of the material characteristic
87When does the SAP BW system build a surrogate ID (SID) table?
- AWhen you first activate a characteristic
- BWhen you first load data into an infocube
- CWhen you first activate an infocube
- DWhen you first load master data into a characteristic
88When 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 person responsible is an attribute of a characteristic. Which SAP BW transformation rule types should you use to achieve this?
There are 2 correct answers to this question- ARoutine
- BDirect assignment
- CConstant
- DRead master data
89In a customer hierarchy, customers are organized in regions and regions are assigned to different regional managers.
One region has to be assigned to two regional managers. How do you model the hierarchy?- AUse a Duplicate node
- BUse two different hierarchy versions
- CUse a temporal hierarchy join
- DUse a Link node
90Which of the following activities can you perform with the Metadata Repository?
- AActivate installed SAP BI content objects
- BInstall SAP BI content objects
- CSearch for installed SAP BI content objects
- DCustomize SAP BI content objects
Information
- Description
- Sertification
- Author
- Andrey Tamashenko
- Language
- English
- Views
- 75
- Tags
- Rating
- No ratings yet Rate this quiz