AWS ACF Módulo 8 - Bancos de dados

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