DBS-C01練習試験テスト最新問題2022年04月 [Q56-Q78]

DBS-C01練習試験テスト最新問題2022年04月

DBS-C01試験を一発合格保証問題集！

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

トピック	出題範囲
トピック 1	データベースソリューションのコストを比較するメンテナンスタスクとプロセスを決定するバックアップと復元の戦略を決定する
トピック 2	監視およびアラート戦略の決定一般的なデータベースの問題のトラブルシューティングと解決
トピック 3	データの準備と移行の戦略を決定するデータベースソリューションの展開を自動化する
トピック 4	特定の種類のデータとワークロードに適したデータベースサービスを選択するデータベースのパフォーマンスを最適化する

質問 56
A company is migrating its on-premises database workloads to the AWS Cloud. A database specialist performing the move has chosen AWS DMS to migrate an Oracle database with a large table to Amazon RDS.
The database specialist notices that AWS DMS is taking significant time to migrate the data.
Which actions would improve the data migration speed? (Choose three.)

A. Create multiple AWS DMS tasks to migrate the large table.
B. Enable an Amazon RDS Multi-AZ configuration.
C. Establish an AWS Direct Connect connection between the on-premises data center and AWS.
D. Increase the capacity of the AWS DMS replication server.
E. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.
F. Configure the AWS DMS replication instance with Multi-AZ.

正解: B,C,D

質問 57
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 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 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.
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

質問 58
A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort.
Which solution meets these requirements in the MOST efficient way?

A. Use Amazon DynamoDB as the database and use Amazon API Gateway
B. Use Amazon Aurora MySQL as the database and use Aurora's buffer cache
C. Use Amazon RDS for MySQL as the database and use Amazon ElastiCache
D. Use Amazon DynamoDB as the database and use DynamoDB Accelerator

正解: D

解説:
Explanation
https://aws.amazon.com/dynamodb/dax/#:~:text=Amazon%20DynamoDB%20Accelerator%20(DAX)%20is,mil
"Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to a 10x performance improvement - from milliseconds to microseconds - even at millions of requests per second. "

質問 59
A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?

A. Enable a read replicas and direct read traffic to it when Amazon RDS is down
B. Enable an Amazon RDS for MySQL Multi-AZ configuration
C. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
D. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down

正解: A

質問 60
A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live.
What change should the Database Specialist make to enable the migration?

A. Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)
B. Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)
C. Configure the AWS DMS connections to allow two-way communication to allow for ongoing change data capture (CDC)
D. Configure the AWS DMS replication instance to allow both full load and ongoing change data capture (CDC)

正解: A

解説:
Explanation
"requires minimal downtime when the RDS DB instance goes live" in order to do CDC: "you must first ensure that ARCHIVELOG MODE is on to provide information to LogMiner. AWS DMS uses LogMiner to read information from the archive logs so that AWS DMS can capture changes"
https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle2postgresql.steps.configureoracle.html
"If you want to capture and apply changes (CDC), then you also need the following privileges."

質問 61
A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?

A. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RDS.
Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
B. Create an AWS Lambda function to trigger on AWS CloudTrail API calls. Filter on specific RDS API calls and write the output to the tracking systems.
C. Write RDS logs to Amazon Kinesis Data Firehose. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
D. Create RDS event subscriptions. Have the tracking systems subscribe to specific RDS event system notifications.

正解: D

質問 62
For the first time, a database professional is establishing a test graph database on Amazon Neptune. The database expert must input millions of rows of test observations from an Amazon S3.csv file. The database professional uploaded the data to the Neptune DB instance through a series of API calls.
Which sequence of actions enables the database professional to upload the data most quickly? (Select three.)

A. Ensure an IAM role for the Neptune DB instance is configured with the appropriate permissions to allow access to the file in the S3 bucket.
B. Use AWS DMS to move data from Amazon S3 to the Neptune Loader.
C. Ensure Amazon Cognito returns the proper AWS STS tokens to authenticate the Neptune DB instance to the S3 bucket hosting the CSV file.
D. Create an S3 VPC endpoint and issue an HTTP POST to the database's loader endpoint.
E. Curl the S3 URI while inside the Neptune DB instance and then run the addVertex or addEdge commands.
F. Ensure the vertices and edges are specified in different .csv files with proper header column formatting.

正解: A,D,F

解説:
Explanation
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-optimize.html

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

A. An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards
B. Amazon DynamoDB global tables
C. An Amazon Aurora global database
D. Amazon DynamoDB streams with AWS Lambda to replicate the data

正解: B

解説:
Explanation
Aurora Global Databases provides a writer and a reader endpoints in the primary region but only a reader endpoints in other region. Although strongly consistent, it does not fulfill the requirements that "there are plenty of read / write activities" in all regions.

質問 64
A gaming company has recently acquired a successful iOS game, which is particularly popular during the holiday season. The company has decided to add a leaderboard to the game that uses Amazon DynamoDB.
The application load is expected to ramp up over the holiday season.
Which solution will meet these requirements at the lowest cost?

A. DynamoDB Streams
B. DynamoDB with on-demand capacity mode
C. DynamoDB with provisioned capacity mode with Auto Scaling
D. DynamoDB with DynamoDB Accelerator

正解: B

質問 65
The website of a manufacturing firm makes use of an Amazon Aurora PostgreSQL database cluster.
Which settings will result in the LEAST amount of downtime for the application during failover? (Select three.)

A. Set Java DNS caching timeouts to a high value.
B. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
C. Edit and enable Aurora DB cluster cache management in parameter groups.
D. Set TCP keepalive parameters to a high value.
E. Set JDBC connection string timeout variables to a low value.
F. Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.

正解: C,E,F

解説:
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.cluster-cache-mgmt.htm
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html#Auro

質問 66
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. Modify the DB instance allocated storage to meet the forecasted requirements.
C. Configure RDS instance Auto Scaling.
D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.

正解: C

質問 67
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 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.
C. 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.
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

質問 68
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. 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.
B. 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.
C. 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.
D. 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

質問 69
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 Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift
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 DynamoDB Accelerator to offload the reads

正解: A

質問 70
A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case.
A database administrator wishes to streamline the process of storing and updating these settings. Additionally, the database administrator want to guarantee that changes to certain configuration categories are automatically implemented to all instances as necessary.
Which AWS service or functionality will assist in automating and achieving this goal?

A. DB parameter group
B. AWS Systems Manager Parameter Store
C. AWS Secrets Manager
D. AWS Config

正解: A

解説:
Explanation
Database parameters specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.

質問 71
A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload.
The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise.
How can a Database Specialist address these requirements with minimal user involvement?

A. Review all evaluate the peak combined workload. Ensure that utilization of the DB cluster node is at an acceptable level. Adjust the number of instances, if necessary.
B. Split up the DB cluster into two different clusters: one for OLTP and the other for reporting. Monitor and set up replication between the two clusters to keep data consistent.
C. Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workload. The cluster can be restarted again depending on the workload at the time.
D. Set up automatic scaling on the DB cluster. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.

正解: D

質問 72
A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level.
How can the Database Specialist meet these requirements?

A. Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
B. Define access privileges to the tables containing sensitive data in the pg_hba.conf file.
C. Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
D. Use AWS IAM database authentication and restrict access to the tables using an IAM policy.

正解: C

質問 73
A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and OLAP reports for the human resources department.
To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.
Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?

A. Create additional readers to cater to the different scenarios.
B. Use custom endpoints to satisfy the different workloads.
C. Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.
D. Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.

正解: B

解説:
Explanation
https://aws.amazon.com/about-aws/whats-new/2018/11/amazon-aurora-simplifies-workload-management-with-c You can now create custom endpoints for Amazon Aurora databases. This allows you to distribute and load balance workloads across different sets of database instances in your Aurora cluster. For example, you may provision a set of Aurora Replicas to use an instance type with higher memory capacity in order to run an analytics workload. A custom endpoint can then help you route the analytics workload to these appropriately-configured instances, while keeping other instances in your cluster isolated from this workload.
As you add or remove instances from the custom endpoint to match your workload, the endpoint helps spread the load around.

質問 74
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. Stop the read replicas before stopping their source instances
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

質問 75
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. Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.
B. Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
C. Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
D. Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.

正解: A

解説:
Explanation
https://docs.aws.amazon.com/vpc/latest/peering/vpc-peering-security-groups.html

質問 76
An IT consulting company wants to reduce costs when operating its development environment databases. The company's workflow creates multiple Amazon Aurora MySQL DB clusters for each development group. The Aurora DB clusters are only used for 8 hours a day. The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.
Which of the following provides the MOST cost-effective solution?

A. Use Aurora Serverless. Restore current Aurora snapshot and deploy to a serverless cluster for each development group. Enable the option to pause the compute capacity on the cluster and set an appropriate timeout.
B. Use the Aurora DB cloning feature. Deploy a single development and test Aurora DB instance, and create clone instances for the development groups. Delete the clones at the end of the development cycle.
C. Use AWS CloudFormation templates. Deploy a stack with the DB cluster for each development group.
Delete the stack at the end of the development cycle.
D. Use Aurora Replicas. From the master automatic pause compute capacity option, create replicas for each development group, and promote each replica to master. Delete the replicas at the end of the development cycle.

正解: B

解説:
Explanation
Aurora Serverless is not compatible to all Aurora provisioned engine version. However, you can do clone with most engine version. Meanwhile, I also consider the performance while restoring snapshot to Aurora Serverless.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html#aurora
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.use

質問 77
A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)