Amazon AWS Certified Database Specialist Set 2

1.

A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on-premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit. Which approach has the least risk and the highest likelihood of a successful data transfer?

Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, start an AWS DMS task to move the data from thesource

to Amazon S3. Use AWS Glue to load the data from Amazon S3 to Amazon Redshift. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Start an AWS DMS task with two AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryption. Use AWS DMS tofinishcopying data to Amazon Redshift. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, use a fleet of 10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data from on-premises to Amazon S3 withAWSKMS encryption. Use AWS Glue to load the data to Amazon redshift. Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage a native database export feature to export the data and compress the files. Use the aws S3 cp multi-port upload command to uploadthesefiles to Amazon S3 with AWS KMS encryption. Once complete, load the data to Amazon Redshift using AWS Glue.

2.

A retail company is about to migrate its online and mobile store to AWS. The company's CEO has strategic plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and write database performance with minimal operational overhead.
What should the Database Specialist do to meet these requirements?

Use Amazon DynamoDB global tables to synchronize transactions Use Amazon EMR to copy the orders table data across Regions Use Amazon Aurora Global Database to synchronize all transactions Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them

3.

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster. Which solution meets these requirements?

Turn on the serverless option in the DB cluster so it can automatically scale based on demand. Provision a clone of the existing DB cluster for the new Application team. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC). Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

Amazon AWS Certified Database Specialist Set 2

Congratulations

COMPANY

Products

OTHERS

Partner

Amazon AWS Certified Database Specialist Set 2

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner