SAP HANA 2.0 Certification Guide

Rudi de Louw is an SAP HANA architect for SAP in South Africa, as well as an international speaker and trainer, principal consultant, and mentor. He has been working with SAP HANA for more than 5 years, and is the SAP HANA and big data market unit champion. He helped to set up several SAP HANA certification exams and is also the content owner for the SAP HANA professional certifi-cation examination. Rudi has provided software and technology solutions to businesses for more than 25 years, and has been with SAP since 1999. He has a passion for sharing knowledge, understanding new technologies, and finding innovative ways to leverage these to help people in their development.

... Acknowledgments ... 15... Preface ... 17... Structure of This Book ... 18... What's New in the Second Edition ... 21... Practice Questions ... 22... Summary ... 231 ... SAP HANA Certification Track-Overview ... 25... Who This Book Is For ... 26... SAP HANA Certifications ... 27... SAP HANA Application Associate Certification Exam ... 31... Summary ... 362 ... SAP HANA Training ... 37... SAP Education Training Courses ... 38... Other Sources of Information ... 41... Hands-On with SAP HANA ... 47... Exam Questions ... 62... General Examination Strategies ... 66... Summary ... 663 ... Architecture, Deployment Scenarios, and Use Cases ... 69... Objectives of This Portion of the Test ... 70... Key Concepts Refresher ... 71... Important Terminology ... 103... Practice Questions ... 105... Practice Question Answers and Explanations ... 111... Takeaway ... 115... Summary ... 1154 ... Modeling Tools, Management, and Administration ... 117... Objectives of This Portion of the Test ... 119... Key Concepts Refresher ... 120... Important Terminology ... 160... Practice Questions ... 161... Practice Question Answers and Explanations ... 163... Takeaway ... 165... Summary ... 1655 ... Information Modeling Concepts ... 167... Objectives of This Portion of the Test ... 168... Key Concepts Refresher ... 169... Important Terminology ... 200... Practice Questions ... 201... Practice Question Answers and Explanations ... 209... Takeaway ... 212... Summary ... 2136 ... Calculation Views ... 215... Objectives of This Portion of the Test ... 216... Key Concepts Refresher ... 217... Important Terminology ... 244... Practice Questions ... 245... Practice Question Answers and Explanations ... 250... Takeaway ... 252... Summary ... 2537 ... Modeling Functions ... 255... Objectives of This Portion of the Test ... 256... Key Concepts Refresher ... 257... Important Terminology ... 289... Practice Questions ... 291... Practice Question Answers and Explanations ... 296... Takeaway ... 298... Summary ... 2998 ... SQL and SQLScript ... 301... Objectives of This Portion of the Test ... 303... Key Concepts Refresher ... 304... Important Terminology ... 327... Practice Questions ... 327... Practice Question Answers and Explanations ... 332... Takeaway ... 335... Summary ... 3369 ... Text, Spatial, Graph, and Predictive Modeling ... 337... Objectives of This Portion of the Test ... 339... Key Concepts Refresher ... 339... Important Terminology ... 364... Practice Questions ... 365... Practice Question Answers and Explanations ... 368... Takeaway ... 369... Summary ... 37010 ... Optimization of Information Models ... 371... Objectives of This Portion of the Test ... 372... Key Concepts Refresher ... 373... Important Terminology ... 388... Practice Questions ... 389... Practice Question Answers and Explanations ... 392... Takeaway ... 394... Summary ... 39411 ... Security ... 395... Objectives of This Portion of the Test ... 396... Key Concepts Refresher ... 397... Important Terminology ... 423... Practice Questions ... 423... Practice Question Answers and Explanations ... 426... Takeaway ... 428... Summary ... 42812 ... Virtual Information Models ... 429... Objectives of This Portion of the Test ... 431... Key Concepts Refresher ... 431... Important Terminology ... 451... Practice Questions ... 452... Practice Question Answers and Explanations ... 456... Takeaway ... 458... Summary ... 45913 ... Data Provisioning ... 461... Objectives of This Portion of the Test ... 462... Key Concepts Refresher ... 463... Important Terminology ... 489... Practice Questions ...