AWS-Certified-Database-Specialty無料問題集「Amazon AWS Certified Database

質問 1

A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances. The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.
What is the MOST operationally efficient solution to meet these requirements?

（A）Create an AWS Lambda function to rotate the secret. Modify the CloudFormation template to add an AWS::SecretsManager::RotationSchedule resource. Configure the RotationLambdaARN value and, for the RotationRules property, set the AutomaticallyAfterDays parameter to 30.

（B）Save the password in an Amazon S3 object. Encrypt the S3 object with an AWS KMS key. Set the KMS key to be rotated every 30 days by setting the EnableKeyRotation property to true. Use a CloudFormation custom resource to read the S3 object to extract the password.

（C）Integrate the Amazon RDS for MySQL DB instances with AWS IAM and centrally manage the master database user password.

（D）Modify the CloudFormation template to use the AWS KMS key as the database password. Configure an Amazon EventBridge rule to invoke the KMS API to rotate the key every 30 days by setting the ScheduleExpression parameter to ***/30***.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

A company is hosting critical business data in an Amazon Redshift cluster. Due to the sensitive nature of the data, the cluster is encrypted at rest using AWS KMS. As a part of disaster recovery requirements, the company needs to copy the Amazon Redshift snapshots to another Region.
Which steps should be taken in the AWS Management Console to meet the disaster recovery requirements?

（A）Create a new KMS customer master key in the destination Region and create a new IAM role with access to the new KMS key. Enable Amazon Redshift cross-Region replication in the source Region and use the KMS key of the destination Region.

（B）Create a new IAM role with access to the KMS key. Enable Amazon Redshift cross-Region replication using the new IAM role, and use the KMS key of the source Region.

（C）Enable Amazon Redshift cross-Region snapshots in the source Region, and create a snapshot copy grant and use a KMS key in the destination Region.

（D）Create a new KMS customer master key in the source Region. Switch to the destination Region, enable Amazon Redshift cross-Region snapshots, and use the KMS key of the source Region.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

A development team at an international gaming company is experimenting with Amazon DynamoDB to store in-game events for three mobile games. The most popular game hosts a maximum of 500,000 concurrent users, and the least popular game hosts a maximum of 10,000 concurrent users. The average size of an event is
20 KB, and the average user session produces one event each second. Each event is tagged with a time in milliseconds and a globally unique identifier.
The lead developer created a single DynamoDB table for the events with the following schema:
Partition key: game name
Sort key: event identifier
Local secondary index: player identifier
Event time
The tests were successful in a small-scale development environment. However, when deployed to production, new events stopped being added to the table and the logs show DynamoDB failures with the ItemCollectionSizeLimitExceededException error code.
Which design change should a database specialist recommend to the development team?

（A）Create one table for each game. Use the player identifier as the partition key. Use the event time as the sort key.

（B）Use the player identifier as the partition key. Use the event time as the sort key. Add a global secondary index with the game name as the partition key and the event time as the sort key.

（C）Replace the sort key with a compound value consisting of the player identifier collated with the event time, separated by a dash. Add a local secondary index with the player identifier as the sort key.

（D）Create two tables. Use the game name as the partition key in both tables. Use the event time as the sort key for the first table. Use the player identifier as the sort key for the second table.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions. The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis.
Which combination of steps should a database specialist take to meet these requirements? (Choose two.)

（A）Modify the system table to enable logging for each user.

（B）Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs.

（C）Modify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.

（D）Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified Amazon S3 bucket

（E）Create a new parameter group with the enable_user_activity_logging parameter set to true. Configure the cluster to use the new parameter group.

正解：B、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

A database specialist needs to move an Amazon RDS DB instance from one AWS account to another AWS account.
Which solution will meet this requirement with the LEAST operational effort?

（A）Use AWS DataSync to back up the DB instance in the source AWS account. Use AWS Resource Access Manager (AWS RAM) to restore the backup in the destination AWS account.

（B）Use AWS Database Migration Service (AWS DMS) to migrate the DB instance from the source AWS account to the destination AWS account.

（C）Create a Multi-AZ deployment for the DB instance. Create a read replica for the DB instance in the source AWS account. Use the read replica to replicate the data into the DB instance in the destination AWS account.

（D）Create a DB snapshot of the DB instance. Share the snapshot with the destination AWS account. Create a new DB instance by restoring the snapshot in the destination AWS account.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

A company hosts a 2 TB Oracle database in its on-premises data center. A database specialist is migrating the database from on premises to an Amazon Aurora PostgreSQL database on AWS.
The database specialist identifies a problem that relates to compatibility Oracle stores metadata in its data dictionary in uppercase, but PostgreSQL stores the metadata in lowercase. The database specialist must resolve this problem to complete the migration.
What is the MOST operationally efficient solution that meets these requirements?

（A）Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.

（B）Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.

（C）Use an AWS Glue job that is attached to an AWS Database Migration Service (AWS DMS) replication task to convert the metadata from uppercase to lowercase.

（D）Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convert-lowercase.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

On AWS, a business is developing a web application. The application needs that the database supports concurrent read and write activities in several AWS Regions. Additionally, the database must communicate data changes across Regions as they occur. The application must be highly available and have a latency of less than a few hundred milliseconds.
Which solution satisfies these criteria?

（A）Amazon DynamoDB global tables

（B）Amazon DynamoDB streams with AWS Lambda to replicate the data

（C）An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards

（D）An Amazon Aurora global database

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

A business is transferring its on-premises database workloads to the Amazon Web Services (AWS) Cloud. A database professional migrating an Oracle database with a huge table to Amazon RDS has picked AWS DMS.
The database professional observes that AWS DMS is consuming considerable time migrating the data.
Which activities would increase the pace of data migration? (Select three.)

（A）Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.

（B）Establish an AWS Direct Connect connection between the on-premises data center and AWS.

（C）Increase the capacity of the AWS DMS replication server.

（D）Create multiple AWS DMS tasks to migrate the large table.

（E）Enable an Amazon RDS Multi-AZ configuration.

（F）Configure the AWS DMS replication instance with Multi-AZ.

正解：B、C、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

A company has an ecommerce website that runs on AWS. The website uses an Amazon RDS for MySQL database. A database specialist wants to enforce the use of temporary credentials to access the database.
Which solution will meet this requirement?

（A）Use MySQL native database authentication.

（B）Use AWS Systems Manager Parameter Store for authentication.

（C）Use AWS Identity and Access Management (IAM) database authentication.

（D）Use AWS Secrets Manager to rotate the credentials.

正解：C 解答を投票する

AWS-Certified-Database-Specialty 無料問題集「Amazon AWS Certified Database - Specialty (DBS-C01)」

弊社を連絡する

関連リンク

トップ試験