最高でDBS-C01最新の2023問題集は100%試験合格率保証付きます [Q65-Q81]

最高でDBS-C01最新の2023問題集は100%試験合格率保証付きます

ベストな方法はAmazon DBS-C01練習試験問題集

質問 65
A database specialist is managing an application in the us-west-1 Region and wants to set up disaster recovery in the us-east-1 Region. The Amazon Aurora MySQL DB cluster needs an RPO of 1 minute and an RTO of 2 minutes.
Which approach meets these requirements with no negative performance impact?

A. Enable asynchronous binlog replication.
B. Create an Aurora Global Database.
C. Copy Aurora incremental snapshots to the us-east-1 Region.
D. Enable synchronous replication.

正解: D

質問 66
A media company is using Amazon RDS for PostgreSQL to store user dat
a. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements.
Only certain on-premises corporate network IPs should connect to the DB instance. Connectivity is allowed from the corporate network only.
Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)

A. Connect to the DB instance using private IPs and a VPN.
B. Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
C. Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
D. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
E. Disable the publicly accessible setting.
F. Move the DB instance to a private subnet using AWS DMS.

正解: A,D,E

質問 67
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. Enable the query cache at the instance level.
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. Modify the client connection timeout to 300 seconds.

正解: A

質問 68
A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application experiences more traffic during the morning and evening hours.
This application has two parts:
An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.
A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data.
A database specialist needs to design a cost-effective database solution to handle this workload. Which solution meets these requirements?

A. 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.
B. 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.
C. 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.
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 Amazon Athena, which is used by the CRM.

正解: D

質問 69
A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

A. Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase
B. Use AccessList Controls policy type to restrict users for database instance deletion
C. Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations
D. Grant least privilege to groups, users, and roles
E. Use policy conditions to restrict access to selective IP addresses
F. Enable AWS CloudTrail logging and Enhanced Monitoring

正解: C,D,E

質問 70
A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database.
Which solution meets these requirements?

A. Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.
B. Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
C. Use AWS Resource Access Manager to share the source DB instance with the destination account.
Create a DB instance in the destination account using the shared resource.
D. Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.

正解: A

解説:
Explanation
Sharing an unencrypted manual DB snapshot enables authorized AWS accounts to directly restore a DB instance from the snapshot instead of taking a copy of it and restoring from that.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html However Resource Access Manager could not share non-Aurora cluster.
https://docs.aws.amazon.com/ram/latest/userguide/shareable.html

質問 71
A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:
ERROR: cloud not write block 7507718 of temporary file: No space left on device What is the cause of this error and what should the Database Specialist do to resolve this issue?

A. The local storage used to store temporary tables is full. The Database Specialist needs to enable localstorage scaling.
B. The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs toenable Aurora storage scaling.
C. The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs tomodify the workload to load the data slowly.
D. The local storage used to store temporary tables is full. The Database Specialist needs to scale up theinstance.

正解: D

質問 72
A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime.
Which solution would meet these requirements?

A. Create a snapshot of the old databases and restore the snapshot with the required storage
B. Create a new database using native backup and restore
C. Create a new read replica and make it the primary by terminating the existing primary
D. Create a new RDS DB instance with the required storage and move the databases from the old instancesto the new instance using AWS DMS

正解: A

質問 73
A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.
What should the Database Specialist do to meet these requirements?

A. Create logical dumps of the production cluster and restore them into new test clusters
B. Use database cloning to create clones of the production cluster
C. Restore a snapshot from the production cluster into test clusters
D. Add an additional read replica to the production cluster and use that node for testing

正解: B

解説:
Explanation
https://aws.amazon.com/getting-started/hands-on/aurora-cloning-backtracking/
"Cloning an Aurora cluster is extremely useful if you want to assess the impact of changes to your database, or if you need to perform workload-intensive operations-such as exporting data or running analytical queries, or simply if you want to use a copy of your production database in a development or testing environment. You can make multiple clones of your Aurora DB cluster. You can even create additional clones from other clones, with the constraint that the clone databases must be created in the same region as the source databases.

質問 74
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?

A. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.
B. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and set up replication to a MySQL DB instance running on Amazon EC2.
C. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.
D. Add a read replica and promote it to an Amazon Aurora MySQL DB cluster master. Then enable Amazon Aurora Serverless.

正解: C

質問 75
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 composite primary key with game_id as the partition key and user_id as the sort key
B. Create a global secondary index with game_id as the partition key
C. Create a global secondary index with user_id as the partition key
D. Create a composite primary key with user_id as the partition key and game_id as the sort key

正解: C

質問 76
An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second. The number of orders and exact schedule for the sale will vary each day. During the sale, approximately 10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low. The acceptable performance for read/write queries should be under 25 ms. Order items are about 2 KB in size and have a unique identifier. The company requires the most cost-effective solution that will automatically scale and is highly available.
Which solution meets these requirements?

A. Amazon Aurora with one writer node and two cross-Region Aurora Replicas
B. Amazon Aurora with one writer node and an Aurora Replica with the parallel query feature enabled
C. Amazon DynamoDB with on-demand capacity mode
D. Amazon DynamoDB with provisioned capacity mode with 5,000 write capacity units (WCUs) and
10,000 read capacity units (RCUs)

正解: C

解説:
Explanation
The number of orders and exact schedule for the sale will vary each day. During the sale, approximately
10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low ==> Setting provisioning DynamoDB fix read 5000/write 10000 with will waste the resource when the traffic is low. It is not cost-effective.

質問 77
A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on-premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit.
Which approach has the least risk and the highest likelihood of a successful data transfer?

A. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, use a fleet of10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data from on-premises toAmazon S3 with AWS KMS encryption. Use AWS Glue to load the data to Amazon redshift.
B. Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage a nativedatabase export feature to export the data and compress the files. Use the aws S3 cp multi-port uploadcommand to upload these files to Amazon S3 with AWS KMS encryption. Once complete, load the data toAmazon Redshift using AWS Glue.
C. Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage AWSSCT and apply the converted schema to Amazon Redshift. Once complete, start an AWS DMS task tomove the data from the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to AmazonRedshift.
D. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Start an AWS DMS task withtwo AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryption.Use AWS DMS to finish copying data to Amazon Redshift.

正解: A

質問 78
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 read replicas before stopping their source instances
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 source instances before stopping their read replicas

正解: C

質問 79
A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company's disaster recovery policies, the database backup needs to be copied into another Region. The company requires the solution to be cost-effective and operationally efficient.
What should a Database Specialist do to copy the database backup into a different Region?

A. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region
B. Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
C. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica
D. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region

正解: C

質問 80
A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?

A. In the same VPC and Availability Zone as the source DB instance
B. In the same VPC and Availability Zone as the target DB instance
C. In the same Region and VPC of the source DB instance
D. In the same Region and VPC as the target DB instance

正解: B

解説:
Explanation
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html#CHAP_ReplicationIn In fact, all the configurations list on above url prefer the replication instance putting into target vpc region / subnet / az.
https://docs.aws.amazon.com/dms/latest/sbs/CHAP_SQLServer2Aurora.Steps.CreateReplicationInstance.html

質問 81
......

Amazon DBS-C01 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Determine data preparation and migration strategies Automate database solution deployments
トピック 2	Recognize potential security vulnerabilities within database solutions Workload-Specific Database Design
トピック 3	Determine monitoring and alerting strategies Troubleshootand resolve common database issues
トピック 4	Evaluateauditing solutions Deployment and Migration Management and Operations Database Security
トピック 5	Comparethe costs of database solutions Determinemaintenance tasks and processes Determinebackup and restore strategies
トピック 6	Encryptdata atrest and intransit Executeand validate data migration Monitoring and Troubleshooting