Amazon DBS-C01 Quiz 2 Topic 6 Questions 6-10

Question: 1

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 medium- sized 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

Question: 2

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

A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.

What is the MOST cost-effective and operationally efficient solution?

ARun SQL Server Enterprise Edition on Amazon EC2.

BRun SQL Server Standard Edition on Amazon RDS.

CRun SQL Server Enterprise Edition on Amazon RDS.

DRun Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.

Show Answer

Question: 4

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

Question: 5

A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too timeconsuming, so it is not an option.

How should the Database Specialist satisfy this new requirement?

ACreate a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted
snapshot. Restore the encrypted snapshot copy.

BModify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.

CRestore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.

DCreate an encrypted read replica of the RDS DB instance. Promote it the master.

Show Answer

Amazon DBS-C01 Quiz:2 Topic:6 Questions:6-10