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