C_TBW60_74

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

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

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

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

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?. Choose the SID Generation During Activation option in the settings of the standard DataStore Object. 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. Create additional indexes for the standard DataStore object.

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

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

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

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. -export datasource -replicated export datasource -infopackage -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. -Qperational data provisioning (ODP) source system -Datasource for the infoprovider of SAP BW System A -transformation -data transfer process.

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

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

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

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

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? Please choose the correct answer. 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. Use emulation first to model the Data Flow with transformations and a data transfer process.

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

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

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. Reverse Image. Before Image and After Image. Delete Image. Additive Image. After Image.

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

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

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

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?. Expert. Start. Global. Local.

Using the remodeling toolbox, which action can you perform for an SAP BW characteristic InfoObject?. Change the attribute type. Add hierarchies. Change the reference characteristic. Add additional atributes.

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

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

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

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 infoprovider do you have to use to load the flat file into SAP BW?. MultiProvider. DataStore Object. Standar InfoCube. Virtual Provider.

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?. The real-time InfoPackage. The data transfer Process. The deamon assignet to the real-time InfoPackage. New data loads into the SAP source system delta queue.

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 OMATERIAL characteristic in SAP BW to keep the material identifiers unique?. Compounded with the OSOURSYSTEM characteristic. With the time-independent navigation attribute OSOURSYSlEM. With the time-dependent navigation attribute OSOURSYSlEM. With the time-independent display attribute OSOURSYSlEM.

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

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?. Define filters in the data transfer process. Trace every record in the Persistent Staging Area (PSA). Define semantic groups in the data transfer process. Set up temporary storage in the data transfer process.

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?. InfoSource. Data Transfer Process. DataSource. InfoPackage.

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?. Validate non-persistent SAP BW objects. Activate non-persistent SAP BW objects. Replace non-persistent SAP BW objects with active SAP BW objects. Copy non-persistent SAP BW objects.

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?. Update rule. Transfer rule. InfoSource. Transformation.

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 sqquence of task yoy must perform in SAP BW?. 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). 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).

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?. InfoSet. VirtualProvider. HybridProvider. Write-optimized DatStore object.

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

Which of the following objects in SAP BW can you use as the target of a Transformation object?. InfoCube. DataStore Object. MultiProvider. DataSource.

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. Extractors with a delta mechanism for SAP ERP tables. Customer-specific tables from SAP ERP. Tables from non-SAP sources. Delta queue tables from SAP ERP Data Sources.

What can you do with the hierarchy framework when you load hierarchies into SAP BW? There are 2 correct answers to this question. Choose: 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.

You load cost center data from different sourcesystems with different data formats into SAPBW. You want to update the data into a single infoprovider with a Source system How does SAP recommend you design the data flow? Choose one: Use one transformation for all data Sources bound by and infoSource to an infoProvider•specific transformation. Use a set of Transformations and data transfer processes (DTPs) for each dataSource. Design a real-time data adquisition data flow for an SAP BW Infoprovider. Use DataSource-specific transformations bound by and InfoSource to an InfoProvider-specific transformation.

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? Choose one: Model the material group as a time-independent navigation attribute 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 and two selectable user date attributes are time- dependent navigation attributes of the material characteristic.

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

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

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? Choose: Direct assignment. Read master data. Constant. Routine.

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

What can you use to accelerate an SAP BW implementation project? Please choose the correct answer. Choose one: SAP BW Statistics. SAP BI Content. SAP BW Data Warehousing Workbench. SAP BW Accelerator (BWA).

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. Choose: Data Sources. MultiProviders. Open hub destinations. InfoPackages.

Your DataSource provides only After Image delta Which InfoProvider can be loaded directly via this DataSource? Choose one: Infocube. Virtual Provider. DataStore Object (DSO). InfoSet.

Which of the following tables contains the attribute values of the ZMATERIAL characteristic? Choose one: /BIC/HZMATERIAL. /BIC/TZMATERIAL. /BIC/JZMATERIAL. /BIC/PZMATERIAL.

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

In your customer's SAP ERP system, plant 01for company code 100 is a large refrigerator, and plant 01for company code 200 is a warehouse. You want plant 01to be unique for both companies. How do you model the plant characteristic to achieve this? Choose one: Set the company code characteristic as a navigation attribute for the plant. Set the company code characteristic as compounding characteristic for the plant. Set the company code characteristic as a reference characteristic for the plant. Set the company code characteristic as time-dependent navigation attribute for the plant.

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

Which of the following connection types supports SAP BW real time data acquision (RDA)? Choose one: Database connect. Universal data connect. Web Service. Flat file interface.

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

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. The Daemon Monitor transaction (RSRDA). The Data Load Monitor. InfoPackage settings. A process chain.

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. Choose: a system handling has been performed. The change log table is empty. request service that load data into the DSO have been stopped. The cache memory has been cleared.

How can you prevent a process chain from starting immediately after activation? There are 2 correct answers to this question. Choose: Maintain your process chain as a sub-process chain without a start process. Set a start process for the process chain using default parameters. Set the start process using the "Meta chain or AlP" scheduling option. Set the start process to a specific data and time using the "Direct scheduling" and "change Selections" scheduling options.

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. New Characteristics. New Dimensions. New Navigation attributes. New Key figures.

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? Choose one: 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-independent navigation attribute of the customer characteristic. Material group as a time-dependent navigation attribute of the material characteristic. 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.

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. Choose: Assign two characteristics that have an N:M relantionship to different dimensions. use line item dimensions for characteristics with high cardinality. Assign two compounded characteristics to different dimensions. distribute the characteristics equally over all dimensions. Place the most selective characteristics first in the dimension.

Which of the following infoproviders do you use to model the operational data store layer in SAPBW? There are 2 correct answers to this question. Choose: Transient Providers. direct access datastore objects. Hybrid providers. Write-optimized datastore objects.

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. Choose: InfoSource. DataSource. DataStoreObject (DSO). MultiProvider.

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

Which transaction must you use to change the level of reporting for statistics data? Choose one: Maintenance of Statistics Properties (RSDDSTAT). ABAP Dictionary Maintenance (SEll). Query Monitor (RSRT). SAP BW Workload Statistics (ST03).

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

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

What are the properties of a standard InfoCube? There are 2 correct answers to this question. Choose: 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.

Which of the following activities can you perform with the Metadata Repository? Choose one: Search for installed SAP BI content objects. Activate installed SAP BI content objects. Install SAP BI content objects. Customize SAP BI content objects.

You want to get the following information: . Duration of data loads . Report runtimes . Details about how SAP BW InfoProviders, InfoObjects, InforSources, source systems and aggregates are used. What can you use to get this information? Choose one: Query monitor. SAP BW administration cockpit. Database statistics. Work load monitor.

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? Choose one: InfoCube. DataStore object. Virtual Provider. MultiProvider.

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? Choose one: 1. Create a data source in SAP BW 2.Create and Info Package 3.Execute the SAP BW Info Package 4.Create a Data Services job in SAP Data Services. 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 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.Create a Data Services job in SAP Data Services 4.Execute the SAP BW InfoPackage.

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

What must you create to use data transfer process (DTP) error handling? Please choose the correct answer. Choose one: A DTP with the transfer method Persistent Staging Area (PSA). A DTP with extraction mode FULL. A DTP with extraction mode INITIAL. A process chain using the DTP.

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

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

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

Your customer wants to store material data (infoObject OMATERIAL) and material proposed data (infoObject ZMAT_PROP). Both infoObjects should be based on the same material master data. Choose one: As a navigation attribute of OMATERIAL. As a referencing characteristic to OMATERIAL. As a Display attribute of OMATERIAL. As a compounding characteristic for OMATERIAL.

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

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

Which of the following infoproviders do you use to model the operational data store layer in SAPBW? There are 2 correct answers to this question. Choose: Transient Providers. direct access datastore objects. write-optimized datastore objects. hybrid providers.