Book Image

AWS Certified Solutions Architect Study Guide: Associate SAA-C01 Exam - Second Edition

By : Ben Piper, David Clinton
Book Image

AWS Certified Solutions Architect Study Guide: Associate SAA-C01 Exam - Second Edition

By: Ben Piper, David Clinton

Overview of this book

The?AWS Certified Solutions Architect Study Guide: Associate (SAA-C01) Exam?enables you to validate your skills, increase your competitive advantage, and take the next step on your career path. Comprehensive and up-to-date content and superior study tools make this guide a must-have resource for those seeking AWS Solutions Architect – Associate certification. The?AWS Certified Solutions Architect Study Guide: Associate (SAA-C01) Exam?is your complete and fully updated resource to the AWS Solutions Architect - Associate certification. This invaluable Sybex study guide covers all relevant aspects of the AWS Solutions Architect job role, including mapping multi-tier architectures to AWS services, loose coupling and stateless systems, applying AWS security features, deploying and managing services, designing large scale distributed systems, and many more. Written by two AWS subject-matter experts, this self-study guide and reference provides all the tools and information necessary to master the exam, earn your certification, and gain insights into the job of an AWS Solutions Architect. Efficient and logical presentation of exam objectives allows for flexible study of topics, and powerful learning tools increase comprehension and retention of key exam elements. Practice questions, chapter reviews, and detailed examination of essential concepts fully prepare you for the AWS Solutions Architect – Associate certification.
Table of Contents (10 chapters)
Free Chapter
1
Acknowledgments
2
About the Authors
7
Index
8
Comprehensive Online Learning Environment
9
Wiley End User License Agreement

Chapter 5: Databases

  • 1. A, C. Different relational databases use different terminology. A row, record, and tuple all describe an ordered set of columns. An attribute is another term for column. A table contains rows and columns.
  • 2. C. A table must contain at least one attribute or column. Primary and foreign keys are used for relating data in different tables, but they’re not required. A row can exist within a table, but a table doesn’t need a row in order to exist.
  • 3. D. The SELECT statement retrieves data from a table. INSERT is used for adding data to a table. QUERY and SCAN are commands used by DynamoDB, which is a nonrelational database.
  • 4. B. Online transaction processing databases are designed to handle multiple transactions per second. Online analytics processing databases are for complex queries against large data sets. A key-value store such as DynamoDB can handle multiple transactions per second, but it’s not a relational database. There’s no such...