[2023年12月31日] DBS-C01のPDFで最近更新された問題です集試験点数を伸ばそう
DBS-C01完全版問題集には無料PDF問題で合格させる
Amazon AWS認定データベース-Specialty（DBS -C01）試験は、データベースの概念を完全に理解し、AWSのデータベースソリューションの設計、展開、管理に必要なスキルを持っている個人向けに設計されています。この認定は、DynamoDB、RDS、RedshiftなどのAWSデータベースサービスを操作するために必要な技術的スキルと知識を検証します。
Amazon DBS-C01（AWS認定データベース - 専門（DBS-C01））認定試験は、AWSデータベースサービスで働くデータベース管理者、開発者、およびアーキテクトにとって貴重な認定です。この認定は、AWSデータベースソリューションの設計、展開、および管理の候補者のスキルをテストするように設計されています。この試験に合格するには、候補者はAWSサービス、データベース、およびSQLの基本的な知識を確実に理解する必要があります。この認定により、専門家はキャリアの見通しを強化し、AWSデータベースサービスの専門知識を実証できます。
質問 # 158
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. Enable the query cache at the instance level.
- C. Set the max_connections parameter to 16,000 in the instance-level parameter group.
- D. Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
正解：D
解説：
Explanation
Amazon RDS Proxy allows applications to pool and share connections established with the database, improving database efficiency and application scalability. With RDS Proxy, failover times for Aurora and RDS databases are reduced by up to 66% and database credentials, authentication, and access can be managed through integration with AWS Secrets Manager and AWS Identity and Access Management (IAM).
https://aws.amazon.com/rds/proxy/
質問 # 159
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 AWS DMS to migrate data from DynamoDB to Amazon DocumentDB
- B. Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift
- C. Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance
- D. Use DynamoDB Accelerator to offload the reads
正解：D
解説：
Explanation
https://docs.amazonaws.cn/en_us/amazondynamodb/latest/developerguide/DAX.html
"Applications that are read-intensive, but are also cost-sensitive. With DynamoDB, you provision the number of reads per second that your application requires. If read activity increases, you can increase your tables' provisioned read throughput (at an additional cost). Or, you can offload the activity from your application to a DAX cluster, and reduce the number of read capacity units that you need to purchase otherwise."
質問 # 160
A corporation intends to migrate a 500-GB Oracle database to Amazon Aurora PostgreSQL utilizing the AWS Schema Conversion Tool (AWS SCT) and AWS Data Management Service (AWS DMS). The database does not have any stored procedures, but does contain several huge or partitioned tables. Because the program is vital to the company, it is preferable to migrate with little downtime.
Which measures should a database professional perform in combination to expedite the transfer process?
(Select three.)
- A. For the large tables, create a table settings rule with a parallel load option in AWS DMS, then perform a full load using DMS.
- B. Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover date.
- C. Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.
- D. Use AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous replication.
- E. For the large tables, change the setting for the maximum number of tables to load in parallel and perform a full load using AWS DMS.
- F. Use the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora PostgreSQL.
正解：A、B、C
質問 # 161
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. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.
- C. Create a support request and work with AWS Support to identify the source of the issue.
- D. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
正解：B
解説：
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/
質問 # 162
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. 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.
- B. 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. 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.
- D. 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.
正解：A
解説：
If you want to enable cross-Region snapshot copy for an AWS KMS-encrypted cluster, you must configure a snapshot copy grant for a root key in the destination AWS Region Source-Region : configure a cross-Region snapshot for an AWS KMS-encrypted cluster In Destination AWS Region : choose the AWS Region to which to copy snapshots. https://docs.aws.amazon.com/redshift/latest/mgmt/managing-snapshots-console.html#xregioncopy-kms-encrypted-snapshot
質問 # 163
A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas.
How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application?
- A. Start a database activity stream on the DB cluster
- B. Enable Enhanced Monitoring on the DB cluster
- C. Call the AWS CLI failover-db-cluster command
- D. Set the TCP keepalive parameters low
正解：D
解説：
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html#Auro
質問 # 164
A Database Specialist is constructing a new Amazon Neptune DB cluster and tries to load data from Amazon S3 using the Neptune bulk loader API. The Database Specialist is confronted with the following error message:
Unable to establish a connection to the s3 endpoint.
The source URL is s3:/mybucket/graphdata/ and the region code is us-east-1. Kindly confirm your Configuration S3.
Which of the following activities should the Database Specialist take to resolve the issue? (Select two.)
- A. Check that an Amazon S3 VPC endpoint exists
- B. Check that Amazon S3 has an IAM role granting read access to Neptune
- C. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
- D. Check that a Neptune VPC endpoint exists
- E. Check that Neptune has an IAM role granting read access to Amazon S3
正解：A、E
解説：
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-tutorial-IAM.html
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-data.html
"An IAM role for the Neptune DB instance to assume that has an IAM policy that allows access to the data files in the S3 bucket. The policy must grant Read and List permissions." "An Amazon S3 VPC endpoint. For more information, see the Creating an Amazon S3 VPC Endpoint section."
質問 # 165
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 set the throughput to the peak value.
- C. Switch the table to provisioned mode and enable auto scaling.
- D. Create a DynamoDB Accelerator cluster and use it to access the DynamoDB table.
正解：C
質問 # 166
A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.
What might account for this? (Choose two.)
- A. The new minor version has not yet been designated as preferred and requires a manual upgrade.
- B. Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.
- C. Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.
- D. The AWS CLI command did not include an apply-immediately parameter.
- E. Applying minor version upgrades requires sufficient free space.
正解：A、D
解説：
Explanation
"When Amazon RDS designates a minor engine version as the preferred minor engine version, each database that meets both of the following conditions is upgraded to the minor engine version automatically"
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Upgrading.html
Call the modify-db-instance Amazon CLI command. Specify the name of your DB instance for the --db-instance-identifier option and true for the --auto-minor-version-upgrade option. Optionally, specify the --apply-immediately option to immediately enable this setting for your DB instance. Run a separate modify-db-instance command for each DB instance in the cluster.
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.Patching.html#
質問 # 167
A company has two separate AWS accounts: one for the business unit and another for corporate analytics. The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1. The company wants to use AWS DMS with Amazon RDS as the source endpoint and Amazon Redshift as the target endpoint.
Which action will allow AVS DMS to perform the replication?
- A. Configure the AWS DMS replication instance in the same account as Amazon Redshift and in the same Region as Amazon RDS.
- B. Configure the AWS DMS replication instance in its own account and in the same Region as Amazon Redshift.
- C. Configure the AWS DMS replication instance in the same account and Region as Amazon RDS.
- D. Configure the AWS DMS replication instance in the same account and Region as Amazon Redshift.
正解：B
質問 # 168
A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT department has established an AWS Direct Connect link from the company's data center. The company's Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from being set over the network. The migration appears to be working successfully, and the data can be queried from a desktop machine.
Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster. Both Analysts are unable to connect to Aurora. Their user names and passwords have been verified as valid and the Database Specialist can connect to the DB cluster using their accounts. The Database Specialist also verified that the security group configuration allows network from all corporate IP addresses.
What should the Database Specialist do to correct the Data Analysts' inability to connect?
- A. Instruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.
- B. Add explicit mappings between the Data Analysts' IP addresses and the instance in the security group assigned to the DB cluster.
- C. Restart the DB cluster to apply the SSL change.
- D. Modify the Data Analysts' local client firewall to allow network traffic to AWS.
正解：D
質問 # 169
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. Create an AWS Lambda function that monitors DB security group changes. Create an Amazon Simple Notification Service (Amazon SNS) topic for notification.
- B. Turn on AWS CloudTrail. Configure notifications for the detection of changes to DB security groups.
- C. Configure an RDS event notification subscription for DB security group events.
- D. Configure an Amazon CloudWatch alarm for RDS metrics about changes to DB security groups.
正解：C
解説：
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html#USER_Events.Mess
質問 # 170
A large company has a variety of Amazon DB clusters. Each of these clusters has various configurations that adhere to various requirements. Depending on the team and use case, these configurations can be organized into broader categories.
A database administrator wants to make the process of storing and modifying these parameters more systematic. The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.
Which AWS service or feature will help automate and achieve this objective?
- A. AWS Config
- B. AWS Systems Manager Parameter Store
- C. AWS Secrets Manager
- D. DB parameter group
正解：D
質問 # 171
A database specialist is working on an Amazon RDS for PostgreSQL DB instance that is experiencing application performance issues due to the addition of new workloads.
The database has SSD of storage space with Provisioned IOPS.
Amazon CloudWatch metrics show that the average disk queue depth is greater than 200 and that the disk I/O response time is significantly higher than usual.
What should the database specialist do to improve the performance of the application immediately?
- A. Increase the available storage space.
- B. Use General Purpose SSD (gp2) storage with burst credits.
- C. Increase the Provisioned IOPS rate on the storage.
- D. Create a read replica to offload Read IOPS from the DB instance.
正解：C
質問 # 172
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. Ensure the DynamoDB table is configured to be always consistent.
- C. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.
- D. 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
解説：
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/API_BatchGetItem_v20111205.html 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.
質問 # 173
A company has a 20 TB production Amazon Aurora DB cluster. The company runs a large batch job overnight to load data into the Aurora DB cluster. To ensure the company's development team has the most up-to-date data for testing, a copy of the DB cluster must be available in the shortest possible time after the batch job completes.
How should this be accomplished?
- A. Schedule a job to create a clone of the DB cluster at the end of the overnight batch process.
- B. Use the AWS CLI to schedule a manual snapshot of the DB cluster. Restore the snapshot to a new DB cluster using the AWS CLI.
- C. Set up a new daily AWS DMS task that will use cloning and change data capture (CDC) on the DB cluster to copy the data to a new DB cluster. Set up a time for the AWS DMS stream to stop when the new cluster is current.
- D. Create a dump file from the DB cluster. Load the dump file into a new DB cluster.
正解：A
質問 # 174
An online bookstore uses Amazon Aurora MySQL as its backend database. After the online bookstore added a popular book to the online catalog, customers began reporting intermittent timeouts on the checkout page. A database specialist determined that increased load was causing locking contention on the database. The database specialist wants to automatically detect and diagnose database performance issues and to resolve bottlenecks faster.
Which solution will meet these requirements?
- A. Create a CPU usage alarm. Select the CPU utilization metric for the DB instance. Create an Amazon Simple Notification Service (Amazon SNS) topic to notify the database specialist when CPU utilization is over 75%.
- B. Use the Amazon RDS query editor to get the process ID of the query that is causing the database to lock.
Run a command to end the process. - C. Use the SELECT INTO OUTFILE S3 statement to query data from the database. Save the data directly to an Amazon S3 bucket. Use Amazon Athena to analyze the files for long-running queries.
- D. Turn on Performance Insights for the Aurora MySQL database. Configure and turn on Amazon DevOps Guru for RDS.
正解：D
解説：
Explanation from Amazon documents:
Performance Insights is a feature of Amazon Aurora MySQL that helps you quickly assess the load on your database and determine when and where to take action. Performance Insights displays a dashboard that shows the database load in terms of average active sessions (AAS), which is the average number of sessions that are actively running SQL statements at any given time. Performance Insights also shows the top SQL statements, waits, hosts, and users that are contributing to the database load.
Amazon DevOps Guru is a fully managed service that helps you improve the operational performance and availability of your applications by detecting operational issues and recommending specific actions for remediation. Amazon DevOps Guru applies machine learning to automatically analyze data such as application metrics, logs, events, and traces for behaviors that deviate from normal operating patterns. Amazon DevOps Guru supports Amazon RDS as a resource type and can monitor the performance and availability of your RDS databases.
By turning on Performance Insights for the Aurora MySQL database and configuring and turning on Amazon DevOps Guru for RDS, the database specialist can automatically detect and diagnose database performance issues and resolve bottlenecks faster. This solution will allow the database specialist to monitor the database load and identify the root causes of performance problems using Performance Insights, and receive actionable insights and recommendations from Amazon DevOps Guru to improve the operational performance and availability of the database.
Therefore, option A is the correct solution to meet the requirements. Option B is not sufficient because creating a CPU usage alarm will only notify the database specialist when the CPU utilization is high, but it will not help diagnose or resolve the database performance issues. Option C is not efficient because using the Amazon RDS query editor to get the process ID of the query that is causing the database to lock and running a command to end the process will require manual intervention and may cause data loss or inconsistency. Option D is not efficient because using the SELECT INTO OUTFILE S3 statement to query data from the database and saving the data directly to an Amazon S3 bucket will incur additional time and cost, and using Amazon Athena to analyze the files for long-running queries will not help prevent or resolve locking contention on the database.
質問 # 175
A manufacturing company has an. inventory system that stores information in an Amazon Aurora MySQL DB cluster. The database tables are partitioned. The database size has grown to 3 TB. Users run one-time queries by using a SQL client. Queries that use an equijoin to join large tables are taking a long time to run.
Which action will improve query performance with the LEAST operational effort?
- A. Migrate the database to a new Amazon Redshift data warehouse.
- B. Add an Aurora read replica.
- C. Take a snapshot of the DB cluster. Create a new DB instance by using the snapshot, and enable parallel query mode.
- D. Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.
正解：D
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.BestPractices.html
質問 # 176
......
100%更新されたのはAmazon DBS-C01限定版PDF問題集：https://www.jpntest.com/shiken/DBS-C01-mondaishu
無料AWS Certified Database DBS-C01公式認定ガイドPDFダウンロード：https://drive.google.com/open?id=1ea6pMidc_CtjBbEhjkw8EeCIW9XYu4Tj