Inhaltsverzeichnis

Alle Kapitel aufklappen
Alle Kapitel zuklappen
Preface
17
Who This Book Is For
17
How This Book Is Organized
17
Acknowledgments
21
1 SAP Certification for SAP HANA
23
Target Audience
24
Why Should You Get Certified?
24
Digital Badges
26
How to Prepare
27
Learning Journeys
27
SAP Learning Hub
28
SAP Training and SAP PRESS Certification Guides
29
Additional Resources
30
SAP Help Portal
30
openSAP Courses
31
SAP Developer Center
32
SAP Community
33
SAP HANA Academy on YouTube
34
SAP Product Support
35
Exam Levels and Editions
36
Associates, Professionals, and Experts
36
Certified Installations with Tailored Data Center Integration
38
Exam Editions
38
How to Book the Exam
39
Exam Product
39
SAP Certification Hub
40
Certification Test Security Guidelines
40
Topic Areas
41
Topic Areas
41
SAP Training Courses
43
Sample Questions
44
Summary
46
2 System Architecture
47
Topic and Objectives
48
Key Concepts Refresher
49
In-Memory Computing
49
Use Cases
55
System Types
58
Deployment Types
59
Editions and Options
62
Software Components
63
Add-On Products
65
System Architecture Overview
65
Important Terminology
74
Practice Questions
77
Practice Question Answers and Explanations
80
Takeaway
82
Summary
83
3 Installation Preparation
85
Topic and Objectives
86
Key Concepts Refresher
87
Delivery Models
88
Sizing
88
Product Availability Matrix
93
SAP HANA Hardware Directory
94
Linux
95
IBM Power Systems
96
Network
97
Persistence
98
Persistent Memory
100
File System Recommendations
102
Hardware Configuration Check
103
Important Terminology
105
Practice Questions
107
Practice Question Answers and Explanations
109
Takeaway
113
Summary
113
4 Installations and Updates
115
Topic and Objectives
116
Key Concepts Refresher
117
Application Lifecycle Management
117
Platform Lifecycle Management
119
Software Downloads
124
Installation
127
Local Secure Store
130
Multiple-Host Installation
130
Installation Automation
132
Resident HDBLCM
134
Updates
136
HDB Tools
139
Troubleshooting
140
Users Created during Installation
141
Post-Installation Activities
141
License
142
Release and Maintenance Strategy
143
SAP HANA Interactive Education
145
Important Terminology
146
Practice Questions
147
Practice Question Answers and Explanations
152
Takeaway
155
Summary
156
5 Database Administration Tools
157
Topic and Objectives
158
Key Concepts Refresher
159
SAP HANA 1.0 Database Tools
159
SAP HANA Cockpit 2.0
167
SAP HANA Database Explorer
167
SQL Analyzer
169
SAP HANA Database Interactive Terminal
169
SAP HANA XS Runtime Administration
172
SAP Tools for SAP HANA Administration
174
Important Terminology
175
Practice Questions
177
Practice Question Answers and Explanations
179
Takeaway
182
Summary
182
6 SAP HANA Cockpit
183
Topic and Objectives
184
Key Concepts Refresher
185
Deployment Options
185
System Architecture
187
Release and Maintenance Strategy
193
Installation
193
Update
199
Uninstall
200
Provisioning and Configuration
201
Database Directory
213
Important Terminology
215
Practice Questions
217
Practice Question Answers and Explanations
220
Takeaway
223
Summary
223
7 Database Administration Tasks
225
Topic and Objectives
226
Key Concepts Refresher
227
Starting and Stopping SAP HANA
227
Alerts
233
Daily Database Administration Tasks
233
Configuring System Parameters
242
Table Management
246
Important Terminology
253
Practice Questions
254
Practice Question Answers and Explanations
258
Takeaway
261
Summary
261
8 Working with Tenant Databases
263
Topic and Objectives
264
Key Concepts Refresher
265
System Architecture
265
Updating Single Container Database System
269
Managing Tenants from the System Database
270
Creating Tenant Databases
274
Database Isolation
275
Cross-Tenant Database Access
277
Tenant Database Management
278
Fallback Snapshot
281
Monitoring and Managing Tenant Databases
281
Copying and Moving Tenant Databases
283
Important Terminology
286
Practice Questions
287
Practice Question Answers and Explanations
289
Takeaway
292
Summary
292
9 Scale-Out Systems
293
Topics and Objectives
296
Key Concepts Refresher
296
Scale-Out, Multiple-Host, Distributed Systems
297
Host Auto-Failover
300
Multiple-Host System Architecture
304
Multiple-Host Installation
313
Configure Host Failover in SAP HANA Cockpit
317
Manage Services in SAP HANA Cockpit
318
Data Distribution
319
Important Terminology
335
Practice Questions
337
Practice Question Answers and Explanations
342
Takeaway
347
Summary
347
10 Security
349
Topic and Objectives
350
Key Concepts Refresher
351
Security and User Management in SAP HANA Cockpit
352
Security Functions
353
Implementation Scenarios
353
User Management
355
User and Role Management in SAP HANA Cockpit
358
Encryption
373
Auditing
385
System Views
392
Security Checklist
393
Important Terminology
394
Practice Questions
396
Practice Question Answers and Explanations
399
Takeaway
402
Summary
403
11 Backup and Recovery
405
Topic and Objectives
406
Key Concepts Refresher
407
Features and Strategy
407
Architecture
408
Authorizations
412
Backup Types
412
Backup Destinations
414
Backup Encryption
416
Backup Catalog
416
Creating Backups
417
Configuration
418
Data Snapshot
421
Fallback Snapshots
422
Backup Scheduling
423
Recovery
424
Database Copy
427
Diagnosis Files for Backup and Recovery
430
Important Terminology
431
Practice Questions
432
Practice Question Answers and Explanations
436
Takeaway
441
Summary
442
12 System Replication
443
Topic and Objectives
445
Key Concepts Refresher
446
High Availability
446
Storage Replication
449
Tools and Prerequisites
450
Considerations
451
Log Replication Modes
452
Operation Modes
454
Enable System Replication
457
Disable System Replication
460
Monitoring
461
Configuration
464
Takeover
464
HA/DR Providers
467
Invisible Takeover
468
Secondary Time Travel
469
Multitier and Multitarget System Replication
469
Active/Active Read-Enabled
470
Additional Systems on the Secondary System
472
Near-Zero Downtime Upgrades
472
Copying and Moving Tenant Databases
473
Important Terminology
475
Practice Questions
478
Practice Question Answers and Explanations
481
Takeaway
484
Summary
485
13 Troubleshooting and Performance Analysis
487
Topic and Objectives
489
Key Concepts Refresher
490
Monitoring
490
Alerts
493
System Monitoring Views
498
Mini Checks
499
System Parameters
500
Troubleshooting
501
Memory
510
CPU Usage
515
Disk and Input/Output
520
Workload Management
524
Admission Control
527
Capture and Replay
529
Important Terminology
536
Practice Questions
537
Practice Question Answers and Explanations
542
Takeaway
546
Summary
546
14 Database Migration
547
Topic and Objectives
549
Key Concepts Refresher
550
Software Logistics Toolset
550
Getting Started with Database Migration Option
551
Preparation
557
Installation
560
Running Software Update Manager with Database Migration Option
562
Benchmarking
579
Important Terminology
582
Practice Questions
585
Practice Question Answers and Explanations
589
Takeaway
594
Summary
594
The Author
595
Index
597