AWS CLF-C02 - Databases and Migration

Question 1

Which AWS service is a fully managed NoSQL key-value database that delivers single-digit millisecond latency performance at any scale?

Accepted Answer

Amazon DynamoDB

Answer

Amazon RDS

Answer

Amazon Redshift

Answer

Amazon Aurora

Question 2

A company needs to migrate an on-premises Oracle database to Amazon Aurora with minimal downtime. Which AWS service should they use?

Accepted Answer

AWS Database Migration Service (DMS)

Answer

AWS Snowball Edge

Answer

AWS Schema Conversion Tool (SCT)

Answer

Amazon RDS

Question 3

Which AWS service is a fully managed, petabyte-scale data warehouse?

Accepted Answer

Amazon Redshift

Answer

Amazon DynamoDB

Answer

Amazon RDS

Answer

Amazon ElastiCache

Question 4

A company wants to use a MySQL-compatible relational database that is up to 5 times faster than standard MySQL databases and offers automatic scalability. Which option is best?

Accepted Answer

Amazon Aurora

Answer

Amazon RDS for MariaDB

Answer

Amazon Redshift

Answer

Amazon DynamoDB

Question 5

Which AWS service would you use to transfer 80 TB of data from an on-premises data center to the AWS cloud when internet bandwidth is limited?

Accepted Answer

AWS Snowball Edge

Answer

AWS Direct Connect

Answer

AWS Snowmobile

Answer

Amazon S3 Transfer Acceleration

Question 6

A company wants to store web user session data for fast in-memory retrieval. Which AWS service is most suitable?

Accepted Answer

Amazon ElastiCache

Answer

Amazon RDS

Answer

Amazon S3

Answer

Amazon Glacier

Question 7

Which of the following tasks is the responsibility of AWS when using Amazon RDS?

Accepted Answer

Patching the underlying operating system and database engine

Answer

Optimizing application SQL queries

Answer

Defining the database schema

Answer

Creating users and permissions within the database

Question 8

Which database engine is NOT available on Amazon RDS?

Accepted Answer

IBM Db2

Answer

PostgreSQL

Answer

Oracle

Answer

MariaDB

Question 9

A company needs to migrate 100 PB (Petabytes) of data to the cloud. Network transfer would take decades. Which Snow family service is appropriate?

Accepted Answer

AWS Snowmobile

Answer

AWS Snowcone

Answer

AWS Snowball Edge

Answer

AWS Direct Connect

Question 10

Which service would you use to run complex SQL queries on data stored in S3 without needing to load the data into a database?

Accepted Answer

Amazon Athena

Answer

Amazon RDS

Answer

Amazon DynamoDB

Answer

Amazon Kinesis