Table of Contents

Open all
Close all
Acknowledgments
15
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
The Author
527
Index
529