WorksheetsAWS ACF Módulo 8 - Bancos de dados
Total questions: 16
Worksheet time: 1hrs 20mins
Which AWS service automates infrastructure provisioning and administrative tasks for an analytical data warehouse?
Amazon Redshift
Amazon DynamoDB
Amazon ElastiCache
Amazon Aurora
Which of the following options of AWS RDS allows for AWS to failover to a secondary database in case the primary one fails?
AWS Multi-AZ
AWs Failover
AWS Secondary
AWS Standby
A business analyst would like to move away from creating complex database queries and static spreadsheets when generating regular reports for high-level management. They would like to dynamically publish insightful, graphically appealing reports with interactive dashboards. Which service can they use to accomplish this?
Amazon QuickSight
Business Intelligence on Amazon Redshift
Amazon CloudWatch dashboards
Amazon Athena integrated with Amazon Glue
In a multi-node deployment architecture of Amazon Redshift data warehouse, what is the role of a leader node?
To access compressed data from the underlying columns
To receive queries and manage client connections
Primarily act as in-memory buffer area to improve operational efficiency
To store data and perform computation and queries
Why is Amazon DynamoDB service best-suited for implementation in mobile, Internet of Things (IoT) and gaming applications?
DynamoDB is a fully-managed database instance with no infrastructure overheads
DynamoDB has a flexible data model and single-digit milisecond latency
Whilst in operation, DynamoDB instances are spread across at least three geographically distinct centers, AWS Regions
DynamoDB supports eventual and strongly consistent reads.
One of a blogger's articles has gone viral which has resulted in a lot of traffic to their blog. This excessive amount of traffic has in turn caused poor browsing experience for some readers. How can normal service to the blog be restored?
Set up a Web Application Firewall (WAF) that will allow legitimate traffic and deny maliciously generated traffic.
Set up Read Replicas on the backend RDS instance where the article resides.
Upgrade the backend RDS instance to a non-relational database
Configure Multi-AZ to enhance the performance of the backend RDS instances running the blog.
Select which use case scenario best suits the implementation of an Amazon RDS database instance over a NoSQL/non-relational database.
Where datasets are constantly evolving and cannot be confined to a static data schema
Where vertical scaling of the database's resources is not permissible and is seldom necessary.
In a organization whose datasets are dynamic and document-based.
In a organization where only a finite number of processes query the database in predictable and well-structured schemas.
Which of the following features of Amazon RDS allows for better availability of databases? Choose 2 answers from the options given below:
VPC Peering
Multi-AZ
Read Replica
Multi-Region
Your company wants to move an existing Oracle Database to the AWS Cloud. Which of the following can help facilitate this move?
AWS Database Migration Service
AWS VM Migration Service
AWS Inspector
AWS Trusted Advisor
Which of the following features of AWS RDS allows you to reduce the load on the database while reading data?
Cross region replication
Creating Read Replicas
Using Snapshots
Using Multi-AZ feature
A company wants to have a database hosted on AWS. As much as possible they want to have control over the database itself. Which of the following would be an ideal option for this?
Using the AWS DynamoDB service
Using the AWS RDS Service
Hosting the database on an EC2 instance
Using the Amazon Aurora Service
Which of the following are benefits of the AWS's Relational Database Service (RDS)? Choose the 2 correct answers from the options below
Automated patches and backup
DB owner can resize the capacity accordingly
It allows you to store unstructured data
It allows you to store NoSQL data
A company currently has an application which consist of a .Net layer which connects to an MySQL database. They now want to move this application onto AWS. They want to make use of all AWS features such as high availability and automated backups. Which of the following would be an ideal database in AWS to migrate to for this requirement?
Aurora
DynamoDB
An EC2 instance with MySQL installed
An EC2 instance with Aurora installed.
A live online game uses DynamoDB instances in the backend to store real-time scores of the participants as they compete against each other from various parts of the world. Which data consistency option is the most appropriate to implement?
Strongly consistent
Eventually consistent
Strong eventual consistency
Optimistic consistency
Which of the following AWS managed database service provides processing power that is up to 5x faster than a traditional MySQL database?
MariaDB
Aurora
PostgreSQL
DynamoDB
Which of the following is TRUE for AWS Database Migration Service (AWS DMS)?
AWS DMS can migrate databases from on-premises to AWS
AWS DMS can migrate databases from AWS to on-premise
AWS DMS can migrate databases from EC2 to Amazon RDS
AWS DMS can have Amazon Redshift and Amazon DynamoDB as target databases
All the above
