Amazon DBS-C01 Quiz 3 Topic 3 Questions 11-15

Question: 1

A company's development team needs to have production data restored in a staging AWS account. The production database is running on an Amazon RDS for

PostgreSQL Multi-AZ DB instance, which has AWS KMS encryption enabled using the default KMS key. A database specialist planned to share the most recent automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in the AWS Management Console.

What should the database specialist do to resolve this?

ADisable automated backups in the DB instance. Share both the automated snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account and enable automated backups.

BCopy the automated snapshot specifying a custom KMS encryption key. Share both the copied snapshot and the custom KMS encryption key with the staging account. Restore the snapshot to the staging account within the same Region.

CModify the DB instance to use a custom KMS encryption key. Share both the automated snapshot and the custom KMS encryption key with the staging account. Restore the snapshot in the staging account.

DCopy the automated snapshot while keeping the default KMS key. Share both the snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account.

Show Answer

Question: 2

A company is running its customer feedback application on Amazon Aurora MySQL. The company runs a report every day to extract customer feedback, and a team reads the feedback to determine if the customer comments are positive or negative. It sometimes takes days before the company can contact unhappy customers and take corrective measures. The company wants to use machine learning to automate this workflow.

Which solution meets this requirement with the LEAST amount of effort?

AExport the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon Comprehend to run sentiment analysis on the exported files.

BExport the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon SageMaker to run sentiment analysis on the exported files.

CSet up Aurora native integration with Amazon Comprehend. Use SQL functions to extract sentiment analysis.

DSet up Aurora native integration with Amazon SageMaker. Use SQL functions to extract sentiment analysis.

Show Answer

Question: 3

For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls.

Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

AEnsure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.

BEnsure the vertices and edges are specified in different .csv files with proper header column formatting.

CUse AWS DMS to move data from Amazon S3 to the Neptune Loader.

DCurl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.

EEnsure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.

FCreate an S3 VPC endpoint and issue an HTTP POST to the databases loader endpoint.

Show Answer

Question: 4

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 onpremises 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?

ASet 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 the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to Amazon Redshift.

BLeverage 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 to finish copying data to Amazon Redshift.

CLeverage 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 with AWS KMS encryption. Use AWS Glue to load the data to Amazon redshift.

DSet 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 upload these files to Amazon S3 with AWS KMS encryption. Once complete, load the data to
Amazon Redshift using AWS Glue.

Show Answer

Question: 5

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will

offload the administrative burdens of operating and scaling distributed databases. The solution must be costeffective and able to handle unpredictable application traffic.

What should a Database Specialist recommend for this user?

ACreate an Amazon DynamoDB table with provisioned capacity mode

BCreate an Amazon DocumentDB cluster

CCreate an Amazon DynamoDB table with on-demand capacity mode

DCreate an Amazon Aurora Serverless DB cluster

Show Answer

Amazon DBS-C01 Quiz:3 Topic:3 Questions:11-15