... 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

... SAP HANA Application Associate Certification Exam ... 31

... Summary ... 36

2 ... 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 ... 66

3 ... 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 ... 115

4 ... 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 ... 165

5 ... 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 ... 213

6 ... 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 ... 253

7 ... 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 ... 299

8 ... 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 ... 336

9 ... 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 ... 370

10 ... 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 ... 394

11 ... 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 ... 428

12 ... 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 ... 459

13 ... Data Provisioning ... 461

... Objectives of This Portion of the Test ... 462

... Key Concepts Refresher ... 463

... Important Terminology ... 489

... Practice Questions ...