Table Of Contents
Notes on Usage and on the Screen Presentation
Dear Reader
Table Of Contents
Acknowledgments
Preface
Structure of This Book
Practice Questions
Summary
1 SAP HANA Certification Track—Overview
Who This Book Is For
SAP HANA Certifications
Associate-Level Certification
Professional-Level Certification
Specialist-Level Certification
SAP HANA Application Associate Certification Exam
Exam Objective
Exam Structure
Exam Process
Summary
2 SAP HANA Training
SAP Education Training Courses
Training Courses for SAP HANA Certifications
Additional SAP HANA Training Courses
Other Sources of Information
SAP Help
hana.sap.com and SAP Community Network
SAP HANA Academy
openSAP and openHPI
Hands-On with SAP HANA
Where to Get an SAP HANA System
Project Examples
Where to Get Data
Exam Questions
Types of Questions
Elimination Technique
Bookmark Questions
General Examination Strategies
Summary
3 Architecture and Deployment Scenarios
Objectives of This Portion of the Test
Key Concepts Refresher
In-Memory Technology
Architecture and Approach
Deployment Scenarios
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
4 Information Modeling Concepts
Objectives of This Portion of the Test
Key Concepts Refresher
Tables
Views
Cardinality
Joins
Core Data Services Views
Cube
Information Views
Using Information Views
Other Modeling Artifacts
Semantics
Hierarchies
Best Practices and Modeling Guidelines
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
5 Information Modeling Tools
Objectives of This Portion of the Test
Key Concepts Refresher
SAP HANA Studio
SAP HANA Web-Based Development Workbench
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
6 Information Views
Objectives of This Portion of the Test
Key Concepts Refresher
Data Sources for Information Views
Calculation Views: Type Dimension, Type Cube, and Type Cube with Star Join
Working with Nodes
Semantics Node
Attribute Views and Calculation Views of Type Dimension
Analytic Views and Calculation Views of Type Cube with Star Join
Migrating Attribute and Analytic Views
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
7 Advanced Information Modeling
Objectives of this Portion of the Test
Key Concepts Refresher
Calculated Columns
Restricted Columns
Filters
Variables
Input Parameters
Currency
Decision Tables
Hierarchies
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
8 SQL and SQLScript
Objectives of This Portion of the Test
Key Concepts Refresher
SQL
SQLScript
Views, Functions, and Procedures
Catching Up with SAP HANA SPS 11
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
9 Text, Spatial, and Predictive Modeling
Objectives of This Portion of the Test
Key Concepts Refresher
Text
Spatial
Predictive
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
10 Optimization of Information Models
Objectives of This Portion of the Test
Key Concepts Refresher
Architecture and Performance
Redesigned and Optimized Applications
Information Modeling Techniques
Optimization Tools
Best Practices for Optimization
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
11 Administration of Information Models
Objectives of This Portion of the Test
Key Concepts Refresher
Validating and Activating Information Models
Transporting Information Models
Core Data Services
Refactoring Information Models
Documenting Information Models
Translating Information Models
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
12 SAP HANA Live
Objectives of This Portion of the Test
Key Concepts Refresher
Background Information
Architecture
Virtual Data Model
SAP HANA Live Views
Installation and Administration
SAP HANA Live Browser—Browse and Use Views
SAP HANA Live Extension Assistant—Modify Views
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
13 Security
Objectives of This Portion of the Test
Key Concepts Refresher
Usage and Concepts
Users
Roles
Privileges
Testing Security
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
14 Data Provisioning
Objectives of This Portion of the Test
Key Concepts Refresher
Concepts
SAP Data Services
SAP LT Replication Server
SAP Replication Server
SAP Direct Extractor Connection
SAP HANA Smart Data Access
SAP HANA Enterprise Information Management
SAP HANA Smart Data Streaming
Flat Files or Microsoft Excel Datasheets
Web Services (OData and REST)
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
15 Utilization of Information Models
Objectives of this Portion of the Test
Key Concepts Refresher
Business Intelligence Concepts
Business Intelligence Tools for Microsoft Office Integration
Business Intelligence Tools for Applications and Dashboards
Business Intelligence Tools for Data Discovery
Business Intelligence Tools for Reporting
Choosing the Right Business Intelligence Tool
Alternative Consumption Methods for SAP HANA
Important Terminology
Practice Questions
Practice Question Answers and Explanations
Takeaway
Summary
The Author
Index
Service Pages
Legal Notes