WorksheetsSAP HANA CERTIFICATION
Total questions: 80
Worksheet time: 27mins
If you need to define help cel s for formulas In the cell editor,what must you do first?
Define two structures in a query
Define two selections In a s1ructure
Reuse a structure in a second query
Define two formulasIn a structure
For which of the following revenue reporting requirements do you create restricted key figures?
Compare this year's planned revenue withlast year's actual revenue
Convert revenue Into a number without currency
Identify the top five countries by revenue for each month
Determine the a\,!erage revenue per customer
Which advantages can you leverage while importing data into a new SAP HANA table using a Rat file? Note· There are 2 correct answers to this question.
Availabilty of deltalogic
Easiness ofloading
Adjustment for column type.length.and name is possible
Transformation cap-abilities
Which objects can be affected by the key dale in a BW query?
Note: There are 2 correct answers to this question.
Conditions
Key figures
Attributes
Hierarchies
You need 10 restrict a sales repon to the products that make up 50% of the totalrevenue.
Which BW query feature do you use?
Restricted key figure
Exception
Condition
Calculated key figure
Whichlayers are part of 1'1elayered scalab e archecture for SAP BW/4HANA (LSA++)?
Note: There are 2 correct answers to this question.
Data acquisition layer
Open Hub layer
BW Workspace layer
Open Operational Data Store layer
You needto enable real time streaming using SAP HANA smart data integration (SOI)to load data into a OataStore object (advanced) What ace prerequisites f0t th s cequirement?
Note There are 2 correct answers to the question
The data target is a partitiontd DataStort object (advanced )
The adapter is real-time enabled
The pcocess chain ts running in streaming mode
The source system is pushing data into SAP BW/4HANA
Which SAP HANA objects are generated when you Switch on the "'Extemat SAP HANA View" property for dataStore objects (advanced)?
Note There are 2 conecl ani'hif'i to thi5 question
SAP HANA HDI containers
SAP HANA privilege
SAP HANA CDS View
SAP HANA calculation views
Which property settings can you assign for a characteristic?
Note· There are 3 correct answers to this question.
High Precision
Enhanced Master Data Update
Useable as lnfoProvider
Stock Coverage
Attribute Only
What is the effect of using the RODPS_REPL_ TEST program to test SAP ERP operational Data Provisioning (ODP) Data Sources?
Note There are 2 conect answers to this question
The program behaves like the RSA3 extractor checker
The apprication data is physically written to the queue.
The Reset Della function affects all ODP delta queues
The program behaves at an additional subscriber
What can you create within the SAP BW/4HANA dala flow object?
Note: There are 3 correct answers to this question.
DalaSource
lnfoObject
Process chain
lnfoArea
Transformation
In an SAP BW query you use a variable that is based on time characterislic OCALMONTH and retums the current quarter
Which offset
do you need to retrieve the corresponding of the previous year?
-4
12
-12
4
Which type of BW variable do you use as a dynamic threshold for an exceptionIna BW query?
Characteristic value variable
Fomula variable
Hierarchy variable
Text variable
You load a data store object (advanced) every night
When can you delete the request you loaded two nights ago Without deleting the latest request?
From a DataStore object (advanced) with modeling property “Data Mart Datastore Object” if the request is activated
From a DataStore object (advanced) with modeling property “Standard DataStore Object with Write Change Log” if the request is activated
From a DataStore object (advanced) with modeling property “Data Mart DataStore Object” if the request not activated
From a DataStore object (advanced) with modeling property “Staging DataStore Object with Compress Data” if the request is compressed
When modeling a characteristic which SAP BW/4HANA features are intended to reduce the physical data volume.
Transitive Attribute
Enhanced master data update
Reference charactteristic
Compounding
Which object Is a valid target of an SAP BW/4HANA transformation?
lnfoObject of type Characteristic
BW Query
Composite Provider
SAP HANA analysis process
You define a remote subscription of type UPSERT in a Smart Data Integration (SDI) realtime update scenario. Which fields are added to the dataSource automatically?
Note. There are 3 correct answers to this question.
SDl_RECORD_SEQUENCE
SDl_RECORD_MODE
SDl_CHANGE_SEQUENCE
SDl_CHANGE_TIME
SDl_CHANGE_TYPE
Your main BW query contains a characteristic value variable with a replacement path from a query
When does the pre·query run?
Each time the main query runs. before the filter values are applied
Directly after data is loaded to the lnfoProvider of the pre-query.
Directly afler a predefined broadcasting event was triggered to calculate the pre-query
Each time the main query runs, after the fitter values are applied.
Ir you use the field-based modeling approach ror persistent data,what does the system check during a data load?
The referential integrity
The availablllty of hierarchies
The data format
The assigned base unit
To create a pixel-precise formaned report,which SAP tool do you suggest?
SAP Crystal Reports for Enterprise
SAP Analysis for CLAP
SAP Analytics Cloud
SAP Lumira Discovery
Which transformation options can be processed in an SAP HANA database?
Note:There are 2 correct answers to this question.
ABAP expert routines
Formulas
Transfer routine
Read master data
Which source types can you use for a generic DataSource? Note: There are 2 correct answers to this question.
Application component
SAP HANA calculation view
DB view or table
Function module
Which objects of an SAP HANA calculation view of data category "DIMENSION" can you re-use
if you define an SAP HANA calculation view of data category "CUBE" and property "with Star Join"?
Note There are 2 correct answers to this question
Attribute assignment
Aggregation method
Hierarchy assignment
Measure assignment
Which processing types can you define for a formula variable?
Note: There are 3 correct answers to this question.
Replacement path from another query
Replacement path from an InfoObject
Authorization
Manual input
Replacement path from another variable
Where can you apply a currency translation?
Note:- There are 3 correct answers to this question
In a BW query
In an SAP BW/4HANA data transfer process (DTP)
In an SAP BW/4HANA lnfoSource
In an SAP BW/4HANA transformation
In an SAP HANA calculation view
Which objects can you associate with a source field in the characteristics folder of an Open ODS view type Facts? Note There are 2 correct answers to this question.
Open ODS view type Master Data for Hierarchies
SAP BW lnfoObject
Open ODS view type Facts
Open ODS view type Master Data for Attributes
Why can tasks run faster if the application uses SAP HANA as a database?
The user interface layer takes over tasks of the application layer
The application layer takes over tasks of the database layer
The application layer takes over tasks of the user interface layer
The database layer takes over tasks of the application layer
How many SAP BW/4HANA transformation and delta data transfer process (DTP) Can you define for the same source and target?
One SAP BW/4HANA transformation
Only one deaa DTP
Multiple SAP BW/4HANA transformation
Multiple delta DTP's with dlfferent filters
One SAP BW/4HANA transformation
Multiple delta DTP's without filters
One SAP BW/4HANA transformation
Multiple detta DTP's with Diifferent tfilters
You use the wizard to create an SAP BW/4HANA Big Data source system. Which acivate are mandatory?
Note. There are 3 correct answers to this question.
Specify business content type.
Select a remote source.
Specify release type.
Specify connection type Big Data.
Select a database schema.
You create a transformation from a dataSource to a datastore object (advanced) The datasource provides an after-image delta for sales data.
Which key figure aggregatation type do you select?
Maximum
Summation
Overwrite
Minimum
You create a DataStore object (advanced) using the modeling property Standard DataStore Object.
Which flags can be set?
Note There are 2 correct answers to this question.
Write Change Log
Unique Data Records
Activate Data
Compress Data
When can you NOT use a characteristic with the High Cardinallty property?
Note. There are 3 correct answers to this question.
When It will be part of a hierarchy
When it will be used in a report-to-report interface
When It will be a navigation attribute
When it will be a compound characteristic
When It wilI be a time-dependent display attribute
Which are the additional tables for the enhanced master data update for the characteristic wih the technical name "MATERIAL"?
Note There are 3 correct answers to this question
/BIC/EMATERIAL
/BIC/FMATERIAL
/BIC/PMATERIAL
/BIC/HMATERIAL
/BIC/GMATERIAL
What happens If a query with time-dependent attributes Is started but NO query key data is manually maintained?
The system display only NON-time-dependent attributes
The "valid from" date of the attribute ls used as the key date
The systern date is used as the key date.
The system displays an error message
You create a new SAP HANA remote connection
How does SAP HANA smart data access (SDA) differ from SAP HANA smart data integration (SDI)?
Note. There are 2 correct answers to this question
SDI supports data replication in real time
SDA does not provide this capabilily
SDI s used only for SAP HANA native apps
The SDA interface is used for SAP BW/4HANA models
SDI requires an additional SAP HANA data provisioning server SDA Is integrated In the SAP HANA Index server
SDI is recommended for data sources with limited changes in the data structure
SDA contains features to act as a full-blown ETL tool
What is the highest node In a graphical SAP HANA calculation view that belongs to the DIMENSION data category?
Star join
Projection
Rank
Aggregation
37 of80
Which options do you have when you define a non-cumulative key figure in SAP BW/4HANA?
Note There are 2 correct answers to this question.
Select Non-Cumulative Value Change with one existing non-cumulative key figure
Select Non-Cumulative Value Change with one existing cumulative key figure
Select Inflow/Outflow with two existing non-cumulative key figures
Select Inftow/Outflow with two existing cumulative key figures
Which features does the SAP Lumira Generic Analysis document provide?
Note There are 3 correct answers to this question.
You can lndude more than one data source.
You can create bookmarks for a navigation state.
You can show the data simultaneously in a table and in a chart.
You can use it for any SW query or SAP HANA calculation view.
You can show the data simultaneously in two different charts
You need to combine masier data (rlght table) and transactional data (left table) using a referential join
How will this referential join behave?
It always returns all fields from the righl table as a result data set
It returns a result data set if the left table has a corresponding entry on the right table.
It returns the result as an Inner join when a descrlption mapping Is defined between the left table and the right table
It returns the result as an inner join when NO fields from the right table are requested.
What must you do if you want to use an object from Business Content In SAP BW/dHANA?
Activate the object in the Data Warehousing Workbench.
Copy the Business Content object Into the customer name space
Convert the object from A version to D version.
ldenlify the Business Content objects in SAP HANA studio
What happens when you perform the Delta Merge operation for a given data target?
The delta between the new data and the already loaded data is removed.
Data is transfermed from the delta store to the main store
The data from the delta queue is extracted and merged into the data target.
The before and after mages of the delta queues are merged
Which objects can you combine using a Composite Provider?
Note· There are 2 correct answers to this question.
SAP HANA calculation views
CompositeProvider
lnfoSources
Key figures
Your customer is using a pure SAP HANA native data warehouse approach.
Which tools shouJd the customer install?
Note:There are 2 correct answers to this question.
BW modeling tools
SAP solutions for enterprise information management
Enterprise Architecture Designer
Process Chain Monitoring app
You create a BW query
How can you check the navigational attributes of a basic characteristic?
Open the lnfoProvlder view and check the Attribute folder below the basic characteristic
Add the basic characteristic to a BW query and check the display properties
Select Attributes from the context menu of the basic characteristic In the rows section
Open the ed tor for the basic characteristic and check the Attributes tab
Which SAP BW/4HANA objects can keep persistent data?
Note· There are 2 correct answers to this question.
Key figure
DataStore object (advanced)
lnfoSource
Characterstic
You need to use an SAP ERP standard DataSource to load dala lnto SAP BW/4HANA.
Which prerequisite must be fulfilled to use the DataSource in the Operational Data Provisioning context?
It must exist in table ROOSATTR.
It must be in-memory-optimized.
It must have a queue entry in transactlon ODQMON
It must be delta-enabled
You want to validate your SAP HANA data modal
To use the data preview functionality. what must you ensure?
The design-time version must be saved and successfully activated
You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user.
You must provlde the key date In the vlew properties
The _SYS_BIC user is created in the system and the runtime information is written to schema_SYS_STATISTICS
What must you do before you can add an SAP HANA system to an SAP BW project?
Assign an SAP BW user to the SAP HANA system
Add an lnfoArea In the SAP BW projects favorite's section
Activate all inactive SAP HANA calculation views of the SAP HANA system
Connect to the SAP HANA database as a system in the SAP HANA Systems view
What can you do in the SAP BW/4HANA Cockpit?
Note· There are 3 correct answers to this question
Maintain data-tiering settings
Model and schedule a replication task
Manage request in lnfoObjects and DataStore objects (advanced)
Model and transport a dalaflow
Model, Schedule and Monitor Process Chains
To gather the requirements for the data model design,which is the logical sequence?
1.Transformations
2 Reporting requirements
3 Sources of data
4.Storage requirements
1.Storage requirements
2.Transformations
3. Sources of data
4. Reporting requirements
1 Reporting requirements
2 Sources of data
3.Transformations
4 Storage requirements
1 Transformations
2 Sources of data
3.Reporting requirements
4.Storage requirements
You need to consume remote HADOOP data in your SAP HANA Native App.
Which components can you use?
Note. There are 3 correct answers to this question.
SAP HANA smart data access
Spark SQL adapter
SAP HANA SQL Controller
SAP Vora ODBC adapter
SAP HANA smart data integration
Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?
Suspend Replication and Start Replication
Suspend Replication and Resume Replication
Stop Replication and Start Replication
Stop Replication and Resume Replcation
Which of the following use cases Is classified as operational reporting?
Near-real-time access to original transactional values
Year-to-date comparlson reports containing prior and actual year numbers
Evaluation of trends over several years
Reporting requirements with monthly data refreshes
Which one of the following methods supports the SAP HANA data vlrtualizatlon approach with ODBC technology?
SAP landscape Transformation Repcation Server
SAP Data Services
SAP HANA smart data access
SAP HANA smart data integration
You load delta records from an ODP_SAP source system including the crossponding Recordmode provided
by the dataSource Which image from the can be processed correctly by data mart Datastore Object (advanced)?
Note There are 2 correct answers to this question
Reverse-image
Additive·lmage
After-image
Delete image
You loaded a 5 MB table from a non-SAP source system to SAP BW/4HANA
How do you explain that the size of the tableis reduced to 1MB?
The target is defined as row store and a delta merge was executed
The target is deflned as row store without delta merge execution
The target is defined as column store wlthout delta merge
execution
The target is defined as column store and a delta merge was executed
For which lnfoProvider types can you select navigation attributes? Note· There are 2 correct answers to this question.
DalaStore object (advanced) with modeling properly Data Mart DataStore Object
Composite Provider
Open ODS view
DataStore object (advanced) with modeling property Standard DataStore Object
For which business requirement do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus?
Note There are 2 correct answers to this question
Enhance existing SAP HANA content models
Report on a harmonized set of master data
Leverage SQL ln·house knowledge
Load snapshots or deltas from different sources on a periodic basis
You edit an SAP BW/4HANA object
In which SAP HANA studio views can you view the last modifier and modification time?
Note:There are 2 correct answers to this question.
Reporting preview
Problems view
Properties view
History view
You need to create CompositeProvider to combine data from an SAP HANA calculation view with a datastore Object (advanced)
Which user interface do you use to create the CompositeProvider?
Embedded SAP GUI in SAP HANA Studio
SAP BW/4HANA Cockpit
BW modeling perspective In SAP HANA Studio
SAP HANA modeler perspective in SAP HANA Studio
You created two structures that are defined without key figures. Afterwards you use both structures In your query definition
How many key figures can the query contain?
Exactly two key figures
Up to 10 key figures
Any number of key figures
Exactly one key figure
Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data category assigned?
Note· There are 2 correct answers to this question.
Join several tables
Persist master data
Define text joins
Aggregate measures
What is the purpose or grouping fields in a CompositeProvlder?
To provide a logical order for the query designer
To define subsets or fields for rule groups
To define subsets of fields for semantic groupings
To improve reponlng performance
For which activity do you use the simple key figure matrix?
Structure the information from the requirement analysis
List properties of the data sources
Allocate project resources
Provide information on the relations between characteristics
Which of the following are core modeling objects for the SAP Analytics Cloud?
Note:There are 2 correct answers to this question.
Story
Model
Layer
Page
You open an SAP Analysis for Microsoft Office workbook.
On which Design Panel tabs can you verity the fitter values?
Note.There are 2 correct answers to this question.
Design Rules
Components
Information
Analysis
You set up the 2LIS_02_ITM (Purchasing line Item) data Source in SAP ERP using the logistic cockpit.
Afterward you successfully run the initalization into SAP BW/4HANA
Your delta load into SAP BW/4HANA shows zero records even through new purchase order were created.
How do you explain that the delta records do NOT appear in SAP BW/4HANA?
Purchasing extractors in SAP ERP were set up with queued Delta upload mode and the collective run job was NOT scheduled
Another SAP BW/4HANA system already pickup the new purchise orders using a delta load
All purchase Orders in SAP ERP were archived overnight before the delta load
A reinitialization for sales orders in SAP ERP was triggered using the logistics cockpit, which deleted the purchase order item intialization.
Which of the following sources are available as Live Data Connections into SAP Analytics Cloud?
Note There are 3 correct answers to this question
SAP BusinessObjects Universe
SAP BW/4HANA
SAP HANA
Excel (xlsx or csv)
SAP Business Suite
Why do you define a custom table as a row store table? Note·There are 2 correct answers to this question.
When the table is accessed, all columns of a single record are processed
Aggregation and fast search is required for query execution.
The values in the columns are different Therefore,data compression would NOT have much effect
The table will be integrated into a native SAP HANA calculation view.
What should be achieved by modeling in a data Warehouse?
Note. There are 3 correct answers to this question
Individual spreadmart reporting
Automizatlon of ETL processes
Independent data silos
Transparent data flows
Single point of truth
Where can you integrate an analysis view from SAP Anatysis for Microsoft Office?
Note:There are 3 correct answers to this question.
In an SAP Crystal Reports 2016 report
In another SAP Analysis for Microsoft Office workbook
In an SAP Business Objects Web Intelligence report
In an SAP Crystal Reports for Enterprise report
In an SAP Lumira document
Which condition must be met to replicate data based on a dtatbase view in SAP landscape Transformation Replication Server (SLT) into an SAP HANA table?
An SAP HANA source system must be defined to customer the view
Each table of the view requires a defined trigger to enable data replication
View based data result sets must be kept persistent before data replication can take place
One table (as part of view) must be defined as primary table and will be used to trigger data replication
Which variable types allow filter values to be determined based on the user's authorizations?
Note:There are 2 correct answers to this question.
Hierarchy variable
Characteristic value variable
Formula variable
Hierarchy node variable
How do you enable streaming mode for a process
chain?
In Customizing (SPRO), change the general settings for SAP BW/4HANA.
In DW Workbench (RSA1), activate streaming mode In the "current Settings" folder of the Administration tab
In the SAP BW/4HANA Cockpit. add a new process variant for "Streaming Mode" in the Process Chain Editor app.
In the SAP BW/4HANA Cockpit set the "Streaming" flag in the Process Chain Editor app.
How do you model plant-specific attributes for the characteristic with the technical name '"MATERIAL"?
Define time-dependent attributes for the characteristic "MATERIAL "
Define navigation atuibutes for the characteristic "MATERIAL"
Compound the MATERIAL" characteristic and the characteristic for plant.
Join the "MATERIAL" characteristic and the characteristic for plant
You need to determlne the number of customers that have revenue In 2018,for each country
What is the reference lnfoObject in an exception aggregation?
Country
Counter
Year
Customer
'Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSoures?
Note There are 2 correct answers to this question
Delta Type
Record type
Paralelizallon
Record mode
You need to use a graphical calculation view with the DIMENSION data category Which constraint applies?
Only time-dependent atlributes are considered
Default node aggregation is required
The output cannot be used by other calcuation views,only in reporting
Only different records will be visible.
You use a measure with the "Amount with Currency code" Semantic type within your SAP HANA Calculation view.
You want to convert the currency
Which currency reference can be assigned to the measure?
Note :- there are 3 correct answer to this question
A currency from a currency Conversion
A fixed currency
A currency from an SAP HANA content calculation view
A currency from SAP BW customizlng
A currency from another column
Which source types can you select when you create an Open ODS view?
Note· There are 3 correct answers to this question
Transformatton
Virtual table using SAP HANA Smart Data Access
DataSouree (BW)
Characteristic
BW Ouery
