1) Que: Best practices when using sqlscript in HANA (HANA 1.0 sqlscript guide), 2 ans required from:
- cursor
- dynamic script
- using where clause from updates and deletes
- 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:
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
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:
- 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.
- 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)
- 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
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