AWS-Certified-Database-Specialty Amazon Exam Questions and Free Practice Test

Question 25

A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

A. Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.

B. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.

C. Edit and enable Aurora DB cluster cache management in parameter groups.

D. Set TCP keepalive parameters to a high value.

E. Set JDBC connection string timeout variables to a low value.

F. Set Java DNS caching timeouts to a high value.

Correct Answer:ABC

Question 26

A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.
What should the Database Specialist do to meet these requirements?

A. Restore a snapshot from the production cluster into test clusters

B. Create logical dumps of the production cluster and restore them into new test clusters

C. Use database cloning to create clones of the production cluster

D. Add an additional read replica to the production cluster and use that node for testing

Correct Answer:C
https://aws.amazon.com/getting-started/hands-on/aurora-cloning-backtracking/
"Cloning an Aurora cluster is extremely useful if you want to assess the impact of changes to your database, or if you need to perform workload-intensive operations—such as exporting data or running analytical queries, or simply if you want to use a copy of your production database in a development or testing environment. You can make multiple clones of your Aurora DB cluster. You can even create additional clones from other clones, with the constraint that the clone databases must be created in the same region as the source databases.

Question 27

A business is transferring a database from one AWS Region to another using an Amazon RDS for SQL Server DB instance. The organization wishes to keep database downtime to a minimum throughout the transfer.
Which migration strategy should the organization use for this cross-regional move?

A. Back up the source database using native backup to an Amazon S3 bucket in the same Regio

B. Then restore the backup in the target Region.

C. Back up the source database using native backup to an Amazon S3 bucket in the same Regio

D. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Regio

E. Then restore the backup in the target Region.

F. Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target database

G. Once the replication is in sync, terminate the DMS task.

H. Add an RDS for SQL Server cross-Region read replica in the target Regio

I. Once the replication is in sync, promote the read replica to master.

Correct Answer:C
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html
With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS.

Question 28

A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live.
What change should the Database Specialist make to enable the migration?

A. Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)

B. Configure the AWS DMS replication instance to allow both full load and ongoing change data capture (CDC)

C. Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)

D. Configure the AWS DMS connections to allow two-way communication to allow for ongoing change data capture (CDC)

Correct Answer:A
"requires minimal downtime when the RDS DB instance goes live" in order to do CDC: "you must first ensure that ARCHIVELOG MODE is on to provide information to LogMiner. AWS DMS uses LogMiner to read information from the archive logs so that AWS DMS can capture changes"
https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle2postgresql.steps.configureoracle.html "If you want to capture and apply changes (CDC), then you also need the following privileges."

Question 29

A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account. The template configures provisioned throughput capacity using hard-coded values. The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned.
Which solution will enable this change?

A. Add values for the rcuCount and wcuCount parameters to the Mappings section of the template.Configure DynamoDB to provision throughput capacity using the stack’s mappings.

B. Add values for two Number parameters, rcuCount and wcuCount, to the templat

C. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.

D. Add values for the rcuCount and wcuCount parameters as outputs of the templat

E. Configure DynamoDB to provision throughput capacity using the stack outputs.

F. Add values for the rcuCount and wcuCount parameters to the Mappings section of the templat

G. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.

Correct Answer:B
Input parameter and FindInMap You can use an input parameter with the Fn::FindInMap function to refer to a specific value in a map. For example, suppose you have a list of regions and environment types that map to a specific AMI ID. You can select the AMI ID that your stack uses by using an input parameter (EnvironmentType). To determine the region, use the AWS::Region pseudo parameter, which gets the AWS Region in which you create the stack.
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/parameters-section-structure.html

Question 30

A single MySQL database was moved to Amazon Aurora by a business. The production data is stored in a database cluster in VPC PROD, whereas 12 testing environments are hosted in VPC TEST with the same AWS account. Testing has a negligible effect on the test data. The development team requires that each environment be updated nightly to ensure that each test database has daily production data.
Which migration strategy will be the quickest and least expensive to implement?

A. Run the master in Amazon Aurora MySQ

B. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

C. Run the master in Amazon Aurora MySQ

D. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.

E. Run the master in Amazon Aurora MySQ

F. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.

G. Run the master in Amazon Aurora MySQL using Aurora Serverles

H. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

Correct Answer:A
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html

START AWS-Certified-Database-Specialty EXAM