AWS-Certified-Database-Specialty Free Practice Test

A gaming company has recently acquired a successful iOS game, which is particularly popular during the holiday season. The company has decided to add a leaderboard to the game that uses Amazon DynamoDB. The application load is expected to ramp up over the holiday season.
Which solution will meet these requirements at the lowest cost?

1. A. DynamoDB Streams
2. B. DynamoDB with DynamoDB Accelerator
3. C. DynamoDB with on-demand capacity mode
4. D. DynamoDB with provisioned capacity mode with Auto Scaling

Correct Answer: C

A huge gaming firm is developing a centralized method for storing the status of various online games' user sessions. The workload requires low-latency key-value storage and will consist of an equal number of reads and writes. Across the games' geographically dispersed user base, data should be written to the AWS Region nearest to the user. The design should reduce the burden associated with managing data replication across Regions.
Which solution satisfies these criteria?

1. A. Amazon RDS for MySQL with multi-Region read replicas
2. B. Amazon Aurora global database
3. C. Amazon RDS for Oracle with GoldenGate
4. D. Amazon DynamoDB global tables

Correct Answer: D
https://aws.amazon.com/dynamodb/?nc1=h_ls

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?

1. A. Back up the source database using native backup to an Amazon S3 bucket in the same Regio
2. B. Then restore the backup in the target Region.
3. C. Back up the source database using native backup to an Amazon S3 bucket in the same Regio
4. D. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Regio
5. E. Then restore the backup in the target Region.
6. F. Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target database
7. G. Once the replication is in sync, terminate the DMS task.
8. H. Add an RDS for SQL Server cross-Region read replica in the target Regio
9. 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.

A company is running an Amazon RDS for PostgeSQL DB instance and wants to migrate it to an Amazon Aurora PostgreSQL DB cluster. The current database is 1 TB in size. The migration needs to have minimal downtime.
What is the FASTEST way to accomplish this?

1. A. Create an Aurora PostgreSQL DB cluste
2. B. Set up replication from the source RDS for PostgreSQL DB instance using AWS DMS to the target DB cluster.
3. C. Use the pg_dump and pg_restore utilities to extract and restore the RDS for PostgreSQL DB instance to the Aurora PostgreSQL DB cluster.
4. D. Create a database snapshot of the RDS for PostgreSQL DB instance and use this snapshot to create the Aurora PostgreSQL DB cluster.
5. E. Migrate data from the RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using anAurora Replic
6. F. Promote the replica during the cutover.

Correct Answer: D
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html Migrating data from an RDS PostgreSQL DB instance to an Aurora PostgreSQL DB cluster by using an
Aurora read replica. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#Aurora
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#Aurora

A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?

1. A. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluste
2. B. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
3. C. Run AWS DMS from the Db2 database to an Aurora DB cluste
4. D. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
5. E. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
6. F. Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster.Create a migration assessment report to evaluate the migration compatibility.

Correct Answer: D