Font size
WorksheetsAWS_Database_Quizz
Total questions: 100
Worksheet time: 50mins
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.
What is the data type of the 'Employee ID' column in Table 5.1?
String
Date
Number
Boolean
What is the data type of the 'Birthdate' column in Table 5.1?
String
Date
Number
Boolean
How many times does the string "Information technology" appear in the Employees table for the information technology department?
1
50
100
It is not mentioned how many times it appears.
What is the primary key in the Employees table as shown in Table 5.3?
Department ID
Last name
Employee ID
Birthdate
In the context of Table 5.3, what does the Department ID in the Employees table represent?
A foreign key
A primary key
A string value
A unique employee identifier
Which table is considered the parent table in the relationship described?
The Employees table
The Departments table
Both A and B
Neither A nor B
What is the purpose of defining primary and foreign keys in database tables?
To enforce foreign key constraints
To create a new table
To delete records from the database
To update the table structure
What is a common misconception about the term "relational" in relational databases?
It refers to the relationship between tables.
It refers to the relationship of attributes within a row.
It means that the database can only have one table.
It implies that there are no relationships between tables.
What is the SELECT statement used for in a SQL database?
To insert data into a table
To query data from a database
To copy data into a table
To join two databases
What is the purpose of the INSERT statement in SQL?
To create a new database
To delete data from a table
To insert data into a table
To update data in a table
Which type of processing is an OLTP database optimized for?
Slow, infrequent transactions
Fast, frequent transactions
Complex queries against large data sets
Data warehousing
What are OLAP databases optimized for?
Fast, frequent transactions
Simple queries against small data sets
Complex queries against large data sets
Real-time data insertion
What is a common use case for an OLTP database?
Backing an online ordering system that processes hundreds of orders a minute
Managing employee data for a large corporation
Aggregating multiple databases into a single data warehouse
Performing regular backup of data
In data warehousing, what is a common practice involving OLTP databases?
Splitting a single OLTP database into multiple OLAP databases
Aggregating multiple OLTP databases into a single OLAP database
Converting OLTP databases into real-time analytics platforms
Reducing the size of OLTP databases for better performance
What is the Amazon Relational Database Service (RDS)?
A software that stores, organizes, and retrieves data in a database
A managed database service that lets you run relational database systems in the cloud
A virtual private cloud that fully manages database instances
A database engine that runs multiple database engines
What does AWS RDS take care of?
Configuring a database instance and managing SSH sessions
Setting up the database system, performing backups, and patching the database software
Providing automatic backups for OLTP applications only
Managing virtual private clouds and EC2 instances
Which of the following is NOT a feature of the database instances managed by AWS RDS?
They exist in a virtual private cloud (VPC)
They are fully managed by AWS
They allow direct SSH access
They do not show up under your EC2 instances
Which storage engines does MySQL offer for RDS-managed automatic backups?
MyISAM and XtraDB
MyISAM and InnoDB
InnoDB and XtraDB
MyISAM and MariaDB
Which of the following is recommended by AWS for maximum compatibility with RDS?
MyISAM storage engine
XtraDB storage engine
InnoDB storage engine
MariaDB storage engine
What is MariaDB in relation to MySQL?
A virtual private cloud service
A managed database service
A drop-in binary replacement for MySQL
A storage engine used by MySQL
Which Oracle Database edition is NOT listed as an option provided by RDS?
Oracle Database 11g
Oracle Database 21c
Oracle Database 19c
Oracle Database 12c Release 1
Which open source database is known as the most Oracle-compatible according to the text?
MySQL
Amazon Aurora
Microsoft SQL Server
PostgreSQL
What does Amazon Aurora provide to reduce the number of writes to the underlying storage?
A virtualized storage layer
An in-memory caching system
A proprietary file system
A distributed ledger technology
Which feature of Amazon Aurora allows you to restore your database to any point within the last 72 hours?
Aurora Backtrack
Aurora Snapshot
Aurora Rollback
Aurora Replay
Which RDS licensing model requires you to obtain a license for the database engine you run?
License included model
Bring Your Own License (BYOL) model
Enterprise Edition (EE) model
Standard Edition Two (SE2) model
Which database engine software supports the Bring Your Own License model according to the text?
MariaDB
MySQL
PostgreSQL
Oracle
What do database option groups allow you to do?
Increase the size of the database
Specify features and apply them to one or more instances
Decrease the cost of database management
Reduce the amount of memory used by databases
Which database engines offer transparent data encryption (TDE)?
MySQL and MariaDB
Microsoft SQL Server and Oracle
Microsoft SQL Server and MySQL
Oracle and MariaDB
What is the purpose of an audit plug-in for MySQL and MariaDB?
To increase query performance
To encrypt data before writing it to storage
To log user logons and queries run against the databases
To provide additional memory to the database
What does the latest-generation standard instance class db.m6i provide?
512 GB of memory and 128 vCPU
40 Gbps network bandwidth and 50,000 Mbps disk throughput
Both A and B
None of the above
What is the most memory-optimized instance class mentioned in the text?
db.m6i
db.xle
db.m4
db.r5
How much memory does the most memory-optimized instance class provide?
512 GB
3,904 GB
128 GB
40 GB
What type of storage do database instances use according to the text?
SSD storage
HDD storage
EBS storage
NAS storage
Do both standard and memory-optimized instance classes provide dedicated bandwidth for transfers to and from EBS storage?
Yes, they both provide dedicated bandwidth
No, only standard instance classes provide dedicated bandwidth
No, only memory-optimized instance classes provide dedicated bandwidth
The text does not specify
What is the latest burstable performance instance class available for Amazon Relational Database Service as mentioned in the document?
db.t2.micro
db.t3.medium
db.t4g
db.m5.large
How much memory does the latest burstable performance instance class provide?
16 GB of memory
32 GB of memory
64 GB of memory
128 GB of memory
What is the network bandwidth available for the latest burstable performance instance class?
1 Gbps
5 Gbps
10 Gbps
20 Gbps
What is the disk throughput for the latest burstable performance instance class?
1,024 Mbps (128 MBps)
2,048 Mbps (256 MBps)
3,072 Mbps (384 MBps)
4,096 Mbps (512 MBps)
Which AWS instance classes are based on the AWS Nitro System?
db.t3 and db.t4g
db.t2 and db.m4
db.t3, db.m5, and db.r5
db.m5 and db.r5
What is the page size of MySQL and MariaDB as mentioned in the document?
4 KB
8 KB
16 KB
32 KB
According to the document, what is the relationship between IOPS and page size?
The larger the page size, the more IOPS you need.
The larger the page size, the fewer IOPS you need.
The page size has no effect on IOPS.
The smaller the page size, the more IOPS you need.
What is the minimum storage volume you can create for general-purpose SSD (gp2) storage in RDS?
20 GB
10 GB
5 GB
1 TB
For each gigabyte of data that you allocate to a volume, how many IOPS does RDS allocate for general-purpose SSD (gp2) storage?
3 IOPS
6 IOPS
10 IOPS
50 IOPS
What is the maximum number of IOPS you can provision with general-purpose SSD (gp2) without needing to overallocate storage?
10,000 IOPS
3,000 IOPS
16,000 IOPS
5,334 IOPS
How is the burst duration in seconds calculated for a volume that temporarily needs to burst to 3,000 IOPS?
(Credit balance) / [3,000 - 3 * (storage size in GB)]
(Credit balance) / [3,000 - 3^(storage size in GB)]
(Credit balance) / [3,000 - 3 * (storage size in TB)]
(Credit balance) / [3,000 - 3 / (storage size in GB)]
Upon booting a database instance, what is the initial credit balance for IOPS that you receive?
5,400,000 IOPS
2,250 seconds
3,000 IOPS
16,000 IOPS
If you are running MariaDB with a page size of 16 KB, how do you determine the number of IOPS you'll need to sustain 2,000 Mbps of disk throughput?
Divide the bandwidth by the page size
Multiply the bandwidth by the page size
Divide the page size by the bandwidth
Multiply the page size by 2,000
What is the rate at which the credit balance is replenished for IOPS on an Amazon RDS gp2 volume?
One baseline IOPS every minute
600 IOPS every second
One baseline IOPS every second
5,400,000 IOPS every hour
What is the maximum number of IOPS you can provision per io1 volume?
5,400,000 IOPS
32,000 IOPS
256,000 IOPS
256,000 IOPS per io1 volume
For Provisioned IOPS SSD (io1), what is the minimum ratio of storage in gigabytes to IOPS?
50:1
100:1
10:1
30:1
When creating an RDS database instance using MariaDB, which template should be selected to avoid incurring any charges?
Standard Create
Dev/Test
Free Tier
Production
According to the RDS guarantee, what percentage of the provisioned IOPS will be achieved within 10 percent for 99.9 percent of the year?
90 percent
99.9 percent
99 percent
10 percent
What is the maximum size of magnetic storage offered by RDS for backward compatibility with older instances?
500 GB
1 TB
2 TB
100 GB
What does scaling vertically mean in the context of database instances?
Adding more database instances
Upgrading to a larger instance class
Distributing the load across multiple instances
Decreasing the resources of an instance
What is the purpose of a read replica in a database system?
To increase write performance
To serve as a backup for the master database
To offload query load from the master database
To replace the master database in case of failure
How many read replicas can you have for RDS and Aurora respectively?
Up to 5 for RDS and up to 10 for Aurora
Up to 10 for RDS and up to 15 for Aurora
Up to 5 for RDS and up to 15 for Aurora
Up to 15 for RDS and up to 20 for Aurora
What happens if the master database instance fails before the replication is complete?
The read replicas will automatically become the new master
The replication process will restart automatically
You will lose the unsynchronized data
The read replicas will continue to function without any data loss
What is the first step in creating a Read Replica in the Amazon RDS service console?
Click the Create Read Replicas button.
In the navigation pane of the RDS service console, click Databases.
Select the read replica you created.
Click Actions and then select Promote.
What must you do before promoting a Read Replica to a Master?
Click the Create Read Replicas button.
Delete the original master instance.
Wait for the replica to enter the Available state.
Click Promote Read Replica immediately after creation.
In a Multi-AZ deployment, what is the role of the standby database instance?
It handles reads and writes to the database.
It is promoted to a read replica.
It takes over if the primary database instance experiences an outage.
It is used to create Read Replicas.
What are some possible causes for a database instance outage?
Availability zone outage
Changing a database instance type
Patching of the instance's operating system
All of the above
When should you enable multi-AZ if you want to experience a significant performance hit?
Before creating your database instance
After creating your database instance during a maintenance window
After creating your database instance at any time
When you change the database instance type
In a Multi-AZ deployment with Oracle, PostgreSQL, MariaDB, MySQL, and Microsoft SQL Server, where must all instances reside?
In different regions
In the same availability zone
In the same region
In multiple availability zones
What is the replication behavior in a Multi-AZ deployment with Oracle, PostgreSQL, MariaDB, MySQL, and Microsoft SQL Server?
The primary instance replicates data to a read replica in a different region
The primary instance does not replicate data
The primary instance replicates data to the standby instance in the same region
The standby instance replicates data to the primary instance
What happens when a failover occurs in a Multi-AZ deployment with Oracle, PostgreSQL, MariaDB, MySQL, and Microsoft SQL Server?
The standby instance becomes the primary and starts serving traffic
The primary instance continues to serve traffic
The application has to do nothing as the transition is seamless
The application has to reconnect to the endpoint
What type of license model is required if you configure multi-AZ using the bring your own license model for Oracle?
A license for the primary instance only
A license for the standby instances only
A license for both the primary and standby instances
No license is required
What are the two options for multi-AZ with Amazon Aurora?
Single-master and dual-master
Single-master and multi-master
Dual-master and multi-region
Single-region and multi-region
What happens to the cluster volume in an Amazon Aurora single-master cluster when the primary instance fails and no Aurora replicas exist?
The cluster volume is deleted
A new primary instance is created to replace the failed one
The cluster volume is manually expanded
The cluster volume remains unchanged
What is the maximum acceptable time to recover data and resume processing after a failure according to the Recovery Time Objective (RTO)?
The time it takes to restore a snapshot
5 minutes
The maximum acceptable time
The time it takes to take a snapshot
What is the Recovery Point Objective (RPO) in the context of Amazon RDS?
The time it takes to restore a snapshot
The maximum period of recent data changes that may be lost in the event of a failure
The time it takes to take a snapshot
The maximum acceptable time to recover data
How often does Amazon RDS take automated snapshots of your instances?
Weekly
Daily during a 30-minute backup window
Monthly
Every 5 minutes
What is the default retention period for automated snapshots in Amazon RDS?
1 day
7 days
35 days
0 days
What happens if you set the retention period for automated snapshots to 0 in Amazon RDS?
It will keep the snapshots indefinitely
It will delete snapshots older than 30 days
It will delete all existing automated snapshots and disable point-in-time recovery
It will create a snapshot every 0 days
What will happen if you change the retention period from 0 to any other value in Amazon RDS?
It will delete the database instance.
It will trigger an immediate snapshot.
It will start the maintenance window.
It will upgrade the database engine.
What does AWS handle as part of its responsibility for RDS maintenance items?
Customer service inquiries.
Patching and upgrades.
Database instance creation.
Data backup and restoration.
How long is the maintenance window for Amazon RDS, and is it possible for tasks to run beyond this time?
20 minutes, and tasks cannot run beyond this time.
30 minutes, but tasks can run beyond this time.
1 hour, and tasks cannot run beyond this time.
45 minutes, but tasks can run beyond this time.
What problem does Amazon RDS Proxy address?
It handles the reconnection to the backup instance during a database failover.
It upgrades the database engine automatically.
It increases the retention period for database snapshots.
It provides additional storage for database instances.
What is maintained by Amazon RDS Proxy to prevent performance problems?
A large number of open connections to the database instance.
A minimal number of open connections to the database instance.
A fixed number of database snapshots.
A constant upgrade schedule for the database engine.
What is Amazon Redshift primarily optimized for?
Online Transaction Processing (OLTP)
Data warehousing applications
Web hosting services
Real-time data analytics
Which of the following is NOT a feature of Amazon Redshift?
Based on PostgreSQL
Part of Amazon RDS
Columnar storage
JDBC and ODBC connectors
What does Amazon Redshift use to reduce the amount of storage space required for each column?
Data encryption
Compression encodings
Data deduplication
Data partitioning
What type of storage nodes can store up to 16,384 TB of storage on fast SSDs in a Redshift cluster?
Dense compute nodes
Dense storage nodes
RA3 nodes
Leader nodes
Which distribution style in Redshift spreads data out evenly across all compute nodes?
EVEN distribution
KEY distribution
ALL distribution
RANDOM distribution
In Amazon Redshift, what is the role of the leader node?
It stores up to 2 PB of data on magnetic hard disk drives.
It coordinates communication among the compute nodes and with clients.
It incurs additional charges.
It compresses data manually.
What is the purpose of Redshift Spectrum?
To import large amounts of data into your cluster
To query data from files stored in S3 without importing them into your cluster
To increase the storage capacity of your database
To migrate databases between different AWS regions
What makes AWS Database Migration Service (DMS) particularly powerful?
Its ability to increase database storage automatically
Its ability to migrate data between different database engines and between relational and nonrelational databases
Its ability to replicate databases within the same engine only
Its ability to backup data to S3 automatically
Which of the following is NOT a database that AWS Database Migration Service can migrate data between?
Aurora
MongoDB
Microsoft Excel
Oracle
What does DMS provision to manage the migration process?
A DMS instance on an EC2 instance
A dedicated S3 bucket
A direct connection to the target database
A virtual private cloud
If a database is too large to transfer over the network for migration, what AWS service is recommended?
AWS Lambda
Snowball Edge
AWS Glacier
Amazon RDS
What is a more accurate description for unstructured data in the context of nonrelational databases?
Data that cannot be stored in any database
Data that has a consistent and fixed structure
Multistructured data that can vary in structure
Data that is always text-based
