Sertification

Ivan Sukhov
Quiz by , created almost 3 years ago

Sertification

678
4
0
Tags No tags specified
Ivan Sukhov
Created by Ivan Sukhov almost 3 years ago
Using GoConqr to study English literature
Sarah Egan
Computer science quiz
Ryan Barton
Social Influence
Kizzy Leverton
What is Marketing?
Stephanie Natasha
1PR101 2.test - Část 14.
Nikola Truong
01 Types of Computers
mc_2871
Golf Putter
Ysabelle Glori
Digital Technologies
lb_
Untitled
lb_
Physics equations
helensellers75

Question 1

Question
You 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?
Answer
  • 1.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
  • 1.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
  • 1.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
  • 1.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

Question 2

Question
Which of the following SAP BW objects can you use to build aggregates? There are 2 correct answers to this question.
Answer
  • Surrogate IDs (SIDs)
  • Characteristics
  • Key figure values
  • Hierarchy levels

Question 3

Question
You have Built a HybridProvider using a DataStore object for real­time data acquisition (RDA) Which of the following must you execute in SAP BW to load the data?
Answer
  • The deamon assignet to the real­time InfoPackage
  • The real­time InfoPackage
  • The data transfer Process
  • New data loads into the SAP source system delta queue

Question 4

Question
Which of the following layers are part of the Enterprise Data Warehouse (EDW) layer? There are 3 correct answers to this question.
Answer
  • Business Transformation
  • Reporting
  • Quality and Harmonization
  • Data Propagation
  • Data Acquisition

Question 5

Question
Which of the following objects can you use as source objects for a transformation object? There are 2 correct answers to this question
Answer
  • Open Hub destination
  • Infoset
  • InfoSource
  • VirtualProvider

Question 6

Question
You 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.
Answer
  • Create an aggregate for these queries
  • Schedule the attribute change run after the data load
  • Partition the SALES infoCube
  • Load the master data before the transaction data

Question 7

Question
What is a prerequisite for scheduling data loads from flat files into SAP BW?
Answer
  • A flat file source system is created for each application
  • Template infoObjects are assigned to source system fields.
  • The flat files are located on the application server.
  • Fields are chosen to set the selection criteria

Question 8

Question
You 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?
Answer
  • Start
  • Local
  • Global
  • Expert

Question 9

Question
What can you do before a transaction data load to improve the performance of the data load?
Answer
  • Roll up the aggregates
  • Build additional indexes on the data targets
  • Update database statistics
  • Load master data

Question 10

Question
What happens when you compress the data of an InfoCube?
Answer
  • The star schema is redefined
  • The data load request indentifier (ID) is set to zero
  • The granularity for a characteristic is reduced
  • Standard dimensions are switched to line­item dimensions

Question 11

Question
You 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?
Answer
  • Create a transformation to replace the transfer rules
  • Replace the 3.x SAP BW InfoSource with a 7.x version SAP BW InfoSource
  • Export the 3.x DataSource version with its mapping and transger structures
  • Delete all entries from the Persistent Staging Area (PSA).

Question 12

Question
What are prerequisites for adding a new characteristic in a dataStore Object (DSO) using the remodeling toolbox? There are 2 correct answers to this question
Answer
  • The change log table is empty
  • The cache memory has been cleared
  • A system handling has been performed
  • Request service that load data into the DSO have been stopped

Question 13

Question
You 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?
Answer
  • Transformation
  • InfoSource
  • Transfer rule
  • Update rule

Question 14

Question
Which 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.
Answer
  • Last value (LAS)
  • Minimum (MIN)
  • Maximum (MAX)
  • Summation (SUM)
  • Average (AVG)

Question 15

Question
What 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.
Answer
  • Include the InfoCube into a semantically partitioned object (SPO).
  • Create one or more line­item dimensions.
  • Split the standard InfoCube data into several InfoCubes contained in a MultiProvider.
  • Execute a pre­load OLAP cache process in a process chain.
  • Create aggregates.

Question 16

Question
You 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?
Answer
  • With the time­independent display attribute 0SOURSYSTEM
  • With the time­independent navigation attribute 0SOURSYSTEM
  • With the time­dependent navigation attribute 0SOURSYSTEM
  • Compounded with the 0SOURSYSTEM characteristic

Question 17

Question
Which of the following settings can you make for error handling in the data transfer process? There are 2 correct answers to this question.
Answer
  • Process the correct records and allow reporting on them.
  • Write invalid records into the target InfoProvider.
  • Process the correct records and do NOT allow reporting on them.
  • Get all new data in source request by request.

Question 18

Question
For which of the following reports must you use non­cumulative key figures?
Answer
  • Stock level analysis on a daily basis
  • Revenues transaction analysis on a daily basis
  • Purchasing open order analysis on a daily basis
  • Cost of sales analysis on a daily basis

Question 19

Question
What can you define when you model hierarchies for a characteristic? There are 3 correct answers to this question.
Answer
  • External characteristics
  • The tables structures of the hierarchies
  • Time­ dependent hierarchy structures
  • The maximum level of hierarchy nodes
  • Version­ dependent hierarchies

Question 20

Question
Your 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.
Answer
  • Implement the entire corporate information factory enterprise data warehouse architecture.
  • Determine which LSA layers are relevant based on the customer’s requirements and objectives.
  • Model disjunct transaction and master data domains for application­ specific reporting.
  • Define specific scenarios for data logistics shaped by the customer environment.

Question 21

Question
Which 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.
Answer
  • Customer­ specific tables from SAP ERP
  • Extractors with a delta mechanism for SAP ERP tables
  • Delta queue tables from SAP ERP DataSources
  • Tables from non­SAP sources

Question 22

Question
Your 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?
Answer
  • Use emulation first to model the Data Flow with transformations and a data transfer process.
  • Use emulation first to model the Data Flow with update rules and a data transfer process.
  • Create the Data Flow manually to create transformations and a data transfer process.
  • Create the Data Flow manually to create update rules and a data transfer process.

Question 23

Question
Your DataSource provides only After Image delta Which InfoProvider can be loaded directly via this DataSource?
Answer
  • Infocube
  • DataStore Object (DSO)
  • InfoSet
  • Virtual Provider

Question 24

Question
What are advantages of using a line ­item dimension when modelling an InfoCube? There are 2 correct answers to this question.
Answer
  • A high cardinality of data is reduced in the infocube
  • Aggregates on this infocube do NOT need to be built
  • Data is loaded into the infocube whithout generating DIM IDs for this dimension
  • The primary key of the infocube fact table is shorter

Question 25

Question
Which InfoProvider type do you typically use for the Virtualisation layer in an Enterprise Data Warehouse architecture?
Answer
  • TransientProvider
  • CompositeProider
  • MultiProvider
  • HybridProvider

Question 26

Question
Which of the following layers are part of an architected data mart layer? There are 3 correct answers to this question.
Answer
  • Reporting
  • Quality and Harmonization
  • Data Propagation
  • Virtualization
  • Bussiness Transformation

Question 27

Question
What can you do in the remodeling toolbox? There are 3 correct answers to this question
Answer
  • Add a charasteristic
  • Add a key figure by mapping it to an existing key figure
  • Convert an infocube dimension to a line­item dimension
  • Add attributes to an existing characteristic
  • Delete a characteristic in an infocube

Question 28

Question
You 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?
Answer
  • 1.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)
  • 1.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
  • 1.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
  • 1.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)

Question 29

Question
What are benefits of the Enterprise Data Warehouse (EDW) layers? There are 2 correct answers to this question.
Answer
  • You can load delta data without overwriting older versions
  • You can schedule data loads via process chains without using InfoPackages
  • You can extract data once and deploy it to several data marts
  • You can publish data on the SAP Enterprise Portal without creating queries

Question 30

Question
You have loaded data into a standard DataStore object. This data has NOT yet been activated. What can you do to accelerate the activation process?
Answer
  • Choose the Overwrite option for the key figures in the transformation rules
  • Choose the unique data records option in the settings of the standard DataStore object
  • Choose the SID Generation During Activation option in the settings of the standard DataStore Object
  • Create additional indexes for the standard DataStore object

Question 31

Question
Your 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?
Answer
  • DataSource
  • InfoSource
  • InfoPackage
  • Data Transfer Process

Question 32

Question
Which source systems can you use as a provider in Operational Data Provisioning? There are 2 correct answers to this question.
Answer
  • SAP IQ (formerly SAP Sybase IQ)
  • SAP Data Services
  • SAP BW
  • SAP LT Replication Server (SLT)

Question 33

Question
Which 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.
Answer
  • DataSource
  • DataStore Object
  • InfoCube
  • MultiProvider

Question 34

Question
Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers to this question.
Answer
  • Evaluate the number and types of users.
  • Evaluate the format of data to be loaded.
  • Evaluate the volume of data to be loaded.
  • Analyze relationships between the characteristics and their attributes.

Question 35

Question
You 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?
Answer
  • Model the material group and two selectable user date attributes are time­ dependent navigation attributes of the material characteristic
  • Model the material group and two selectable user data attributes as a time­ dependent display attribute of the material characteristic
  • Model the material characteristic and two selectable user data attributes as time­ dependent navigation attributes of the material group
  • Model the material group as a time­independent navigation attribute of the material characteristic

Question 36

Question
What can you use transformation rules for? There are 2 correct answers to this question.
Answer
  • To harmonize the data from different source systems
  • To enrich and change extracted data
  • To store the source data in the Persistent Staging Area (PSA)
  • To use an InfoPackage as a source object

Question 37

Question
You 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
Answer
  • - operational data provisioning (ODP) source system ­ - Datasource for the infoprovider of SAP BW System A ­ - transformation ­- data transfer process
  • - ­target infocube as open hub destination - ­transformation ­- data transfer process
  • - Generic data source - ­replicated generic datasource ­ - infopackage ­- trasformation - ­data transfer process
  • - export datasource - ­replicated export datasource - ­infopackage - ­transformation ­- data transfer process

Question 38

Question
Which 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
Answer
  • direct access datastore objects
  • write­-optimized datastore objects
  • hybrid providers
  • Transient Providers

Question 39

Question
Which transaction must you use to change the level of reporting for statistics data?
Answer
  • Query Monitor (RSRT)
  • SAP BW Workload Statistics (ST03)
  • ABAP Dictionary Maintenance (SE11)
  • Maintenance of Statistics Properties (RSDDSTAT)

Question 40

Question
Which actions can you accomplish using a process chain? There are 2 correct answers to this question.
Answer
  • Delete InfoObjects
  • Create aggregates
  • Activate DataStore objects data
  • Delete indexes

Question 41

Question
Your 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?
Answer
  • HybridProvider
  • VirtualProvider
  • InfSet
  • Write­optimized DatStore object

Question 42

Question
You 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?
Answer
  • Validate non­persistent SAP BW objects
  • Copy non­persistent SAP BW objects
  • Activate non­persistent SAP BW objects
  • Replace non­persistent SAP BW objects with active SAP BW objects

Question 43

Question
What happens when you activate a request in a standard DataStore object (DSO)? There are 3 correct answers to this question.
Answer
  • Record are updated in the Active Data table
  • Records are compressed in the Active Data table
  • Records are deleted from the activation queue
  • Records are updated in the Change Log table
  • Records are aggregated in the Change Log table

Question 44

Question
Your 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?
Answer
  • DataStore object
  • MultiProvider
  • VirtualProvider
  • InfoCube

Question 45

Question
Which tool do you use to perform maintenance and administration tasks in SAP BW?
Answer
  • SAP Change and Transport Organizer
  • SAP Business Explorer
  • SAP BW Statistics
  • SAP Data Warehousing Workbench

Question 46

Question
What are performance advantages when using an InfoCube instead of a DataStore object? There are 2 correct answers to this question.
Answer
  • Navigational attributes can be used.
  • Surrogate IDs (SIDs) replace master data values in dimension tables.
  • Reporting access to granular data using standard dimensions is faster.
  • Surrogate ID (SID) keys and DIM_ID keys are generated automatically.

Question 47

Question
What can you use to accelerate an SAP BW implementation project?
Answer
  • SAP BW Accelerator (BWA)
  • SAP BW Statistics
  • SAP BW Data Warehousing Workbench
  • SAP BI Content

Question 48

Question
Using the remodelling toolbox, which action can you perform for an SAP BW characteristic InfoObject?
Answer
  • Add additional attributes
  • Change the reference characteristic.
  • Add hierarchies.
  • Change the attribute type

Question 49

Question
Which of the following does the data propagation layer of your SAP BW system offer? There are 2 correct answers to this question.
Answer
  • A single version of the truth
  • Fast load of mass data
  • Ability to extract once and deploy many times
  • Homogenized data

Question 50

Question
Which of the following record modes delivered by a DataSource can you directly upload to an InfoCube? There are 3 correct answers to this question.
Answer
  • Before Image and After Image
  • After Image
  • Additive Image
  • Reverse Image
  • Delete Image

Question 51

Question
Which 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
Answer
  • Write­-optimized datastore objects
  • Transient Providers
  • Direct access datastore objects
  • Hybrid providers

Question 52

Question
What 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.
Answer
  • It uses the Application Link Enabling (ALE) inbox
  • It provides Hierarchy DataSources for all types of source systems
  • It uses transformations and data transfer processes (DTPs)
  • It can use start, end, and expert routines within transformations
  • The InfoPackage controls the file format of the hierarchy data

Question 53

Question
Which of the following connection types supports SAP BW real time data acquisition (RDA)?
Answer
  • Universal data connect
  • Web Service
  • Database connect
  • Flat file interface

Question 54

Question
You 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.
Answer
  • MultiProviders
  • Open hub destinations
  • DataSources
  • InfoPackages

Question 55

Question
What can you define in a currency translation type in SAP BW? There are 2 correct answers to this question
Answer
  • Target currency
  • Transformation Rule type
  • Currency Table
  • Exchange rate type

Question 56

Question
What can you do when you model a MultiProvider to ensure optimal query performance?
Answer
  • Select nom­cumulative key figures for the multiprovider
  • Select characteristics for reporting that are available in all the components
  • Select parts of compound characteristics for the MultiProvider
  • Assign the characteristics for reporting evenly among the dimensions

Question 57

Question
In 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?
Answer
  • Set the company code characteristic as a navigation attribute for the plant
  • Set the company code characteristic as time­dependent navigation attribute for the plant
  • Set the company code characteristic as a reference characteristic for the plant
  • Set the company code characteristic as compounding characteristic for the plant

Question 58

Question
Which of the following activities can you perform with the Metadata Repository?
Answer
  • Activate installed SAP BI content objects
  • Customize SAP BI content objects
  • Install SAP BI content objects
  • Search for installed SAP BI content objects

Question 59

Question
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 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.
Answer
  • Routine
  • Read master data
  • Direct assignment
  • Constant

Question 60

Question
Which of the following SAP BW InfoProviders is typically used in the Enterprise Data Warehouse (EDW) layer?
Answer
  • Stardard DataStore object
  • InfoSet
  • InfoCube
  • MultiProvider

Question 61

Question
In 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?
Answer
  • Model the material group characteristic as a time­dependent attribute of the material characteristic
  • Model the material characteristic with the two additional attributes Valod from and Valid to
  • Model the material and material group as InfoProvider characteristics
  • Model the material characteristic as a time­dependent attribute of the material group characteristic.

Question 62

Question
How can you prevent a process chain from starting immediately after activation? There are 2 correct answers to this question.
Answer
  • Set a start process for the process chain using default parameters
  • Set the start process using the “Meta chain or AIP” scheduling option
  • Maintain your process chain as a sub­process chain without a start process
  • Set the start process to a specific data and time using the “Direct scheduling” and “change Selections” scheduling options

Question 63

Question
Which archiving strategy would use to reduce the SAP BW database size and still allow reporting on an ad­-hoc basis?
Answer
  • Reload of archived data back into the InfoProvider
  • Near­line storage archiving for InfoProvider data
  • Classic archiving for data load request administration and log data
  • XML­based archiving to a WebDAV system for InfoProvider data

Question 64

Question
What are the properties of a standard InfoCube? There are 2 correct answers to this question.
Answer
  • It can combine several InfoProviders
  • It has a minimum of four dimension tables
  • It is a write­optimized provider
  • It can contain a maximum of 233 key figures

Question 65

Question
What happens during the creation of an Info-cube? There are 3 correct answers to this question.
Answer
  • Compounded characteristics of select characteristics are chosen
  • The unit of measure or currency of each key figure in assigned in the unit dimension
  • The charactesristic 0REQUID (Request ID) is assigned to the Data Package dimension
  • Dimension that contain multiple characteristics are set as line item dimensions
  • Navigational attributes are assigned to a separate dimension

Question 66

Question
All of your data updates into a standard DataStore object are successful but the report does not show the correct results. You want to re­run the DTP. What must you do before the reload to investigate this issue?
Answer
  • Trace every record in the Persistent Staging Area (PSA)
  • Set up temporary storage in the data transfer process
  • Define semantic groups in the data transfer process
  • Define filters in the data transfer process

Question 67

Question
What can you do with the hierarchy framework when you load hierarchies into SAP BW? There are 2 correct answers to this question
Answer
  • You can expand the hierarchy if the field length is changed
  • You can identify the details of nodes that are built from characteristics
  • You can expand the hierarchy by using Star, end and expert routines in the transformation
  • You can use multiple persistent Staging area (PSA) one for each segment of the hierarchy

Question 68

Question
When does the SAP BW system build a surrogate ID (SID) table?
Answer
  • When you first load master data into a characteristic
  • When you first load data into an infocube
  • When you first activate a characteristic
  • When you first activate an infocube

Question 69

Question
You 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?
Answer
  • Use a set of Transformations and data transfer processes (DTPs) for each dataSource
  • Use Data Source ­specific transformations bound by and InfoSource to an Info-Provider­ specific transformation
  • Design a real­time data adquisition data flow for a n SAP BW Infoprovider
  • Use one transformation for all data Sources bound by and infoSource to an infoProvider­specific transformation

Question 70

Question
Using 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
Answer
  • New Key figures
  • New Characteristics
  • New Navigation attributes
  • New Dimensions

Question 71

Question
In 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?
Answer
  • Model the material group as a time­independent attribute of the material
  • Model the material group as a time­dependent attribute of the material
  • Model the material group compounded to the material
  • Model the material and the material group in the dimentions of the infocube

Question 72

Question
You 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
Answer
  • How to handle user authorizations
  • How to manage master data coming from different source systems
  • How to handle multiple currencies
  • How to handle queue delta loads

Question 73

Question
Which of the following tables contains the attribute values of the ZMATERIAL characteristic?
Answer
  • /BIC/TZMATERIAL
  • /BIC/PZMATERIAL
  • /BIC/HZMATERIAL
  • /BIC/JZMATERIAL

Question 74

Question
You 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?
Answer
  • Data has been compressed in the infocube with zere elimination
  • Data was not rolled up into the aggregates
  • Data has been deleted by request from the DSO but not fron the infocube
  • Data in the DSP activation queue has not been activated

Question 75

Question
What must you create to use data transfer process (DTP) error handling?
Answer
  • A DTP with extraction mode FULL
  • A DTP with the transfer method Persistent Staging Area (PSA)
  • A process chain using the DTP
  • A DTP with extraction mode INITIAL

Question 76

Question
Which 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
Answer
  • Distribute the characteristics equally over all dimensions
  • Assign two characteristics that have an N:M relantionship to different dimensions
  • Assign two compounded characteristics to different dimensions
  • Use line item dimensions for characteristics with high cardinality
  • Place the most selective characteristics first in the dimension

Question 77

Question
In which layered architecture (LSA) layer of SAP BW do you model business requirements?
Answer
  • Enterprise data warehouse
  • Quality and Harmonization
  • Architected Data Mart
  • Data Propagation

Question 78

Question
What can you use to ensure that the daemon that triggers the real­time data acquisition (RDA) for your sales orders stops at the end of a workday? There are 2 correct answers to this question.
Answer
  • The Data Load Monitor
  • The Daemon Monitor transaction (RSRDA)
  • A process chain
  • InfoPackage settings

Question 79

Question
What can you do during the data activation of a DataStore object (DSO)? There are 2 correct answers to this question.
Answer
  • Update other InfoProviders from the DSO
  • Execute queries on the DSO
  • Delete the contents of the DSO
  • Upload data into the DSO

Question 80

Question
Which SAP BW InfoProviders can serve as data targets? There are 2 correct answers to this question.
Answer
  • InfoSet
  • MultiProvider
  • Standard DataStore Object
  • InfoCube

Question 81

Question
You 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?
Answer
  • VirtualProvider
  • DataStore Object
  • MultiProvider
  • Standar InfoCube

Question 82

Question
Which 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
Answer
  • InfoSource
  • DataSource
  • MultiProvider
  • DataStoreObject (DSO)

Question 83

Question
You 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?
Answer
  • Query monitor
  • Work load monitor
  • SAP BW administration cockpit
  • Database statistics

Question 84

Question
You 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?
Answer
  • 1. 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)
  • 1. 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
  • 1. 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)
  • 1. 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

Question 85

Question
Your 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.
Answer
  • As a navigation attribute of 0MATERIAL
  • As a compounding characteristic for 0MATERIAL
  • As a Display attribute of 0MATERIAL
  • As a referencing characteristic to 0MATERIAL

Question 86

Question
You 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?
Answer
  • Customer group as a time­independent navigation attribute of the customer characteristic. Material group as a characteristic in your infocube
  • Customer group as a time­dependent navigation attribute of the customer characteristic. Material group as a characteristic in your infocube.
  • Customer Group as a characteristic in your infocube. Material group as a time­ independent navigation attribute of the material characteristic
  • Customer group as a time­independent navigation attribute of the customer characteristic. Material group as a time­dependent navigation attribute of the material characteristic

Question 87

Question
When does the SAP BW system build a surrogate ID (SID) table?
Answer
  • When you first activate a characteristic
  • When you first load data into an infocube
  • When you first activate an infocube
  • When you first load master data into a characteristic

Question 88

Question
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 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
Answer
  • Routine
  • Direct assignment
  • Constant
  • Read master data

Question 89

Question
In 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?
Answer
  • Use a Duplicate node
  • Use two different hierarchy versions
  • Use a temporal hierarchy join
  • Use a Link node

Question 90

Question
Which of the following activities can you perform with the Metadata Repository?
Answer
  • Activate installed SAP BI content objects
  • Install SAP BI content objects
  • Search for installed SAP BI content objects
  • Customize SAP BI content objects