[2024年04月23日]AWS-Certified-Database-Specialty試験問題集PDF正確率保証と更新された問題
合格させるAWS-Certified-Database-Specialty試験にはリアルテストエンジンPDFには325問題あります
Amazon DBS -C01（AWS認定データベース - 専門）認定試験は、多くの準備と研究が必要な挑戦的な試験です。候補者は、AWSデータベースサービスについての十分な知識と、データベースの概念と原則を深く理解する必要があります。この試験の準備をするために、候補者はAWSトレーニングコースを受講し、AWSドキュメントを読み、AWSデータベースサービスで練習できます。また、AWSは、候補者が試験の準備を支援するために、研究資料、練習試験、およびその他のリソースを提供します。
Amazon DBS-C01（AWS認定データベース - 専門（DBS-C01））認定試験は、AWSデータベースサービスで働くデータベース管理者、開発者、およびアーキテクトにとって貴重な認定です。この認定は、AWSデータベースソリューションの設計、展開、および管理の候補者のスキルをテストするように設計されています。この試験に合格するには、候補者はAWSサービス、データベース、およびSQLの基本的な知識を確実に理解する必要があります。この認定により、専門家はキャリアの見通しを強化し、AWSデータベースサービスの専門知識を実証できます。
質問 # 25
A database specialist is constructing an AWS CloudFormation stack using AWS CloudFormation. The database expert wishes to avoid the stack's Amazon RDS ProductionDatabase resource being accidentally deleted.
Which solution will satisfy this criterion?
- A. Create a stack policy to prevent updates. Include "Effect: ProductionDatabase" and "Resource: Deny" in the policy.
- B. Create an RDS DB instance without the DeletionPolicy attribute. Disable termination protection.
- C. Create an AWS CloudFormation stack in XML format. Set xAttribute as false.
- D. Create a stack policy to prevent updates. Include Effect, Deny, and Resource :ProductionDatabase in the policy.
正解：D
解説：
Explanation
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/protect-stack-resources.html "When you set a stack policy, all resources are protected by default. To allow updates on all resources, we add an Allow statement that allows all actions on all resources. Although the Allow statement specifies all resources, the explicit Deny statement overrides it for the resource with the ProductionDatabase logical ID. This Deny statement prevents all update actions, such as replacement or deletion, on the ProductionDatabase resource."
質問 # 26
A startup company in the travel industry wants to create an application that includes a personal travel assistant to display information for nearby airports based on user location. The application will use Amazon DynamoDB and must be able to access and display attributes such as airline names, arrival times, and flight numbers. However, the application must not be able to access or display pilot names or passenger counts.
Which solution will meet these requirements MOST cost-effectively?
- A. Configure an AWS Lambda function to extract only allowed attributes from tables based on user profiles.
- B. Use IAM policies with a combination of IAM conditions and actions to implement fine-grained access control.
- C. Use a proxy tier between the application and DynamoDB to regulate access to specific tables, items, and attributes.
- D. Use DynamoDB resource policies to regulate access to specific tables, items, and attributes.
正解：B
解説：
Explanation
https://aws.amazon.com/blogs/aws/fine-grained-access-control-for-amazon-dynamodb/
質問 # 27
A company has applications running on Amazon EC2 instances in a private subnet with no internet connectivity. The company deployed a new application that uses Amazon DynamoDB, but the application cannot connect to the DynamoDB tables. A developer already checked that all permissions are set correctly.
What should a database specialist do to resolve this issue while minimizing access to external resources?
- A. Assign a new security group to the EC2 instances with an outbound rule to ports 80 and 443.
- B. Create a VPC endpoint for DynamoDB and add a route to the endpoint in the subnet's route table.
- C. Add a route to a NAT gateway in the subnet's route table.
- D. Add a route to an internet gateway in the subnet's route table.
正解：B
解説：
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/vpc-endpoints-dynamodb.html
質問 # 28
A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete.
What is the MOST likely cause of the 5-minute connection outage?
- A. After a database crash, Aurora needed to replay the redo log from the last database checkpoint
- B. There were no active Aurora Replicas in the Aurora DB cluster
- C. The client-side application is caching the DNS data and its TTL is set too high
- D. After failover, the Aurora DB cluster needs time to warm up before accepting client connections
正解：C
解説：
Explanation
When your application tries to establish a connection after a failover, the new Aurora PostgreSQL writer will be a previous reader, which can be found using the Aurora read only endpoint before DNS updates have fully propagated. Setting the java DNS TTL to a low value helps cycle between reader nodes on subsequent connection attempts.
Amazon Aurora is designed to recover from a crash almost instantaneously and continue to serve your application data. Unlike other databases, after a crash Amazon Aurora does not need to replay the redo log from the last database checkpoint before making the database available for operations. Amazon Aurora performs crash recovery asynchronously on parallel threads, so your database is open and available immediately after a crash. Because the storage is organized in many small segments, each with its own redo log, the underlying storage can replay redo records on demand in parallel and asynchronously as part of a disk read after a crash. This approach reduces database restart times to less than 60 seconds in most cases
質問 # 29
A company has a database fleet that includes an Amazon RDS for MySQL DB instance. During an audit, the company discovered that the data that is stored on the DB instance is unencrypted.
A database specialist must enable encryption for the DB instance. The database specialist also must encrypt all connections to the DB instance.
Which combination of actions should the database specialist take to meet these requirements? (Choose three.)
- A. In the RDS console, choose "Enable encryption" to encrypt the DB instance by using an AWS Key Management Service (AWS KMS) key.
- B. Encrypt the read replica of the unencrypted DB instance by using an AWS Key Management Service (AWS KMS) key. Fail over the read replica to the primary DB instance.
- C. Require SSL connections for applicable database user accounts.
- D. Enable SSH encryption on the DB instance.
- E. Create a snapshot of the unencrypted DB instance. Encrypt the snapshot by using an AWS Key Management Service (AWS KMS) key. Restore the DB instance from the encrypted snapshot. Delete the original DB instance.
- F. Use SSL/TLS from the application to encrypt a connection to the DB instance.
正解：A、E、F
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html#Overview.Encryption.Enabling
質問 # 30
A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries.
How should the company identify the source of the problem?
- A. Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
- B. Create a support request and work with AWS Support to identify the source of the issue.
- C. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
- D. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
正解：D
解説：
Explanation
Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action. Performance Insights allows non-experts to detect performance problems with an easy-to-understand dashboard that visualizes database load. https://aws.amazon.com/rds/performance-insights/
質問 # 31
A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read-only workload scaling. A failover event occurs and application performance is poor for several minutes. During this time, application servers in all Availability Zones are healthy and responding normally.
What should the company do to eliminate this application performance issue?
- A. Configure both of the Aurora Replicas to the same instance class as the primary DB instance. Enable cache coherence on the DB cluster, set the primary DB instance failover priority to tier-0, and assign a failover priority of tier-1 to the replicas.
- B. Deploy an AWS Lambda function that calls the DescribeDBInstances action to establish which instance has failed, and then use the PromoteReadReplica operation to promote one Aurora Replica to be the primary DB instance. Configure an Amazon RDS event subscription to send a notification to an Amazon SNS topic to which the Lambda function is subscribed.
- C. Configure one Aurora Replica to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and one replica with the same instance class. Set the failover priority to tier-1 for the other replicas.
- D. Configure both Aurora Replicas to have the same instance class as the primary DB instance. Implement Aurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DB instance and to tier-1 for the replicas.
正解：D
質問 # 32
A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.
What could be the reason for this?
- A. Stopped DB instances will automatically restart if the instance is not manually started after 7 days.
- B. Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.
- C. When stopping the DB instance, the option to create a snapshot should have been selected.
- D. When stopping the DB instance, the duration for stopping the DB instance should have been selected.
正解：A
解説：
https://aws.amazon.com/premiumsupport/knowledge-center/rds-stop-seven-days/
質問 # 33
A gaming company is designing a mobile gaming app that will be accessed by many users across the globe.
The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.
Which solution meets these requirements?
- A. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
- B. Use Amazon Neptune for storage
- C. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
- D. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
正解：C
質問 # 34
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. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
- B. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
- C. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
- D. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
正解：D
解説：
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#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica
質問 # 35
A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?
- A. Configure RDS Storage Auto Scaling.
- B. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
- C. Configure RDS instance Auto Scaling.
- D. Modify the DB instance allocated storage to meet the forecasted requirements.
正解：C
質問 # 36
A company is releasing a new mobile game featuring a team play mode. As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table. Periodically, the other users' devices read the latest statuses of their teammates from the table using the BatchGetltemn operation.
Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date. The developers are unable to replicate this issue and have asked a database specialist for a recommendation.
Which recommendation would resolve this issue?
- A. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to false.
- B. Enable a stream on the DynamoDB table and subscribe each device to the stream to ensure all devices receive up-to-date status information.
- C. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.
- D. Ensure the DynamoDB table is configured to be always consistent.
正解：C
解説：
Explanation
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/API_BatchGetItem_v20111205.htm By default, BatchGetItem performs eventually consistent reads on every table in the request. If you want strongly consistent reads instead, you can set ConsistentRead to true for any or all tables.
質問 # 37
A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.
Which backup methodology should the database specialist use to MINIMIZE management overhead?
- A. Create an AWS Lambda function that creates a backup of the DynamoDB table. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.
- B. Configure DynamoDB backup and restore for an on-demand backup frequency of every 24 hours.
- C. Install the AWS CLI on an Amazon EC2 instance. Write a CLI command that creates a backup of the DynamoDB table. Create a scheduled job or task that executes the command on a nightly basis.
- D. Create a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.
正解：D
解説：
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/CreateBackup.html#:~:text=If%20you%20don%27t%20want%20to%20create%20scheduling%20scripts%20and%20cleanup%20jobs%2C%20you%20can%20use%20AWS%20Backup%20to%20create%20backup%20plans%20with%20schedules%20and%20retention%20policies%20for%20your%20DynamoDB%20tables.%20AWS%20Backup%20runs%20the%20backups%20and%20deletes%20them%20when%20they%20expire.%20For%20more%20information%2C%20see%20the%20AWS%20Backup%20Developer%20Guide.
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/backuprestore_HowItWorks.html
質問 # 38
A business uses Amazon EC2 instances in VPC A to serve an internal file-sharing application.
This application is supported by an Amazon ElastiCache cluster in VPC B that is peering with VPC A.
The corporation migrates the instances of its applications from VPC A to VPC B.
The file-sharing application is no longer able to connect to the ElastiCache cluster, as shown by the logs.
What is the best course of action for a database professional to take in order to remedy this issue?
- A. Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
- B. Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.
- C. Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.
- D. Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
正解：B
解説：
Explanation
https://docs.aws.amazon.com/vpc/latest/peering/vpc-peering-security-groups.html
質問 # 39
A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective.
Which approach should the Database Specialist take?
- A. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.
- B. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
- C. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.
- D. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp). Run data transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.
正解：B
解説：
https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/
質問 # 40
A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)
- A. Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
- B. Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
- C. Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
- D. Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQLstatements, hosts, or users.
- E. Use Amazon QuickSight to view the SQL statement being run.
正解：A、D
質問 # 41
A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.
What should the database specialist do to meet these requirements? (Choose two.)
- A. Enable Enhanced Monitoring on the DB instance.
- B. Enable auditing of CONNECT and QUERY_DML events.
- C. SSH to the DB instance and review the database logs.
- D. Publish the database logs to Amazon CloudWatch Logs.
- E. Create an RDS event subscription to the audit event type.
正解：B、D
解説：
Explanation
https://aws.amazon.com/blogs/database/configuring-an-audit-log-to-capture-database-activities-for-amazon-rds-f
質問 # 42
A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company's migration to AWS.
Which MySQL database option would meet these requirements?
- A. Amazon Aurora Serverless MySQL cluster
- B. Amazon Aurora MySQL cluster
- C. Amazon RDS for MySQL with read replica
- D. Amazon RDS for MySQL with Multi-AZ
正解：B
質問 # 43
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. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.
- B. Add a global 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. Add a local secondary index on Invoice ID to the existing table.
正解：C
解説：
Explanation
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
質問 # 44
A company requires near-real-time notifications when changes are made to Amazon RDS DB security groups.
Which solution will meet this requirement with the LEAST operational overhead?
- A. Configure an Amazon CloudWatch alarm for RDS metrics about changes to DB security groups.
- B. Configure an RDS event notification subscription for DB security group events.
- C. Create an AWS Lambda function that monitors DB security group changes. Create an Amazon Simple Notification Service (Amazon SNS) topic for notification.
- D. Turn on AWS CloudTrail. Configure notifications for the detection of changes to DB security groups.
正解：B
解説：
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html#USER_Events.Mess
質問 # 45
A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.
The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.
How should the Database Specialist edit the script to fix this issue?
- A. Delete each read replica before stopping its corresponding source instance
- B. Use the AWS CLI to stop each read replica and source instance at the same time
- C. Stop the read replicas before stopping their source instances
- D. Stop the source instances before stopping their read replicas
正解：A
解説：
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html
"The following are some limitations to stopping and starting a DB instance: You can't stop a DB instance that has a read replica, or that is a read replica." So if you cant stop a db with a read replica, you have to delete the read replica first to then stop it???
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html#US
質問 # 46
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. 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.
- 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. 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.
正解：A
解説：
Explanation
The correct answer is D. Create one table for each game. Use the player identifier as the partition key.
Use the event time as the sort key.
The explanation is as follows:
The ItemCollectionSizeLimitExceededException error occurs when an item collection exceeds the 10 GB limit1.
An item collection is a group of items that have the same partition key value but different sort key values2.
In this case, the item collection is based on the game name, which has only three possible values.
This means that all events for each game are stored in the same item collection, which can easily exceed the 10 GB limit given the high volume and size of events.
To avoid this error, a database specialist should recommend a design change that distributes the events across more partitions and reduces the size of each item collection.
Option D achieves this by creating one table for each game, and using the player identifier as the partition key. This way, each event is stored in a separate partition based on the player identifier, and sorted by the event time. This design also supports efficient queries by game, player, and time range.
Option A is incorrect because it still uses a single table for all events, which can cause hot partitions and throttling due to uneven access patterns across games. Also, using the player identifier as the partition key can result in many small partitions that are underutilized and waste provisioned capacity. Adding a global secondary index with the game name as the partition key and the event time as the sort key does not solve the problem of item collection size limit, because global secondary indexes have their own item collections that are subject to the same limit3.
Option B is incorrect because it creates two tables with redundant data and increases storage costs. Also, using the game name as the partition key in both tables does not solve the problem of item collection size limit, as explained above.
Option C is incorrect because it still uses a single table for all events, which can cause hot partitions and throttling due to uneven access patterns across games. Also, replacing the sort key with a compound value consisting of the player identifier collated with the event time does not reduce the size of each item collection, because each event still has a unique sort key value. Adding a local secondary index with the player identifier as the sort key does not solve the problem of item collection size limit, because local secondary indexes share the same item collections as their base table4.
References:
1: ItemCollectionSizeLimitExceededException (AWS SDK for Java - 1.12.547)
2: Best practices for designing and using partition keys effectively - Amazon DynamoDB
3: Global Secondary Indexes - Amazon DynamoDB
4: Local Secondary Indexes - Amazon DynamoDB
質問 # 47
An online gaming company is using an Amazon DynamoDB table in on-demand mode to store game scores.
After an intensive advertisement campaign in South
America, the average number of concurrent users rapidly increases from 100,000 to 500,000 in less than 10 minutes every day around 5 PM.
The on-call software reliability engineer has observed that the application logs contain a high number of DynamoDB throttling exceptions caused by game score insertions around 5 PM. Customer service has also reported that several users are complaining about their scores not being registered.
How should the database administrator remediate this issue at the lowest cost?
- A. Enable auto scaling and set the target usage rate to 90%.
- B. Switch the table to provisioned mode and enable auto scaling.
- C. Create a DynamoDB Accelerator cluster and use it to access the DynamoDB table.
- D. Switch the table to provisioned mode and set the throughput to the peak value.
正解：B
質問 # 48
After restoring an Amazon RDS snapshot from 3 days ago, a company's Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?
- A. The production DB instance is using a custom option group
- B. The restored DB instance does not have Enhanced Monitoring enabled
- C. The restored DB instance is using the default security group
- D. The production DB instance is using a custom parameter group
正解：C
解説：
https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html
質問 # 49
......
AWS Certified Database - Specialty (DBS-C01)試験は、AWS上でデータベースを扱う人々にとって重要な認定試験です。この試験に合格することは、候補者がAWS上でデータベースを管理するスキルと知識を持っていることを示し、認定プロフェッショナルのコミュニティにアクセスできることを意味します。適切な準備と経験を持っている場合、候補者はAWS Certified Database - Specialty (DBS-C01)試験に合格し、データベース管理の分野でキャリアを進めることができます。
最新をゲットせよ！AWS-Certified-Database-Specialty認定練習テスト問題試験問題集：https://www.jpntest.com/shiken/AWS-Certified-Database-Specialty-mondaishu
リアルAWS-Certified-Database-Specialty試験問題集解答で有効なAWS-Certified-Database-Specialty問題集PDF：https://drive.google.com/open?id=1o0mEaOUk-o4a8xVw4_M-GESsjSPAEXzL