With SAP BW/4HANA 2.0, SAP introduced a new capability called Write Interface for DataStore objects (Advanced). Which SAP solutions can leverage this interface to push data into the inboud table of DataStore objects (Advanced)? Note: There are 3 correct answers to this question. SAP Data Warehouse Cloud SAP Process Integration SAP Landscape Transformation Replication Server SAP Data Services SAP Business Technology Platform. You are involved in an SAP BW/4HANA project focusin on General Ledger reporting and want to use the SAP ERP Estándar DataSource oFI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system Transaction RSA1 (BI Content) in the SAP BW/4HANA system Transaction ODQMON (Monitor Delta Queues) in the SAP Source system Transaction RSO2 (Maintain Generic DataSource) in the SAP source system. 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 BW/4HANA. Run program RODPS_OS_EXPOSE in SAP ERP for the DataSource Adapt the function module using transaction ODQMON Release the DataSource in SAP BW/4HANA for ODP Generate the PSA table of the DataSource in SAP BW/4HANA. Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use? Note: There are 2 correct answers to this question. BAPIs (Business Application Programming Inetrface)
AMDPs (ABAP Manged Database Procedures)
Stored procedures
Calculation views
. What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question. By referencing a table
By accessing an SAP HANA Calculation View of data category Dimension
By entering the values manually
By using a transformation and data transfer process
By using a query
. In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question. Call an ABAP function module
Split datasets
Combine datasets
Execute an SAP HANA analysis process
Execute a stored procedure
. You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows? One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers
Only one result row with the sales revenue sum of the top 10 customers
Only one result row with the sales revenue sum of all 100 customers
One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 100 customers
. 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. Spark SQL Adapter
SAP Vora ODBC adapter
IQ (ODBC) adapter
SAP HANA Adapter
. You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an additve-image delta for data. Which key figure aggregation type do you select? Overwrite
Minimum
Maximum
Summation
. You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time udate scenario. Which fields are added to the DataSource automatically? Note: There are 3 correct answers to this question. SDI_CHANGE_TIME
SDI_CHANGE_SEQUENCE
SDI_CHANGE_TYPE
SDI_ENTITY_COUNTER
SDI_RECORD_MODE
. In which ODP context is the operational delta queue (ODQ) managed by the target system? ODP_HANA
ODP_SAP
ODP_BW
ODP_CDS
. What are the reasons for implementing CompositeProviders? Note: There are 2 correct answers to this question. To provide a virtual data mart layer
To provide an interface for BW queries
To persist combined data for reporting
To store snapshots for reporting
. Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers to this question. Creating bookmarks for a navigation state
Displaying data simultaneously in a table and a chart
Dragging measures in and out of the report
Changing context menu entries
Including more than one data source
. 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 generated external SAP HANA Calcution Views
To use the ABAP CDS view based virtual data model
To use the SAP HANA Deployment Infrastructure
To use the SAP HANA optimized business content
. What is the maximum number of characteristics that can be used for a multi-dimensional exception aggegation in a BW query? 10
5
7
3
. You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct answers to this question. Open ODS view of type Master Data
Calculation View of type Dimension
Open ODS view of type Facts
InfoObjetc of type Characteristic
. Which interface do you use to create a BW InfoObjet with access type "SAP HANA view!? SAP Web IDE for SAP HANA
Embedded SAP GUI in SAP HANA studio
SAP HANA modeler persperctive in SAP HANA studio
BW moedling persperctive in SAP HANA studio
. What are some of the advantages of using SAP BW/4HANA business content? Note: There are 2 correct answers to this question. Automatic content activation during installation of SAP BW/4HANA
Ability to integrate business content objects in custom-defined objetcs
Adjustments to activated content objetc will be delivered by SAP in a new namespace
Accelerated SAP BW/4HANA Implementation using ready-made models
. You use SAP HANA to integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join). What do you need to do before you can integrate the HDI Calculation View (data category Dimension)?
Integrate the desing time file of the HDI Calculation View (data category Cube with Star Join) into a CompositeProvider.
Integrate the desing time file of the HDI Calculation View (data category Dimension) into a CompositeProvider.
Build the design time file of the HDI Calculation View (data category Dimension) to generate a run time objetc
Build the run time objetc of the HDI Calculation View (data category Cube with Star Join) to generate a design time file
. You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system for test purposes. Which approach should you consider fro rapid prototyping?
Generate Data Flow
InfoObject base modeling
Field-based modeling
Business content activation
. Which of the following are posible delta-specific field for a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.
Time stamp
Record mode
Calendar day
Request ID
Numeric pointer
. 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. Support of cluster and pool tables
Log-based replication
Real-time and scheduled data replication
Virtualization capabilities
. What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?
Request is canceled, records are not tracked, and tarjet is not updated
Request is set to failed, error stack is written, and valid records are updated
Request is set to success, error stack is written, and valid records are updated
Request is canceled, firt incorrect record is tracked, and target is not updated.
. Which features can be leveraged using a CompositeProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.
Combine infoProviders using Joins and Unions
Join two ABAP CDS views
Integrate SAP HANA Calculations views
Create new calculated fields
Define new restricted key figrues
. Which modeling function is possible in modeling with an SAP HANA Calculation View that is not possible in modeling with a CompositeProvider?
Combine datasets by union
Use aggregation for datasets
Create a calculated column
Generate a rank column
. Which development object needs to be built to generate an HDI Container?
SQL script procedure
Package
Space
HDB module
. Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.
Position of child nodes
Sort direction
Expand to level
Time dependency
Allow temporal hierarchy join
. How can the delta merge process be initiated? Note: There are 3 correct answers to this question.
By setting a specific flag in the data transfer process
By using the SAP BW/4HANA data load monitor
By setting a specific flag in the transformation
By using SAP HANA smart merge technology
By using a specific process type in a process chain
. What are benefits of using an InfoSource in a data flow? Note: There are 2 correct answers to this question.
Connecting sequetial trnsformartions in the data flow without storing the data again
Reducing the numer of transformations for scenarios with many sources and targets
Reducing the numer od data transfer processes (DTP)
Storing the extraction delta information of the data source file
. For which requirements do you suggest an SAP HANA modeling focus rather that an SAP BW/4HANA modeling focus?? Note: There are 2 correct answers to this question.
Leverage SQL in-house knowledge
Enhance existing SAP HANA content models
Report on a harmonized set of master data
Load snapshots or deltas from different sources on a periodic basis
. Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.
To decrease memory consumption
To improve the read perfomance of InfoProviders
To combine the query cache from different executions
To move the most recent data from disk to memory
. You would like to highlight the deviation from predefined theshold values for key figures actual revenue. Which BW feature do you use? Exceptions
Calculated key figures
Conditions
Structure
. 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
HANA Deployment Infratructure (HDI)
Hybrid Mode
External SAP HANA View
. You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different atribute values assigned. How do you desing the model?
Compound the characteristic for Controlling Area with the characteristic "COSTOBJ"
Define characteristic "COSTOBJ" as a navigation attribute for Controlling Area
Define Controlling Areas as a navigation attribute for the characteristic "COSTOBJ"
Compound characteristic "COSTOBJ" with the characteristic for Controlling Area
. You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question.
Aggregate measures as a sum
Create restricted columns
Combine master data and transactional data
Provide default time characteristics
Persist transactional data
. You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source. Which tool can you use to create this analysis view?
SAP Analysis for Microsoft Office
SAP BusinessObjetc Web Intelligence
SAP Crustal Reportis for Enterprise
SAP Lumira, designer edition
. Which layers offer the visualization approach for the layered scalable architecture (LSA++) of SAP BW/4HANA? Note: There are 2 correct answers to this question.
Data Acquisition layer
Open operational data store layer
Virtual data mart layer
Open hub layer
. SAP provides three data warehouse solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned?
To empower business users to generate SQL code that ispushed to SAP BW/4HANA
To support business user who want to simplify theris own ABAP routines
To empower business users to create an dmaintain process chain from SAP BW/4HANA dataflows
To support business user with a new self-service tool to model their own data flows
. Which objetcs can be affected by the key date in a BW query? Note: There are 3 correct answers to this question.
Conditions
Navigation attributes
Hierachies
Key figures
Display attributes
. Where can you automatically generate a process chain?
Within the process chain maintance
Form a data flow objetc
Within the process chain editor app
from a streaming enable DataSource
. In a DatStore object (advanced) of type Data Mart, which request-based deletion is possibel?
Any older activated reqeust in the inbound table
The lastest not-yet-activated reques in the inbound table
The lastest request in the change log table
The lastest request in the active data table
. With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which tecnical namespace is assigned to identify the new SAP ERP-related business content?
/IMO/
/SFA/
/BW4/
/0SAP/
. You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.
Components
Information
Design Rules
Analysis
. When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? Note: There are 2 correct answers to this question.
When you define the attributes of material, select the "Time Dependent" setting
When you define the data transfer process, choose the "Set Manually" setting for "Overrall status of request"
When you define the material characteristic, select the "Enhanced Master data update" setting
When you define the data transfer process, select the "Load records wit new key only" setting
. You want to run a BW query, but you only have partial authorization for the data selection. What happens related to the BW query in this scenario?
The BW query starts and the unautohorized values are 0
The BW query does not start running
The BW query starts and only the authorized data is displayed
The BW query starts and shows an error message
. You are following a top-down method for your SAP BW/4HANA modeling project. What would be your first task?
Collect reporting requirements
Check available sources in the SAP ERP system
Determine enhancements of SAP Business Content
Determine if physical or logical objetcs will be needed
. With which query considerations can you optimize the query performance? Note: There are 3 correct answers to this question.
Use exclude functions in the restricted key figures
Use include functions in the restricted key figures
Use fewer drill-down characteristics in the initial view
Use characteristic filters that overlap
Use mandatory characteristic value variables
. Which data deletion options are offered for a standard DataStore objetc (advanced)? Note: There are 3 correct answers to this question.
Selective deletion of data
Deletion of all data from active table only
Selection deletion incluiding data of subsequent targets
Deletion of data from all tables
Request-based data deletion
. Which of the following are possible source types for an Open ODS view? Note: There are 3 correct answers to this question.
Database table or view
DataStore objetc (advanced)
Transformations
CompositeProveider
Open hub destination
. What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA? Note: There are 2 correct answers to this question.
There must be no transaction data referring to the cost centers
There must be no BW analysis authorizations defined thta use any of the cost centers
There must be no hierarchy for the cost centers
There must be no BW query that uses cost cenetr as a free characteristics.
. 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 SAP HANA data type
A reference to an existing measure
A condition criterium
An aggregation method
. Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.
SAP query
ABAP class method
HDI Calculation View
Database view
ABAP function module
. Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this question.
Open Hub Destination
DataStore Objetc (advanced)
SAP HANA Analysis Process
InfoSource
CompositeProvider
. 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 variable in the same SAP HANA view
A column from another SAP HANA view
A fixed currency from table TCURC
Another column of the same SAP HANA view
. What are some of the variable tyoes n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.
Text
Hierarchy node
Formula
Charateristic value
. Which features of an SAP BW/4HANA InfoObjet are intended to reduce the physical data volume? Note: There are 2 correct answers to this question.
Transitive attribute
Reference charateristic
Compounding charateristic
Enhanced master data update
. You create a DataStore object (advanced) using the "Data Mart DataStore Objetc" modeling property. Which behaviors are specific to this modeling property? Note: There are 2 correct answers to this question.
Reporting is done based on a union of the inbound and active tables
All characteristic are automatically defined as key
Query results are only shown when data has been activated
The change log table will only be filled after data activation
. The Database Explorer in the Web IDE for SAP HANA proveides a data file improt wizard to create a table in SAP HANA from a flat file. What are possible actions adter the system suggests the target structure?? Note: There are 3 correct answers to this question.
Adjust the suggested data type of the target table fileds
Map InfoObjetcs to fields in the target tavle
Switch the table type between row store and column store
Define sorting properties for a target table field
Change the order of the fields in the target table
. Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?
Forecasting
Search to insight
Smart Predict
Smart Discovery
. In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell tupes can this be achieved?? Note: There are 2 correct answers to this question.
Formula cell
Help cell
Reference cell
Selection cell
. What can you leverage using the live data connectyions of SAP Analytics Cloud with SAP BW/4HANA? Note: There are 2 correct answers to this question.
Process chain streaming functionally
Existing authorization concepts
BW data models for planning scenarios
BW data models for analysis
. What kind of cold data tiering options do you have with SAP BW/4HANA? Note: There are 2 correct answers to this question.
Hadoop cluster
SAP IQ database
SAP Data Warehouse Cloud
SAP HANA extension node
. What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 2 correct answers to this question.
Distinguish between changeable and non-changeable data
Provide language-dependent text
Ensure referential integrity on you transactional data
Avoid generation of SID values
. You expect to have more than 2 billion record as master data reference for a charateristic in your data model and want to use the high cardinality option. What do you need to consider in reporting??
To identify the required data sourfes
To automatically generate the LSA++ architectrue
To identify the user groups and required authorizations
To determine the sequence of projects
. 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 an aggregation node to a star join node
Switch form a projection node to an aggregation node
Switch from an aggregation node to a projection node
Switch from a projection node to a star join node
. In the Web IDE for SAP HANA workspace, you have imported a project including an HDB module with calculation views. What do you need to do in the project sittings before you can successfully build the HDB module?
Assign a space
Enter an organization
Reset the project type
Define a package
. To achieve an urgent business requirement, you choose the field-based modeling approach, but you also want to leverage a characteristic hierarchy. On which level does LSA++ architecture recommend the appropriate InfoObjet to be associated?
In the SAP BW DataStore (advanced)
In the SAP BW Open ODS View
In the SAP BW InfoSource
In the SAP BW CompositeProvider
. For a BW query, you want to have the first month of the curret quarter as a default value for an input-ready BW variable for the characteristic 0CALMONTH. Which processing tyoe do you use?
Manuel Input with default value
Customer Exit
Manual Input with offset value
Replacement Path
. What are some of the prerequesites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question.
An Operational Data Provisioning Framework must be configured in SAP BW/4HANA
An ODP source system with contest ODP_CDS must be created in SAP BW/4HANA
The ABAP CDS views must be defined with the appropriate data extraction annotations
THE ABAP CDS views must be released via program RODPS_OS_EXPOSE for BW extraction
. From which SAP BW/4HANA objetcs can you start generating an external View? Note: There are 2 correct answers to this question.
Open ODS view
Semantic group object
BW query
CompositeProvider
. Which join types can you use in a CompositeProvider? Note: There are 3 correct answers to this question.
Referential join
Full outer join
Inner join
Text join
Hierarchy join
. 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.
Design the data layer concept
Check the availability of data
Implement transport routes and layers
Monitor batch jobs and data volume
Specify necessary data conversion
. 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 aatribute could be the reason? Note: There are 2 correct answers to this question.
Attribute Only
Useable as InfoProvider
Case-Sensitive
High Cardinality
. You want to build Web-based dashboards with interactive visualizations. Which SAP tool would you use??
SAP Analysis for OLAP
SAP Crystal Reports for Enterprise
SAP Lumira, designer edition
SAP Analysis for Microsoft Office
. With SAP HANA 2.x you can model Calculation Views in the SAP Web IDE for SAP HANA. Which node types for a native SAP HANA Calculation View are available in the SAP Web IDE, and not available in SAP HANA studio? Note: There are 2 correct answers to this question.
Union
Rank
Intersect
Graph
. You created an Open ODS view based on a database table in SAP HANA 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 objetcs will be created when using te Generate Dataflow function via the Open ODS view? Note: There are 3 correct answers to this question.
Transformation
DataStore objetc (advanced)
CompositeProveider
Data source
SAP HANA calculation view
. 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 hacve to analyze a potential extractor issue? Note: There are 2 correct answers to this question.
Use the ODQ maintance in SAP BW/4HANA
Use program RODPS_REPL_TEST in SAP ERP
Use transaction RSA3 (Extractor checker) in SAP ERP
Check entries in table RSDDSTATEXTRACT in SAP ERP
. In an SAP HANA Calculation View, you need to combine attributes data (left table) and the data's language-dependent text (right table) using a text join. What should you select to restrict the result set to the logon language?
The join cardinality between both tables
the language column in the righ table
the language column in the left table
The logon language in the left table
. Which features are related to the start process in a process chain? Note: There are 2 correct answers to this question.
it can be re-used in other process chains
it can be a succesor of another process
Only one start process is allowed for ecah process chain
It is the only process that can be scheduled without a predecessor.
. You expect to have more than 2 billion record as master data reference for a charateristic in your data model and want to use the high cardinality option. What do you need to consider in reporting??
Using a hierarchy of this characteristic for navigation will impact response time
Using this characteristic as a navigational attribute will impact response time
The local SID values are create automatically during reporitng, which will impact the response time
The high Cardinality property needs to be defined in the Composite Proveider
.
|