Preface

17

Structure of This Book

18

What’s New in the Second 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

31

Exam Objective

32

Exam Structure

34

Exam Process

35

Summary

36

2 SAP HANA Training

37

SAP Education Training Courses

38

Training Courses for SAP HANA Certifications

39

Additional SAP HANA Training Courses

40

Other Sources of Information

41

SAP Help

41

SAP HANA Home Page and SAP Community

44

SAP HANA Academy

44

openSAP

46

Hands-On with SAP HANA

47

Where to Get an SAP HANA System

47

Project Examples

59

Where to Get Data

61

Exam Questions

62

Types of Questions

62

Elimination Technique

65

Bookmark Questions

65

General Examination Strategies

66

Summary

66

3 Architecture, Deployment Scenarios, and Use Cases

69

Objectives of This Portion of the Test

70

Key Concepts Refresher

71

In-Memory Technology

71

Architecture and Approach

77

Deployment Scenarios

89

SAP HANA in the Cloud

99

Important Terminology

103

Practice Questions

105

Practice Question Answers and Explanations

111

Takeaway

115

Summary

115

4 Modeling Tools, Management, and Administration

117

Objectives of This Portion of the Test

119

Key Concepts Refresher

120

New Modeling Process

120

New Architecture for Modeling and Development

126

Creating a Project

132

Creating SAP HANA Design-Time Objects

142

Building and Managing Information Models

148

Refactoring

155

Important Terminology

160

Practice Questions

161

Practice Question Answers and Explanations

163

Takeaway

165

Summary

165

5 Information Modeling Concepts

167

Objectives of This Portion of the Test

168

Key Concepts Refresher

169

Tables

169

Views

169

Cardinality

172

Joins

172

Core Data Services Views

183

Cube

184

Calculation Views

188

Using Calculation Views

190

Other Modeling Artifacts

193

Semantics

197

Hierarchies

198

Important Terminology

200

Practice Questions

201

Practice Question Answers and Explanations

209

Takeaway

212

Summary

213

6 Calculation Views

215

Objectives of This Portion of the Test

216

Key Concepts Refresher

217

Data Sources for Information Views

218

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

218

Working with Nodes

230

Semantics Node

239

Important Terminology

244

Practice Questions

245

Practice Question Answers and Explanations

250

Takeaway

252

Summary

253

7 Modeling Functions

255

Objectives of This Portion of the Test

256

Key Concepts Refresher

257

Calculated Columns

257

Restricted Columns

262

Filters

267

Variables

269

Input Parameters

273

Currency

277

Hierarchies

282

Important Terminology

289

Practice Questions

291

Practice Question Answers and Explanations

296

Takeaway

298

Summary

299

8 SQL and SQLScript

301

Objectives of This Portion of the Test

303

Key Concepts Refresher

304

SQL

304

SQLScript

310

Views, Functions, and Procedures

324

Catching Up with SAP HANA 2.0

326

Important Terminology

327

Practice Questions

327

Practice Question Answers and Explanations

332

Takeaway

335

Summary

336

9 Text, Spatial, Graph, and Predictive Modeling

337

Objectives of This Portion of the Test

339

Key Concepts Refresher

339

Text

340

Predictive

349

Spatial

354

Graph

360

Important Terminology

364

Practice Questions

365

Practice Question Answers and Explanations

368

Takeaway

369

Summary

370

10 Optimization of Information Models

371

Objectives of This Portion of the Test

372

Key Concepts Refresher

373

Architecture and Performance

373

Redesigned and Optimized Applications

374

Effects of Good Performance

375

Information Modeling Techniques

376

Optimization Tools

377

Best Practices for Optimization

386

Important Terminology

388

Practice Questions

389

Practice Question Answers and Explanations

392

Takeaway

394

Summary

394

11 Security

395

Objectives of This Portion of the Test

396

Key Concepts Refresher

397

Usage and Concepts

397

SAP HANA XSA and SAP HANA Deployment Infrastructure

400

Users

404

Roles

411

Privileges

414

Assigning Roles to Users

422

Important Terminology

423

Practice Questions

423

Practice Question Answers and Explanations

426

Takeaway

428

Summary

428

12 Virtual Information Models

429

Objectives of This Portion of the Test

431

Key Concepts Refresher

431

Background Information

432

SAP HANA Live

435

SAP S/4HANA Embedded Analytics

447

Important Terminology

451

Practice Questions

452

Practice Question Answers and Explanations

456

Takeaway

458

Summary

459

13 Data Provisioning

461

Objectives of This Portion of the Test

462

Key Concepts Refresher

463

Concepts

464

SAP Data Services

470

SAP Landscape Transformation Replication Server

472

SAP Replication Server

474

SAP HANA Smart Data Access

475

SAP HANA Enterprise Information Management

479

SAP HANA Streaming Analytics

482

SQL Anywhere and Remote Data Sync

484

SAP Vora

485

Flat Files

486

Web Services (OData and REST)

488

Important Terminology

489

Practice Questions

491

Practice Question Answers and Explanations

494

Takeaway

496

Summary

497

14 Consumption of Information Models

499

Objectives of this Portion of the Test

500

Key Concepts Refresher

501

Business Intelligence Concepts

501

Business Intelligence Tools for Microsoft Office Integration

507

Business Intelligence Tools for Data Discovery and Applications

511

Business Intelligence Tools for Reporting

515

Choosing the Right Business Intelligence Tool

516

Alternative Consumption Methods for SAP HANA

517

Important Terminology

520

Practice Questions

520

Practice Question Answers and Explanations

523

Takeaway

524

Summary

525