Which action can you perform when you select manager an Advanced Data store object? Please choose the correct answer.
- A . Display metadata.
- B . create ae transfer process.
- C . Selectively delete data.
- D . Activate the advanced Data store object.
SAP Landscape Transformation replication server with operational data provisioning utilizes the operational delta queue (ODQ).
Which of the following is an advantage of the ODQ? Please choose the correct answer.
- A . The ODQ uses a daemon for scheduling
- B . The ODQ provides scheduling through infopackages independently of the data transfer process setting.
- C . The ODQ provides semantic parallelization for error handling.
- D . The ODQ provides high data compression of 90% or more.
You want to copy an SAP Business warehouse query from a source info provider to a target info provider.
Which prerequisite must be fulfilled? Please choose the correct answer.
- A . The query to be copied must NOT contain reusable query components.
- B . The type of the source info provider and the target info provider must be the same
- C . The target info provider must contain at least all the info objects
Which of the following objects are available when you activate SAP Business objects Business Intelligence content? There are 3 correct answers to this question.
- A . Data flow
- B . Calculation view
- C . Process chain
- D . Planning function
- E . Aggregation level
You need to create an SAP Business Warehouse data flow that combines data from two sources in an advanced Datastore object (DSO) There are different and value for the same entry in the source.
Which approach does SAP recommend? Please choose the correct answer.
- A . Create an open ODS as a non-persistent intermediate layer to perform a join from the source dependent parts need to be implemented in the same transformation.
- B . Create a composite provider as a non-persistent intermediate layer to perform a join from the source the source-dependent parts need to be implemented in the same transformation.
- C . Create an infosource as a non-persistent intermediate layer.the source-dependent parts of the a transformation need to be implemented before the info source.
- D . Create an infoset as a non-persistent intermediate layer.the source-dependent parts of the transformation need to be implemented before the info set.
You need to delete data for a company code from an advanced Datastorg ghieet where do you do this?
- A . Please choose the correct answer.
- B . Select the request->delete
- C . Environment menu->Selective Deletion
- D . Environment menu->Delete content
- E . Environment menu->remove inbound table
You instantiate a non-persistent characteristic info object.
Which options do you have? There are 2 correct answers to this question.
- A . Change existing in object
- B . Create new in object
- C . Use existing in object
- D . Generate in object
You use the query monitor transaction (RSRTI) to investigate the poor performance of a query.
Which actions do you perform when you use this transaction? There are 3 correct answers to this question.
- A . Debug the query
- B . Maintain the read mode and the cache mode of the query.
- C . Execute the query without using the cache
- D . Maintain the technical info of the query.
- E . Change the query definition
Which tool do you use to monitor streaming process chains? Please choose the correct answer.
- A . Subscription monitor
- B . Queued Task manager monitor
- C . Operational Delta Queue monitor
- D . Real-time Data acquisition monitor
In the SAP business Warehouse Query Designer in the SAP HANA studio, what can you define using the cell editor? Please choose the correct answer.
- A . Additional filters restrictions that apply to a complete column or row of the result set
- B . Formulas and selections for cells to override the cell values
- C . Cell references that can pass their results to variables processed with a replacement path
- D . Help cells that serve as containers for help selections or formulas to display in the query
Your customer needs views of data, defined by multiple conditions you create multiple conditions in a query and activate multiple conditions in the report.
What is the effect on the report result? Please choose the correct answer.
- A . The report result depends on the application of a logical OR between the conditions.
- B . The report result depends on the application of a logical AND between the conditions.
- C . The report result depends on the activation sequence of the conditions.
- D . The report result is independent of the report drilldown.
You need to create an SAP HANA calculation view and connect a fact table to a dimension view.
Which type of node do you create? Please choose the correct answer.
- A . Aggregation node
- B . Star join node
- C . Union node
- D . Join node
Which of the following process steps are common between a classical SAP Business warehouse process chain and an SAP HANA optimized process chain? Please choose the correct answer.
- A . Roll up aggregates.Execute data transfer process to infocube
- B . Execute data transfer process to datastore transfer object.generate database statistics
- C . Execute data transfer pies atastore object.trigger delta merge.
- D . Execute data transfer process to infocube.Execute attribute change run.
You need to generate SAP HANA views SAP based on Business Warehouse (SAP BW) infoproviders Which activities do you perform to consume the There are 2 correct answers to this question.
- A . Assign the SAP HANA user in SAP BW user administration
- B . Migrate the SAP BW user roles in the HANA user.
- C . Create an SAP HANA user with the identical name as the SAP BW user.
- D . Create an SAP HANA role on the SAP BW role.
You want to create a workbook that shows turnover per material group. Materials are organized hierarchically on three levels. Business users want to view the level 3. They also want to be able to aggregate on lower hierarchy levels.
How can they do this? There are 2 correct answers to this question.
- A . Open the hierarchy options of the material from hore bar and deselect the required level in the show levels option.
- B . Open the hierarchy options of the material & the ment bar and select the required level in the show levels option.
- C . Open the context menu of tee in the analysis and expand the hierarchy of the required level.
- D . Open the hierarchy options of the material from the ment bar and expand the hierarchy to the required level.
You use SAP Landscape Transformation Replication sees th operational data provisioning.
Which of the following data acquisition features are provided? There are 3 correct answers to this question.
- A . Ability to use complex coded mapping rules
- B . Direct update to SAP Business warehouse info providers
- C . Removal of restrictions for extractors.
- D . Real-time replication to SAP Business warehouse
- E . Ability to use simple coded mapping rules
Which advanced Datastore object modeling templates are available in SAP Business Warehouse? There are 2 correct answers to this question.
- A . Compositeprovider
- B . Open ODS view
- C . Corporate memory with compression.
- D . Data acquisition layer
Which SAP Business warehouse (SAP BWobjects) are supported to generate external SAP HANA Views? There are 3 correct answers to this question.
- A . SAP BW Multiprovider
- B . SAP BW Data Source
- C . SAP BW Info cubes (HANA optimized)
- D . SAP BW queries
- E . SAP BW advanced Data storeobject.
Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse? Please choose the correct answer.
- A . Database Connect
- B . Web service
- C . File interface
- D . Universal Data Connect
You need to use SAP Data services for a controlled distribution of SAP Business warehouse (SAP BSD) to legacy systems and application.
Which of the following activities must you perform? There are 3 correct answers to this question.
- A . Craete a generic Data source in SAP BW as part of the data flow.
- B . Create an SAP BW data flow to an open hub destination.
- C . Create an SAP BW process chain to control data distribution.
- D . Execute the SAP BW Process chain from SAP Data services.
- E . Create a Data store in SAP Data services based on the Data source
Which objects are mandatory when you create a transactional data flow in operational data provisioning? There are 2 correct answers to this question.
- A . InfoPackage
- B . Data transfer process
- C . Transformation
- D . Real-time daemon
Our customer wants to create a composite provider to combine data form two advanced Data store objects (DSO).
Which operation does the system propose, by default to combine the data of both advanced DSOs? Please choose the correct answer.
- A . Left Outer join
- B . Union
- C . Join
- D . Inner join
You run a query containing many free characteristics and some external hierarchies should be as fast as possible.
Which of the following read modes do you choose? Please choose the correct answer.
- A . A Query to read all data at once
- B . H Query to read when you navigate or expand hierarchies
- C . X Query to read data during navigation
The result of a calculation: Si Business Warehouse is incorrect, but the formula is correct.
What options do you have to correct the calculation? There are 3 correct answers to this question.
- A . Set an exception aggregation to change the calculation behavior
- B . Create the formula again to receive a new time stamp.
- C . Change the formula collision property to use result of concurrent formula
- D . Change the formula collision property to use result of this formula.
- E . Create a new structure to receive a new time stamp.
Which of the following statements are true regarding the differences between compounding and concatenation? There are 4 correct answers to this question.
- A . Concatenation is supported in the definition of the InfoObject whereas compoubding is only relevant for transectional data.
- B . Adding key fields in concatenation is easier because only the transformation needs to be changed but in compounding structres need to be changed and date re-loaded
- C . Concatenation uses a single key value but compounding uses more than one
- D . Compounding is easier to filter in queries because the objects are seperate whereas with concatenation, the key string needs to be marked
- E . Compounding is easier for users to understanding because it is based on a 1:1 object mapping but concatenation is more complex for users to understand and decipher
What do Database connect, universal date connect, and the SAP business warehouse service API have in common? Please choose the correct answer.
- A . The Data source must be created directly in SAP Business warehouse.
- B . Using the persistent staging Area is mandatory
- C . The delta queue exists
- D . The direct access is available
You want to fill variables automatically by using the Replacement path more.
Which of the following variables types are supported? There are 3 correct answers to this question.
- A . Text
- B . Hierarchy
- C . Characteristic value
- D . Formula
- E . Hierarchy node
You need to transfer delta data and ensure Full Quality of Service. You are using an SAP Business Warehouse Web service.
Which SAP Process Integration (SAP PI) adapter do you use? Please choose the correct answer.
- A . SAP PI Simple Object Access Protocol Call adapter
- B . SAP PI Remote Function Call adapter
- C . SAP PI ABAP proxy communication adapter
- D . SAP PI File Transfer Protocol adapter
Your customer has a division that sells the same products with different master data.
How you can enhance an SAP HANA view to include the division’s sales of these products? Please choose the correct answer.
- A . Use the SAP HANA studio and add a level or parent-chlid hierarchy based on eth tables in the semantics node.
- B . Use the SAP Business warehouse modelling tools of SAP HANA studio the necessary characteristics to include external hierarchies.
- C . Use the SAP HANA studio and add a level or parent-chlid hierarchy based on a join with tables from the subsidiary system in the semantics node.
- D . Use the SAP HANA studio and add a calculation view of type dimension With two additional hierarchies in the Semantics node.
Your customer wants to activate SAP HANA-Optimized business content to store historical data
Which layer do you use?
- A . Please choose the correct answer.
- B . ODS layer
- C . Virtual data mart layer
- D . Corporate memory layer