AWS-Certified-Database-Specialty問題集には練習試験問題解答 [Q71-Q95]

AWS-Certified-Database-Specialty問題集には練習試験問題解答

AWS-Certified-Database-SpecialtyはAWS Certified Database実際の無料試験練習テスト

質問 71
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 new RDS DB instance with the required storage and move the databases from the old instancesto the new instance using AWS DMS
B. Create a snapshot of the old databases and restore the snapshot with the required storage
C. Create a new database using native backup and restore
D. Create a new read replica and make it the primary by terminating the existing primary

正解: B

質問 72
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 Systems Manager Parameter Store
B. AWS Secrets Manager
C. DB parameter group
D. AWS Config

正解: C

質問 73
Developers have requested a new Amazon Redshift cluster so they can load new third-party marketing dat a. The new cluster is ready and the user credentials are given to the developers. The developers indicate that their copy jobs fail with the following error message:
"Amazon Invalid operation: S3ServiceException:Access Denied,Status 403,Error AccessDenied." The developers need to load this data soon, so a database specialist must act quickly to solve this issue.
What is the MOST secure solution?

A. Create a new IAM role with read-only access to the Amazon S3 bucket with the assume role action. Add this role to the developer IAM user ID used for the copy job that ended with an error message.
B. Create a new IAM user with access keys and a new role with read-only access to the Amazon S3 bucket. Add this role to the Amazon Redshift cluster. Change the copy job to use the access keys created.
C. Create a new IAM role with the same user name as the Amazon Redshift developer user ID. Provide the IAM role with read-only access to Amazon S3 with the assume role action.
D. Create a new IAM role with read-only access to the Amazon S3 bucket and include the assume role action. Modify the Amazon Redshift cluster to add the IAM role.

正解: B

質問 74
An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company's Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.
What should the database specialist do to achieve this? (Choose two.)

A. Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
B. Enable email notifications for AWS Trusted Advisor.
C. Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
D. Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
E. Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.

正解: C,D

質問 75
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. 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
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. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region

正解: C

質問 76
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. Tests were run on the database after work hours, which generated additional database logs. The free storage of the RDS DB instance is low due to these additional logs.
What should the company do to address this space constraint issue?

A. Create a ticket with AWS Support to have the logs deleted
B. Log in to the host and run the rm $PGDATA/pg_logs/* command
C. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to bedeleted
D. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs

正解: C

質問 77
A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table.
The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table.
To prepare the new table with identical settings, which steps should be performed? (Choose two.)

A. Define the TTL settings
B. Encrypt the table from the AWS Management Console or use the update-table command
C. Set the provisioned read and write capacity
D. Re-create global secondary indexes in the new table
E. Define IAM policies for access to the new table

正解: C,D

質問 78
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. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
B. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.
C. Add a global secondary index on Invoice ID to the existing table.
D. Add a local secondary index on Invoice ID to the existing table.

正解: A

質問 79
An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora.
Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

A. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPUconsumption.
B. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoingreplication using AWS DMS change data capture (CDC).
C. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
D. Provision a clone of the existing DB cluster for the new Application team.

正解: C

質問 80
A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi- AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance.
Which approach should the database specialist to take to resolve this issue without changing the application?

A. Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).
B. Add an RDS for MySQL read replica.
C. Implementing sharding to distribute the load to multiple RDS for MySQL databases.
D. Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.

正解: B

質問 81
A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

A. Create an Amazon DocumentDB cluster
B. Create an Amazon DynamoDB table with on-demand capacity mode
C. Create an Amazon DynamoDB table with provisioned capacity mode
D. Create an Amazon Aurora Serverless DB cluster

正解: B

質問 82
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. 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.
B. 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.
C. Schedule a job to create a clone of the DB cluster at the end of the overnight batch process.
D. Create a dump file from the DB cluster. Load the dump file into a new DB cluster.

正解: C

質問 83
A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306. The company's Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a "could not connect to server: Connection times out" error message to Amazon CloudWatch Logs.
What is the cause of this error?

A. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
B. The user name and password the application is using are incorrect.
C. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
D. The user name and password are correct, but the user is not authorized to use the DB instance.

正解: A

質問 84
After restoring an Amazon RDS snapshot from 3 days ago, a company's Development team cannot connect tothe restored RDS DB instance. What is the likely cause of this problem?

A. The production DB instance is using a custom parameter group
B. The restored DB instance is using the default security group
C. The restored DB instance does not have Enhanced Monitoring enabled
D. The production DB instance is using a custom option group

正解: A

質問 85
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 MySQL cluster
B. Amazon RDS for MySQL with read replica
C. Amazon RDS for MySQL with Multi-AZ
D. Amazon Aurora Serverless MySQL cluster

正解: A

質問 86
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 scale up theinstance.
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 enable localstorage scaling.

正解: A

質問 87
A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend. A custom stored procedure is used to send email notifications to another system when data is inserted into a table. The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams. The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.
Which AWS solution meets these requirements?

A. Use Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications. Configure Amazon RDS event subscriptions to publish a message to an Amazon SNS topic and subscribe the other system's email address to the topic.
B. Use Amazon Aurora MySQL with a read replica for the reporting applications. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topic. Subscribe the other system's email address to the topic.
C. Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting applications. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.
D. Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting applications. Configure Amazon SES integration to send email notifications to the other system.

正解: B

質問 88
A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after- the-fact analyses.
What should a Database Specialist do to meet these requirements with minimal effort?

A. Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
B. Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Logs. Change the log retention policy for the log group to expire the events after 90 days.
C. Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.
D. Modify the RDS databases to publish log to Amazon CloudWatch Logs. Change the log retention policy for each log group to expire the events after 90 days.

正解: A

質問 89
A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Auror a. The cost for the database migration must be kept to a minimum, and both the on-premises Oracle database and the Aurora DB cluster must remain open for write traffic until the company is ready to completely cut over to Aurora.
Which combination of actions should a database specialist take to accomplish this migration as quickly as possible? (Choose two.)

A. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Select the migration type to replicate ongoing changes to keep the source and target databases in sync until the company is ready to move all user traffic to the Aurora DB cluster.
B. Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster.
C. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS Kinesis Data Firehose stream to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
D. Create an AWS Glue job and related resources to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS DMS task to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
E. Use Oracle's Data Pump tool to export a copy of the source database schema and manually edit the schema in a text editor to make it compatible with Aurora.

正解: B,C

質問 90
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 fail as the most recent modification was too soon.
D. The request will succeed only if the primary instance is in active status.

正解: D

質問 91
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 pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
C. Disable the publicly accessible setting.
D. Move the DB instance to a private subnet using AWS DMS.
E. Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
F. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.

正解: A,C,F

質問 92
An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)

A. Set TerminationProtection to True
B. Set MultiAZ to True
C. Set DeletionPolicy to Retain
D. Set DeleteAutomatedBackups to False
E. Set DeletionProtection to True
F. Set DeletionPolicy to Delete

正解: A,C,E

質問 93
The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

A. Use pg_audit to generate audit logs and send the logs to the Security team.
B. Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
C. Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.
D. Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.

正解: B

質問 94
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 and use AWS Lambda to copy the snapshot into another Region
B. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a secondLambda function to copy the snapshot into another Region
C. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication tocopy the snapshot into another Region
D. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot ofthe read replica

正解: D

質問 95
......

Amazon AWS-Certified-Database-Specialty 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Determine access control and authentication mechanisms Determine strategies for disaster recovery and high availability
トピック 2	Encryptdata atrest and intransit Executeand validate data migration Monitoring and Troubleshooting
トピック 3	Determine monitoring and alerting strategies Troubleshootand resolve common database issues
トピック 4	Determine data preparation and migration strategies Automate database solution deployments
トピック 5	Recognize potential security vulnerabilities within database solutions Workload-Specific Database Design
トピック 6	Evaluateauditing solutions Deployment and Migration Management and Operations Database Security
トピック 7	Managethe operational environment of a database solutionDomain Design database solutions for performance, compliance, and scalability