In a two system landscape, you want to transport SAP HANA information models from the source system to a target system. The source system has information objects that refer to physical schema S1. The target system uses physical schema S2. When you import the information objects into the target system, the information objects at the target cannot be opened as they still refer to schema S1.
What must you do to be able to open the information objects in the target system?
- A . Create a new schema.
- B . Execute a refactoring.
- C . Reimport the information models.
- D . Add a schema mapping.
How can you improve the performance of an information model?
- A . Use analytic views wherever possible.
- B . Use attribute views wherever possible.
- C . Use constraint filters.
- D . Use generated columns.
- E . Use indexes on all measures.
Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT.
Where in the attribute properties of ID_1 can you change this?
- A . In the name
- B . In the label
- C . In the alias label
- D . In the alias name
Which mapping do you use for objects which are maintained in customizing?
- A . MDG value mapping (code mapping)
- B . MDG key mapping (ID mapping)
- C . Cost object mapping framework
- D . Process Integration mapping
What do you have to define in an attribute view to reduce the initial amount of data selected from the data foundation tables?
- A . A dynamic filter value on a measure in the attribute view
- B . A restricted column in the output structure
- C . A column marked as "Hidden" in the output structure
- D . A static filter value on any column in the data foundation tables
What is a document splitting method?
- A . Set of business transactions
- B . Set of item categories
- C . Transaction splitting rule
What is True about CDS views for expired tables?
- A . Read and write access from custom ABAP Programs or reports possible with S/HANA.
- B . CDS (Core data services) views used for Non-disruptiveness of business functions.
- C . Read access from custom ABAP Programs or reports possible with S/HANA.
- D . Code inspector can be used to find out the affected part of code with S/HANA.
Universal Journal entry table (ACDOCA) stores:
- A . Majority of data with document header record (BKPF).
- B . Majority of data with or without document header record (BKPF).
CORRECT TEXT
Which view need be considered in development for read operations on mass data required?
- A . Attribute
- B . Analytic / Calculation
- C . Analytic
- D . Calculation
Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Suite?
- A . It allows using generic virtual data models
- B . It provides real-time replication
- C . It provides real-time operational reporting
- D . It uses the generic capabilities of SAP HANA such as the XS Engine
- E . It runs in older versions of the SAP Business Suite
On which level can you activate central payment?
- A . Business partner
- B . Client
- C . Company code
- D . Payment run ID
Which of the following describes an SAP HANA analytic view?
- A . It is a set of tables joined together in a star schema.
- B . It is a copy of data after transformation.
- C . It is a materialized set of data.
- D . It is a reusable object in attribute views.
User should securely distribute information across your organization, the ability to ask and answer own questions, able to print reports.
What are the best SAP available tools to meet the requirement?
- A . SAP Lumira.
- B . Crystal reports.
- C . Fiori Analytical applications.
- D . Web Intelligence (WEBI reports).
In an SQLScript calculation view, one variable contains the records that are the result of a SELECT * statement from a database table with 10 fields. You want to use this variable to populate a new variable with the same result set restricted to 1 of the 10 fields.
Which CE function do you use?
- A . CE_CALC
- B . CE_COLUMN_TABLE
- C . CE_AGGREGATION
- D . CE_PROJECTION
In a graphical calculation view you specify the default client to be dynamic.
How is the client value determined when the view is used?
- A . By reading the client of the tables in the view
- B . By applying the filtering conditions on the client field
- C . By executing a procedure in the user’s own schema
- D . By checking the session client of the user accessing the view
What must you do to replicate project definitions and WBS elements? Note: There are 2 correct answers to this question.
- A . Configure the inbound and outbound ALE.
- B . Activate the Central Finance accounting interface.
- C . Reset the SAP Landscape Transformation staging tables.
- D . Set up the Application Interface Framework.
You need to retrieve data from SAP HANAthat is restricted to a certain region and specific users.
How can you implement this security strategy?
- A . By assigning Package privileges to the necessary users
- B . By assigning Analytic privileges to the necessary users
- C . By assigning System privileges to the necessary users
- D . By assigning SQL privileges to the necessary users
The Fiori Launchpad designer is the standard tool for:
- A . Creating pre-configured groups and catalogs for the Launchpad home page.
- B . Transporting the configurations via correction requests / packages or customizing workbench.
- C . Configuring the tiles for static app launchers, dynamic app launchers, and target mapping.
Which information model can you use with measures from multiple fact tables?
- A . Analytic view
- B . Calculation view
- C . Attribute view
- D . Analytic privilege
Why do you call S/4 HANA an Agile approach?
- A . Because of Real time process.
- B . Because of new Account based COPA.
- C . Because of index /total tables removed.
- D . Because of New Cash Management.
Which system/function use the System Landscape Directory (SLD) to determine the local business system?
- A . Central Projects (WBS) – Reporting Scenario
- B . Activate central payment by company code
- C . Partial Payments integration
- D . Central Finance
Which of the following tools can you use to load data into SAP HANA from SAP DataSource extractors?
- A . SAP Landscape Transformation Server
- B . SAP Sybase Replication Server
- C . SAP Direct Extractor Connection
- D . SAP Data Services
When you create a new set of mappings, the system proposes a default set of mappings based on a preliminary examination of the characteristics or value fields being mapped?
- A . Standard Settings
- B . Combined quantity and value flow
- C . Variances cannot be determined for this production orders
- D . Requirements
SAP S4 HANA, which ones are correct:
- A . Advanced processing.
- B . New User Experience.
- C . Choice of deployment.
- D . Multitenancy.
- E . Simplified Data model.
SAP Simple Finance is
- A . Aligned – Single Source of Truth
- B . Predictive – Dynamic Planning and Analysis
- C . Agile – Real time processes
In your company, you tend to go through many reorganizations, which often leads to extra master data maintenance work.
Which grouping functionality can save you time maintaining profit center groups?
- A . Configuring derivation rules
- B . Defining flexible hierarchies
- C . Copying groups with suffixes
- D . Creating multidimensional sets
You are building a calculation view and want to select data from an analytic view.
How can you achieve better performance for this requirement?
- A . Use L programming
- B . Use CE functions
- C . Use SQL statements
- D . Use table indexing
In which of the following can you use a FOR loop over your data?
- A . Analytic View
- B . Monitoring View
- C . Calculation View
- D . Analytic View
The derivation of profit center can happen through assignments to which objects? There are three correct answers.
- A . Document splitting
- B . Material assignment
- C . Cost estimate assignment
- D . Cost center assignment
- E . Fixed asset assignment
You want to create a custom attribute in addition to your data model.
How can you achieve this?
- A . Create the attribute as a calculated measure within the attribute view.
- B . Create the attribute as a calculated attribute within the analytic view.
- C . Create the attribute as a restricted attribute within the calculation view.
- D . Create the attribute and add it to the appropriate system table manually.
Which of the following steps are key factors for a successful Central Finance implementation? Note: There are 2 correct answers to this question.
- A . Involve business process owners during system design.
- B . Reorganize source systems.
- C . Migrate from a two-tier architecture to a three-tier architecture.
- D . Define strong master data governance processes.
You develop a disaster recovery plan.
What do you have to consider in case of a disk failure?
- A . Log volumes can be backed up.
- B . Configuration files can be restored automatically.
- C . Save points can be backed up.
- D . Committed transactions can be recovered.
- E . Non-committed transactions can be recovered.
Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server?
- A . Write data to the SAP HANA system using the DB connection.
- B . Schedule replication processes.
- C . Map database structures between SAP HANA and the source system.
- D . Create repositories in the source system.
The Universal journal entry document number is dependent on:
- A . Fiscal Year
- B . Company Code
Which security settings can you apply in analytic privileges?
- A . Grant access to analytic views.
- B . Restrict access within an analytic view using attribute values.
- C . Restrict access within an analytic view using measure values.
- D . Restrict access to hierarchies.
In an SAP S/4HANA system, you have two profit centers with the same profit center code and the same validity period, but different names.
What does this indicate about the configuration of the profit centers?
- A . They are defined in separate company codes.
- B . They are defined in separate controlling areas.
- C . They are assigned to different functional areas.
Which privilege type do you have to assign to a role, when you want to provide row-level access to data?
- A . ANALYTIC
- B . SQL
- C . SYSTEM
- D . PACKAGE
In an analytic view, you need two different logical joins from the data foundation to an attribute view. The analytic view already contains the attribute view but you have to use the attribute view again.
To which of the following do you connect the second join?
- A . To a derived attribute view
- B . To a shared attribute view
- C . To a copy of the attribute view
- D . To a new instance of the attribute view
What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA? in You can merge data streams.
- A . You can perform real-time data replication
- B . You can use the same hardware.
- C . You can load unstructured data into SAP HANA.
- D . You can use Bl Content extractors or function modules.
Which of the following tools use SQL to communicate with SAP HANA?
- A . SAP BusinessObjects Dashboards
- B . SAP BusinessObjects Web Intelligence
- C . SAP BusinessObjects Information Design Tool
- D . SAP BusinessObjects Analysis, edition for Microsoft Office
- E . SAP BusinessObjects Analysis, edition for OLAP
Is it possible to post a value directly to a standalone profit center?
- A . True
- B . False
You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year.
How can you achieve this?
- A . Use a CE function.
- B . Use a variable.
- C . Use a calculated attribute.
- D . Use a calculated measure.
Company needs to load external data from a flat file into SAP HANA.
How can you do this?
- A . SAP HANA Direct Extractor Connection (DXC)
- B . SAP HANA SQL Import statement
- C . SAP BusinessObjects Data Services
- D . SAP System Landscape Transformation (SLT)
Which event triggers the transfer of COGS to the Central Finance system?
- A . Invoice receipt
- B . Production order settlement
- C . Goods delivery
- D . Sales order creation
Which tasks can you perform with the data provisioning view in the SAP HANA studio?
- A . Suspend replication of tables
- B . Filter replicated data
- C . Start replication of tables
- D . Apply data transformations
An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution.
Which of the following could you check to resolve the error?
- A . The Web Intelligence report variables
- B . The business view
- C . The SAP HANA information model
- D . The business layer
Which delivered role is mandatory for a system administrator in SAP HANA?
- A . CONTENT_ADMIN
- B . SAP_ALL
- C . SYS_ADMIN
- D . IC MODELER
What happens when you turn on replication of an SAP ERP source system using SAP Landscape Transformation (SLT)?
- A . SLT creates ABAP code in the ERP system that writes to logging tables.
- B . SLT creates database triggers in the ERP system that write to application tables.
- C . SLT creates ABAP code in the ERP system that writes to application tables.
- D . SLT creates database triggers in the ERP system that write to logging tables.
Required installation components for Central Finance are:
- A . SAP HANA Live/Fiori and Smart Business Cockpits etc.
- B . SAP Business Intelligence tools like Analysis for Office.
- C . SAP Landscape Transformation (SLT) Replication Server (plus partner products like Datalytics for non-SAP ERP systems).
- D . Additional Simple Finance products like Integrated Business Planning, Cash Management, or Fraud Management etc. (optional).
- E . SAP S/4HANA (ERP with SAP Simple Finance).
- F . SAP HANA Hardware (on-premise, cloud, private cloud) and software (database / appliance).
In which order are views consumed by the SAP HANA Live virtual data model?
- A . 1. Query 2. Reuse 3. Private
- B . 1. Query 2. Private 3. Reuse
- C . 1. Reuse 2. Private 3. Query
- D . 1. Reuse 2. Query 3. Private
With HANA, much of logic execution performed in Application server instead of Database.
- A . No
- B . Yes
Which document splitting Customizing settings do you maintain to ensure that financial statements can always be produced separately for each profit center?
- A . Zero-balance
- B . Dummy profit center
- C . Inheritance
- D . Standard account assignment
You have a table of transactional data with different transaction types. You want to create an analytic view for only one of the transaction types.
How can you ensure that only rows with the required transaction type are displayed in the analytic view?
- A . Create an input parameter
- B . Create a calculated column
- C . Create a restricted column
- D . Create a filter on the table
Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?
- A . Include only relevant tables for DB recording.
- B . Record relevant changes in logging tables.
- C . Ensure that replicated changes are kept within the logging tables.
- D . Decluster table classes into a transparent format.
what are the capabilities of the Customer/Vendor Integration (CVI) business function? Note: There are 2 correct answers to this question.
- A . Integrates the business partner, customer master, and vendor master
- B . Checks for duplicates of business partner, customer master, and vendor master
- C . Replaces the customer master and vendor master with business partners
- D . Allows bi-directional replication of business partner, customer master, and vendor master
Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA?
- A . SAP Landscape Transformation (SLT)
- B . SAP Landscape Directory (SLD)
- C . SAP Direct Extractor Connection (DXC)
- D . SAP BusinessObjects Data Services
Which technologies use trigger-based replication?
- A . Near Zero Downtime
- B . Test Data Migration Server (TDMS)
- C . ABAP extractors
- D . Standard SQL database replication
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA?
- A . It eliminates the need to upgrade to the latest SAP BW application version.
- B . It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.
- C . It allows re-use of your available SAP BW application servers.
- D . The sizing of your current SAP BW application servers remains valid.
- E . The system usage is the same as an equivalent SAP BW on non-SAP databases.
What is correct about data process using HANA Database especially SAP stand point?
- A . Database used for data store and process.
- B . Database used for data store.
- C . Data processing happen in application server.
Existing programs and interfaces can still be used access via compatibility views:
- A . Read access is automatically re-directed to the universal journal as the new single source of truth.
- B . Read access from custom ABAP programs or reports to prior tables will work as before.
How can you improve the performance of a report that is based on SAP HANA data?
- A . Ensure that all calculations are pushed down to the SAP HANA database.
- B . Maintain appropriate constraint filters in SAP HANA.
- C . Ensure that all SAP HANA tables are in the same schema.
- D . Gather new database statistics.
Which of the following remote data sources can you access with SAP HANA smart data access?
- A . Teradata Database
- B . Apache Hadoop
- C . Microsoft SQLServer
- D . SAP NetWeaver Business Warehouse
- E . SAP Sybase Adaptive Service Enterprise
You are implementing the SAP CO-PAAccelerator to enable real-time profitability reporting.
Which configuration steps must you do?
- A . Configure the SAP BusinessObjects Data Services replication jobs.
- B . Build attribute and analytic views in SAP HANA.
- C . Create a secondary database connection in SAP ERR
- D . Install the SAP HANA database clients on all SAP ERP application servers.
- E . Activate continuous data replication of tables CEIxxxx, CE2xxxx, CE4xxxx.
True or False: Parallel valuations’ multi-valuation ledger updates multiple ledgers.
- A . False
- B . True
User A has to set up tables and views in a database schema that is owned by user B.
Which of the following privilege must you grant?
- A . CREATE ANY to user A
- B . REFERENCES to user B
- C . REFERENCES to user A
- D . CREATE ANY to user B
Where can you deploy the column view of a decision table?
- A . In SAP Visual Intelligence
- B . In Microsoft Excel
- C . In calculation views
- D . In analytic views
To ensure all that profit center master data is accurate and complete, we use which of the following?
- A . Profit Center Monitor
- B . Assignment Monitor
- C . Customizing Monitor
You want to load a large amount of source data (more than one billion rows) into SAP HANA for read-intensive information models.
Which table type is recommended for this scenario?
- A . Row table
- B . Global temporary table
- C . Column table
- D . Decision table
With Universal Journal, one line item table with full detail for all components. Data stored only once, so no reconciliation needed by architecture, and reduction of memory footprint through elimination of redundancy.
- A . True
- B . False
Universal Journal Entry, which ones are correct?
- A . ACDOCA table has 6 digit field for line item numbering.
- B . ACDOCA table has 23 digits for currency fields.
- C . The new journal entry consists of a header (table BKPF) and the respective items (table ACDOCA).
- D . ACDOCA table contains all fields needed for G/L, CO, AA, ML, PA.
- E . All cost elements except secondary cost elements are G/L accounts.
- F . Multi-GAAP capability through "RLDNR" dimension.