AWS_Database_Quizz

Which domains are covered in Chapter 5 of the AWS Certified Solutions Architect Associate Exam learning material?

• Domain 1: Design Secure Architectures

• Domain 2: Design Resilient Architectures

• Domain 3: Design High-Performing Architectures

• Domain 4: Design Cost-Optimized Architectures

What allows an application to store, organize, and quickly retrieve data?

• A) A spreadsheet

• B) A relational database

• C) A flat file

• D) A programming language

What are the two flavors of databases mentioned in the text?

• A) Relational and nonrelational

• B) Static and dynamic

• C) Local and cloud-based

• D) SQL and NoSQL

What are the columns in a relational database table also called?

• A) Cells

• B) Records

• C) Attributes

• D) Entries

What are the rows in a relational database table also called?

• A) Cells

• B) Records or tuples

• C) Attributes

• D) Entries

Which AWS service is NOT mentioned as a managed database service provided by AWS?

• A) Amazon RDS

• B) Amazon Redshift

• C) DynamoDB

• D) Amazon S3

What term is used to describe a database that allows for flexible queries and is represented by tables such as the one in Table 5.1?

• Hierarchical database

• Object-oriented database

• Relational database

• Network database

According to the text, what is a disadvantage of not using multiple related tables in a database?

• It increases the security of the database.

• It makes the database easier to understand.

• It can lead to unnecessary duplication and make queries slower.

• It simplifies the structure of the database.

What happens if you delete a column from a relational database table?

• It deletes only the column header but keeps the data.

• It deletes the data stored under the column for all employees.

• It rearranges the remaining columns automatically.

• It creates a backup of the deleted data.

Why might an application use multiple related tables instead of a single table?

• To increase the complexity of the database.

• To make data entry more challenging.

• To avoid wasted space and improve query performance.

• To limit the types of queries that can be performed.