You created an Open ODS view based on a database table SAP RANA tovirtuany &splay the data SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data SAP BW/4HANA.
Which objects will be created when using the Generate Dataflow function via Open ODS view? (3)
- A . CompositeProvider
- B . SAP HANA calculation View
- C . Datastore Objects (advanced)
- D . Transformation
- E . Data Source
You create a transformation from a DataSource to a DataStore Object (advanced). The DataSource provides an additive-image delta for data .
Which key figure aggregationtype do you select? (1)
- A . Overwrite
- B . Summation
- C . Maximum
- D . Minimum
With BW/4HANA 2.0, SAP introduced a new capability called Write Interface for DataStore objects (advanced).
Which SAP solution can leverage this interface to push data into the table of aDSOs SAP BW/4HANA 2.0 via HTTP-based connection (REST)? (2)
- A . SAP Cloud PlatformIntegration
- B . SAP Data Warehouse Cloud
- C . SAP Process Integration
- D . SAP Data Services
You developed a BW information model and want to re-use a generated external SAPHANA view .
Which objects are supported? (3)
- A . Query as InfoProvider
- B . CompositeProvider
- C . SAP BW/4HANA query
- D . Open ODS view
- E . Semantic group object
What are the key benefits of using the SAP Landscape Transformation Rep5cation Server for data provisioning into SAP HANA? (2)
- A . Support of cluster and pool tables
- B . Virtualization capabilities
- C . Real-time and scheduled data replication
- D . Log-based replication
With SAP BW/4HANA the new HANA-optimized business content is designed according to the LSA++ framework .
Which technical namespace is assigned to identify new SAP ERP-related business content?(1)
- A . /IMO/
- B . /0SAP/
- C . /BW4/
- D . /SFA/
Which features does SAP Analysis for Microsoft Office provide? (3)
- A . Dragging measures in and out of the report
- B . Including more than one data source
- C . Creating bookmarks for a navigation state
- D . Changing context menu entries
- E . Displaying data simultaneously in a table and a chart
Which user group is the Digital Boardroom designed for? (1)
- A . IT users
- B . Business executives
- C . Business users
- D . BI architects
Which of the following are possible error handding settings in a data transfer process (DTP) SAP BW/4HANA? (3)
- A . Request Red. Do Not Track Records. No Update
- B . Request Red. Write Error Stack. Update Valid Records
- C . Cancel Request. Write Error Stack, No Update
- D . Cancel Request TrackFirst Incorrect Record. No Update
- E . Request Green. Write Error Stack, update Valid Records
Where Can you automatically generate a process chain? (1)
- A . From a data flow object
- B . From a CompositeProvider
- C . Within the process chain maintenance
- D . Within the Process Chain Editor app
Your company decided to use a Hadoop cluster as a data storage location .
Which components can be used to consume remote Hadoop data in your SAP HANA native app? (3)
- A . SAP HANA smart data access
- B . SAP HANA smart data integration
- C . SAP HANA SQL controller
- D . Spark SQL adapter
- E . SAP Vora ODBC adapter
When loading master data for a material you want to have a look at the new values before they are released for reporting .
What could you do using modeling features? (2)
- A . When you define attributes Of material, select the "Time Dependent" Setting
- B . When you define the material characteristic, select "Enhanced Master data update" setting
- C . When you define the data transfer prOC.eSS. select the "Loadrecords with new key only" setting
- D . When you define the data transfer process, choose "Set manually" setting for "Overall status Of request’
You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? (2)
- A . Components
- B . Design Rules
- C . Analysis
- D . Information
What are some Of the possible variable types for the processing type SAP HANA Exit?(2)
- A . Formula
- B . Text
- C . Hierarchy node
- D . Characteristic value
Which Of the following are valid data deletion options for astandard DataStore Object (advanced)? (3)
- A . Selection deletion including subsequent targets
- B . Selective deletion of data
- C . Deletion of all data from active table only
- D . Request-based data deletion
- E . Deletion of data from all tables
You define a remote subscription Of type INSERT in an SAP RANA Smart Data Integration (SOI) real-tine updatescenario .
Which fields are added to the DataSource automatically? (3)
- A . SDI_CHANGE_SEQUENCE
- B . SDI_RECORD_SEQUENCE
- C . SDI_RECORD_MODE
- D . SDI_CHANGE_TYPE
- E . SDI_CHANGE_TIME
In which ODP context is the operational delta queue (ODQ) managed by thetarget system? (1)
- A . ODP_BW
- B . ODP_SAP
- C . DP_HANA
- D . ODP _CDS
You would like to highlight the deviations between budget and actual revenue in query .
Which BW feature do you use? (1)
- A . Conditions
- B . Calculated key figures
- C . Formula variable
- D . Exceptions
What is the benefit of using an InfoSource in a data flow? (1)
- A . Provide an interface for extracting data aquery
- B . Persist htermediate results
- C . Avoid using a DataSource
- D . Connect multiple sequential transformations
Which Of the following are possible Source types for an Open ODS view? (3)
- A . Transformations
- B . Composite Provider
- C . Open hub destination
- D . Database table Or view
- E . Datastore Object (advanced)
Which interface do you use to create a BW InfoObject access "SAP HANA view"?(1)
- A . BW modeling perspective in SAP HANA studio
- B . Embedded SAP GUI in SAP HANA studio
- C . SAP web for SAP HANA
- D . SAP HANA modeler perspective in SAP HANA stu60
You use a measure wah semantic type "Amount Currency Code" in your SAP HANA calculation view .
Which kindof currency reference can be assigned to measure? (2)
- A . Another column Of the seme SAP HANA view
- B . A column from another SAP HANA view
- C . A fixed currency from table TCURC
- D . A variable in the same SAP NANA view
You created a generic DataSource. ZWEATHER_DATA in SAP ERP using a function module. You tried to replicate the DataSource in SAP BW/4HANA, but it is not available in the ODP_SAP context .
Which prerequisite must be fulfilled for this DataSource before you can use it in SAP BW/4HANA? (1)
- A . It must be defined with a delta-specific field durutg data source creation.
- B . It must have a delta queue entry transaction ODQMON
- C . It must be released for OOP with program RODPS_OS_EXPOSE
- D . It must be released for ODP with program BS_ANLY_DS_RELEASE_ODP
Which features prevent the SAP HANA-optimization of transformations in the SAP HANA database? (2)
- A . Transfer routine on the characteristic level
- B . ABAP expert routine in the transformation
- C . ABAP end routine in the transformation
- D . Lookup master data in the transformation
You need to combine attributes data (left table) and the datas language-dependent texts (right table) using a text join. You want to restrict the result set to the logon language .
What do you need to select? (1)
- A . The logon language the left table
- B . The join cardinality between both tables
- C . The language column in the right table
- D . The language column in the left table
You create a Datastore Object (advanced) using the "data mart DataStore object" modeling property .
Which behaviors are specific to this modeling property? (2)
- A . Reporting is done based on a union of the inbound and active tables
- B . The change log table Will only by filled after activation
- C . Query results are only shown when data has been activated
- D . All characteristics are automatically defined as key
To achievean urgent business requirement, you choose the field-based approach because no complex harmonization is needed.
Assuming the LSA++ architecture is considered, and you want to leverage a characteristic hierarchy, on which level do you have to assign an InfoObject last? (1)
- A . In the SAP BW Datastore Object (advanced)
- B . In the SAP BW Open ODS view
- C . In the SAP HANA calculation view
- D . In the SAP BW CompositeProvider
For which business requirements do you suggest an SAP HANA modeing focus rather than an SAP BW/4HANA modelins focus? (2)
- A . Load snapshots or deltas from different Sources on a periodic basis
- B . Report on a harmonized set Of master data
- C . Enhance existing SAP HANA content models
- D . Leverage SQL in-house knowledge
You have created a Custom Characteristic with me technical name "COSTOBJ".
Depending on the controlling area, you need to have different attribute values assigned .
How do you design the model? (1)
- A . Compound the characteristic for Controling Area with the characteristic "COSTOBJ"
- B . Join the characteristic "COSTOBJ" and the Controlling Area in a BW query
- C . Define Controlling Area as a navigation attrbute for the characteristic "COSTOBJ"
- D . Compound characteristic "COSTOBJ" Rh the characteristic for Controlling Area.
You want to execute a query, but do not have the authorization for selection defined in the query for authorization-relevant characteristics .
What would occur in this scenario? (2)
- A . You get an error message
- B . You get only the authorized data
- C . You cannot run the query
- D . You will not get a query result