Thursday, December 1, 2016

Day 4 SAP HANA Certification

Questions ~ 30 -36

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


  1. cursor
  2. dynamic script
  3. using where clause from updates and deletes
  4. use union all not union

2)  Que: which tool/connectivity option do you use for hierarchy reporting Ans: MDX, other options ODBC, JDBC.  ODBO


MDX:
       A)  The language used by reporting tools to access data from multi dimensional objects in                        database environment.
       B)  In our case, only MS Office uses this language to access get the data from SAP HANA

ODBC:
      A)  It stands for Open DataBase Connectivity built for relation reporting and uses SQL language              to interact with database platform
      B)  It is widely adopted in the industry and we do have ODBC drivers for other platforms like                 LINUX and UNIX

JDBC:
      A) it stands for Java Database Connectivity built for relational reporting from Java community                 which uses SQL as interaction language to send queries to the database platform
      B)  It is widely used in UNIX platform

ODBO:
       A)  Microsoft driver for multi-dimensional reporting and request are sent using MDX language               to the database platform
       B)  In our case, MS Excel uses ODBO driver and MDX language to itneract with SAP HANA                  system

BICS:
      A)  It stands for BI Consumer Services which is SAP proprietary driver that offers advantages                 for OLAP access over MDX for multi-dimensional reporting.
      B)  This uses SQLDC as interaction language to send queries to the database platform.


3)  Que: another question will be similar to the above, Ans: Excel

     A)  has the powerful reporting inbuilt options available and one of them being quickly build           the reports using pivot tables and charts
     B)  We can use MS Excel to connect to HANA using ODBO driver and MDX interaction                  language.  MS Excel is the only reporting tool that can access hierarchies built in SAP                HANA as it uses MDX as interaction language.
     C)  The other things with MS Excel is we can only access the SAP HANA models that has                the property as 'Cube' in semantics ( like Analytic Views and Calculation Views),                        however we cannot access attribute views using MS excel
     D) 

4)  Que:  Which transaction will be used to check the table relationship, Ans: SD11

     SD11:
      


5)Que:  How many result tables are generated from one calculation view per session,


1, other options 2, 3, 4


6)  In a calculation view which node is used

          Ans: Projection, Union, there were other options
          -Projection:  It is used to select data without aggregation.  NO group by clause.  You will get entire dataset for selected columns.
          -Aggregation:  Group by clause, get less number of rows in output.

   
   
7)  Functions of the controller module in SLT Ans:

          Ans:  Controls portions of data transfer and transformation

           -Controls portions of data transfer and transformations.


8)  Functions of DB Trigger.
   
        2 answers were needed and I normally know the functions for both DB and logging tables.

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

A) Columnar table  B) Transparent table   C)  Cluster table  D) Row Table

Column Vs Row Data Storage

Column-storage:  It stores records in a sequence of columns i.e. the entries of a column is stored in contiguous(sharing a common border) memory locations

Row Storage: stores table records in a sequence of rows

Traditional database store data simply in rows.  The HANA in-memory database stores data in both rows and columns; which increases the speed, flexibility and performance of Hana db.

Column-based tables:  


  1.  Faster data Access:  Only affected columns have to be read during the selection process of a query.  Any of the columns can serve as an index.
  2. Better Compression:  Columnar data storage allows highly efficient compression because the majority of the columns contain only few distinct values (compared to number of rows)
  3. Better Parallel processing:  In a column store, data is already vertically partitioned.  This means that operations on different columns can easily be process in  parallel.  
Advantages and disadvantages of row-based tables:  

       Row based tables have advantages in the following circumstances:
               -The application needs to only process a single record at one time(many selects and/or                          updates of single records)
               -the application typically needs to access a complete record
               -Neither aggregations nor fast searching are required.
               -The table has a small number of rows(i.e. configuration tables, system tables)



       
10)  Which extractor T/A support through ODP API?

            ROOATTR

11)  Developers should not have access to production data?

Use client data only in production system, use simulated data in development system (these were the correct answers)

12)  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

A) WEBI, or Web Intelligence, is the SAP BusinessObjects tool most optimally suited for Ad-Hoc and Parameterized Reporting. It is a great reporting tool for Non-Technical users as it has a very intuitive and visual interface. If you can drag and drop objects, then you can build a WEBI report.
       
B) HANA Model

C)  Universe

D)CMC

13)  Which BO tool is good for visualization:

BO Explorer

14)  What is the standard user for HANA admin activities:

SYSTEM USER

15)  Which BO tool is good for formatted reports?

Crystal Reports

16)  What is the standard user for HANA admin activities:

SYSTEM User

17)  Which BO tool is good for Formatted reports?

CMC

18)  Set of commands pushed intensive data logic to HANA DB?

True

19)  Set of sql commands pushed intensive data logic to client tools:

False

20) In what situation the calculation view is required?

Unification of data models

21)  What replication method is good for complex transformation?

BODS

22)  Types of privileges?

Analytic, system, sql and package

23)  Type of privilege for dropping table

SQL PRIVILEGE

24)  Question on where used list?

To identify where the object has been used.

25)  When importing a model view to target system, how to activate the dependent objects?

By using mass activate option from quick launch

26)  Type of cardinal between attribute view and text tables?

Refer System









     

No comments:

Post a Comment