最新なAmazon AWS-Certified-Database-Specialty問題集（325題）、真実試験の問題を全部にカバー！

質問 1：
A bike rental company operates an application to track its bikes. The application receives location and condition data from bike sensors. The application also receives rental transaction data from the associated mobile app.
The application uses Amazon DynamoDB as its database layer. The company has configured DynamoDB with provisioned capacity set to 20% above the expected peak load of the application. On an average day, DynamoDB used 22 billion read capacity units (RCUs) and 60 billion write capacity units (WCUs). The application is running well. Usage changes smoothly over the course of the day and is generally shaped like a bell curve. The timing and magnitude of peaks vary based on the weather and season, but the general shape is consistent.
Which solution will provide the MOST cost optimization of the DynamoDB database layer?
A. Use AWS Auto Scaling and configure time-based scaling.
B. Enable DynamoDB Accelerator (DAX).
C. Enable DynamoDB capacity-based auto scaling.
D. Change the DynamoDB tables to use on-demand capacity.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
A company uses Microsoft SQL Server on Amazon RDS in a Multi-AZ deployment as the database engine for its application. The company was recently acquired by another company. A database specialist must rename the database to follow a new naming standard.
Which combination of steps should the database specialist take to rename the database? (Choose two.)
A. Update the application with the new database connection string.
B. Turn off automatic snapshots for the DB instance. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on the automatic snapshots.
C. Update the DNS record for the DB instance.
D. Delete all existing snapshots for the DB instance. Use the rdsadmin.dbo.rds_modify_db_name stored procedure.
E. Turn off Multi-AZ for the DB instance. Rename the database with the
rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on Multi-AZ Mirroring.
正解：A,E
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
A company's application team needs to select an AWS managed database service to store application and user data. The application team is familiar with MySQL but is open to new solutions. The application and user data is stored in 10 tables and is de-normalized. The application will access this data through an API layer using an unique ID in each table. The company expects the traffic to be light at first, but the traffic Will Increase to thousands of transactions each second within the first year- The database service must support active reads and writes in multiple AWS Regions at the same time_ Query response times need to be less than 100 ms Which AWS database solution will meet these requirements?
A. Deploy an Amazon Aurora MySOL global database with write forwarding turned on
B. Deploy an Amazon DocumentDB global cluster across multiple Regions.
C. Deploy an Amazon RDS for MySQL environment in each Region and leverage AWS Database Migration Service (AWS DMS) to set up a multi-Region bidirectional replication
D. Deploy an Amazon DynamoDB database with global tables
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

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

質問 5：
A database specialist is building a system that uses a static vendor dataset of postal codes and related territory information that is less than 1 GB in size. The dataset is loaded into the application's cache at start up. The company needs to store this data in a way that provides the lowest cost with a low application startup time.
Which approach will meet these requirements?
A. Use Amazon Aurora Serverless. Allow the service to spin resources up and down, as needed.
B. Use Amazon DynamoDB in on-demand capacity mode.
C. Use an Amazon RDS DB instance. Shut down the instance once the data has been read.
D. Use Amazon S3 and load the data from flat files.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)