Preface

17

Structure of This Book

18

Practice Questions

21

Summary

22

1 SAP HANA Certification Track—Overview

23

Who This Book Is For

24

SAP HANA Certifications

25

Associate-Level Certification

27

Professional-Level Certification

28

Specialist-Level Certification

28

SAP HANA Application Associate Certification Exam

29

Exam Objective

31

Exam Structure

31

Exam Process

33

Summary

34

2 SAP HANA Training

35

SAP Education Training Courses

36

Training Courses for SAP HANA Certifications

37

Additional SAP HANA Training Courses

38

Other Sources of Information

39

SAP Help

39

hana.sap.com and SAP Community Network

41

SAP HANA Academy

41

openSAP and openHPI

44

Hands-On with SAP HANA

46

Where to Get an SAP HANA System

46

Project Examples

52

Where to Get Data

54

Exam Questions

56

Types of Questions

56

Elimination Technique

58

Bookmark Questions

59

General Examination Strategies

59

Summary

60

3 Architecture and Deployment Scenarios

61

Objectives of This Portion of the Test

62

Key Concepts Refresher

63

In-Memory Technology

63

Architecture and Approach

69

Deployment Scenarios

79

Important Terminology

89

Practice Questions

91

Practice Question Answers and Explanations

96

Takeaway

99

Summary

99

4 Information Modeling Concepts

101

Objectives of This Portion of the Test

102

Key Concepts Refresher

103

Tables

103

Views

103

Cardinality

106

Joins

107

Core Data Services Views

117

Cube

119

Information Views

122

Using Information Views

124

Other Modeling Artifacts

127

Semantics

132

Hierarchies

132

Best Practices and Modeling Guidelines

134

Important Terminology

135

Practice Questions

136

Practice Question Answers and Explanations

144

Takeaway

147

Summary

148

5 Information Modeling Tools

149

Objectives of This Portion of the Test

150

Key Concepts Refresher

151

SAP HANA Studio

151

SAP HANA Web-Based Development Workbench

170

Important Terminology

174

Practice Questions

175

Practice Question Answers and Explanations

178

Takeaway

179

Summary

180

6 Information Views

181

Objectives of This Portion of the Test

182

Key Concepts Refresher

183

Data Sources for Information Views

184

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

185

Working with Nodes

197

Semantics Node

202

Attribute Views and Calculation Views of Type Dimension

205

Analytic Views and Calculation Views of Type Cube with Star Join

208

Migrating Attribute and Analytic Views

209

Important Terminology

213

Practice Questions

214

Practice Question Answers and Explanations

218

Takeaway

220

Summary

221

7 Advanced Information Modeling

223

Objectives of this Portion of the Test

224

Key Concepts Refresher

225

Calculated Columns

225

Restricted Columns

231

Filters

236

Variables

238

Input Parameters

242

Currency

246

Decision Tables

250

Hierarchies

253

Important Terminology

258

Practice Questions

260

Practice Question Answers and Explanations

264

Takeaway

267

Summary

268

8 SQL and SQLScript

269

Objectives of This Portion of the Test

271

Key Concepts Refresher

271

SQL

272

SQLScript

278

Views, Functions, and Procedures

293

Catching Up with SAP HANA SPS 11

295

Important Terminology

299

Practice Questions

300

Practice Question Answers and Explanations

306

Takeaway

309

Summary

309

9 Text, Spatial, and Predictive Modeling

311

Objectives of This Portion of the Test

313

Key Concepts Refresher

313

Text

314

Spatial

323

Predictive

327

Important Terminology

332

Practice Questions

333

Practice Question Answers and Explanations

337

Takeaway

338

Summary

339

10 Optimization of Information Models

341

Objectives of This Portion of the Test

342

Key Concepts Refresher

343

Architecture and Performance

343

Redesigned and Optimized Applications

344

Information Modeling Techniques

345

Optimization Tools

346

Best Practices for Optimization

358

Important Terminology

359

Practice Questions

360

Practice Question Answers and Explanations

363

Takeaway

365

Summary

366

11 Administration of Information Models

367

Objectives of This Portion of the Test

368

Key Concepts Refresher

369

Validating and Activating Information Models

369

Transporting Information Models

374

Core Data Services

383

Refactoring Information Models

383

Documenting Information Models

387

Translating Information Models

389

Important Terminology

390

Practice Questions

392

Practice Question Answers and Explanations

397

Takeaway

400

Summary

401

12 SAP HANA Live

403

Objectives of This Portion of the Test

404

Key Concepts Refresher

405

Background Information

405

Architecture

409

Virtual Data Model

410

SAP HANA Live Views

412

Installation and Administration

413

SAP HANA Live Browser—Browse and Use Views

415

SAP HANA Live Extension Assistant—Modify Views

422

Important Terminology

424

Practice Questions

425

Practice Question Answers and Explanations

428

Takeaway

430

Summary

430

13 Security

433

Objectives of This Portion of the Test

434

Key Concepts Refresher

435

Usage and Concepts

435

Users

439

Roles

443

Privileges

446

Testing Security

458

Important Terminology

459

Practice Questions

461

Practice Question Answers and Explanations

463

Takeaway

465

Summary

465

14 Data Provisioning

467

Objectives of This Portion of the Test

468

Key Concepts Refresher

469

Concepts

470

SAP Data Services

476

SAP LT Replication Server

478

SAP Replication Server

484

SAP Direct Extractor Connection

485

SAP HANA Smart Data Access

488

SAP HANA Enterprise Information Management

495

SAP HANA Smart Data Streaming

497

Flat Files or Microsoft Excel Datasheets

500

Web Services (OData and REST)

502

Important Terminology

502

Practice Questions

505

Practice Question Answers and Explanations

508

Takeaway

510

Summary

511

15 Utilization of Information Models

513

Objectives of this Portion of the Test

514

Key Concepts Refresher

515

Business Intelligence Concepts

515

Business Intelligence Tools for Microsoft Office Integration

522

Business Intelligence Tools for Applications and Dashboards

527

Business Intelligence Tools for Data Discovery

529

Business Intelligence Tools for Reporting

532

Choosing the Right Business Intelligence Tool

533

Alternative Consumption Methods for SAP HANA

534

Important Terminology

538

Practice Questions

538

Practice Question Answers and Explanations

541

Takeaway

542

Summary

542