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

Question 13

An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
Update scores in real time whenever a player is playing the game. Retrieve a player’s score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?

A. Create a global secondary index with game_id as the partition key

B. Create a global secondary index with user_id as the partition key

C. Create a composite primary key with game_id as the partition key and user_id as the sort key

D. Create a composite primary key with user_id as the partition key and game_id as the sort key

Correct Answer:D
https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/ "EA uses the user ID as the partition key and primary key (a 1:1 modeling pattern)."
https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/
"Partition key and sort key: Referred to as a composite primary key, this type of key is composed of two attributes. The first attribute is the partition key, and the second attribute is the sort key."

Question 14

A business is launching a new Amazon RDS for SQL Server database instance. The organization wishes to allow auditing of the SQL Server database.
Which measures should a database professional perform in combination to achieve this requirement? (Select two.)

A. Create a service-linked role for Amazon RDS that grants permissions for Amazon RDS to store audit logs on Amazon S3.

B. Set up a parameter group to configure an IAM role and an Amazon S3 bucket for audit log storage.Associate the parameter group with the DB instance.

C. Disable Multi-AZ on the DB instance, and then enable auditin

D. Enable Multi-AZ after auditing is enabled.

E. Disable automated backup on the DB instance, and then enable auditin

F. Enable automated backup after auditing is enabled.

G. Set up an options group to configure an IAM role and an Amazon S3 bucket for audit log storage.Associate the options group with the DB instance.

Correct Answer:AE
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.Audit.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/security_iam_service-with-iam.html

Question 15

A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and India. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.
Which database solution satisfies these criteria?

A. Amazon DocumentDB

B. Amazon RDS Multi-AZ deployment

C. Amazon DynamoDB global table

D. Amazon Aurora Global Database

Correct Answer:C

Question 16

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

A. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.

B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.

C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Correct Answer:C
https://aws.amazon.com/blogs/database/best-practices-for-migrating-rds-for-mysql-databases-to-amazon-aurora/ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#Aurora

Question 17

A company’s ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key.
To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead.
What should the database administrator do to meet these requirements?

A. Add a global secondary index on Invoice ID to the existing table.

B. Add a local secondary index on Invoice ID to the existing table.

C. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.

D. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.

Correct Answer:C
as Local secondary index can only be created while creating the Dynamodb table. and query needs to use third attribute on top of primary and sort key, so Local Secondary index has primary and sort key as well as the third attribute. Global secondary index can be created without primary and sort key

Question 18

A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas.
How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application?

A. Set the TCP keepalive parameters low

B. Call the AWS CLI failover-db-cluster command

C. Enable Enhanced Monitoring on the DB cluster

D. Start a database activity stream on the DB cluster

Correct Answer:A
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html#Aur

START AWS-Certified-Database-Specialty EXAM