sap hana interview questions and answears
1. What are the benefits of implementing SAP HANA
with SAP ERP?
a)
|
O
|
Performance optimization for operational reporting
|
b)
|
O
|
Processing of large volumes of data
|
c)
|
O
|
Reduction of
Business Suite process steps.
|
d)
|
O
|
Provision of BI
Content.
|
e)
|
O
|
Provision of real-time analytics
|
2. What are the reasons for building a calculation
view with SQL script rather than the graphical interface
a)
|
O
|
To reuse standard SQL functions not provided within the
modeler
|
b)
|
O
|
To create custom reusable calculation functions
|
c)
|
O
|
To query existing
attribute and analytic views.
|
d)
|
O
|
To perform
projections on tables.
|
e)
|
O
|
To perform joins
between column and row store tables.
|
3. Which tool can you use to preview calculation
view data?
a)
|
O
|
SQL Preview.
|
b)
|
O
|
Export Model.
|
c)
|
O
|
Data Editor.
|
d)
|
O
|
Data Preview
|
e)
|
O
|
SQL Editor
|
4.
You have created a
balances report with data from SAP HANA and want to check that the values on
the report are correct.
With which of the following would you compare
the balances on the report?
a)
|
O
|
With the balances
stored in the SAP BusinessObjects universe.
|
b)
|
O
|
With the calculated
measures stored in SAP HANA.
|
c)
|
O
|
With the aggregate values stored in SAP
HANA
|
d)
|
O
|
With the sums of the
individual values stored in SAP HANA or in the source system.
|
5.
Which technology
supports true real-time replication of SAP ERP Pool and Cluster tables in an
SAP HANA database?
Please choose one(1) correct answer.
a)
|
O
|
Sybase Replication
Server
|
b)
|
O
|
SAP Landscape Transformation (SLT)
|
c)
|
O
|
SAP BusinessObjects
Data Services
|
d)
|
O
|
SAP BusinessObjects
Information Steward
|
- Which of the following settings are mandatory for
configuring the import server in the SAP HANA studio?
Please choose the correct answer.
a)
|
O
|
Repository name
Logon credentials. |
b)
|
O
|
Type of objects
SAP HANA target object. |
c)
|
O
|
Server address
Repository name |
d)
|
O
|
Type of objects
Source connection. |
- Which component of the Execution Control module breaks
the query into executable parts?
Please choose the correct answer.
a)
|
O
|
SQL script.
|
b)
|
O
|
Calculation engine.
|
c)
|
O
|
MDX.
|
d)
|
O
|
SQL parser
|
8. What
are the components of SAP IMCE Clients 1.0
a)
|
O
|
IMCE ODBO 1.0
|
b)
|
O
|
IMCE ODBC 1.0
|
c)
|
O
|
IMCE JDBC 1.0
|
d)
|
O
|
IMCE SQLDBC 1.0
|
e)
|
O
|
All of the above
|
9. SAP
HANA Software is available is the following editions
a)
Platform edition
b)
Enterprise
server edition
c)
Enterprise edition
d)
Enterprise extended edition
a)
|
O
|
Options
(a),(b) & (c)
|
b)
|
O
|
Options (a),(c) & (d)
|
c)
|
O
|
Only
(b) & (d)
|
d)
|
O
|
All
of the above
|
- Semantic Layer (UNX) is available for reporting by which
of the following reporting tools
a)
|
O
|
Crystal
Reports Enterprise, Dashboards & WebI
|
b)
|
O
|
Explorer,
Dashboards & WebI
|
c)
|
O
|
BI
BO Analysis v1.1
|
d)
|
O
|
MS-Excel & Crystal Reports 2011
|
- Calculation View can contain the following:
a)
|
O
|
Database tables
|
b)
|
O
|
Attribute views
|
c)
|
O
|
Analytic views
|
d)
|
O
|
Calculation views
|
- Which is the default perspective of IMCE Studio?
a)
|
O
|
Information
modeler
|
b)
|
O
|
Administrator console
|
c)
|
O
|
Life cycle
management
|
d)
|
O
|
Documentation
overview
|
- How many types of Exports/Imports can be performed from
HANA studio?
a)
|
O
|
2 (Client & Server)
|
b)
|
O
|
1 (Content)
|
c)
|
O
|
3 (Client, Server
& Content)
|
d)
|
O
|
0
|
- Which is the default schema for activated views?
a)
|
O
|
_SYS_BI
|
b)
|
O
|
_SYS_REPO
|
c)
|
O
|
_SYS_BIC
|
d)
|
O
|
_SYS_VIEWS
|
- List out the ETL based replication?
a)
|
O
|
Sybase Replication
(LOG BASED)
|
b)
|
O
|
SBO Data Services
(ETL BASED)
|
c)
|
O
|
SLT Replication (DB
TRIGGER BASED)
|
- What constitute SAP BO Analysis?
a)
|
O
|
MS-Excel 2010
|
b)
|
O
|
Crystal Reports
2011
|
c)
|
O
|
MS-Powerpoint 2010
|
- Which universe is used for Semantic Business Layer?
a)
|
O
|
OLAP Universe
|
b)
|
O
|
Relational Universe
|
c)
|
O
|
Semantic Universe
|
- Data preview is available with the following options?
a)
|
O
|
All Data
|
b)
|
O
|
Distinct Values
|
c)
|
O
|
Raw Data
|
d)
|
O
|
Analysis
|
- Identify the DB trigger Replication services?
a)
|
O
|
LT replication
|
b)
|
O
|
Log based
replication
|
c)
|
O
|
Sybase real time
replication
|
d)
|
O
|
ETL real time
replication
|
20 .
Analytic privilege can be assigned to Attribute View?
a)
|
O
|
True
|
b)
|
O
|
Only to Analytic
view
|
c)
|
O
|
False
|
- What is the Operating System of IMDB ?
a)
|
O
|
Unix Enterprise
Server
|
b)
|
O
|
SUSE Linux Enterprise Server
|
c)
|
O
|
Sybase ASE
|
- HANA Enterprise Server can be configured via Scale up or
Scale out configurations.
a)
|
O
|
True
|
b)
|
O
|
False
|
- Distributed system handling cannot be maintained in HANA
since it’s just one Enterprise server?
a)
|
O
|
True
|
b)
|
O
|
False
|
- What is the role SAP TDMS in SAP HANA?
a)
|
O
|
Used for upgrade
of HANA Studio
|
b)
|
O
|
Used for
replicating data via Data services
|
c)
|
O
|
Used within LT replication
|
- During power outage HANA DB performs the following:
a)
|
O
|
Recovers last data
savepoint
|
b)
|
O
|
Recovers log between last data savepoint
& time of failure
|
c)
|
O
|
Recovers from
external disk drive
|
- Select the correct Authorization privileges for
controlling activation of views?
a)
|
O
|
Analytic privilege
|
b)
|
O
|
Package privilege
|
c)
|
O
|
System privilege
|
d)
|
O
|
SQL privilege
|
- Network authentication protocol is not required for HANA
server access?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Reporting client users cannot be integrated with IMCE
users?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Roles assigned to a user are also grantable to other
users?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Single sign on users cannot be created in HANA since its
an independent system for Information models?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Which privilege controls User Admin & Create Schema
roles?
a)
|
O
|
Analytic privilege
|
b)
|
O
|
Package privilege
|
c)
|
O
|
System privilege
|
d)
|
O
|
SQL privilege
|
- Without Analytic Privilege, no data can be viewed from
a)
|
O
|
Attribute Views
|
b)
|
O
|
Analytic
Views
|
c)
|
O
|
Calculation Views
|
d)
|
O
|
All of the above
|
- Analytic Privileges belong to?
a)
|
O
|
_SYS_BI
|
b)
|
O
|
_SYS_REPO
|
c)
|
O
|
_SYS_BIC
|
d)
|
O
|
_SYS_VIEWS
|
- Private attributes from the Attribute views are used to
join to the Key attributes?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Following types of joins are possible in Attribute view?
a)
|
O
|
Referential join
|
b)
|
O
|
Description join
|
c)
|
O
|
Inner join
|
d)
|
O
|
Outer join
|
- Persistence layer in the HANA DB has the following
components:
a)
|
O
|
Data volumes &
Log Volumes
|
b)
|
O
|
Page management & Logger
|
c)
|
O
|
Row store &
Column store
|
- Which section controls the data processing in the HANA
DB?
a)
|
O
|
Transaction Manager
|
b)
|
O
|
Authorization
Manager
|
c)
|
O
|
Metadata Manager
|
- Which tool is used to create Universe for reporting in
dashboard?
a)
|
O
|
Semantic layer
tool
|
b)
|
O
|
Information design tool
|
c)
|
O
|
Universe layer
tool
|
- OPD for data replication API is used in which replication?
a)
|
O
|
Log based real
time data replication services
|
b)
|
O
|
Data services 4.0
|
c)
|
O
|
Sybase real time
data replication
|
- RFC connection is required for connection from
Replication server to HANA Database
a)
|
O
|
True
|
b)
|
O
|
False
|
- Life cycle management perspective is used for:
a)
|
O
|
SAP HANA
application management
|
b)
|
O
|
Upgrade/Updates for HANA studio
|
c)
|
O
|
SAP HANA appliance
management
|
- Information modeler also provide list of Users/Roles
created in the system?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Views available in the Quick launch of Information
modeler are:
a)
|
O
|
Navigator
|
b)
|
O
|
Where-used list
|
c)
|
O
|
Job log
|
d)
|
O
|
Properties
|
e)
|
O
|
All of the above
|
- MDX stand for:
a)
|
O
|
Meta Data
Expansions
|
b)
|
O
|
Multi Data
Expressions
|
c)
|
O
|
Multi Dimensional Expressions
|
d)
|
O
|
Meta Data Extended
|
- Content folder can be accessed from the Navigator of the
Administrator console?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Which table provides the mapping & assignment of
rules in the SLT replication:
a)
|
O
|
IUUC_ASS_RULE_MAP
|
b)
|
O
|
IUUC_REPL_TABSTG
|
c)
|
O
|
ROOSOURCE
|
d)
|
O
|
ROOSATTR
|
- Transformation in SLT replication can be handled in the
following ways:
a)
|
O
|
Event based
|
b)
|
O
|
Rule based
|
c)
|
O
|
Parameter based
|
- Which Business Objects tool is used for replicating data
to HANA?
a)
|
O
|
Data designer
|
b)
|
O
|
Data services designer
|
c)
|
O
|
Central management
console
|
d)
|
O
|
Information design tool
|
- Measures are:
a)
|
O
|
Data that can be quantified and
calculated
|
b)
|
O
|
Descriptive
data
|
- Data provisioning can be both initial load and
replication:
a)
|
O
|
True
|
b)
|
O
|
False
|
- What is the default maximum number of rows in Data
preview?
a)
|
O
|
500
|
b)
|
O
|
1000
|
c)
|
O
|
5000
|
- Validation rules of Analytic View can be selected &
de-selected from the ‘Manage Preferences’?
a)
|
O
|
True
|
b)
|
O
|
False
|
- A Package within a package can be created?
a)
|
O
|
True
|
b)
|
O
|
False
|
- SAP delivered content Information models can be
activated from?
a)
|
O
|
Import
|
b)
|
O
|
Migrate
|
c)
|
O
|
Mass copy
|
- Auto-documentation generates technical design document
in the _______format?
a)
|
O
|
.doc
|
b)
|
O
|
.pdf
|
c)
|
O
|
.xml
|
- What is full form of HANA?
- Which non-SAP system can SAP HANA connect to ?
a)
|
O
|
Oracle Enterprise
|
b)
|
O
|
IBM Informix
|
c)
|
O
|
Sybase ASE
|
- SAP BO Dataservices can connect to any OLTP system
including DBMS & RDBMS?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Hierarchies with hierarchy levels are supported in
Attribute view?
a)
|
O
|
True
|
b)
|
O
|
False
|
- In SAP HANA SP03 it will be possible to suspend a table from
the replication process and to resume it a later point in time
a)
|
O
|
True
|
b)
|
O
|
False
|
- What are the business benefits of ODP for non SAP BW
customers?
a)
|
O
|
Get access to the
Business Suite Extractors without having to go through SAP NetWeaver BW
|
b)
|
O
|
There is no need
for an ABAP Dataflow and therefore no ABAP program required for staging data
|
c)
|
O
|
Only (a)
|
d)
|
O
|
Both (a) & (b)
|
e)
|
O
|
None of the above
|
- Calculation engine performs the following:
a)
|
O
|
Create joins at run-time
|
b)
|
O
|
Create calculated measures & calculated attributes
|
c)
|
O
|
Compute & executes Calculation Views
|
d)
|
O
|
All of the above
|
- For SAP BW to be powered by HANA, what are the primary
steps required?
a)
|
O
|
Upgrade to SAP Netweaver BW 7.3
|
b)
|
O
|
Migrate Database (RDBMS) to HANA DB
|
c)
|
O
|
Connect HANA to
BWA
|
- The HANA optimized Infocubes has the following features:
a)
|
O
|
No dimension tables
|
b)
|
O
|
No secondary fact-table
|
c)
|
O
|
They represent “flat structures
|
d)
|
O
|
All of the above
|
- LT replication “Schema” can be configured to support
extraction jobs as follows:
a)
|
O
|
Real time
|
b)
|
O
|
Schedule by interval
|
c)
|
O
|
Schedule by time
|
d)
|
O
|
All of the above
|
- For Time Attribute views, which calendar types can be
created?
a)
|
O
|
Gregorian calendar
|
b)
|
O
|
Fiscal calendar
|
c)
|
O
|
Factory calendar
|
d)
|
O
|
All of the above
|
- Filter values can assigned at the ‘Data foundation’ in
the Analytic view?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Procedures can be created with Invoker’s rights only?
a)
|
O
|
True
|
b)
|
O
|
False
|
- SAP Solution Manager is used to provide remote access to
HANA Studio?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Security & Authorization of SAP HANA is required to
maintain the following?
a)
|
O
|
Control access to
objects/views
|
b)
|
O
|
Field-level
security
|
c)
|
O
|
Restrict users
from viewing Information models
|
d)
|
O
|
All of the above
|
- Pre-requisite to execute Crystal reports enterprise?
a)
|
O
|
JDBC/ODBC interfaces
|
b)
|
O
|
Relational Universe
|
c)
|
O
|
MDX
|
d)
|
O
|
All of the above
|
- Which of the following cardinalities are supported in
Attribute view:
a)
|
O
|
1:N
|
b)
|
O
|
N:1
|
c)
|
O
|
1:1
|
d)
|
O
|
N:N
|
- Is it possible to add tables later after the Analytic
view is created?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Packages can be exported without assigning Delivery
units for Server type exports?
a)
|
O
|
True
|
b)
|
O
|
False
|
- ‘Migrate’ from Quick launch is used for which of the
following:
a)
|
O
|
Multi lingual support
|
b)
|
O
|
N:1
|
c)
|
O
|
1:1
|
d)
|
O
|
N:N
|
- Calculation views can also be used as business reporting
view?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Attribute view provides the master data information
&can be used in any analytic view?
a)
|
O
|
True
|
b)
|
O
|
False
|
- SAP HANA supports ‘BIG’ data analytics?
a)
|
O
|
True
|
b)
|
O
|
False
|
- SAP HANA IMDB supports multiple hosts within the system
landspace?
a)
|
O
|
True
|
b)
|
O
|
False
|
- Information Composer is a browser like application for
End-users to create reports?
a)
|
O
|
True
|
b)
|
O
|
False
|