|Which join types can you use in a CompositeProvider? Note: There are 3 correct answers to this
question. Inner join Text join Full Outer join Referential join
What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct
answers to this question.
By using a transformation and data transfer process (DTP) By referencing a table By accessing an SAP HANA Calculation View of data category Dimension By using a query
By entering the values manually
Which features of an SAP BW/4HANA InfoObject are intended to reduce the physical data
volume? Note: There are 2 correct answers to this question.
Compounding characteristic Reference characteristic Enhanced master data update.
Which objects can be affected by the key date in a BW query? Note: There are 3 correct answers
to this question.
Navigation attributes Display attributes Hierarchies Key figures
You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI)
real-time update scenario. Which fields are added to the DataSource automatically? Note: There
are 3 correct answers to this question. SDI_ENTITY_COUNTER
SDI_RECORD_MODE SDI_CHANGE_TYPE SDI_CHANGE_SEQUENCE SDI_CHANGE_TIME.
You created an Open ODS view based on a database table in SAP HANA to virtually display the
data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked
to persist the data in SAP BW/4HANA. Which objects will be created when using the Generate
Dataflow function via the Open ODS view? Note: There are 3 correct answers to this question. SAP HANA calculation view CompositeProvider DataStore object (advanced) Data source Transformation.
What are some of the variable types in a BW query that can use the processing type SAP HANA
Exit? Note: There are 2 correct answers to this question. Characteristic value
You are following a top-down method for your SAP BW/4HANA modeling project. What would be
your first task? Determine if physical or logical objects will be needed Determine enhancements of SAP Business Content Check available sources in the SAP ERP system Collect reporting requirements.
What are the reasons for implementing CompositeProviders? Note: There are 2 correct answers to
this question. To persist combined data for reporting To provide a virtual data mart layer To provide an interface for BW queries
To store snapshots for reporting.
In an SAP HANA smart data integration flowgraph, which transformation options are available?
Note: There are 3 correct answers to this question. Combine datasets Execute a stored procedure Call an ABAP function module Split datasets
Execute an SAP HANA analysis process.
What kind of cold data tiering options do you have with SAP BW/4HANA? Note: There are 2
correct answers to this question.
SAP Data Warehouse Cloud Hadoop cluster SAP IQ database SAP HANA extension node.
SAP provides three data warehousing solutions to provide customers more flexibility. How is SAP
Data Warehouse Cloud positioned? To support business users who want to simplify their own ABAP routines To support business users with a new self-service tool to model their own dataflows To empower business users to create and maintain process chains from SAP BW/4HANA
dataflows To empower business users to generate SQL code that is pushed to SAP BW/4HANA.
You want to add a Source System of type Big Data in SAP BW/4HANA. Which adapters can you use
to reference the remote source system? Note: There are 2 correct answers to this question.
IQ (ODBC) adapter SAP Vora ODBC adapter Spark SQL adapter SAP HANA adapter.
Which features can be leveraged using a CompositeProvider in SAP BW/4HANA? Note: There are 3
correct answers to this question. Join two ABAP CDS views Define new restricted key figures Create new calculated fields
Combine InfoProviders using Joins and Unions Integrate SAP HANA calculation views
You create a transformation from a DataSource to a DataStore object (advanced). The DataSource
provides an additive-image delta for data. Which key figure aggregation type do you select? Minimum Summation
You want to build Web-based dashboards with interactive visualizations. Which SAP tool would
SAP Lumira, designer edition
SAP Crystal Reports for Enterprise SAP Analysis for Microsoft Office
SAP Analysis for OLAP
Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully
populated, multi-tabbed stories? Smart Predict
Search to Insight
Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers
to this question. Displaying data simultaneously in a table and a chart Including more than one data source Creating bookmarks for a navigation state Dragging measures in and out of the report
Changing context menu entries.
How can the delta merge process be initiated? Note: There are 3 correct answers to this question.
By using the SAP BW/4HANA data load monitor By using a specific process type in a process chain By setting a specific flag in the transformation By setting a specific flag in the data transfer process By using SAP HANA smart merge technology.
You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to
use the SAP ERP Standard DataSource 0FI_GL_14 (New GL Items). Which transactions can be used
to activate this DataSource? Note: There are 2 correct answers to this question.
Transaction ODQMON (Monitor Delta Queues) in the SAP source system
Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system Transaction RSA1 (BI Content) in the SAP BW/4HANA system Transaction RSO2 (Maintain Generic DataSource) in the SAP source system
You create a DataStore object (advanced) using the "Data Mart DataStore Object" modeling
property. Which behaviors are specific to this modeling property? Note: There are 2 correct
answers to this question. Query results are only shown when data has been activated. Reporting is done based on a union of the inbound and active tables. All characteristics are automatically defined as key.
The change log table will only be filled after data activation.
You want to define a restricted column in an SAP HANA calculation view. What do you need to
define? Note: There are 2 correct answers to this question. An aggregation method An SAP HANA data type A condition criterium A reference to an existing measure.
You have created an SAP HANA Calculation View in SAP Web IDE for SAP HANA and want to
integrate it into an SAP BW/4HANA CompositeProvider. Which "Settings for HANA Consumption
in BW" in transaction SPRO can you use in this scenario? Note: There are 2 correct answers to this
question. SAP HANA Repository
Hybrid Mode HANA Deployment Infrastructure (HDI) External SAP HANA View.
Which data deletion options are offered for a standard DataStore object (advanced)? Note: There
are 3 correct answers to this question. Deletion of all data from active table only Request-based data deletion
Deletion of data from all tables Selective deletion of data Selection deletion including data of subsequent targets.
Which modeling function is possible in modeling with an SAP HANA Calculation View that is not
possible in modeling with a CompositeProvider? Use aggregation for datasets
Generate a rank column
Create a calculated column Combine datasets by union
You want to build an SAP HANA calculation view of data category CUBE, but you get the "no
measure defined" error. For the business requirement, a measure does not make sense. Besides
changing the data category to DIMENSION, what do you have to do? Switch from a projection node to a star join node.
Switch from an aggregation node to a projection node. Switch from an aggregation node to a star join node. Switch from a projection node to an aggregation node.
From which SAP BW/4HANA objects can you start generating an external View? Note: There are 2
correct answers to this question. BW query
Open ODS view Semantic group object
What are the key benefits of using the SAP Landscape Transformation Replication Server for data
provisioning into SAP HANA? Note: There are 2 correct answers to this question. Virtualization capabilities Support of cluster and pool tables Log-based replication
Real-time and scheduled data replication.
In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible? The latest request in the active data table The latest request in the change log table The latest not-yet-activated request in the inbound table Any older activated request in the inbound table.
Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP) ? Note:
There are 3 correct answers to this question. SAP HANA Analysis Process CompositeProvider
InfoSource Open Hub Destination DataStore Object (advanced).
You use a measure with semantic type "Amount with Currency Code" in your SAP HANA
calculation view. Which kind of currency reference can be assigned to the measure? Note: There
are 2 correct answers to this question.
A column from another SAP HANA view A variable in the same SAP HANA view A fixed currency from table TCURC
Another column of the same SAP HANA view.
Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP
BW/4HANA project? Note: There are 3 correct answers to this question. Implement transport routes and layers Specify necessary data conversion
Design the data layer concept Monitor batch jobs and data volume Check the availability of data.
Where can you automatically generate a process chain? From a data flow object
From a streaming enabled DataSource Within the process chain maintenance Within the Process Chain Editor app
You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first
persistent data layer in SAP BW/4HANA. Which options do you have to analyze a potential
extractor issue? Note: There are 2 correct answers to this question.
Check entries in table RSDDSTATEXTRACT in SAP ERP
Use transaction RSA3 (Extractor checker) in SAP ERP Use program RODPS_REPL_TEST in SAP ERP Use the ODQ maintenance in SAP BW/4HANA.
You created a generic DataSource in SAP ERP using a function module. Which manual activity
could you perform to enable your generic DataSource to use as an ODP_SAP DataSource in SAP
Run program RODPS_OS_EXPOSE in SAP ERP for the DataSource Adapt the function module using transaction ODQMON Generate the PSA table of the DataSource in SAP BW/4HANA Release the DataSource in SAP BW/4HANA for ODP.
What are benefits of using an InfoSource in a data flow? Note: There are 2 correct answers to this
Connecting sequential transformations in the data flow without storing the data again
Reducing the number of data transfer processes (DTP) Storing the extraction delta information of the data source file Reducing the number of transformations for scenarios with many sources and targets.
Your company is using SAP S/4HANA as a business operational system and you have to provide
operational analytical reports. Why might you consider SAP S/4HANA embedded analytics?
To use the SAP HANA optimized business content.
To use the ABAP CDS view based virtual data model.
To use the SAP HANA Deployment Infrastructure.
To use the generated external SAP HANA Calculation Views.
What are some of the advantages of using SAP BW/4HANA business content? Note: There are 2
correct answers to this question. Accelerated SAP BW/4HANA implementation using ready-made models Automatic content activation during installation of SAP BW/4HANA Adjustments to activated content objects will be delivered by SAP in a new namespace Ability to integrate business content objects in custom-defined objects.
You want to turn a display attribute into a navigation attribute, but it's not possible to do it in the
SAP BW/4HANA system. Which setting of this display attribute could be the reason? Note: There
are 2 correct answers to this question.
Attribute Only Useable as InfoProvider High Cardinality
You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new nonSAP source system for test purposes. Which approach should you consider for rapid prototyping? Field-based modeling Generate Data Flow Business content activation
InfoObject based modeling.