Shared Flashcard Set

Details

HANA
HANA Flahscards
147
Computer Science
Professional
11/01/2013

Additional Computer Science Flashcards

 


 

Cards

Term
1. How do you add a host?
Definition
HDB addhost
Term
2. What tool is used for real time data provisioning in HANA projects?
Definition
SLT
Term
3. Which tool is used for complex and realtime data transformation?
Definition
Wrong Question. Realtime is SLT, Complex is DS.
Term
4. Starting and Stopping
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
5. What is RTDP?
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
Unified Installer
Term
9. Do we still need ABAP Stack for SAP BW on HANA?
Definition
Yes
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
Heterogenous System Copy
Term
12. Can we install SAP Java stack on HANA?
Definition
No
Term
13. Tool used for complex data transformation?
Definition
DS
Term
14. SLT Install
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
Anyone.
Term
17. What is important in SAP HANA License?
Definition
Memory purchased.
Term
18. Do we still need storage persistence in IMDB?
Definition
Yes
Term
19. When we have 3 nodes in HANA Cluster for BW, how many DB’s are running on these nodes?
Definition
1
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
NZDT and TDMS
Term
22. Can HANA support both OLAP and OLTP?
Definition
Term
23. Who can install SLT?
Definition
Any qualified Basis Consultant.
Term
24. What is SLT?
Definition
NW 7.02 or NW 7.30
Term
25. DMIS goes on SLT and Source system.
Definition
Term
26. JRE 1.6 is needed for HANA Studio
Definition
Term
27. HANA Port
Definition
3xx15
Term
28. CAN SLT extract data from non-SAP sources?
Definition
YES
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
45. /hana/data/SID1
Definition
Term
46. /hana/data/SID2
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
Service.sap.com
Term
49. Default port for HTTPS?
Definition
8443
Term
50. Default port for HTTP?
Definition
8080
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
Administer HANA DB.
Term
55. What transaction do you use to start DBA Cockpit?
Definition
dbacockpit
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
8) one bw question
Definition
answer is hetrogenious database migration to hana
Term
9) connectivity form bi explorer to hana.
Definition
answer: jdbc
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
13) a gui installation
Definition
Answer: hdbsetup
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
SQL server express
Term
7. How much memory for dynamic objects
RAM dynamic = RAM static
Definition
Term
8. Which system is the logging tables for SLT
Definition
Source system
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
HDB stop
HDB start
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
uninstall - hdbuninst
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
hanarename
Definition
Triggers HANA rename
Term
smdsetup
Definition
needed in order to talk with Solution Manager
Term
smduninstall
Definition
- uninstall SMD agent
Term
sldconfig
Definition
Configure SLD Connection to specific HANA System
Term
addhanasystem
Definition
Adding another HANA system (adding 2nd or 3rd SID)
Term
removehanasystem
Definition
Removes additionally installed HANA System
Term
aflinstall
Definition
Application Function Library
Term
lcainstall
Definition
Triggers LiveCache Applications installation
Term
changehanaedition
Definition
Change from Platform license to Enterprise edition
Term
addhost
Definition
Triggers adding of additional host, scaling out.
Term
removehost
Definition
Triggers removing of additional host
Term
Adding a system
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
Name Server Process
Term
Minimum number of servers required in Hana HA?
Definition
2
Term
Distribution:
Definition
Scales systems beyond one server and can remove the single point of failure
Term
When you scale out what is added?
Definition
Server
Term
Who can install second DB on PRD?
Definition
wrong question/trick
Term
What is minimum requirement for HANA HA
Definition
Standby node
Term
Can SLT be installed on 4.6C SAP system?
Definition
NO
Term
How do you measure HANA query performance?
Definition
SQL trace
Term

What is maximun memory allowed per node

 for BW/ HANA

Definition
1TB
Term
How SLT connects to non-SAP source systems?
Definition
Via DB connection
Term
How HANA Studio connects to HANA DB
Definition
Via JBDC driver
Term
What is important in SAP HANA license?
Definition
memory
Term
What tool is used for real time data provisioning in HANA projects?
Definition
SLT
Term
Remember this: Real Time- SLT
Definition
Term
Complex- Data Services
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
Supporting users have an ad free experience!