Term
| 1. How do you add a host? |
|
Definition
|
|
Term
| 2. What tool is used for real time data provisioning in HANA projects? |
|
Definition
|
|
Term
| 3. Which tool is used for complex and realtime data transformation? |
|
Definition
| Wrong Question. Realtime is SLT, Complex is DS. |
|
|
Term
|
Definition
HDB stop or HDB start or stop and start from Studio after right clicking on Instance. 3rd way you can use sapcontrol (part of saphostagent) command.
a. Sapcontrol –nr 00 –function Stop
b. Sapcontrol –nr 00 –function Start
c. Sapcontrol –nr 00 –function GetProcessList |
|
|
Term
|
Definition
| Real Time Data Provisioning with tools and solutions from HANA, Sybase and EIM. |
|
|
Term
| 6. What tools are used to update HANA DB |
|
Definition
| HANA Studio LCM Perspective, hdbupd |
|
|
Term
| 7. Can customers use SLT and DS both for data provisioning? |
|
Definition
| YES, if there is a valid requirement |
|
|
Term
| 8. What tools are used to install HANA DB? |
|
Definition
|
|
Term
| 9. Do we still need ABAP Stack for SAP BW on HANA? |
|
Definition
|
|
Term
| 10. What is SAP HANA Information Composer? |
|
Definition
|
|
Term
| 11. Customer wants to migrate entire BW/Oracle system to BW/HANA, what type of migration is this? |
|
Definition
|
|
Term
| 12. Can we install SAP Java stack on HANA? |
|
Definition
|
|
Term
| 13. Tool used for complex data transformation? |
|
Definition
|
|
Term
|
Definition
a. NW 7.02 or 7.30. Install DMIS on SLT and Source system
b. |
|
|
Term
| 15. How does HANA Studio connect to HANA DB? |
|
Definition
| JDBC Driver. Need the server and instance number and password for SYSTEM. Then, first adjustment you do in HANA Studio is set the default client. Windows Preferences Default Model Parameters set client |
|
|
Term
| 16. Who can install HANA Studio? |
|
Definition
|
|
Term
| 17. What is important in SAP HANA License? |
|
Definition
|
|
Term
| 18. Do we still need storage persistence in IMDB? |
|
Definition
|
|
Term
| 19. When we have 3 nodes in HANA Cluster for BW, how many DB’s are running on these nodes? |
|
Definition
|
|
Term
| 20. As a certified SAP HANA Platform consultant, can you re-install HANA DB… |
|
Definition
|
|
Term
| 21. What other tools use trigger based technology? |
|
Definition
|
|
Term
| 22. Can HANA support both OLAP and OLTP? |
|
Definition
|
|
Term
|
Definition
| Any qualified Basis Consultant. |
|
|
Term
|
Definition
|
|
Term
| 25. DMIS goes on SLT and Source system. |
|
Definition
|
|
Term
| 26. JRE 1.6 is needed for HANA Studio |
|
Definition
|
|
Term
|
Definition
|
|
Term
| 28. CAN SLT extract data from non-SAP sources? |
|
Definition
|
|
Term
| 29. What webdynpro is used to start LTR transaction? |
|
Definition
LTR
a. SLT connects to non-SAP via DB, to SAP via RFC, to HANA via DB Connection. |
|
|
Term
| 30. Who can install HANA DB? |
|
Definition
| Certified Hardware Partner |
|
|
Term
| 31. Test Question: Can we load cluster tables directly into HANA? |
|
Definition
|
|
Term
| 32. Can we load cluster tables directly into HANA? |
|
Definition
|
|
Term
| 33. Enterprise Edition adds Direct Extractor, DS, and SLT. |
|
Definition
|
|
Term
| 34. Host Agent responsible for monitoring. |
|
Definition
|
|
Term
| 35. Pushing down 90% of processing to the DB Layer. Abap 7.4 is expected to be 100% HANA Optimized. |
|
Definition
|
|
Term
| 36. More than one Hana system is called a Hana cluster (more than 1 Hana Instance). We support up to 16 Instances in 1 cluster. |
|
Definition
|
|
Term
| 37. Installed by Vendor: HANA DB, HAND Studio, SAP Host Agent 7.20, Solman Diag Agent 7.30, SUM and LM Structure. |
|
Definition
|
|
Term
| 38. As of Solman 7.1 SP04, HANA can be integrated into Solman. |
|
Definition
|
|
Term
| 39. Five processors are installed. Index Server, XS Engine, Preprocessor Server, Statistics Server, Name Server. Each server has a specific role (next page). Hana Studio is also installed but not part of the HANA DB Engine. Normally, we don’t recommend Studio to be installed on the Appliance. |
|
Definition
|
|
Term
| 40. Only Index Server and Preprocessor server will be running on additional nodes. Name server is like “message server”. It knows what is existing on other nodes. It maintains landscape info. |
|
Definition
|
|
Term
| 41. /usr/sap – not shared amongst all nodes. Local FS. |
|
Definition
|
|
Term
| /hana/shared (equal to sapmnt) - shared to all HANA nodes. |
|
Definition
|
|
Term
| 43. /hana/log - shared to all HANA nodes. Log is a flash disk. Much faster read/write/ PCI SSD disk. |
|
Definition
|
|
Term
| 44. /hana/data - shared to all HANA nodes. |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| 47. Unified Installer installs all the things on this slide in one shot. You could update each of these components individually, but it is not recommended. Best to use HANA Studio. Unified installer is part of the Installation Master. |
|
Definition
|
|
Term
| 48. What URL do you have to maintain to update HANA Studio? |
|
Definition
|
|
Term
| 49. Default port for HTTPS? |
|
Definition
|
|
Term
| 50. Default port for HTTP? |
|
Definition
|
|
Term
| 51. How many persectives in HANA Studio? |
|
Definition
| Administrative, HANA Development, LCM |
|
|
Term
| 52. HANA Configtool questions. |
|
Definition
| Onsite Configtool. Used to install 2nd HANA DB, rename hostnames, SID. |
|
|
Term
| 53. Installing Studio not recommended on Appliance. Install on PC, need local admin, domain admin. No path, it will take /tmp directory for log file. |
|
Definition
|
|
Term
| 54. What is purpose of DBA Cockpit? |
|
Definition
|
|
Term
| 55. What transaction do you use to start DBA Cockpit? |
|
Definition
|
|
Term
| 56. Solman SMD Agent Host Agent HANA |
|
Definition
|
|
Term
| 57. To change password of |
|
Definition
|
|
Term
| 58. HANA can be used with 4.6C onwards. |
|
Definition
|
|
Term
| 59. Unified Installer includes SMD Agent 7.30 and installs local copy of HANA Studio on Server for support purposes. Onsite Configtool, now allows to configure/connect SMD Agent to Solman. Onsite Configtool now allows to configure/connect SLD Datasupplier. |
|
Definition
|
|
Term
| 60. Linux SLES 11 SP1 needed. |
|
Definition
|
|
Term
| 61. File System
a. /sapmnt shared, global files and profiles 5gb
b. /usr/sap local SAP system instance directories 2gb
c. //data directory for data volumes. Must be created before Installer started. At least 800 mbs.
d. //log log volumes for HANA. Must be created before Installer started. At least 100,000 I/O ops.
e. Working dir temp dir for installer to work in. 200mb |
|
Definition
|
|
Term
| 62. Setuphana.slmodel.template is the installation file with sid, instancenr, sapmntPath, dataPath, logPath, hdbHost. |
|
Definition
|
|
Term
| 63. Unified Installer Onsite config tool SUM |
|
Definition
|
|
Term
| 64. Start Installer: ./setup.sh /tmp/hanainst /tmp/setuphana.slmodel |
|
Definition
|
|
Term
65. Client software needs to be installed on the server in order for other servers to communicate with HANA.
a. Linux
i. SQLDBC
ii. ODBC
iii. JDBC
b. MS Windows
i. SQLDBC
ii. ODBC
iii. ODBO
iv. JDBC |
|
Definition
|
|
Term
66. Hdbsetup (GUI installation) or hdbinst (command line installation)
a. GUI - ./hdbsetup –a client
b. CC - ./hdbinst –a client [option list]
i. Set LD_LIBRARY_PATH to the installation path
ii. Install logs found in /vat/tmp/hdb_client_ |
|
Definition
|
|
Term
| 67. MS-SQL Express, it requires CMS for DS info objects config. |
|
Definition
|
|
Term
Questions on the test
1) hana license....what's on the hana license
answer: memory size |
|
Definition
|
|
Term
2) hana sizing
answers are cpu size, memory size & disk size |
|
Definition
|
|
Term
3) some solman questions – sap support to connect to hana studio, solman monitoring for hana
study TZH200 |
|
Definition
|
|
Term
| 4) provisioning for data services- after you import meta data from source to hana, what is the next step? |
|
Definition
| answer: import metadata from hana to data server. |
|
|
Term
| 5) a strange question on co-pa accelerator network chart...ask you which network ecc is connected to? |
|
Definition
| Answer: Connected to the Data Network. It was a chart and the Data Network was purple |
|
|
Term
| 6) one slt question about db triggers |
|
Definition
| 2 answers. select relevant tables & relevant data |
|
|
Term
| 7) a question on hdb command |
|
Definition
|
|
Term
|
Definition
| answer is hetrogenious database migration to hana |
|
|
Term
| 9) connectivity form bi explorer to hana. |
|
Definition
|
|
Term
| 10) how to get to trace log on hana studio |
|
Definition
| answer admin diag files |
|
|
Term
| 11) how to get to user & role on hana studio |
|
Definition
| answer: from navigation view |
|
|
Term
| 12) hana instance number 51 which port to connect to |
|
Definition
| Answer: 315 which is 35115 |
|
|
Term
|
Definition
|
|
Term
1. What do you need for EWA on HANA server
host agent and script |
|
Definition
|
|
Term
2. Location of the data and log backup
global.ini configuration file |
|
Definition
|
|
Term
3. DROP is an example of what?
SQL Privileges |
|
Definition
|
|
Term
| 4. What privileges you need to have read-only access to the Administration Console |
|
Definition
System privilege CATALOG READ or DATA ADMIN
SQL privilege SELECT for SQL schema_SYS_STATISTICS |
|
|
Term
| 5. What Kerberos implementation is supported |
|
Definition
Windows Active Directory Domain Kerberos implementation
MIT Kerberos network authentication protocol |
|
|
Term
| 6. What version of DB is installed with BO Platform Services (BOE-light |
|
Definition
|
|
Term
7. How much memory for dynamic objects
RAM dynamic = RAM static |
|
Definition
|
|
Term
| 8. Which system is the logging tables for SLT |
|
Definition
|
|
Term
9. What is SLT controller responsible for
Structure mapping
Write to HANA |
|
Definition
|
|
Term
10. SAP connect via the OSS connection to
Index server |
|
Definition
|
|
Term
Know these:
hdbsetup – install in graphical mode (same name used for client install).
hdbinst – install in command mode (same name used for client install).
hdbupd – update the revision of the HANA DB.
hdbuninst – uninstall HANA |
|
Definition
|
|
Term
| Also, they ask what are the two ways to display Hana processes: HDB proc and HDB info. |
|
Definition
|
|
Term
| To install HANA Studio you must have a local admin or domain admin rights. This is a question. |
|
Definition
|
|
Term
| HDB proc – List the HANA processes that are running |
|
Definition
|
|
Term
| To stop/start the database you must be sidadm (hd7adm). They ask how to stop/start. |
|
Definition
|
|
Term
| Must know that the port is 3xx15. Xx is the Instance no. |
|
Definition
|
|
Term
| If 20 is the system number then the port is 32015. You may have to open this port because there could be a firewall between the client and the DB. |
|
Definition
|
|
Term
| Multiple Schemas in Hana. 7 default schemas. |
|
Definition
|
|
Term
| Content is used by Modelers and Developers. |
|
Definition
|
|
Term
Can also stop and start from Hana Studio and hostagent commands. Must know that there are 3 ways to stop and start Hana.
HDB stop / HDB start
Hana Studio
Sapcontrol command |
|
Definition
|
|
Term
You don’t see how may users on this screen. You see how much memory the Customer is licensed for. Once the license is applied, the memory will change. Should be much higher such as 512GB.
Question is what is important when you see the license? Memory. |
|
Definition
|
|
Term
Stopping the DB.
There is a question about stopping the system and you get an error and the answer is hostagent is not installed. |
|
Definition
|
|
Term
|
Definition
|
|
Term
| When appliance is installed, SAPHOSTAGENT should be installed. You can update it, but don’t change any structures without approval from HW Partner. |
|
Definition
|
|
Term
HANA Configuration Tool - Change hostname, SID, install another DB, etc. Onsite Configtool is part of the Installation Master.
hanaconfig.sh |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| needed in order to talk with Solution Manager |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Configure SLD Connection to specific HANA System |
|
|
Term
|
Definition
| Adding another HANA system (adding 2nd or 3rd SID) |
|
|
Term
|
Definition
| Removes additionally installed HANA System |
|
|
Term
|
Definition
| Application Function Library |
|
|
Term
|
Definition
| Triggers LiveCache Applications installation |
|
|
Term
|
Definition
| Change from Platform license to Enterprise edition |
|
|
Term
|
Definition
| Triggers adding of additional host, scaling out. |
|
|
Term
|
Definition
| Triggers removing of additional host |
|
|
Term
|
Definition
| ./hanaconfig.sh –interactive addhahasystem |
|
|
Term
| 10-12 questions on Design and 10-12 questions on Implementation |
|
Definition
|
|
Term
| Know these use cases. 1 question on Agile Data Marts and 1 question on Operational |
|
Definition
|
|
Term
| HANA Use Cases – Two types of Data Marts |
|
Definition
|
|
Term
Like COPA – There is a question on COPA and RDS.
We have a COPA RDS and it can be implemented in 3-4 weeks. |
|
Definition
|
|
Term
| HANA is more than just a DB. It has an App Layer. |
|
Definition
|
|
Term
| This is a question. Sizing involves CPU, DISK and MEMORY |
|
Definition
|
|
Term
| What is single point of failures in Hana DB? |
|
Definition
|
|
Term
| Minimum number of servers required in Hana HA? |
|
Definition
|
|
Term
|
Definition
| Scales systems beyond one server and can remove the single point of failure |
|
|
Term
| When you scale out what is added? |
|
Definition
|
|
Term
| Who can install second DB on PRD? |
|
Definition
|
|
Term
| What is minimum requirement for HANA HA |
|
Definition
|
|
Term
| Can SLT be installed on 4.6C SAP system? |
|
Definition
|
|
Term
| How do you measure HANA query performance? |
|
Definition
|
|
Term
What is maximun memory allowed per node
for BW/ HANA |
|
Definition
|
|
Term
| How SLT connects to non-SAP source systems? |
|
Definition
|
|
Term
| How HANA Studio connects to HANA DB |
|
Definition
|
|
Term
| What is important in SAP HANA license? |
|
Definition
|
|
Term
| What tool is used for real time data provisioning in HANA projects? |
|
Definition
|
|
Term
| Remember this: Real Time- SLT |
|
Definition
|
|
Term
|
Definition
|
|
Term
| What service constitutes HA? |
|
Definition
|
|
Term
. I already mentioned Sizing and what does scale out mean (add server). Scale out is not adding memory, cpu and storage. The answer is SERVERS. |
|
Definition
|
|
Term
Sizing for mem, CPU and disk
memory for dynamic obj is same as static objects.
CPU sizing...actively running users
Uncompressed sources size must be ref for HANA sizing.
HANA Cluster(single and multi nodes-Master and Slaves) N/W Configuration |
|
Definition
|
|
Term
Distributed Environment
We add servers which in turn add memory,cpu and storage |
|
Definition
|
|
Term
Summary for Architecture Implementation
Back up types
Save Points
Performance of Query
File Paths for Trace and Log Files
Export and Import Options |
|
Definition
|
|
Term
Questions on DBA Cockpit
Adding Nodes |
|
Definition
|
|
