Preface

17

Structure of This Book

18

What’s New in the Third Edition

21

Practice Questions

22

Summary

23

1 SAP HANA Certification Track—Overview

25

Who This Book Is For

26

SAP HANA Certifications

27

Associate-Level Certification

28

Specialist-Level Certification

30

SAP HANA Application Associate Certification Exam

30

Exam Objective

32

Exam Structure

34

Exam Process

36

Summary

37

2 SAP HANA Training

39

SAP Education Training Courses

40

Training Courses for SAP HANA Certifications

41

Additional SAP HANA Training Courses

42

Other Sources of Information

43

SAP Help

43

SAP HANA Home Page and SAP Community

46

SAP HANA Academy

46

openSAP

48

Hands-On with SAP HANA

49

Where to Get an SAP HANA System

50

Project Examples

61

Where to Get Data

63

Exam Questions

64

Types of Questions

64

Elimination Technique

67

Bookmark Questions

67

General Examination Strategies

68

Summary

69

3 Technology, Architecture, and Deployment Scenarios

71

Objectives of This Portion of the Test

72

Key Concepts Refresher

73

In-Memory Technology

73

Architecture and Approach

79

Deployment Scenarios

93

SAP HANA in the Cloud

104

SAP Analytics Cloud and Business Intelligence

108

Important Terminology

114

Practice Questions

116

Practice Question Answers and Explanations

122

Takeaway

126

Summary

127

4 Modeling Tools, Management, and Administration

129

Objectives of This Portion of the Test

131

Key Concepts Refresher

132

New Modeling Process

132

New Architecture for Modeling and Development

138

Creating a Project

145

Creating SAP HANA Design-Time Objects

155

Building and Managing Information Models

162

Refactoring

170

Important Terminology

174

Practice Questions

175

Practice Question Answers and Explanations

178

Takeaway

180

Summary

180

5 Information Modeling Concepts

181

Objectives of This Portion of the Test

182

Key Concepts Refresher

183

Tables

183

Views

183

Cardinality

186

Joins

186

Core Data Services Views

197

Cube

200

Calculation Views

204

Other Modeling Artifacts

208

Semantics

213

Hierarchies

213

Important Terminology

216

Practice Questions

217

Practice Question Answers and Explanations

225

Takeaway

229

Summary

229

6 Calculation Views

231

Objectives of This Portion of the Test

232

Key Concepts Refresher

233

Data Sources for Calculation Views

234

Calculation Views: Dimension, Cube, and Cube with Star Join

235

Working with Nodes

248

Semantics Node

263

Important Terminology

269

Practice Questions

271

Practice Question Answers and Explanations

275

Takeaway

278

Summary

278

7 Modeling Functions

279

Objectives of This Portion of the Test

280

Key Concepts Refresher

281

Calculated Columns

281

Restricted Columns

286

Filters

291

Variables

293

Input Parameters

297

Session Variables

302

Currency

303

Hierarchies

308

Hierarchy Functions

316

Important Terminology

326

Practice Questions

328

Practice Question Answers and Explanations

333

Takeaway

336

Summary

336

8 SQL and SQLScript

337

Objectives of This Portion of the Test

339

Key Concepts Refresher

340

SQL

340

SQLScript

347

Views, Functions, and Procedures

362

Catching Up with SAP HANA 2.0

365

Important Terminology

365

Practice Questions

366

Practice Question Answers and Explanations

371

Takeaway

374

Summary

374

9 Data Provisioning

375

Objectives of This Portion of the Test

376

Key Concepts Refresher

377

Concepts

378

SAP Data Services

383

SAP Landscape Transformation Replication Server

385

SAP Replication Server

387

SAP HANA Smart Data Access

388

SAP HANA Smart Data Integration and SAP HANA Smart Data Quality

392

SAP HANA Streaming Analytics

395

SQL Anywhere and Remote Data Sync

397

Flat Files

399

Web Services (OData and REST)

400

SAP Vora

401

SAP HANA Data Management Suite

402

Important Terminology

403

Practice Questions

405

Practice Question Answers and Explanations

408

Takeaway

410

Summary

410

10 Text Processing and Predictive Modeling

411

Objectives of This Portion of the Test

413

Key Concepts Refresher

414

Text Processing

414

Predictive Modeling

432

Important Terminology

452

Practice Questions

453

Practice Question Answers and Explanations

456

Takeaway

457

Summary

458

11 Spatial, Graph, and Series Data Modeling

459

Objectives of This Portion of the Test

461

Key Concepts Refresher

461

Spatial Modeling

462

Graph Modeling

480

Series Data Modeling

498

Important Terminology

508

Practice Questions

509

Practice Question Answers and Explanations

513

Takeaway

517

Summary

517

12 Optimization of Information Models

519

Objectives of This Portion of the Test

520

Key Concepts Refresher

521

Architecture and Performance

521

Redesigned and Optimized Applications

522

Effects of Good Performance

523

Information Modeling Techniques

524

Optimization Tools

525

Best Practices for Optimization

536

Important Terminology

542

Practice Questions

543

Practice Question Answers and Explanations

546

Takeaway

548

Summary

548

13 Security

549

Objectives of This Portion of the Test

550

Key Concepts Refresher

551

Usage and Concepts

551

SAP HANA XSA and SAP HANA Deployment Infrastructure

554

Users

559

Roles

565

Privileges

569

Assigning Roles to Users

577

Data Security

578

Important Terminology

581

Practice Questions

582

Practice Question Answers and Explanations

585

Takeaway

587

Summary

587

14 Virtual Data Models

589

Objectives of This Portion of the Test

591

Key Concepts Refresher

591

Reporting in the Transactional Systems

592

SAP HANA Live

595

SAP S/4HANA Embedded Analytics

608

Important Terminology

612

Practice Questions

613

Practice Question Answers and Explanations

617

Takeaway

619

Summary

620