0
More
Next Blog»
Wednesday, 19 Decem Decem ber 201 2012 2
sap sa p hana certification hana certification questions and answers
Overview and Architecture of HANA What is HANA ? –High ? –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, 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 tools can directly report on HANA Data from HANA can also be used be used in MS MS Excel - MDX Row Store – 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 – Store – The data is stored in columns like in SAP BWA : In memory is great but it is volatile and data can be lost with Persistence La yer : Persistence power outage or hardware failures. To avoid this HANA has a Persistence Layer
Creat e Blog
Sign In
which is not volatile. Session Management : This component takes care of logon services. Two processing processing e ngines ngines – – 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 . MDX . HANA Supports Sybase Replication Server – Sybase Replication Server can be used for real time synchronization of data between ERP and HANA
About Me
Copy Protected by Shakil Wahid.Protect
srinivas r
Modeling Studio Using Modeling Studio you can, Specify which tables a re stored in HA HANA NA,, first part is to get the meta data and then schedule data replication jobs replication jobs Manage Data Services to load the data from SAP BW and other 3rd party systems. Manage connections to ERP ins tances, current release release does not support connecting to several ERP instances
Follow
Yours !
1
View my complete profile
Blog Archive
▼ 2012 (12) ▼ December (12) sap hana certification questions and answers
Use Data s erv ervices ices to for the modeling Do modeli ng in HANA itself (This is independent of Data services). You can also do model ing can also be done in Business Objects Business Objects Universes Universes whi ch is nothing but joining fact and dimens ional tables.
SAP BPC WITH HANA SAP HANA-INMEMORY DATABASE ADMIN ADM IN SAP HANA ADMINISTR ADM INISTR ATION AT ION
Reporting Clien t tools can acces s HANA directly, directly, Like MS EXCEL, EXCEL, SAP BI 4.0 Reporting tools, tools, Dashboard Desi gn Tool (Xcelsius) (Xcelsius) can also access HANA directly directly.. Third party reporting tools can leverage ODBC, JDBC and ODBO (for MDX requests) drivers in HANA for for repo rting. HANA supports BICS interface
SAP BPC CONSOLID ATION AT ION SAP BPC 10.0 TERMINOL OGY SAP BPC VERSIONS SAP BPC 10.0
which is not volatile. Session Management : This component takes care of logon services. Two processing processing e ngines ngines – – 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 . MDX . HANA Supports Sybase Replication Server – Sybase Replication Server can be used for real time synchronization of data between ERP and HANA
About Me
Copy Protected by Shakil Wahid.Protect
srinivas r
Modeling Studio Using Modeling Studio you can, Specify which tables a re stored in HA HANA NA,, first part is to get the meta data and then schedule data replication jobs replication jobs Manage Data Services to load the data from SAP BW and other 3rd party systems. Manage connections to ERP ins tances, current release release does not support connecting to several ERP instances
Follow
Yours !
1
View my complete profile
Blog Archive
▼ 2012 (12) ▼ December (12) sap hana certification questions and answers
Use Data s erv ervices ices to for the modeling Do modeli ng in HANA itself (This is independent of Data services). You can also do model ing can also be done in Business Objects Business Objects Universes Universes whi ch is nothing but joining fact and dimens ional tables.
SAP BPC WITH HANA SAP HANA-INMEMORY DATABASE ADMIN ADM IN SAP HANA ADMINISTR ADM INISTR ATION AT ION
Reporting Clien t tools can acces s HANA directly, directly, Like MS EXCEL, EXCEL, SAP BI 4.0 Reporting tools, tools, Dashboard Desi gn Tool (Xcelsius) (Xcelsius) can also access HANA directly directly.. Third party reporting tools can leverage ODBC, JDBC and ODBO (for MDX requests) drivers in HANA for for repo rting. HANA supports BICS interface
SAP BPC CONSOLID ATION AT ION SAP BPC 10.0 TERMINOL OGY SAP BPC VERSIONS SAP BPC 10.0
Request Processing and Execution Control SQL Script, Script, MDX MDX statements statements are pa ssed to calculation models. Optimizer Opt imizer which is included in calculation engine optimi zes for better performance. Calculation Engine : Modeler can define data sources as inputs and different operations join, join ( , aggregation, projection) on top of them for data manipulation The calculation engine will break up a model into sub processe s for optimized performance on cost based. System Sy stem will use m aximum resources to achieve max through through put Planning Engine : Will : Will be included in next release. Will include planning functions like distribute and copy functions.
ROW Store One of the relational engines to s tore data in row format. Pure in-memory store (Future (Future versions versions will als o have an option of disk bas ed 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 INSE RT also writes to persisted s egment Mov oves es visible version from memory to persisted segment Clears outdated record versions versions from Transactional Version Version m emory Row Store tables have a primar y index index
SAP BW REALTIME INTERVIEW QST&ANS WEAR SAP BW INTERVIEW QST SAP BW INTERVIEW QST
Secondary indexes can be created Row ID contains the segm ent and the page for the record Indexes in row store only exist in mem ory Index definition stored with table meta
Column Store Improves read functionality significantly, als o improves write functionality Highly compress ed data No real files , virtual files Optimizer and Executer – Handles queries and execution plan Delta data for fast write Asynchrono us de lta merge Consistent view Manager Main store compress ed and read optimized – Data is read from Main Store Delta Store – Write optimized – for write operations. Asynchronous mer ge move the data from delta store to ma in store Compress ion by create dictionary and applying further compression methods Even during the m erge operation, the columnar table will s till be available for read and write operations. To fulfill this, a second del ta and main s torage are used internally Merge operation can also be triggered manually with an SQL command
Persistence Layer
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 d uring s ystem restart Last save point must be restored plus undo logs mus t be read and uncommitted transactions saved with last save point and apply redo logs Complete content of row store is loade d into mem ory during start process Flags can be s et for column store to specify which tables are loaded during system restart
Modeling Modeling only possible for Column tables Information Modeler only works for colum n tables Replication servers create tables in column store per default Data Services creates tables i n column s tore per default SQL to create column table: Create COLUMN TABLE Store can chan ged wi th ALTER TABLE System tables are create where they fit best Schema SYS -> adminis trative table of engine Tables from s tatistics server
In-Memory Computing Studio Build with java based e clipse 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 s ource schemas , mass and sel ective load Landscapes The models are just virtual definitions they don't store actual data Analytic Views are like cube m odel wh ere Transa ction Data is con nected 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 – Ch aracteris tics Measure – Key Figures Attribute Views – Dim ens ions Analytic Views – Cubes
Hierarchies Leveled – based on multiple attributes Parent-child hierarchy Analytic Privilege – Security Object
Navigation View HANA instance -> Hana server name a nd instance num ber -> user database schema -> views functions and tables Information Models – Attribute, Analytic, Calculation Views and Analytic Privilege
Attribute View : Attributes a dd context to data Attributes a re mode led us ing attributes views Can be regarded as Master Data Tables Can be linked to fact tables in Analytical Views A mea sure e.g. wei ght can be define d as an a ttributes 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 s tored in colum n store tabl e or view based on Analytical View structure
Attributes a nd Measures – Like key figures Data Preview – Similar to lis t cube functionality
Calculation View : Define table output Structure Write SQL statement Ensure the sele cted 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 s pace concept in HANA at this m oment, so two ERP instances can't be connected to HANA. However this i ssue can be avoided us ing data s ources CRM also can use HANA Data from BW into HANA can be load ed into us ing Data Services a nd 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 :
ii) e.
Monitoring and Administration (Integration to Solution Manager)
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 : à SAP HANA 1.0 a. In-Memory in Parallel (Now) b. Primary Data Store for BW (short t erm) à SAP HANA 1.5 à SAP HANA 1.5 c. New Applications (short term) 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
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 webbased 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 Replicati on 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 Replicati on Server = SAP Host Agent c) SAP HANA Database Clients = LM Structure Files d) SAP HANA Database = SAPCAR
3) SAP HANA Enterprise ex tended edition : (For Log based repli cation) i) Sybase Replicat ion Agent ii) Sybase Replicati on Server iii) SAP HANA Load Controller (R/3 Load in Source + R/3 Load in SAP HANA) 4) Replication Methods Overview : a) Trigger-Based Replicati on
c) Log-Based Replicati on (Database à Log File) 5) Replication Methods Overview : a) Source System-SAP ERP (Application Layer) à Trigger Based Replication à SAP InMemory Database b) Source System-SAP ERP (Application Layer) à ETL Based Replicati on à SAP InMemory Database à Log Based Replicati on à SAP Inc) Source System-Database (Log File) 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. Whic h 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 ADM -- Database leve l administration SYSTEM -- Modele r admini stration 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 ti me 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 intensi ve data logic to client tools Ans Set of sql comma nds pushed intensive data l ogic to HANA DB 5. On calculation view 3 questions for example: In what situation the calculation view is required? Ans When we re quire complex logi c 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 Ans a. a. b. c.
privileges - ????? All of the ABOVE??? SYSTEM Privilege s, b) SQL Privile ges & c) Analytic Privile ges System, SQL Privile ges (Schema Privilege s + Data Objects Privilege s) ANALYTIC Privilege s PACKAGE Privilege s
12. Type of privilege for Dropping Table Ans SQL Privile ges (Schema Privilege s + Data Object Privile ges ) 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 analyt ic 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
a Cascade function 2. Where used 3. Hierarchy function 4. History function Ans Cascade Function , Where Used, Hiera rchy 19. Benefits of using different accelerators on HANA? Ans Real time da ta and faster data access 20. Type of cardinality between attribute view and text tables? Ans 1:1 for tex t 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 SA P Metadata into BODS c. Import SAP Metadata from BODS into SAP HANA d. Import SAP Metadata – Target struc ture 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 releva nt 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 ma pping be twe en 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 st eps: 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
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, pe rsistent 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 approve d by SAP, so only Rele ased 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 wi thin 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 WEB I 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
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 t echnology 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
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 & W EBI 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? Adminis trator Console 13. How many types of Exports/Imports c an 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? 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 Replicati on services?
LT Replicati on
20. Analytic privilege can be assigned to Att ribute View? True
Relational Universe (BO)
21. What is the Operating Sys tem 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 Replicati on
25. During power outage HANA DB performs the following : Recovering log between last data savepoint and time of failure
26. Select t he correct Authorizat ion privileges for controll ing activation of views ? Package Privilege
27. Network authenticati on 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 Vi ews 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. Persis tence layer in the HANA DB has the following components : Logger
Page Management &
37. Which section controls the data processi ng in the HANA DB ? Transact ion Manager 38. Which tool is used to create Universe for reporting in dashboard ? (IDT) 39. OPD for data replicati on API is used in which repli cation ?
Information Design Tool
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 Administ rator 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 Object s tool is used for replicat ing 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 acti vated from? Mass Copy 55. Auto-documentation generates technical design document in t he _______format? .pdf format 56. What is full form of HANA? SAP High Performance Analyt ical Applianc e 1.0
· ·
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 Attri bute 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 Ext ractors 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 optimize d 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
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 t o 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 view s 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 syst em 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 sc ript 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: Ex cel 4.
Which t ransaction will be used to check t he 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 t able, 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 cli ent data only in production system, use simulated data in development sys tem (these were the correct answers) but there were more
13. What tool to handle duplicate names of HANA?
14. Which extractor T/A s upport 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 Syst em to SA P 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 .
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
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 s ales 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 S AP 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.
//*********************************************** 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. backi ng up of archived log files c. information model recovery d. 3.History => keeps track of object changes usi ng the versions.??? 4. hich user hasor the analytic view: table, attribute view
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?
Posted by srinivas r at 07:27
6 comments:
Recommend this on Google
Home Subscribe to: Posts (Atom)
Older Posts