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

A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a

MySQL database that is hosted in Amazon RDS.

After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections.

Which solution will meet this requirement?

AUpdate the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON.

BConnect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user.

CUpdate the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established.

DUpdate the DB instance, and enable the Require Transport Layer Security option.

Show Answer

Question: 4

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: 5

A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three

Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one mediumsized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.

In the event of a primary failure, what will occur?

AAurora will promote an Aurora Replica that is of the same size as the primary instance

BAurora will promote an arbitrary Aurora Replica

CAurora will promote the largest-sized Aurora Replica

DAurora will not promote an Aurora Replica

Show Answer

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