Databases, App Integration, Management, Migration Flashcards

(51 cards)

1
Q

What is Amazon RDS?

A) Relational Database Service – managed relational DB service.
B) RDS is a serverless data warehouse service for OLAP analytics on large datasets.
C) RDS is a NoSQL database service for unstructured and schema-less data at petabyte scale.
D) RDS is a managed caching service compatible with Redis and Memcached.

A

A) Relational Database Service – managed relational DB service.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the key features of RDS?

A) RDS does not support encryption — you must use a self-managed database for encrypted storage.
B) Multi-AZ (synchronous standby, HA not read scaling), Read Replicas (async, up to 5, for read scaling), automated backups, manual…
C) Multi-AZ and Read Replicas are the same feature; both provide high availability and read scaling.
D) Multi-AZ for read scaling, Read Replicas for high availability, and manual backups only.

A

B) Multi-AZ (synchronous standby, HA not read scaling), Read Replicas (async, up to 5, for read scaling), automated backups, manual…

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is RDS Multi-AZ and what is it for?

A) Multi-AZ creates asynchronous read replicas in another AZ for scaling read traffic.
B) A synchronous standby replica in a different AZ. Provides automatic failover for high availability.
C) Multi-AZ deploys the database across all regions simultaneously for global low latency.
D) Multi-AZ is a backup strategy that stores RDS snapshots in a different AZ automatically.

A

B) A synchronous standby replica in a different AZ. Provides automatic failover for high availability.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is RDS Read Replicas and what is it for?

A) Read Replicas are synchronous standbys used for automatic failover during outages.
B) Read Replicas are incremental backups that can be restored to create a new primary.
C) Asynchronous copies of the primary database (up to 5). Used to scale read traffic.
D) Read Replicas are multi-region primary databases used for active-active configurations.

A

C) Asynchronous copies of the primary database (up to 5). Used to scale read traffic.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is Amazon Aurora?

A) Aurora is an in-memory caching layer for RDS that provides sub-millisecond query times.
B) Aurora is a managed data warehouse service 5× faster than Redshift for OLAP queries.
C) Aurora is a NoSQL database compatible with MongoDB and Cassandra.
D) AWS-proprietary relational DB engine. MySQL and PostgreSQL compatible.

A

D) AWS-proprietary relational DB engine. MySQL and PostgreSQL compatible.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is Amazon DynamoDB?

A) DynamoDB is a managed relational database compatible with MySQL and PostgreSQL.
B) DynamoDB is a managed data warehouse service for petabyte-scale analytics.
C) DynamoDB is a managed graph database optimised for social network applications.
D) Fully managed NoSQL database (key-value + document). Single-digit millisecond latency at any scale. Serverless.

A

D) Fully managed NoSQL database (key-value + document). Single-digit millisecond latency at any scale. Serverless.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the key DynamoDB concepts?

A) Collections, Documents, Fields, ObjectID — DynamoDB uses MongoDB-compatible data model.
B) Clusters, Keyspaces, Partitions, and Tokens — DynamoDB uses a Cassandra-compatible model.
C) Tables, Rows, Columns, Primary Keys, Foreign Keys, and Indexes — same as SQL databases.
D) Tables, Items (rows), Attributes (flexible schema). Primary Key = Partition Key + optional Sort Key.

A

D) Tables, Items (rows), Attributes (flexible schema). Primary Key = Partition Key + optional Sort Key.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is DynamoDB DAX?

A) DAX is DynamoDB’s built-in backup service that takes automatic point-in-time snapshots.
B) DAX is a DynamoDB streaming feature that captures item changes for event-driven processing.
C) DAX is DynamoDB’s cross-region replication feature for multi-master active-active setups.
D) DynamoDB Accelerator – an in-memory cache for DynamoDB delivering microsecond read latency (vs milliseconds without DAX).

A

D) DynamoDB Accelerator – an in-memory cache for DynamoDB delivering microsecond read latency (vs milliseconds without DAX).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is Amazon Redshift?

A) Redshift is a managed OLTP relational database optimised for transactional workloads.
B) Redshift is an in-memory cache that speeds up DynamoDB queries to microsecond latency.
C) Fully managed petabyte-scale data warehouse. SQL-compatible, OLAP (Online Analytical Processing).
D) Redshift is a managed search and analytics engine based on Elasticsearch.

A

C) Fully managed petabyte-scale data warehouse. SQL-compatible, OLAP (Online Analytical Processing).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is Amazon ElastiCache?

A) ElastiCache is a managed relational database for caching SQL query results on disk.
B) Managed in-memory caching. Redis: rich data structures, persistence, replication, cluster mode.
C) ElastiCache is a DynamoDB accelerator that uses SSD storage to speed up reads.
D) ElastiCache is a CDN service that caches web content at AWS edge locations.

A

B) Managed in-memory caching. Redis: rich data structures, persistence, replication, cluster mode.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

SQL vs NoSQL databases – key differences?

A) SQL and NoSQL have identical performance characteristics; they differ only in query language.
B) NoSQL uses ACID properties; SQL uses BASE properties for eventual consistency.
C) SQL is horizontally scaled and schema-less; NoSQL is vertically scaled and uses fixed schemas.
D) SQL: structured/schema, ACID properties, vertically scaled, uses SQL. | …

A

D) SQL: structured/schema, ACID properties, vertically scaled, uses SQL. | …

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the specialty AWS database services?

A) Kinesis, SQS, SNS, MQ, and EventBridge — the five specialty streaming database services.
B) S3, EBS, EFS, Glacier, and FSx — the five specialty storage-as-database services.
C) DocumentDB (MongoDB-compatible), Neptune (graph DB), QLDB (immutable ledger), Timestream (time-series), Keyspaces…
D) RDS, Aurora, DynamoDB, ElastiCache, and Redshift — the five specialty database services.

A

C) DocumentDB (MongoDB-compatible), Neptune (graph DB), QLDB (immutable ledger), Timestream (time-series), Keyspaces…

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is AWS DMS?

A) DMS is a continuous backup service that replicates RDS snapshots to another region.
B) DMS is a schema conversion tool that rewrites database schemas between SQL engines.
C) Database Migration Service – migrates databases to AWS with minimal downtime and zero data loss.
D) DMS is a managed ETL service that transforms data between data warehouse formats.

A

C) Database Migration Service – migrates databases to AWS with minimal downtime and zero data loss.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is AWS SCT?

A) SCT is a compliance assessment tool that checks database configurations against standards.
B) Schema Conversion Tool – converts database schema from one engine to another (e.g. Oracle to PostgreSQL).
C) SCT is a data masking service that anonymises sensitive data before migrating to AWS.
D) SCT is a database performance tuning tool that optimises slow SQL queries automatically.

A

B) Schema Conversion Tool – converts database schema from one engine to another (e.g. Oracle to PostgreSQL).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Self-managed vs managed databases – trade-offs?

A) Both have identical operational overhead — the only difference is licensing cost.
B) Self-managed: full control, but you handle backups, HA, replication, patching, and scaling – high operational overhead.
C) Managed databases give more control; self-managed databases are easier to operate.
D) Self-managed databases are always cheaper; managed services include hidden premium fees.

A

B) Self-managed: full control, but you handle backups, HA, replication, patching, and scaling – high operational overhead.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is Amazon SQS?

A) Simple Queue Service – fully managed message queue. Decouples application components.
B) SQS is a managed API gateway that queues HTTP requests for backend processing.
C) SQS is a real-time streaming service for ingesting IoT and clickstream data.
D) SQS is a pub/sub notification service where one message fans out to many subscribers.

A

A) Simple Queue Service – fully managed message queue. Decouples application components.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is Amazon SNS?

A) Simple Notification Service – pub/sub messaging. One published message fans out to many subscribers simultaneously.
B) SNS is a managed email service for sending transactional and marketing emails.
C) SNS is a real-time data streaming service for high-throughput event ingestion.
D) SNS is a message queue that stores messages for up to 14 days for later processing.

A

A) Simple Notification Service – pub/sub messaging. One published message fans out to many subscribers simultaneously.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

SQS vs SNS – full comparison?

A) Both SQS and SNS are push-based; SQS fans out to multiple consumers; SNS queues messages.
B) SQS: queue (pull model), one consumer per message, persists up to 14 days, used for decoupling/buffering. | …
C) SNS persists messages for 14 days; SQS delivers immediately and does not store messages.
D) SQS delivers to multiple subscribers simultaneously; SNS delivers to only one consumer.

A

B) SQS: queue (pull model), one consumer per message, persists up to 14 days, used for decoupling/buffering. | …

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is Amazon EventBridge?

A) EventBridge is a managed message queue service that replaces SQS for event-driven apps.
B) EventBridge is a cron job service that only runs scheduled tasks on a fixed interval.
C) EventBridge is a real-time analytics service for processing streaming IoT event data.
D) Serverless event bus for event-driven applications (formerly CloudWatch Events).

A

D) Serverless event bus for event-driven applications (formerly CloudWatch Events).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is Amazon Kinesis?

A) Real-time data streaming. Kinesis Data Streams: capture/process/store data streams.
B) Kinesis is a pub/sub notification service (like SNS) optimised for streaming workloads.
C) Kinesis is a managed message queue (like SQS) designed for high-throughput event ingestion.
D) Kinesis is a managed ETL service that transforms data between S3 and Redshift.

A

A) Real-time data streaming. Kinesis Data Streams: capture/process/store data streams.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is AWS Step Functions?

A) Serverless visual workflow service.
B) Step Functions is a CI/CD pipeline service for orchestrating code deployments.
C) Step Functions is an event bus service for routing events between AWS services.
D) Step Functions is a managed cron job service for scheduling Lambda executions.

A

A) Serverless visual workflow service.

22
Q

What is Amazon API Gateway?

A) API Gateway is a DNS service that routes API subdomains to backend EC2 instances.
B) API Gateway is a load balancer that distributes REST API traffic across Lambda functions.
C) API Gateway is a CDN service that caches API responses at CloudFront edge locations.
D) Fully managed service to create, publish, and maintain REST and WebSocket APIs.

A

D) Fully managed service to create, publish, and maintain REST and WebSocket APIs.

23
Q

What is Elastic Load Balancing (ELB) in the context of application integration?

A) ELB is a DNS failover service that redirects traffic when a region becomes unavailable.
B) ELB is a caching layer that stores backend responses to reduce database query load.
C) Distributes incoming traffic across multiple backend targets (EC2, ECS, EKS, Lambda).
D) ELB is a VPN service that securely connects client applications to backend services.

A

C) Distributes incoming traffic across multiple backend targets (EC2, ECS, EKS, Lambda).

24
Q

What is Amazon MQ?

A) A managed message broker service for Apache ActiveMQ and RabbitMQ.
B) Amazon MQ is a managed Kafka service for high-throughput event streaming workloads.
C) Amazon MQ is a managed alternative to SQS designed for cloud-native microservices.
D) Amazon MQ is a managed MQTT broker specifically designed for IoT device communication.

A

A) A managed message broker service for Apache ActiveMQ and RabbitMQ.

25
What is AWS AppFlow? A) AppFlow is an API gateway that routes mobile app traffic to backend microservices. B) AppFlow is a data lake ingestion service that loads data from S3 into Redshift. C) Used to integrate data between SaaS applications and AWS services without writing code. D) AppFlow is a CI/CD service for deploying application updates from GitHub to AWS.
C) Used to integrate data between SaaS applications and AWS services without writing code.
26
What is Amazon CloudWatch? A) Monitoring and observability service. B) CloudWatch is an audit logging service that records all API calls in an AWS account. C) CloudWatch is a network monitoring service that captures VPC packet-level traffic. D) CloudWatch is a cost management service that tracks spending per service and account.
A) Monitoring and observability service.
27
What are CloudWatch Alarms? A) Trigger actions when a metric exceeds a threshold. B) CloudWatch Alarms automatically remediate resource misconfigurations detected by Config. C) CloudWatch Alarms are compliance checks that validate resources against security policies. D) CloudWatch Alarms are billing notifications sent when a budget threshold is exceeded.
A) Trigger actions when a metric exceeds a threshold.
28
What does AWS CloudTrail record and how? A) Records all API calls in your AWS account: who did what, when, and from where. B) CloudTrail records EC2 performance metrics including CPU, memory, and disk I/O. C) CloudTrail records network traffic metrics like bandwidth, latency, and packet loss. D) CloudTrail records billing events and cost anomalies across all linked accounts.
A) Records all API calls in your AWS account: who did what, when, and from where.
29
What is AWS Systems Manager? A) Systems Manager is a managed SIEM service that aggregates security events from all sources. B) Systems Manager is a database migration service that moves on-premises databases to RDS. C) Systems Manager is a configuration management tool for EC2 instances using Chef and Puppet. D) Operations hub for AWS and on-premises resources.
D) Operations hub for AWS and on-premises resources.
30
What is AWS Config? A) Config is a deployment service that automatically rolls back infrastructure changes. B) Config is a cost analysis service that tracks spending changes for each resource over time. C) Assesses, audits, and evaluates resource configurations for compliance. Configuration History tracks changes over time. D) Config is a real-time threat detection service using ML to identify unusual API patterns.
C) Assesses, audits, and evaluates resource configurations for compliance. Configuration History tracks changes over time.
31
What is AWS Trusted Advisor? A) Real-time guidance to provision resources following AWS best practices. B) Trusted Advisor is a managed compliance service that runs HIPAA and PCI-DSS audits. C) Trusted Advisor is a database performance tool that recommends query optimisations. D) Trusted Advisor is a network monitoring tool that checks VPC routing for misconfigurations.
A) Real-time guidance to provision resources following AWS best practices.
32
What is the AWS Health Dashboard? A) Health Dashboard is a CloudWatch dashboard template for common EC2 health metrics. B) Health Dashboard is a Trusted Advisor report that summarises account best practice scores. C) Personalised view of AWS service health. Service Health: real-time status of all AWS services globally. D) Health Dashboard is a paid monitoring add-on that provides SLA breach notifications.
C) Personalised view of AWS service health. Service Health: real-time status of all AWS services globally.
33
What is AWS OpsWorks? A) OpsWorks is an EC2 monitoring tool that triggers Auto Scaling based on application metrics. B) Configuration management service providing managed instances of Chef and Puppet. C) OpsWorks is a compliance service that enforces CIS Benchmarks on EC2 configurations. D) OpsWorks is a code deployment service that integrates with GitHub and CodePipeline.
B) Configuration management service providing managed instances of Chef and Puppet.
34
What is AWS Service Catalog? A) Allows organisations to create and manage catalogues of approved CloudFormation/Terraform templates that teams can use... B) Service Catalog is AWS Marketplace for third-party software and SaaS products. C) Service Catalog is a billing tool that creates cost allocation reports per business unit. D) Service Catalog is a compliance dashboard that tracks approved vs unapproved services.
A) Allows organisations to create and manage catalogues of approved CloudFormation/Terraform templates that teams can use...
35
What is AWS Control Tower? A) Control Tower replaces AWS Organizations entirely with a simpler management interface. B) Helps set up and govern a multi-account AWS environment following best practices. C) Control Tower is a single-account governance tool for enforcing IAM best practices. D) Control Tower is a cost management console for setting cross-account budgets.
B) Helps set up and govern a multi-account AWS environment following best practices.
36
What are the 7 Rs of cloud migration? A) Reduce, Reuse, Recycle, Recover, Reprovision, Reformat, and Reconnect. B) Replicate, Restore, Reconfigure, Redeploy, Retest, Revalidate, and Release. C) Retire, Retain, Rehost (Lift and Shift), Relocate, Replatform (Lift and Tinker), Repurchase... D) Rehost, Replatform, Refactor, Replace, Rebuild, Revert, and Retire.
C) Retire, Retain, Rehost (Lift and Shift), Relocate, Replatform (Lift and Tinker), Repurchase...
37
What is Rehosting (Lift and Shift)? A) Rehosting involves rewriting the application to use cloud-native services and APIs. B) Moving an application to the cloud without making any changes. Allows companies to migrate quickly at scale. C) Rehosting means switching from a self-managed database to a managed RDS service. D) Rehosting is retiring the application and replacing it with an equivalent SaaS product.
B) Moving an application to the cloud without making any changes. Allows companies to migrate quickly at scale.
38
What is Replatforming? A) Replatforming means completely rewriting the application using cloud-native microservices. B) Replatforming means moving the application without any changes — a direct copy. C) Replatforming means retiring the application and purchasing a SaaS replacement. D) Making a few cloud optimisations to gain tangible benefit without changing the core architecture.
D) Making a few cloud optimisations to gain tangible benefit without changing the core architecture.
39
What is Refactoring/Re-architecting? A) Reimagining how an application is architected using cloud-native features. B) Refactoring means moving the application without any changes to reduce migration risk. C) Refactoring means purchasing a commercial SaaS replacement for a legacy application. D) Refactoring means making small optimisations like moving a database to RDS.
A) Reimagining how an application is architected using cloud-native features.
40
What is Repurchasing? A) Repurchasing means rebuilding the application from scratch using cloud-native architecture. B) Moving from a traditional licence to a SaaS model. Example: migrating from a self-hosted CRM to Salesforce. C) Repurchasing means making minor optimisations to gain cloud benefits without full rewrite. D) Repurchasing means keeping the application on-premises because it is not ready to migrate.
B) Moving from a traditional licence to a SaaS model. Example: migrating from a self-hosted CRM to Salesforce.
41
What is Retaining in the context of migration? A) Retaining means moving the application without changes using a lift-and-shift approach. B) Retaining means decommissioning an application found to be no longer needed. C) Retaining means switching from a self-hosted application to a managed SaaS product. D) Keeping applications in the source environment that are critical to the business.
D) Keeping applications in the source environment that are critical to the business.
42
What is Retiring in the context of migration? A) When migrating to the cloud, some infrastructure components are found to be no longer needed. B) Retiring means keeping an application on-premises because it requires major refactoring. C) Retiring means moving the application to cloud without changes to reduce migration time. D) Retiring means rewriting the application using cloud-native services and microservices.
A) When migrating to the cloud, some infrastructure components are found to be no longer needed.
43
What are the 6 perspectives of the AWS Cloud Adoption Framework (CAF)? A) Cloud Readiness, Skills Gap, Cost Model, Compliance, Vendor Risk, and Change Management. B) Infrastructure, Applications, Data, Security, Compliance, and Finance perspectives. C) Technical, Organisational, Financial, Legal, Operational, and Strategic perspectives. D) Business (value, risk), People (training, change management), Governance (portfolio management), Platform...
D) Business (value, risk), People (training, change management), Governance (portfolio management), Platform...
44
What is AWS Migration Hub? A) Migration Hub is a database migration tool for moving Oracle databases to Aurora. B) Central location to track and manage migration progress across AWS migration services. C) Migration Hub is a cost estimation tool for projecting cloud migration expenses. D) Migration Hub is a physical data transfer service for moving large datasets to AWS.
B) Central location to track and manage migration progress across AWS migration services.
45
What is AWS Application Discovery Service? A) Application Discovery Service migrates applications from on-premises to EC2 automatically. B) Application Discovery Service converts on-premises VMware VMs to EC2-compatible AMIs. C) Discovers on-premises servers, maps dependencies, and gathers data to help plan cloud migrations. D) Application Discovery Service estimates the cost of running on-premises apps in AWS.
C) Discovers on-premises servers, maps dependencies, and gathers data to help plan cloud migrations.
46
What is AWS Application Migration Service (MGN)? A) Performs lift-and-shift server migrations by continuously replicating source servers to AWS and enabling... B) MGN is a database migration tool that replicates data from on-premises to RDS. C) MGN is a discovery tool that inventories on-premises servers and their dependencies. D) MGN is a cost calculator that estimates savings from migrating to AWS.
A) Performs lift-and-shift server migrations by continuously replicating source servers to AWS and enabling...
47
What is AWS DataSync? A) Automates and accelerates online data transfer between on-premises storage (NFS, SMB) and AWS storage services (S3,... B) DataSync is a database migration service for moving relational databases to RDS. C) DataSync is a physical data transfer appliance for offline migration of large datasets. D) DataSync is a backup service that archives EC2 snapshots to Glacier automatically.
A) Automates and accelerates online data transfer between on-premises storage (NFS, SMB) and AWS storage services (S3,...
48
What is the AWS Transfer Family? A) Transfer Family is a Direct Connect service for high-speed data transfer to S3. B) Transfer Family is a Snow Family companion service that encrypts physical data transfers. C) Managed SFTP, FTPS, FTP, and AS2 file transfer service that connects to S3 or EFS backends. D) Transfer Family is a VPN service for securely connecting on-premises storage to AWS.
C) Managed SFTP, FTPS, FTP, and AS2 file transfer service that connects to S3 or EFS backends.
49
What is AWS Elastic Disaster Recovery? A) Minimises downtime and data loss with fast recovery of on-premises and cloud-based applications using affordable... B) Elastic DR is a multi-region replication service for DynamoDB Global Tables. C) Elastic DR is a backup scheduling service that coordinates RDS automated snapshots. D) Elastic DR is an S3 versioning service that enables point-in-time recovery of objects.
A) Minimises downtime and data loss with fast recovery of on-premises and cloud-based applications using affordable...
50
What is AWS Mainframe Modernisation? A) A service that assists in migrating and modernising mainframe applications to AWS. B) Mainframe Modernisation is a compliance service for COBOL application security audits. C) Mainframe Modernisation is a Snow Family device for transferring mainframe data to S3. D) Mainframe Modernisation is a DMS extension for migrating DB2 databases to Aurora.
A) A service that assists in migrating and modernising mainframe applications to AWS.
51
What online data transfer protocols does AWS Transfer Family support? A) MQTT, AMQP, STOMP, and CoAP — Transfer Family supports IoT messaging protocols. B) SCP, rsync, NFS, and SMB — Transfer Family supports Linux file copy protocols. C) SFTP, FTPS, FTP, and AS2 — all connect to S3 or EFS as the backend storage target. D) HTTP, HTTPS, WebSocket, and gRPC — Transfer Family supports web-standard protocols.
C) SFTP, FTPS, FTP, and AS2 — all connect to S3 or EFS as the backend storage target.