What can you use to accelerate an SAP BW implementation project? Select the correct answer. SAP BW Data Warehousing Workbench SAP BI Content SAP BW Accelerator (BWA) SAP BW Statistics.
Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers. Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers. Evaluate the volume of data to be loaded Evaluation of the number and types of users Evaluate the format of data to be loaded.
Which of the following does the data propagation layer of your SAP BW system offer? There are 2 correct answers. Ability to extract once and deploy many times Fast load of mass data A single version of the truth Homogenized data.
Your customer wants to model their SAP BW system according to the best practices. You propose using a layered scalable architecture (LSA). Which of the following steps must you perform? There are 2 correct answers. Model disjoint 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 is the purpose of the Enterprise Data Warehouse (EDW) Layer? There are 2 correct answers. To ensure vertical consistency of the data flow To provide a layer where data can be overwritten to reflect the current status of business transactions To provide an enterprise wide repository of business data at a summary level To ensure that data is only extracted once from source systems.
Which of the following types of join are possible with an InfoSet? There are 3 correct answers. Union Unbalanced Temporal Inner Left Outer.
Which of the following is a valid sequence for modeling objects in the BW data flow? Select the correct answer. From DataSource to InfoSource to InfoCube without a Transformation From DataSource to Transformation to InfoSource to InfoCube From DataSource to Transformation to InfoSource to Transformation to InfoCube From DataSource to InfoSource then directly to another InfoSource to Transformation to InfoCube From InfoSource to DataSource to InfoCube.
Which of the following statements about aggregates is true? There are 2 correct answers. Aggregates can only be created for Basic Cubes Aggregates are stored as a single transparent table, which houses the aggregated data Aggregates can be created on dimension characteristics and navigational attributes Several dimension characteristics used in an aggregate always have the same aggregation level Aggregates reduce the number of key figures.
Which of the following statements about aggregates with time-dependent components is true? Select the correct answer. Aggregates with time-dependent components are calculated for a key date The key date for an aggregate with a time-dependent component is always a fixed date When aggregates with a time-dependent component are filled the key date is retrieved For a query to use data in an aggregate with a time-dependent component, the query's key date does not have to match the key date of the aggregated.
Which of the following are true regarding an aggregate roll-up? Select the correct answer. It is needed every time new data is loaded into the InfoCube It does not have any relationship to the availability of data for reporting in an aggregate It compresses data into the E Table of the aggregate It is the same thing as an attribute change run.
Which of the following statements about InfoCube management is true? There are 2 correct answers You can inspect the contents of the fact table only Repair and rebuild indices Gain an overview of SID values Roll-up requests into aggregates regardless of the activation status of the aggregate.
Which of the following statements about the compression of an InfoCube are true? Select the correct answer. Compression leads to a reduction in storage space and an increase in read performance During compression the Request ID in the Data Packet Dimension is ignored Once compression takes place it is still possible to manage individual request separately The compressed data is retained in the F Table of the InfoCube.
Which of the following definitions of a DSO is true? Select the correct answer. DSO Objects are subsets of an InfoCube's data DSO Objects are equivalent to aggregates DSO Objects contain consolidated data at the atomic level DSO Objects are unique to OLTP Systems.
Which of the following are features of DSOs? There are 2 correct answers. They store unconverted OLTP data They enable drilldown in reporting from InfoCube to the DSO They enable overwrite functions for key figures and non-key figure characteristics They are integrated with the Business Explorer (BEx).
Standard DSO Objects consist of which of the following tables? Select the correct answer. Activation Queue, Active Data and PSA Active Data, Change Log and PSA Active Data, Change Log and PSA Change Log, Activation Queue, Active Data.
Which of the following are features of the Write-Optimized DSO? There are 2 correct answers. They utilize the single Active Data Table They are intended to contain aggregated data They enable mass data loads They utilize a semantic (business) key for record uniqueness.
Which of the following are standard aggregation types for Key Figures? There are 2 correct answers. Summation Average Last Value Minimum.
How are non-cumulative Key Figures calculated? There are 2 correct answers. They can utilize a virtual Key Figure to combine inflows and outflows They are designed in Business Explorer queries They can utilize two virtual Key Figures to represent inflows and outflows Their calculation is accomplished in Transformations.
What can you do to have two or more hierarchies with the same technical name? Configure the hierarchy as version-dependent Configure the hierarchy to have a time-dependent structure Configure the hierarchy with link nodes Configure the hierarchy as time-dependent.
What other layer of the EDW layer can be used in place of the Corporate Memory? Select the correct answer. The Business Transformation Layer The Reporting Layer The Data Acquisition Layer The Data Propagation Layer.
How can BI Content be used in a SAP BW implementation? There are 2 correct answers. Enable Business Blueprint and Realization Eliminate the need for requirements analysis Replaces analysis and data modeling Continuous improvement after go-live.
End-users want to see the Material Group assigned to a Material at the time of the transaction. How should you model there InfoObjects to accomplish this? Select the correct answer. Model Material Group as a time-dependent navigation attribute of Material Model Material Group as a time-dependent hierarchy of Material Model Material and Group in the same InfoCube Dimension Table Model Material Group as a time-independent navigation attribute of Material.
You want postable nodes in a hierarchy to appear in multiple hierarchy branches. What action could you take to accomplish this? Enter the postable nodes as Link Nodes Configure the hierarchy as time-dependent Create multiple similar hierarchies Configure the hierarchy with a time-dependent structure.
What are the differences between the Reporting and Operational Data Store (ODS) layers in LSA if both are reportable? There are 2 correct answers. They can use different InfoProvider types The ODS layer is typically used for archiving They differ in data refresh requirements They differ in the granularity of data.
What are the advantages of using a line-item dimension when modeling an InfoCube? There are 2 correct answers. The primary key of the InfoCube fact table is shorter The number of joins that must be executed during query runtime is reduced Data is loading into the InfoCube without generating DIM IDs for this dimension Aggregates on this InfoCube do NOT need to be built.
Which of the following objects can you use as a source objects for a Transformation object? There are 2 correct answers. Transient Provider Infoset OpenHub Destination Infosource.
What can you do in the remodeling toolbox? There are 3 correct answers. Convert an InfoCube dimension to a line-item dimension Change the standard aggregation of the key figure Delete a characteristic Change the reference characteristic Delete a characteristic of an InfoCube.
Which of the following actions must you perform to design the dimensions of an InfoCube when you want to accelerate query performance? There are 3 correct answers. Assign two characteristics that have an N:M relationship to different dimensions Each dimension should have the same number of characteristics Place the most selective characteristics first in the dimensions Use the line item dimensions for characteristics with high cardinality Assign two compounded characteristics to different dimensions.
What are the advantages of using a line-item dimension when modeling an InfoCube? There are 2 correct answers. The primary key of the InfoCube fact table is shorter The number of joins that must be executed during query runtime is reduced Data is loaded into the InfoCube without generating DIM Ids for this dimension Aggregates on this InfoCube do NOT need to be built.
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. Create aggregates Replace the InfoCube by a SPO Use the process type "Fill OLAP cache" in a process chain Use navigation attributes instead of dimension characteristics Use several InfoCubes as PartProviders of a MultiProvider instead of a single standard InfoCube.
You have created a new Data Flow object in the graphical sAP BW data Flow tool by copying a Data Flow template. What must you do to use the new Data Flow? Select the correct answer. Copy non-persistent SAP BW Objects Validate non-persistent SAP BW Objects Activate non-persistent SAP BW Objects Replace non-persistent SAP BW objects with active SAP BW objects.
You are executing a process chain to load transaction data from an SAP source system via a standard DSO into an InfoCube but NO DATA arrives in the InfoCube. What are possible reasons for this? There are 2 correct answers. The data does NOT meet the selection criteria of the DTP The data comprises an error and the error handling setting is set to "Cancel Request, Do Not Track Records, No Update" The Data Flow object has NOT been activated The Integrity check is NOT switched on in the transformations.
You want to update the 3.x version of an SAP BW DataSource to a 7.x version with the capability to restore the original version. What should you do during the migration to achieve this? Please choose the correct answer. Replace the 3.x SAP BW InfoSource with a 7.x version SAP BW InfoSource Migrate the 3.x DataSource version with export. Delete all entries from the Persistent Staging Area (PSA Create a transformation to replace the transfer rules.
What are performance advantages when using an InfoCube instead of a DataStore object? There are 2 correct answers. Reporting access to granular data using standard dimensions is faster. The use of Surrogate IDs (SIDs) to replace master data values in tables. Dimension tables can be read independently. Navigational attributes can be used.
Which of the following does the data propagation layer of your SAP BW system offer? There are 2 correct answers. Complete data history. Fast load of mass data. A single version of the truth. Ability to extract once and deploy many times.
Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers. Evaluate the volume of data to be loaded. Derive the customer specific LSA. Analyze relationships between the characteristics and their attributes. Evaluate the format of data to be loaded.
Which of the following are true regarding BW Data Modeling? There are 3 correct answers. BW objects are created with reference to administrative needs. Reporting requirements are the necessary starting point. Different types of reporting end-users can be ignored. Reference to BW Business Content should be conducted during the development of the data model. Business Content does not need to be activated.
Which of the following are true regarding navigational attributes? There are 3 correct answers. They are directly linked to the InfoCube Dimension tables. They must be switched on for specific InfoProviders. They do not generate additional tables outside the InfoProvider. Behave like Characteristics in a Dimension table. Must be part of the definition of the Characteristic InfoObject definition.
Which of the following are true regarding Aggregates? There are 3 correct answers. They are intended to increase query performance. They can be created for DataStore Objects. They can be created with reference to a time-dependent navigational attribute. They are flat when containing 15 or less user-defined Characteristics. Flat aggregates have no effect on query performance.
Which of the following is a viable alternative to having more than 13 unrelated Characteristics in an InfoCube? Select the correct answer. Reduce the number of Characteristics down to 13. Create more than 13 custom-defined Dimensions. Add the extra ones as Key Figures. Associate unrelated Characteristics in a single dimension. Use more than one InfoCube in the design.
Which is the best way to model the object "Price?" There are 2 correct answers. If the price of an object changes slowly, model it as a navigational attribute. If the desired result is the price paid by a customer at the time of the Transaction, model price as a calculated Key Figure. Leave it out of the data model. If the price of an object changes slowly, model it as a display attribute.
Your InfoCube contains the following Key Figures: Planned Amount, Budgeted Amount, Forecasted Amount, Planned Quantity, Budgeted Quantity and Forecasted Quantity. You want to reduce the number of Key Figures to only Amount and Quantity and still retain the uniqueness of key figure values? How can you accomplish this? There are 2 correct answers. Create a new Dimension table containing a Characteristic to distinguish the key figure types. Create three InfoCubes; one each for Planned, Budgeted and Forecasted key figure values. Create Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types. Use the Select option "Unique for Every Cell" in the distinguishing Characteristic.
Which of the following process chain collector steps prevent multiple executions of a successor process? There are 2 correct answers. The Start process step triggered by a Meta Chain The Exclusive OR process step. The OR process step. The Attribute Change Run process step. The AND process step.
A process chain has encountered an error before its conclusion. What are possible troubleshooting steps? There are 3 correct answers. Review the message in the context menu of the failed step. Repeat the scheduled trigger of the process chain. If available, use the Manage object context menu option of the failed step. Use either the Repeat or Repair context menu option of the failed step. Reschedule the process chain for the next day.
Which of the following are true about the process step options Repair and Repeat? There are 3 correct answers. Repeat schedules the process chain for a future date. Repair automatically fixes the error allowing the process chain to continue. Repair uses the same step instance. Certain steps can use either option. Repeat begins a new step instance.
You want to load data from an SAP ERP source system in SAP BW. Which of the following ETL technologies could you use? There are 2 correct answers. Flat files. SAP Data Services with the Service API. UD Connect with JDBC connectors to SQL Server. DB Connect with a Microsoft Access database. BI Content with the Service API.
Which of the following are true about generic DataSources? There are 3 correct answers. They can NOT be enhanced with additional fields after creation. They are can be defined with delta capability. They are can be used with real-time data extraction. They are replicated by process chain. They can be defined with filter criteria.
You have configured an extraction of master data from an SAP ERP source system. After the first extraction, all of the previously extracted data is being loaded. What could be the possible cause? There is one correct answer. The DataSource extraction type has been set to "Full." The InfoPackage has been set to "Full" update. The subsequent Transformation has rules set to "Addition." There is no delta data in the PSA table. The DataSource has been configured with interim storage.
Your reporting end-users request reporting on year-to-date data. Which of the following would enable this capability? There are 2 correct answers. Use a combination of an InfoCube query with current data directly extracted from the source system. Use a HybridProvider based on a Virtual Provider. Use TransientProviders. Use a DSO with Real-time Data Acquisition. Use a MultiProvider with a Write-Optimized DSO and an InfoCube as components.
Data is loaded via a process chain to an Open Hub destination table. When this table data is then loaded into a non-SAP operational system, it is found that records are duplicated over time. What action should you take to resolve this? Select the correct answer. Configure a technical key for the destination table. Configure the destination table to be recreated on load. Configure a semantic key for the destination table. Switch the destination to a flat file in XML format.
A HybridProvider based on a RDA DSO is duplicating data in the standard InfoCube. What could be the cause of this scenario? Select the correct answer. Disable all unnecessary aggregates. The associated process chain does not delete the DSO data. The associated process chain does not delete the InfoCube data. The Daemon schedule must be less frequent.
A Flat interface DataSource is used to extract file data into the PSA. The DTP, however, is having trouble loading the data into an InfoCube. What could be the possible solution? Select the correct answer. The BW DTP is set to Full extraction. The Transformation does not have rules for all destination fields. The DataSource has a delta process of FIL0. The BW DTP is set to Full extraction.
What does SAP recommend you do to improve the overall reporting performance of an InfoCube in SAP BW 7.4? There are 3 correct answers. Include the InfoCube into a semantically partitioned object (SPO). Execute a pre-load OLAP cache process in a process chain. Create aggregates Create one or more line item dimensions. Split the standard InfoCube data into several InfoCubes contained in a MultiProvider.
Which of the following record modes delivered by a DataSource can you directly upload to an InfoCube? There are 3 correct answers. Reverse Image Before Image and After Image Delete Image Additive Image After Image.
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 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 update rules and a data transfer process. Create the Data Flow manually to create transformations and a data transfer process.
Which of the following settings can you make for error handling in the data transfer process? There are 2 correct answers. Write invalid records into the target InfoProvider. Process the correct records and allow reporting on them. Process the correct records and do NOT allow reporting on them. Get all new data in source request by request.
What must you create to use data transfer process (DTP) error handling? Choose the correct answer. A DTP with extraction mode FULL A DTP with extraction mode INITIAL A process chain using the DTP A DTP with the transfer method Persistent Staging Area (PSA).
Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers. Analyze relationships between the characteristics and their attributes. Evaluate the volume of data to be loaded Evaluate the number and types of users. Evaluate the format of the data to be loaded.
Which of the following does the data propagation layers of your SAP BW system offer? There are 2 correct answers. Ability to extract once and deploy many times Fast load of mass data A single version of the truth Homogenized data.
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. 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 requirement and objectives.
What are performance advantages when using an InfoCube instead of a DataStore Object? There are 2 correct answers. Navigational attributes can be used. Surrogate ID (SID) keys and DIM_ID keys are generated automatically. Surrogate IDs (SIDs) replace master data values in dimension tables. Reporting access to granular data using standard dimensions is faster.
You need to transport your BW objects and your ECC DataSources. Which is the right order to do so? Select the correct answer. Transport your DataSources, Transport your BW objects, Replicate your DataSources Transport your BW Objects, Replicate your DataSources, Transport your DataSources Transport your DataSources, Replicate your DataSources, Transport your BW Objects.
When is the Change Run required after successful completion of a master data load? Select the best answer. When changes are made to texts from Characteristics used in an Aggregate. When changes are made to attributes or hierarchies from Characteristics used in an Aggregate When changes are made to attributes, hierarchies or texts from Characteristics used in an Aggregate. When changes are made to the structure of the InfoCube.
Which setting increases the performance of the Activation job for a Standard DSO? Select the correct answer. Unique Data Records Automatically Repeat Red Requests in Process Chain. Parallel Activation of Requests in Activation Queue SID Generation During Activation.
You have been asked to delete a request from an InfoCube. What best describes the situation? Select the correct answer. You cannot delete the request since it is compressed. You cannot delete the request if it has a red status. You have to create Aggregates before you delete the request. You must change the request status to green before you can delete.
You are not able to delete a request from a DSO. What best describes the situation? Select the correct answer The request has been compressed. The request is contained in an Aggregate The request is contained in a subsequent InfoProvider. The request must be deleted selectively.
You are not able to transport newly created queries from your development SAP BW system to production. Which of the following could be a possible problem. There are 2 correct answers. The queries have not been written against a MultiProvider. The queries not have an active version. The queries are contained in the incorrect InfoArea. The queries have not been assigned to a BEx transport request.
After transporting BEx workbooks to production from development, users state that they cannot find the workbooks. What would be the most logical reason? Select the correct answer. The BEx workbooks are not active in production. The users' roles have to be updated in production. The BEx workbooks have not been authorized. The users' roles have to be re-transported.
You want to increase the overall performance of a designed standard DSO. The DSO has contains 100 InfoObjects in its definition, 5 of which are in the Key Part. Which of the following possible actions should you take? There are 3 correct answers. Create secondary indexes Decrease the size of the Key Part. Set up automatic deletion of Change Log data. Set the Settings option for Unique records. Set up the automatic movement of Active Table records to a subsequent InfoProvider.
Which of the following layers of the LSA can also serve in the capacity of Corporate Memory? Select the correct answer. The Data Acquisition layer. The Business Transformation layer. The Quality and harmonization layers. The Data Propagation layers. The Reporting layer.
A Business Content transactional Datasource that uses delta queue processing was converted to Real Time Data Acquisition. An analysis reveals that no new deltas are being transferred into SAP BW 7.x, even though documents are regularly created in the SAP source system delta queue. What tools could you use? There are 2 correct answers. Process Chain Monitor Extractor Checker in SAP ECC SAP BW Delta Queue Data Load Monitor.
An InfoCube has been designed with 2 user-defined Dimensions containing 1 and 3 Characteristics respectively. All InfoObjects have the same level of master data value cardinality. How can you change the design of the InfoCube to optimize performance? Select the correct answer. Put all Characteristics in a single user-defined Dimension. Distribute the InfoObjects unevenly between the Dimensions. Make the single InfoObject the one Dimension the key of the InfoCube. Create 2 more Dimensions so that each has only 1 InfoObject.
The Materials department has created several new products (0PRODUCT) and transactional data for them in the source system. Neither the new products nor the transactional data are visible in SAP BW reporting. Which of the following helps you analyze the issue? There are 3 correct answers. Check for the new data in the DataSource PSA. Check that the InfoCube compression is up to date. Check that the InfoCube contains the new master data. Check that the InfoCube contains the new transaction data. Check the Attribute Change Run.
You have added the fields "ZCOUNTRY" and "ZLOCALITY" to the DataSource, 0CUSTOMER_ATTR . Which of the following is necessary to ensure that the new fields can be extracted from the source system into PSA of the DataSource in SAP BW. Select the correct answer. All target InfoProviders must be active and connected. All target InfoProviders must have their table space increased. All fields of 0CUSTOMER_ATTR have been mapped. All active customer ABAP enhancements of 0CUSTOMER_ATTR are active.
What are the features of using the Operational Data Provisioning (ODP) Infrastructure in BW 7.4? There are 3 correct answers. Extract once and deploy many times. Relies on the proven Delta Queue technology. High compression rate up to 90% of extracted data. Single point of monitoring. Makes complete use of mandatory PSA's.
Which of the following are true regarding ODP/ODQ data extraction into BW? There are 2 correct answers. PSA tables continue to be mandatory. DTPs continue to be mandatory. DataSources continue to be mandatory. Transformation are no longer necessary. The Delta Queue in BW is necessary.
How does an ODP DataSource become visible in the Operational Delta Queue (ODQ)? Select the correct answer The ODQ load program is run periodically. The DataSource's InfoPackage or DTP is executed. The DataSource is activated in the BI Content area of the Data Warehousing Workbench. When the SAP source system is connected to SAP BW.
When should you use the Generic Data Extractor tools to create a data source? There are 3 correct answers. When Business Content does not contain a data source for your application. When you use customer written programs in R/3 to populate your tables. When the data to be extracted is highly granular. When the application does not feature its own data extraction method. If you want to extract data without delta extractions.
You want to report on a MultiProvider containing a Standard DSO and an InfoCube. Data in the InfoCube has been archived to a SAP IQ near line storage system. Queries written for the MultiProvider do not display the archived data. What setting should you check? Select the correct answer. Release OLE DB for OLAP Read Mode NLS Usage Data Integrity.
Which of the following are true regarding DB and UD Connect technologies? There are 2 correct answers. UD Connect contains an inherent "Group By" clause. UD Connect requires ABAP connectors. DB Connect normally reduces the granularity of the data. DB Connect requires the potential use of a Database Shared Library.
A BW 7.4 data flow has been working successfully for a while. Today the data flow resulted in an error after the DataSource has been changed and reactivated. What could be the possible problem? Select the correct answer. The Transformation connecting the DataSource needs reactivation. The PSA entries need to be reactivated. The PSA entries should have been deleted prior to the DataSource reactivation. The InfoProvider data should have been first deleted.
The hierarchy framework allows the DataSource to read the hierarchy structure based on which setting? Select the correct answer. The hierarchy is version-dependent. The hierarchy is sorted. The hierarchy reverses +/- nodes. The hierarchy is flexible.
There is a need to extract millions of records from an Oracle database into BW for analysis. Which of the following represents the best ETL strategy? Select the correct answer. Modify a BI Content DataSource to include the Teradata fields in the extraction. Use the File interface to extract manageable files of no more than 20,000 records each Use a WebService DataSource to stream the records into the PSA of the DataSource. Use DB Connect for the ETL process. Use UD Connect for the ETL process.
A Flat interface DataSource is used to extract file data into the PSA. The DTP, however, is having trouble loading the data into an InfoCube. What could be the possible solution? Select the correct answer. The BW Delta Queue is empty. The BW DTP is set to Full extraction. The DataSource has a delta process of FIL0. The InfoPackage is not active. The Transformation does not have rules for all destination fields.
What pre-requisites must be fulfilled to use a generic DataSource for real time data acquisition (RDA)? There are 2 correct answers. A Generic Delta Service must be part of the definition. The delta field must be a selection criteria. The Delta Service must be marked for RDA. The delta field must be a numeric pointer. The DataSource must be based on a function module.
The UD Connect extraction of document level data from a SQL Server database results in a loss of document detail in BW. What possible action could you take to resolve this? Select the correct answer. Use a generic DataSource with a numeric pointer for the delta service. Use a DataSource based on SAP Data Services to restore the detail. Use a DSO for Real Time Data Acquisition. Use a DB Connect based DataSource.
The Marines order 8 service members for deployment on Monday. This data is loaded to a Standard DSO. Then the office requests 2 less service members, for a total of 6. This new after image data is also loaded to the DSO. What records will be in the Change Log? Select the correct answer. 8, -8, 6 8, -8, 2 8, 6 8, 2 8, 6, 2.
What is necessary for a VirtualProvider to display data? There are 3 correct answers. A DTP for Direct Access A DataSource for Direct Access HybridProvider MultiProvider DTP that loads data Transformation.
You design a Standard DSO with a semantic key consisting of controlling area and cost center number in the Key Part. What should you do to prevent valid records from being written to the Error Stack during load? Select the correct answer. Use a technical key for the Error Stack. Put all key figures in the Key Part of the Error Stack. Create secondary indexes on the Error Stack. Create a wider semantic group for the Error Stack.
Your reporting end-users have noticed that several Basic InfoCube queries are staring to run more slowly. After examination of the InfoCube, you notice that 2 out of 7 user-defined Dimensions are approaching 50% the size of the Fact Table. What action should you take to resolve this? There are 2 correct answers. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics among the other Dimensions. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics in additional new Dimensions. Remodel the Cube by moving the high-cardinality Characteristics from these Dimensions into one of these 2 Dimensions and the other Characteristics in the other Dimension. Remodel the Cube by creating more Dimensions making as many of them as possible into Line-Item Dimensions and eliminate the remaining Characteristics.
Many of the records you have loaded into a Basic InfoCube consist of Reverse and Additive images. What could you do to reduce the size of the Fact Table? There are 2 correct answers. Divide those records into appropriate Aggregates. Compress the Fact Table. Move these records into a Standard DSO. Rollup the InfoCube. Compress the Fact Table with zero elimination.
The Air Force orders 10 F-14's for deployment on Monday. This data is loaded to an InfoCube. Then the office requests 2 more fighters, for a total of 12. The new after image data is also to be loaded to the InfoCube. However, you receive an error on the InfoCube update. What could be the issue? Select the correct answer. The Transformation should be set to overwrite. The DTP should be set to Full update. The after image needs to first be loaded in a DSO. The InfoPackage should be assigned to a daemon.
Your business is using a variety of queries. You plan on upgrading your SAP BW 7.4 system to the latest support package. You want to ensure that the query results are correct with various navigation steps. What tool would you use to accomplish this? Select the correct answer. The BEx Web Analyzer. The BW Administration Cockpit. The BW Metadata Repository. The BEx Analyzer. The BW Trace Tool.
Partitioning can be used to either aid query response time or manage large amounts of InfoCube data. Which of the following statements are true about InfoCube partitioning? There are 2 correct answers. Logical and table partitioning cannot be combined. The Analytic Engine can do partition pruning. Table partitions are based either on 0CALMONTH or 0FISCPER. The Repartitioning toolbox can be used with logical partitioning.
What are the indications of a missing or inappropriate aggregate? There are 3 correct answers. Percentage of total query time spent on the database exceeds 30%. Ratio of number of rows selected to total query run time exceeds 10%. Database time less than 2 seconds. Ratio of number of rows transferred to the number of rows selected is greater than 10%.
Which of the following are true in designing aggregates? There are 3 correct answers. Multiple aggregates should be designed to fit into a rollup hierarchy. Aggregates containing navigational attributes can be larger than aggregates based on dimensional characteristics. Aggregates are evaluated by the BW system based on usage and number of records. Aggregates can share dimension tables with the InfoCube. Time-dependent aggregates can be adjusted upon changes of the key date only through process chains.
A newly designed important query has less than desirable performance. Which of the following should you check? There are 3 correct answers. Too many key figures in the Columns area of the query default view. Too many characteristics in the Rows area of the query definition. Overlapping filters. Too many characteristics in the Free Characteristics of the query definition. Overuse of filter exclusions on the Filter tab of the query definition.
A MultiProvider has four InfoCubes as components. One InfoCube is a VirtualProvider and two of the others have aggregates. The total execution time of the MultiProvider query is 29 sec when you expect 10 sec. What can account for this scenario? There are 3 correct answers. The shadow aggregates are being used because of the roll up job. The query is running in a batch process. There are non-cumulative key figures in the InfoCubes. The query is configured for nonparallel processing. There are insufficient background processes at execution time.
|
