Amazon DBS-C01 Exam Practice Test Instant Access

Question 1

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?

ACreate a global secondary index with game_id as the partition key

BCreate a global secondary index with user_id as the partition key

CCreate a composite primary key with game_id as the partition key and user_id as the sort key

DCreate a composite primary key with user_id as the partition key and game_id as the sort key

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 2

A financial institution uses AWS to host its online application. Amazon RDS for MySQL is used to host the application's database, which includes automatic backups.

The program has corrupted the database logically, resulting in the application being unresponsive. The exact moment the corruption occurred has been determined, and it occurred within the backup retention period.

How should a database professional restore a database to its previous state prior to corruption?

AUse the point-in-time restore capability to restore the DB instance to the specified time. No changes to the application connection string are required.

BUse the point-in-time restore capability to restore the DB instance to the specified time. Change the application connection string to the new, restored DB instance.

CRestore using the latest automated backup. Change the application connection string to the new, restored DB instance.

DRestore using the appropriate automated backup. No changes to the application connection string are required.

Answer : B

When you perform a restore operation to a point in time or from a DB Snapshot, a new DB Instance is created with a new endpoint (the old DB Instance can be deleted if so desired). This is done to enable you to create multiple DB Instances from a specific DB Snapshot or point in time.'

Question 3

On a single Amazon RDS DB instance, a business hosts a MySQL database for its ecommerce application. Automatically saving application purchases to the database results in high-volume writes. Employees routinely create purchase reports for the company. The organization wants to boost database performance and minimize downtime associated with upgrade patching.

Which technique will satisfy these criteria with the LEAST amount of operational overhead?

AEnable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.

BEnable a Multi-AZ deployment of the RDS for MySQL DB instance, and set up replication to a MySQL DB instance running on Amazon EC2.

CEnable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.

DAdd a read replica and promote it to an Amazon Aurora MySQL DB cluster master. Then enable Amazon Aurora Serverless.

Answer : C

Question 4

A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when

survey responses are being collected, a Database Specialist sees the ProvisionedThroughputExceededException error.

What can the Database Specialist do to resolve this error? (Choose two.)

AChange the table to use Amazon DynamoDB Streams

BPurchase DynamoDB reserved capacity in the affected Region

CIncrease the write capacity units for the specific table

DChange the table capacity mode to on-demand

EChange the table type to throughput optimized

Answer : C, D

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/switching.capacitymode.html

Question 5

A database professional is tasked with the task of migrating 25 GB of data files from an on-premises storage system to an Amazon Neptune database.

Which method of data loading is the FASTEST?

AUpload the data to Amazon S3 and use the Loader command to load the data from Amazon S3 into the Neptune database.

BWrite a utility to read the data from the on-premises storage and run INSERT statements in a loop to load the data into the Neptune database.

CUse the AWS CLI to load the data directly from the on-premises storage into the Neptune database.

DUse AWS DataSync to load the data directly from the on-premises storage into the Neptune database.

Answer : A

1.Copy the data files to an Amazon Simple Storage Service (Amazon S3) bucket.

2. Create an IAM role with Read and List access to the bucket.

3. Create an Amazon S3 VPC endpoint.

4. Start the Neptune loader by sending a request via HTTP to the Neptune DB instance.

5. The Neptune DB instance assumes the IAM role to load the data from the bucket.

Question 6

A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster. A recent audit showed that no log files contained database administrator activity. A database specialist needs to recommend a solution to provide database access and activity logs. The solution should use the least amount of effort and have a minimal impact on performance.

Which solution should the database specialist recommend?

AEnable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.

BCreate an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.

CEnable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.

DAllow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.

Answer : C

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.Overview.html

Question 7

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi- AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.

What should the company do to address this space constraint issue?

ALog in to the host and run the rm $PGDATA/pg_logs/* command

BModify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted

CCreate a ticket with AWS Support to have the logs deleted

DRun the SELECT rds_rotate_error_log() stored procedure to rotate the logs

Answer : B

To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for one day. The default value is 4,320 (three days). The maximum value is 10,080 (seven days).

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.Concepts.PostgreSQL.html

Amazon DBS-C01 AWS Certified Database - Specialty Exam Practice Test