Amazon AWS-Certified-Database-Specialtyテストエンジン問題集トレーニングには325問あります
AWS-Certified-Database-Specialty問題一発合格させる問題集はAWS Certified Database認定
AWS認定データベーススペシャリスト(DBS-C01)試験は、AWSプラットフォーム上のデータベース設計、展開、移行、管理に関する知識とスキルをテストする包括的な認定試験です。この試験に合格することで、AWSデータベースサービスを扱う専門知識を証明し、専門的なスキルアップに取り組む姿勢を示すことができます。AWSは試験準備のための様々なトレーニングリソースを提供しており、試験に合格することで新しいキャリアチャンスを得ることができ、収益力を高めることができます。
質問 # 189
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 Database Migration Service (AWS DMS) to migrate the DB instance from the source AWS account to the destination AWS account.
- B. 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.
- C. 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. 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.
正解：C
解説：
Explanation
The solution that will meet the requirement with the least operational effort is to create a DB snapshot of the DB instance, share the snapshot with the destination AWS account, and create a new DB instance by restoring the snapshot in the destination AWS account. This solution is simple, secure, and does not require any additional services or tools. It also preserves the configuration and data of the original DB instance. The other solutions are either more complex, require additional services or tools, or do not guarantee data consistency or security. For example, using AWS DMS to migrate the DB instance requires setting up replication endpoints, tasks, and network connectivity between the source and destination accounts. Creating a Multi-AZ deployment and a read replica for the DB instance involves additional costs and complexity, and does not ensure data consistency between the source and destination DB instances. Using AWS DataSync and AWS RAM to back up and restore the DB instance requires additional storage and permissions, and does not support encryption or compression for the backup data
質問 # 190
A company recently migrated its line-of-business (LOB) application to AWS. The application uses an Amazon RDS for SQL Server DB instance as its database engine.
The company must set up cross-Region disaster recovery for the application. The company needs a solution with the lowest possible RPO and RTO.
Which solution will meet these requirements?
- A. Take manual snapshots of the DB instance in the primary Region. Copy the snapshots to the disaster recovery Region.
- B. Create a cross-Region read replica of the DB instance. Promote the read replica at the time of failover.
- C. Use AWS Database Migration Service (AWS KMS) for ongoing replication of the DB instance in the disaster recovery Region.
- D. Set up SQL replication from the DB instance to an Amazon EC2 instance in the disaster recovery Region. Promote the EC2 instance as the primary server.
正解：C
解説：
Explanation
https://aws.amazon.com/blogs/database/cross-region-disaster-recovery-of-amazon-rds-for-sql-server/
質問 # 191
An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application.
The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts.
How should a Database Specialist address these requirements?
- A. Use DynamoDB Accelerator to offload the reads
- B. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
- C. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
- D. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into AmazonRedshift
正解：D
質問 # 192
A database professional maintains a fleet of Amazon RDS database instances that are configured to utilize the default database parameter group. A database expert must connect a custom parameter group with certain database instances.
When will the instances be allocated to this new parameter group once the database specialist performs this change?
- A. Within 24 hours after the change is made to the parameter group
- B. After the DB instances are manually rebooted
- C. Instantaneously after the change is made to the parameter group
- D. In the next scheduled maintenance window of the DB instances
正解：B
解説：
Explanation
When you associate a new DB parameter group with a DB instance, the modified static and dynamic parameters are applied only after the DB instance is rebooted.
質問 # 193
An ecommerce company is running Amazon RDS for Microsoft SQL Server. The company is planning to perform testing in a development environment with production data. The development environment and the production environment are in separate AWS accounts. Both environments use AWS Key Management Service (AWS KMS) encrypted databases with both manual and automated snapshots. A database specialist needs to share a KMS encrypted production RDS snapshot with the development account.
Which combination of steps should the database specialist take to meet these requirements? (Select THREE.)
- A. Allow the development account to access the production account KMS encryption key.
- B. Share the snapshot that is encrypted by using the production account custom KMS encryption key.
- C. Create an automated snapshot. Share the snapshot from the production account to the development account.
- D. Share the snapshot that is encrypted by using the development account default KMS encryption key.
- E. Create a manual snapshot. Share the snapshot from the production account to the development account.
- F. Allow the production account to access the development account KMS encryption key.
正解：A、B、E
解説：
Explanation from Amazon documents:
To share an encrypted Amazon RDS snapshot with another account, you need to do the following123:
Create a manual snapshot of the production database. You can't share an automated snapshot directly, but you can copy it to a manual snapshot and then share it1.
Use a custom KMS encryption key for the manual snapshot. You can't share a snapshot that is encrypted using the default KMS key of the source account1.
Share the snapshot with the development account by specifying the account ID of the target account1.
Allow the development account to access the custom KMS key of the source account by adding the target account ID to the key policy of the source account2.
Copy the shared snapshot to the development account by using a KMS key of the target account2.
Therefore, option B, D, and E are the correct steps to meet the requirements. Option A is incorrect because you can't share an automated snapshot. Option C is incorrect because you can't share a snapshot that is encrypted using the default KMS key. Option F is unnecessary because the production account does not need to access the development account KMS key.
質問 # 194
A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync.
What should the company do to resolve these performance issues?
- A. Add an Aurora Replica to scale the read traffic.
- B. Modify applications to commit transactions in batches.
- C. Modify applications to avoid conflicts by taking locks.
- D. Scale up the DB instance class.
正解：A
質問 # 195
A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DB instance. This program is very popular, and the corporation anticipates a tenfold rise in the application's user base over the next several months. The application receives a higher volume of traffic in the morning and evening.
This application is divided into two sections:
An internal booking component that takes online reservations in response to concurrent user queries.
A component of a third-party customer relationship management (CRM) system that customer service professionals utilize. Booking data is accessed using queries in the CRM.
To manage this workload effectively, a database professional must create a cost-effective database system.
Which solution satisfies these criteria?
- A. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
- B. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
- C. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.
- D. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
正解：D
解説：
Explanation
"AWS Lambda function to capture changes" capture changes to what? ElastiCache? The main use of ElastiCache is to cache frequently read data. Also "the company expects a tenfold increase in the user base" and "correspond to simultaneous requests from users"
質問 # 196
A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application. The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.
How can the database specialist minimize the performance degradation after failover?
- A. Enable Query Plan Management for the Aurora DB cluster and force the query optimizer to use the desired plan
- B. Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0
- C. Enable cluster cache management tor the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-1
- D. Enable Query Plan Management for the Aurora DB cluster and perform a manual plan capture
正解：B
解説：
Correct answer: A
Explanation from Amazon documents:
Amazon Aurora PostgreSQL supports cluster cache management, which is a feature that helps reduce the impact of failover on query performance by preserving the cache of the primary DB instance on one or more Aurora Replicas. Cluster cache management allows you to assign a promotion priority tier to each DB instance in your Aurora DB cluster. The promotion priority tier determines the order in which Aurora Replicas are considered for promotion to the primary instance after a failover. The lower the numerical value of the tier, the higher the priority.
By enabling cluster cache management for the Aurora DB cluster and setting the promotion priority for the writer DB instance and replica to tier-0, the database specialist can minimize the performance degradation after failover. This solution will ensure that the primary DB instance and one Aurora Replica have the same cache contents and are in the same promotion priority tier. In the event of a failover, Aurora will promote the tier-0 replica to the primary role, and the cache will be preserved. This will reduce the number of cache misses and improve query performance after failover.
Therefore, option A is the correct solution to minimize the performance degradation after failover. Option B is incorrect because setting the promotion priority for the writer DB instance and replica to tier-1 will not preserve the cache after failover. Aurora will first try to promote a tier-0 replica, which may have a different cache than the primary instance. Option C is incorrect because enabling Query Plan Management and performing a manual plan capture will not affect the cache behavior after failover. Query Plan Management is a feature that helps you control query execution plans and improve query performance by creating and enforcing custom execution plans. Option D is incorrect because enabling Query Plan Management and forcing the query optimizer to use the desired plan will not affect the cache behavior after failover. Forcing the query optimizer to use a desired plan may improve query performance by avoiding suboptimal plans, but it will not prevent cache misses after failover.
質問 # 197
A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers.
Which approach meets these requirements?
- A. Modify the client connection timeout to 300 seconds.
- B. Set the max_connections parameter to 16,000 in the instance-level parameter group.
- C. Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
- D. Enable the query cache at the instance level.
正解：D
質問 # 198
A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?
- A. Insufficient resources on the master
- B. New volumes created from snapshots load lazily in the background
- C. Overload of a single replication thread by excessive writes on the master
- D. Long-running statements on the master
正解：B
解説：
Explanation
snapshot is lazy loaded If the volume is accessed where the data is not loaded, the application accessing the volume encounters a higher latency than normal while the data gets loaded
https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-ebs-fast-snapshot-restore-eliminates-need-for-pr
質問 # 199
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. Stop the source instances before stopping their read replicas
- B. Delete each read replica before stopping its corresponding source instance
- C. Use the AWS CLI to stop each read replica and source instance at the same time
- D. Stop the read replicas before stopping their source instances
正解：B
解説：
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#USER_MySQL.Replication.ReadReplicas.StartStop
質問 # 200
A business's production databases are housed on a 3 TB Amazon Aurora MySQL DB cluster. The database cluster is installed in the region us-east-1. For disaster recovery (DR) requirements, the company's database expert needs to fast deploy the DB cluster in another AWS Region to handle the production load with an RTO of less than two hours.
Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?
- A. Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Region. Restore the snapshot to an appropriately sized DB cluster in the DR Region.
- B. Create an Aurora global database that spans two Regions. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.
- C. Create a smaller DB cluster in the DR Region. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.
- D. Add a cross-Region read replica in the DR Region with the same instance type as the current primary instance. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.
正解：D
解説：
RTO is 2 hours. With 3 TB database, cross-region replica is a better option
質問 # 201
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 Neptune for storage
- B. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
- C. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling
- D. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
正解：C
質問 # 202
A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.
Which step should be taken to troubleshoot this issue?
- A. Ensure that the database option group for the RDS DB instance allows ingress from the Developer machine's IP address
- B. Ensure that the RDS DB instance's subnet group includes a public subnet to allow the Developer to connect
- C. Ensure that the RDS DB instance has not reached its maximum connections limit
- D. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections
正解：D
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Concepts.General.SSL.Using.html
質問 # 203
A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space. In response, the database specialist modified the DB instance and added 50 GB of storage capacity. Three hours later, a new alert is generated due to a lack of free space on the same DB instance. The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.
What will happen when the modification is submitted?
- A. The request will fail because this storage capacity is too large.
- B. The request will succeed only if CPU utilization is less than 10%.
- C. The request will succeed only if the primary instance is in active status.
- D. The request will fail as the most recent modification was too soon.
正解：D
解説：
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html
質問 # 204
An electric utility company wants to store power plant sensor data in an Amazon DynamoDB table. The utility company has over 100 power plants and each power plant has over 200 sensors that send data every 2 seconds. The sensor data includes time with milliseconds precision, a value, and a fault attribute if the sensor is malfunctioning. Power plants are identified by a globally unique identifier. Sensors are identified by a unique identifier within each power plant. A database specialist needs to design the table to support an efficient method of finding all faulty sensors within a given power plant.
Which schema should the database specialist use when creating the DynamoDB table to achieve the fastest query time when looking for faulty sensors?
- A. Create a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a local secondary index (LSI) on the fault attribute.
- B. Use the plant identifier as the partition key and the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.
- C. Use the plant identifier as the partition key and the sensor identifier as the sort key. Create a local secondary index (LSI) on the fault attribute.
- D. Create a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.
正解：A
質問 # 205
An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application. The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts.
How should a Database Specialist address these requirements?
- A. Use DynamoDB Accelerator to offload the reads
- B. Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
- C. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
- D. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift
正解：D
質問 # 206
......
AWS-Certified-Database-Specialty練習テストPDF試験材料：https://www.jpntest.com/shiken/AWS-Certified-Database-Specialty-mondaishu
AWS-Certified-Database-Specialty解答の無料サンプルには全てリアル試験に基づいています：https://drive.google.com/open?id=1o0mEaOUk-o4a8xVw4_M-GESsjSPAEXzL