sap hana certification questions and answers

Overview and Architecture of HANA

• What is HANA ? –High Performance Analytical Appliance - In memory computing engine
• In memory computing studio as a frontend for modeling and administration. 
• HANA is connected to ERP systems, Frontend modeling studio can be used for load control and replication server management 
• Two types of Relational Data stores in HANA : Row Store, Column Store 
• SAP BOBJ tools can directly report on HANA 
• Data from HANA can also be used in MS Excel - MDX
• Row Store – Traditional Relational Database. The difference is that all the rows are in memory in HANA where as they are stored in a hard drive in traditional databases. 
• Column Store – The data is stored in columns like in SAP BWA 
• Persistence Layer : In memory is great but it is volatile and data can be lost with power outage or hardware failures. To avoid this HANA has a Persistence Layer component which makes sure that all the data in memory is also store in a hard drive which is not volatile. 
• Session Management : This component takes care of logon services. 
• Two processing engines – Well, data is in memory which is good but How do I extract/report on the data? HANA has two processing engines one is based on SQL which accepts SQL queries and the other one is based on MDX .  
• HANA Supports Sybase Replication Server – Sybase Replication Server can be used for real time synchronization of data between ERP and HANA 

Modeling Studio

Using Modeling Studio you can,

• Specify which tables are stored in HANA, first part is to get the meta data and then schedule data replication jobs 
• Manage Data Services to load the data from SAP BW and other 3^rd party systems. 
• Manage connections to ERP instances, current release does not support connecting to several ERP instances 
• Use Data services to for the modeling 
• Do modeling in HANA itself (This is independent of Data services).
• You can also do modeling can also be done in Business Objects Universes which is nothing but joining fact and dimensional tables.

Reporting

• Client tools can access HANA directly, Like MS EXCEL, SAP BI 4.0 Reporting tools, Dashboard Design Tool (Xcelsius)  can also access HANA directly. 
• Third party reporting tools can leverage ODBC, JDBC and ODBO (for MDX requests) drivers in HANA for reporting. 
• HANA supports BICS interface

Request Processing and Execution Control

•  SQL Script, MDX statements are passed  to calculation models.
• Optimizer which is included in calculation engine optimizes for better performance.
•  Calculation Engine :
•  Modeler can define data sources as inputs and different operations (join, aggregation, projection) on top of them for data manipulation
•  The calculation engine will break up a model into sub processes for optimized performance on cost based.
•  System will use maximum resources to achieve max through put
•  Planning Engine : Will be included in next release. Will include planning functions like distribute and copy functions. 

ROW Store

• One of the relational engines to store data in row format.
• Pure in-memory store (Future versions will also have an option of disk based store)
• In memory object store (in future) for live cache functionality
• Transactions Version Memory is the heart of row store
• Row store architecture
• Write operation mainly go into "Transactional Version Memory"
• INSERT also writes to persisted segment
• Moves visible version from memory to persisted segment
• Clears outdated record versions from Transactional Version memory
• Row Store tables have a primary index
• Row ID maps to primary key
• Secondary indexes can be created
• Row ID contains the segment and the page for the record
• Indexes in row store only exist in memory
• Index definition stored with table meta

Column Store

• Improves read functionality significantly, also improves write functionality
• Highly compressed data
• No real files, virtual files
• Optimizer and Executer – Handles queries and execution plan
• Delta data for fast write
• Asynchronous delta merge
• Consistent view Manager
• Main store compressed and read optimized – Data is read from Main Store
• Delta Store – Write optimized – for write operations.
• Asynchronous merge move the data from delta store to main store
• Compression by create dictionary and applying further compression methods
• Even during the merge operation, the columnar table will still be available for read and write operations. To fulfill this, a second delta and main storage are used internally
• Merge operation can also be triggered manually with an SQL command

Persistence Layer

• Persistence Layer is needed as Main memory is volatile
• Provides Backup and Restore functionality
• One Persistency Layer takes care of both row and column stores
• Regular Save Points
• Logs capturing DB transactions since last save point

• Actions during system restart
• Last save point must be restored plus undo logs must be read and uncommitted  transactions saved with last save point and apply redo logs
• Complete content of row store is loaded into memory during start process
• Flags can be set for column store to specify which tables are loaded during system restart

Modeling

• Modeling only possible for Column tables
• Information Modeler only works for column tables
• Replication servers create tables in column store per default
• Data Services creates tables in column store per default
• SQL to create column table: Create COLUMN TABLE
• Store can changed with ALTER TABLE
• System tables are create where they fit best
• Schema SYS ->  administrative table of engine
• Tables from statistics server

In-Memory Computing Studio

• Build with java based eclipse
• Navigator to access different HANA systems on left, Quick Launch View at the middle and Properties view at the bottom.
• Information Modeler Features:
• Database views
• Choice to publish and consume at 4 levels of modeling
• Attribute view, analytic view ...
• Physical tables and Information Models
• Import/export models, data source schemas, mass and selective load
• Landscapes
• The models are just virtual definitions they don't store actual data
• Analytic Views are like cube model where Transaction Data is connected to attribute view
• Calculation View – With custom functions and calculations

Modeling Process Flow

• Import Source System Metadata
• Create Information Models
• Consume using BICS, SQL or MDX
• Information Modeler Terminology
• Attributes – Characteristics
• Measure – Key Figures
• Attribute Views – Dimensions
• Analytic Views – Cubes
• Calculation Views – Similar to Virtual provider concept in BW
• Hierarchies
• Leveled – based on multiple attributes
• Parent-child hierarchy
• Analytic Privilege – Security Object

• Navigation View
• HANA instance -> Hana server name and instance number -> user database schema -> views functions and tables
• Information Models – Attribute, Analytic, Calculation Views and Analytic  Privilege

• Attribute View :
• Attributes add context to data
• Attributes are modeled using attributes views
• Can be regarded as Master Data Tables
• Can be linked to fact tables in Analytical Views
• A measure e.g. weight can be defined as an attributes
• Table Joins and properties
• Left outer, right outer, full outer or text table
• Cardinality 1:1, N:1, 1:N
• Language Column
• Analytic View:
• Similar to Cube
• Analytic Views does not store any data. The data is stored in column store table or view based on Analytical View structure
• Attributes and Measures – Like key figures
• Data Preview – Similar to list cube functionality

• Calculation View:
• Define table output Structure
• Write SQL statement
• Ensure the selected fields corresponds to previously defined output structures
• SQL Scripts unlike SQL procedure can't change any data they are read only

Other Notes:

•  External tools can connect to HANA using JDBC and ODBC drivers
• HANA currently doesn't support complete MDX set, it supports EXCEL 2010 standard MDX
• BWA Hardware can be upgraded to HANA given that hardware is relatively new
• BWA Licenses can be transferred to HANA
• ERP and BW can be connected to HANA using Data services or Sybase Replication
• No  name space concept in HANA at this moment, so two ERP instances can't be connected to HANA. However this issue can be avoided using data sources
• CRM also can use HANA
• Data from BW into HANA can be loaded into using Data Services and Info spokes

Additional Notes :

1)     No Aggregates where BWA is used. Only flexible views

2)     Benefits of SAP NetWeaver BW on HANA :

a.     Superior Reporting Performance

b.    Real-Time Data Access

c.     Simulate More and Plan Faster

d.    Superior Loading Performance

e.     Simplified Maintenance

f.     Modeling Flexibility

g.    HANA optimized InfoCube and Data Store Objects (DSO)

h.     Acceleration via In-Memory Column Storage

i.      Reduced admin tasks an lower TCO

j.      Self-service access to all information

k.     Minimal training or disruption

l.      No Disruption to W application

3)     SAP HANA is the only Persistence layer for SAP Business Suite and SAP NW BW

4)      Web Based Modeler called as Information Composer for business users to quickly build models

5)     SAP HANA – Backup Recovery = Point-in-time recovery.

6)     Monitoring and Administration in SAP HANA is improved through Solution Manager integration

7)     SAP HANA SP3 Highlights :

a.               More End User Flexibility

i)          Web Based Modeler (Information Composer)

ii)         User Interface improvements

b.              New Landscape Deployment options :

i)          Enhanced back-up recovery

ii)         Simplified Deployment

c.               Extended Calculation Capability & Performance :

i)          Business Function Library

ii)         Predictive Algorithm Library

iii)        Improved Loading Performance

d.              Further Support & Monitoring Capabilities :

i)          New tracing and debugging (within SAP HANA Model Studio)

ii)         Monitoring and Administration (Integration to Solution Manager)

e.               Enhanced Security & Compliance :

i)            Secure Network Connectivity

ii)           Comprehensive & complaint user provisioning

iii)          Auditing Enhancements

iv)          License Key

8)     In-Memory Computing :

a.     Row and Column Store

b.    Compression

c.     Partitioning

d.    No Aggregate Tables

e.     Insert Only on Delta

9)     SAP HANA In-Memory Computing can execute 64 things (threads) in parallel

10)  HANA = High Performance Analytical Appliance

11)  SAP HANA Modeling is based on SBO Information Designer (“Universe”)

12)  SAP HANA has Open Full ANSI 92 SQL and MDX

13)  SAP HANA for Marketing Users (CRM) = Leverages TREX/BWA technology to conduct analysis on prospect Master Data.

14)  SAP HANA = Real-time integration of OLTP and “In-Memory” store.

15)  POS = Point of Sale Analysis

16)  IMP = In-Memory Platform

17)  MPP = Massive Parallel Processing

18)  In-Memory in Parallel : Analytic models from Production EDW can be brought into memory for agile modeling and reporting.

19)  Third Party Data (POS, CDR) can be brought into memory for agile modeling and reporting.

20)  Today’s System Landscape of SAP HANA :

a.     In-Memory in Parallel (Now)                  à SAP HANA 1.0

b.    Primary Data Store for BW (short term) à SAP HANA 1.5

c.     New Applications (short term)                à SAP HANA 1.5

d.    Real Time Data Feed (Medium term)    à SAP HANA 2.0

e.     Platform Consolidation (Medium term)  à SAP HANA 2.0

21)  SAP HANA delivers an In-Memory Calculation Engine with Data Compression that overcomes the challenge of handling ever increasing data volumes

22)   BI Tools :

a.     BO Analysis , edition for Microsoft Office = Multidimensional data analysis with Microsoft Office

user experience (Microsoft Excel)

b.    BO Analysis, edition for OLAP = Multidimensional data analysis within a web-based environment

c.     BO Analysis, edition for Application Design = Rich and Intuitive design environment for building

powerful analytical and planning BI applications.

d.    BO Crystal Reports = Design well-formatted, layout-focused reports.

e.     BO WEBI = Adhoc Interactive Reporting

f.     BO Dashboards = Visualize complex data easily with interactive dashboards

g.    BO Explorer = Search relevant information and direct exploration of data

23)  Crystal Reports, WEBI, SBOP Dashboards are able to leverage hierarchies in reports but are lacking deep hierarchial capabilities.

24)  SAP BO Explorer is available for the iPhone/Pad

25)  A “What-if” scenario is the strength of SAP BO Dashboards.

26)  a) SAP ERP à SLT (Replication Server) ----(Real Time Replication) à SAP HANA à SAP BO  à Presentation

b) SAP BPC or Non-SAP à Data Services/BODS (Near Real-time Replication) à SAP HANA à BO à Presentation

1)  SAP HANA System Landscape :

A) Data Sources :

i.  SAP ERP

                 ii.  SAP Host Agent 7.20

                iii.  Sybase Replication Agent (HP, UNIX, SLEX, AIX)

 B) LT System :

i.  NW 7.02

ii. Add-on DMIS 2010_1_700

C) SAP HANA Appliance (SLES 11 SP1)

                              i. SAP HANA Database – Clients Studio

                             ii. SAP HANA Load Controller

                            iii. SAP Host Agent 7.20

                            iv. Sybase Replication Server 15.5 + ECDA

D)  Admin Workstations :

                            i.  SAP HANA Studio

                           ii.  SAP HANA database clients

                          iii.  Data Services Designer

                          iv.  Information Designer

                           v.  MS Excel 2010

                          vi.  Web Access to BI Admin Tools

E)  End Users Workstations :

i.   MS Excel 2010

ii.   SAP HANA Database Clients 1.0

     iii.   Web Access to BI Clients (1577128)

F)  Data Services :

i.  Data Services 4.0

       ii.  Data Services Job Server

      iii.  Repository (shared with BOC)

G)  BI-4.0 :

i.   BI Platform

        ii.  BO Explorer

       iii.  BO Web Application Server

       iv.  BO Repository

2)  SAP HANA Appliance Software :

        a)  SAP HANA Studio                   = SAP HANA Load Controller

b)  Sybase Replication Server    = SAP Host Agent

        c)  SAP HANA Database Clients = LM Structure Files

        d)  SAP HANA Database              = SAPCAR

3)  SAP HANA Enterprise extended  edition : (For Log based replication)

i)  Sybase Replication Agent

              ii)  Sybase Replication Server

             iii)  SAP HANA Load Controller (R/3 Load in Source + R/3 Load in SAP HANA)

4)  Replication Methods Overview :

         a)  Trigger-Based Replication

b)  ETL-Based Replication

c)  Log-Based Replication (Database à Log File)

5)   Replication Methods Overview :

       a)  Source System-SAP ERP (Application Layer) à Trigger Based Replication à SAP In-Memory Database

       b)  Source System-SAP ERP (Application Layer) à    ETL Based Replication  à SAP In-Memory Database

       c)  Source System-Database (Log File)                 à   Log Based Replication  à SAP In-Memory Database

CHANDRA :

1.   In a BO WEBI report,  if you want retrieve data for a particular year from HANA DB, for optimization where is the best place to filter:     WEBI query        2.HANA Model  3.Universe          4.CMC

Ans   HANA MODEL

2.   Which BO Tool is good for visualization

Ans   DASHBOARDS

3.  Which BO tool is good for Formatted reports

Ans CRYSTAL REPORTS

1.     What is the standard user for HANA admin activities

Ans   <SYS>ADM -- Database level administration

            SYSTEM    -- Modeler administration

2.     If you want to retrieve more than 5000 records in the BO report where do you do this setting?

Ans  Increase the Array Fet size to 5000. -->  not sure about it.

3.   What are the benefits of BOBJ on HANA?

Ans  quick response time SAP and NON SAP interfaces. Near real time data.

4.     On SQL SCRIPT there are 3 questions one of the question is like this:
What is SQL SCRIPT:
Set of abap commands run on ABAP application server
Set of sql commands run NETWEAVER server
Set of sql commands  pushed intensive data logic to HANA DB  

     Set of sql commands  pushed intensive data logic to client tools  

Ans  Set of sql commands  pushed intensive data logic to HANA DB  

5.     On calculation view 3 questions for example: In what situation the calculation view is required?

Ans  When we require complex logic that cant be delivered by Attribute and Analytical Views.

6.     Data Services 3 questions
#Analytic Privileges 2 questions

10. What replication method is good for complex transformation?

Ans  ETL base Replication ( Data Services )

11.  Types of privileges - ????? All of the ABOVE???

Ans          a.    SYSTEM Privileges, b) SQL Privileges & c) Analytic Privileges

a.     System, SQL Privileges   (Schema Privileges + Data Objects Privileges)

b.    ANALYTIC Privileges

c.     PACKAGE Privileges

12.  Type of privilege  for Dropping Table

Ans    SQL Privileges (Schema Privileges + Data Object Privileges )

13.  Question about Descriptive Mapping

I think, you are referring to Text Mapping. If it is text mapping following are valid. --> 1:1 mapping, Language Column is mandatory and should be SPRAS, Join type is Text Join

14. Business Layer steps/ Semantic Layer

Ans --> create Package --> Create Relational Connection --> Create Data Foundation --> Publish Data Foundation to Repository --> Create Business Layer ( universe) --> Publish Business Layer to Repository.

15.  Input for analytic view  2 questions

16.  question on where used list

Ans we use this to find objects affected by that model.

17.  When import a model view to target system, How to activate the dependent objects?

Ans  Cascade Activate

18.  When you right Click the object you have the Option to

a Cascade function 2. Where used 3. Hierarchy function 4. History function

Ans  Cascade Function , Where Used, Hierarchy

19.  Benefits of using different accelerators on HANA?

Ans  Real time data and faster data access

20.  Type of cardinality between attribute view and text tables?

Ans  1:1 for text joins

21.  SLT steps

Ans -->DB Trigger --> Logging Tables --> Read Module --> Controller Module --> Write Module --> HANA data base

22.  BODS and Hana connection steps

Ans

a.     Create a connection to an SAP Target System in BODS

b.    Import SAP Metadata into BODS

c.     Import SAP Metadata from BODS into SAP HANA

d.    Import SAP Metadata – Target structure from  SAP ERP Source Table to the SAP HANA Target Table

e.     Create a BODS job and dataflow with 1:1 to load data into SAP HANA

f.     Execute the job in BODS to load data into SAP HANA

g.    Preview uploaded data in SAP HANA

23.  What is DB trigger

Ans      Only relevant tables considered for DB recording

All relevant changes are recorded in logging table

Replicated changes are deleted from logging tables

Recording and replication possible for all table classes

24.  What is Load Controller

Ans  Ensure mapping between HANA DB Structures and DB Structures of source system
Provides ability to conversion/migration values Provide scheduling options to determine the frequency of data replication

25.  BW on HANA what are the steps: example: Database migration etc.

Ans  Copy and Migrate the DB convert the info cube to IN memory

26.  In the following which one is for real time replication with zero downtime: SLT, BODS, Sybase and some other thing

Ans  SLT

27.  Given the HANA Architecture view diagram and the question is what are the important components of HANA database ?

Ans  In-memory computing engine ( Row store, column store, persistent layer, calculation/Execution engine, interfaces), In-memory computing studio

28.  With ODP data replication API what extractors are available? 1. Released extractors 2. Business content extractors etc…

Ans  Customers customized extractors approved by SAP, so only Released Extractors

29.  Question on profitability analysis

 ANS: CO-PA accelerator

37. How can you evaluate the actual speed of a calculation within HANA DB, Ans: (3 answers needed)

a)  Write and execute SQL statement
b)  Use data preview
c)  Execute WEBI 

d)  Execute information space view, e0 trace using python admin tool within TREX.

38.  What tool to handle duplicate names of HANA?  ???

         a.  MDM

         b.  Data Service
         c.  UNION SQL

39.  How do you verify the quality of HANA
a.  Use SQL Editors 
b.  Compare data with HANA_STATISTICS 
c.  Use data service quality process
d.  Use WEBI report 
e.  Use SLT to very quality 
f.   Compare ERP with HANA data

40.  What is the Authentication method for Single-Sign on 1. LDAP 2.Keberos

Keberos

PARAM :

1.   What are the benefits of implementing SAP HANA with SAP ERP?

a.     Performance Optimization for operational reporting

b.    Processing of large volumes of data

c.     Provision of real-time analytics

2.     What are the reasons for building a calculation view with SQL script rather than the graphical interface

a)     To reuse standard SQL functions not provided within the modeler

b)    To create custom reusable calculation functions

3.     Which tool can you use to preview calculation view data?

a)     Data Preview

b)    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)     With the aggregate values stored in SAP HANA

5.     Which technology supports true real-time replication of SAP ERP Pool and Cluster tables in an SAP HANA database?   SAP Landscape Transformation (SLT)

6.     Which of the following settings are mandatory for configuring the import server in the SAP HANA studio?

Server Address Repository name

7.     Which component of the Execution Control module breaks the query into executable parts?    Please choose the correct answer.

SQL Parser

8.     What are the components of SAP IMCE Clients 1.0

a.     IMCE ODBO 1.0

b.    IMCE ODBC 1.0

c.     IMCE JDBC 1.0

d.    IMCE SQLDBC 1.0

9.     SAP HANA Software is available is the following editions

a.     Platform  Edition

b.    Enterprise Edition

10.  Semantic Layer (UNX) is available for reporting by which of the following reporting  tools

a.     Crystal Reports Enterprise, Dashboards & WEBI

11.  Calculation View can contain the following:

a.     Database Tables

b.    Attribute Views

c.     Analytic Views

d.    Calculation Views

12.  Which is the default perspective of IMCE Studio?    Administrator Console

13.  How many types of Exports/Imports can be performed from HANA studio ?    a. 2 (Client & Server)

14.  Which is the default schema for activated views?

a.     _SYS_BIC

15.  List out the ETL based replication?     SBO Data Services (ETL Based)

16.  What constitute SAP BO Analysis (BICS)?

a.     MS Excel 2010

b.    MS Powerpoint 2010

17.  Which universe is used for Semantic Business Layer?    Relational Universe (BO)

Information Designer Tool

18.  Data preview is available with the following options?

a.     Raw Data

b.    Distinct Values

c.     Analysis

19.  Identify the DB trigger Replication services?    LT Replication

20.  Analytic privilege can be assigned to Attribute View?   True

21.  What is the Operating System of IMDB ?   SUSE Linux Enterprise Server 11 SP3

22.  HANA Enterprise Server can be configured via Scale up or Scale out configurations.   True

23.  Distributed system handling cannot be maintained in HANA since it’s just one Enterprise server ?  False

24.  What is the role SAP TDMS in SAP HANA?   Used with LT Replication

25.  During power outage HANA DB performs the following :  Recovering log between last data savepoint and time of failure

26.  Select the correct Authorization privileges for controlling activation of views ?  Package Privilege

27.  Network authentication protocol is not required for HANA server access ?  False

28.  Reporting client users cannot be integrated with IMCE users ?   False

29.  Roles assigned to a user are also grantable to other users ?   True

30.  Single sign on users cannot be created in HANA since it is an independent system for Information models ? False

31.  Which privilege controls User Admin & Create Schema roles ?System Privilege

32.  Without Analytic Privilege, no data can be viewed from

a.     Attribute Views

b.    Analytic Views

c.     Calculation Views

33.  Analytic Privileges belong to ?    _SYS_REPO

34.  Private attributes from the Attribute views are used to join to the Key attributes ?   False

35.  Following types of joins are possible in Attribute view?

·         Referential Join

·         Inner Join

·         Outer Join

36.  Persistence layer in the HANA DB has the following components :   Page Management &  Logger

37.  Which section controls the data processing in the HANA DB ?   Transaction Manager

38.  Which tool is used to create Universe for reporting in dashboard ?    Information Design Tool (IDT)

39.  OPD for data replication API is used in which replication ?    Data Services 4.0

40.  RFC connection is required for connection from Replication server to HANA Database : False

41.  Life cycle management perspective is used for :   Upgrade / Updates for HANA Studio

42.  Information modeler also provide list of Users/Roles created in the system ?  False

43.  Views available in the Quick launch of Information modeler are:

·         Navigator

·         Where-Used List

·         Job Log

·         Properties

44.  MDX stand for :    Multi Dimensional Expressions

45.  Content folder can be accessed from the Navigator of the Administrator console ?   False

46.  Which table provides the mapping & assignment of rules in the SLT replication :  IUUC_ASS_RULE_MAP

47.  Transformation in SLT replication can be handled in the following ways:

·         Event Based

·         Parameter Based

48.  Which Business Objects tool is used for replicating data to HANA ?     Data Services Designer

49.  Measures are : Data that can be quantified and calculated

50.  Data provisioning can be both initial load and replication : True

51.  What is the default maximum number of rows in Data preview ?  5000

52.  Validation rules of Analytic View can be selected & de-selected from the ‘Manage Preferences’? True

53.  A Package within a package can be created? True

54.  SAP delivered content Information models can be activated from?  Mass Copy

55.  Auto-documentation generates technical design document in the _______format?  .pdf format

56.  What is full form of HANA?  SAP High Performance Analytical Appliance 1.0

57.  Which non-SAP system can SAP HANA connect to ?

·         Oracle Enterprise

·         IBM Informix

58.  SAP BO Dataservices can connect to any OLTP system including DBMS &RDBMS ? True

59.  Hierarchies with hierarchy levels are supported in Attribute view?  True

60.  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 :  True

61.  What are the business benefits of ODP for non SAP BW customers?

·         Get access to the Business Suite Extractors without having to go through SAP NetWeaver BW

·         There is no need for an ABAP Dataflow and therefore no ABAP Program is required for staging data

62.  Calculation engine performs the following:

·         Create Joins at run-time

·         Create Calculated Measures and Calculated Attributes

·         Compute and Execute Calculation Views

63.  For SAP BW to be powered by HANA, what are the primary steps required?

·         Upgrade to SAP NetWeaver BW 7.3

·         Migrate Database (RDBMS) to HANA DB

64.  The HANA optimized Infocubeshas the following features:

·         No Dimension Tables

·         No Secondary Fact-Table

·         They represent “Flat Structures”

65.  LT replication “Schema” can be configured to support extraction jobs as follows:

·         Real Time

·         Schedule by Interval

·         Schedule by Time

66.  For Time Attribute views, which calendar types can be created?

·         Gregorian Calendar

·         Fiscal Calendar

67.  Filter values can assigned at the ‘Data foundation’ in the Analytic view ? True

68.  Procedures can be created with Invoker’s rights only ? False

69.  SAP Solution Manager is used to provide remote access to HANA Studio? True

70.  Security & Authorization of SAP HANA is required to maintain the following?

·         Control Access to Objects/Views

·         Field-Level Security

·         Restrict users from viewing Information Models

71.  Pre-requisite to execute Crystal reports enterprise?

·         JDBC / ODBC Interfaces

·         Relational Universe

72.Which of the following cardinalities are supported in Attribute view:

·         1:N

·         N:1

·         1:1

73.  Is it possible to add tables later after the Analytic view is created ? True

74.  Packages can be exported without assigning Delivery units for Server type exports ? False

75.  ‘Migrate’ from Quick launch is used for which of the following: Multi Lingual Support

76.  Calculation views can also be used as business reporting view ? True

77.  Attribute view provides the master data information & can be used in any analytic view ? True

78.  SAP HANA supports ‘BIG’ data analytics ? True

79.  SAP HANA IMDB supports multiple hosts within the system landspace ? True

80.  Information Composer is a browser like application for End-users to create reports ? True

PAT MATAZ :

Questions are like these and these are the easier ones which I remember:

1.     Best practices when using sqlscript in HANA (HANA 1.0 sqlscript guide) , 2 Ans required from:

a) cursor, b) dynamic script   c) Using where clause for updates and deletes, d) use union all not union

2.     Which tool/ connectivity option do you use for hierarchy reporting

Ans: MDX, other options ODBC, JDBC. ODBO

3.     Another question will be similar to the above,

Ans: Excel

4.      Which transaction will be used to check the table relationship,

 Ans: SD11

5.     How many result tables are generated from one calculation view per session,

Ans: 1, other options 2,3,4

6.     In a calculation view which node is used

Ans: Projection, Union, there were other options

7.     Functions of the controller module in SLT

Ans: 2 answers were required including writing to HANA which I am not sure but thought it was not correct as the write module is there.

8.     Functions of DB trigger (not logging table).

 Ans: 2 answers were needed and I normally know the functions for both DB and logging tables so was tricky.

9.     You want to use a small look-up table in your model for data transformation

Ans: Columnar table, Transparent table, cluster table and row table. I wasn't sure of this one

10.  How can you evaluate the actual speed of a calculation within a DB,

 Ans: (3 answers needed) a) write and execute SQL statement, b) Use data preview, c) execute Webi, d) Execute information space view, e0 trace using python admin tool within TREX (don't ask me what I picked!)

11.  Developers should not have access to production data,

Ans: use client data only in production system, use simulated data in development system (these were the correct answers) but there were more

12.  There was question which needed ROOSOURCE as ans

13.  What tool to handle duplicate names of HANA?

14.  Which extractor T/A support through ODP API

Ans: ROOATTR

15.  Verify the quality of HANA.

 Ans: a) Use sql editors, b) compare data with HANA_STATISTICS, c) use data service quality process, d) use webi report, e)  use SLT

Additional Notes :

1.       No standard business content available in HANA

2.     To which components are Hierarchies available in SAP HANA ?

   Hierarchies only available Excel and ODBO.

3.     Can you import Roles and Security from ECC System to SAP HANA ?

We CANNOT import roles and security from ECC system to HANA

4.     What is SQL Script ?

SQL script is used for calculation view and is a proprietary language.

5.     TCode to find the Tables  in SAP HANA ?

T.Code: SD11

6.     Web intelligence is used for operational reporting.

7.     What is the BO Tool used for Dashboard Reports ?

XCelsius (For Interactive Dashboards)

8.     Why are Crystal Reports used ?

Crystal Report is for developing formatted reports like P & L, Balance sheet, etc.

9.     What is CO-PA Accelerator ?

COPA accelerator is for Profitability analysis .

10.  To which Table are the Release Extractor Names added ?

Release extractor names are added to the ROOSATTR Table. 

11.  Column views(Attribute Views) are located in Schema_SYS_BIC,

Metadata is located in Schema_SYS_BI .

12.  What is Metadata Manager? Located in Schema _SYS_BI

13.  What is Replication Agent ?  SLT

14.  What is SQL parser ?

For Syntax check

15.  Why universes are used : additional security or filed names uniform ..etc 

16.  What ETL Server is used  for  ECC system ?

Use SAP SLT server.

17.  What is SAVE POINT ?

Save points are self-contained consistent states of the database that may be loaded without reading the log volumes.

18.  For complex logic and large volumes of data use ABAP code.

19.  For less volume use RFC or BAPI or RFC_READ_TABLE used.

20.  What is Data Foundation and  Logical View ?

21.  What is a Text join ? Ans. 1:1 cardinality

22.  To get the Description eg., SPRAS

23.  What is the purpose of Hierarchy Active = False and Hierarchy Active = True ?

24.  What is SAVE the view and Activate the View ?

25.  What is Restricted Measure ? example.

Restricted measures are used to filter the value based on the user-defined rules for the attribute values.

26.  What is Calculated Measure ? example

Calculated measures are defined based on a combination of data from OLAP cubes, arithmetic operators, constants, and functions. Ex the total sales of a product

Data Types (decimals, numbers etc), Field Length, Scale, Aggregation defined in properties (sum, min, max and count)

27.  What is Private Attribute ?

Private Attributes : Private attributes are used to model analytic views and cannot be used outside the

view. Private attributes are required to link to the subject area or attribute views. Private attributes add  

              more information to the model. Private Attribute selected from a Database table

28.  What Is new in SAP HANA SPS3? – Overview ISAP HANA Database for SAP Business Warehouse

·         SAP HANA as database for SAP BW 7.30

·         Single In Memory Persistence and Storage - All BW tables are In-Memory objects

·         New In-memory optimized Data Store Objects (with SAP BW 7.3 SP5)

·         New In-Memory DSO activation process

·         New - Number Range handling

·         New In-memory optimized InfoCubes(with SAP BW 7.3 SP5)

·         Simplified design and indexing

·         Faster data loads and simplified modeling

·         In-Memory Planning engine

·         Based on existing Integrated Planning (BW-IP)

·         Push down of OLAP engine into SAP HANA from SAP BW‘s ABAP layer

·         Tools to seamlessly migrate BW underlying database to SAP HANA Planning Engine

·         In Memory operations like Disaggregation, copy, write-back

·         Supporting BW – IP and Business ByDesignapplication use cases

29.  Benefits : Fast data loads (no DIMIDs)

·         Upto 80% time reduction.

·         Dimensions not physically present

·         Simpler  modeling and faster structural changes.

·         All processes, all Queries and Multi Providers can remain unchanged

//***********************************************

From Raana's HANA exam:

-------------------

use of the universe, where do you use it?

requirement for the analytic view: table, attribute view

sys_repo ->

tzhana => security, authentication, authorization

back up and recovery => Param's Arani consulting document

non-sap erp data extration to HANA is done by BODS.

extraction of data from

BICS = Business Intelligence Consumer Servies

To create analytic view, what is the minimum requirement for the attributes?

//**************************************************************

Questions by Uma:

1. SAP BW implemented on HANA SP1.3, what are the stes need to be done?

a.     Migrate the BW data into HANA

b.    Create In-memory Indexes

c.     Convert Info cubes into HANA object types.

d.    ???

2. Backup and recovery by SAP standard?

  a. point-in-time recovery

  b. backing up of archived log files

  c. information model recovery

  d.

3.History => keeps track of object changes using the versions.???

4. hich user hasor the analytic view: table, attribute view

sys_repo ->

tzhana => security, authentication, authorization

back up and recovery => Param's Arani consulting document

non-sap erp data extration to HANA is done by BODS.

extraction of data from

BICS = Business Intelligence Consumer Servies

To create analytic view, what is the minimum requirement for the attributes?