[2023年更新]DBS-C01はAWS Certified Databaseリアルな無料試験練習テスト
無料AWS Certified Database DBS-C01試験問題を提供します
Amazon AWS-CERTIFIED-DATABASEスペシャリティ（AWS認定データベース - 専門（DBS-C01））認定試験は、AWS環境でのデータベース管理におけるスキルと専門知識を検証したい専門家のための求められている認定です。データベーステクノロジーの強力なバックグラウンドを持ち、AWSでデータベースの設計、展開、管理の習熟度を実証したい個人向けに設計されています。
質問 # 108
Recently, a financial institution created a portfolio management service. The application's backend is powered by Amazon Aurora, which supports MySQL.
The firm demands a response time of five minutes and a response time of five minutes. A database professional must create a disaster recovery system that is both efficient and has a low replication latency.
How should the database professional tackle these requirements?
- A. Configure a cross-Region read replica.
- B. Configure AWS Database Migration Service (AWS DMS) and create a replica in a different AWS Region.
- C. Configure an Amazon Aurora global database and add a different AWS Region.
- D. Configure a binlog and create a replica in a different AWS Region.
正解：C
解説：
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-disaster-recovery.html
https://aws.amazon.com/blogs/database/how-to-choose-the-best-disaster-recovery-option-for-your-amazon-aurora-mysql-cluster/
https://aws.amazon.com/about-aws/whats-new/2019/11/aurora-supports-in-place-conversion-to-global-database/
質問 # 109
An electric utility company wants to store power plant sensor data in an Amazon DynamoDB table. The utility company has over 100 power plants and each power plant has over 200 sensors that send data every 2 seconds.
The sensor data includes time with milliseconds precision, a value, and a fault attribute if the sensor is malfunctioning. Power plants are identified by a globally unique identifier. Sensors are identified by a unique identifier within each power plant. A database specialist needs to design the table to support an efficient method of finding all faulty sensors within a given power plant.
Which schema should the database specialist use when creating the DynamoDB table to achieve the fastest query time when looking for faulty sensors?
- A. Use the plant identifier as the partition key and the sensor identifier as the sort key. Create a local secondary index (LSI) on the fault attribute.
- B. Use the plant identifier as the partition key and the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.
- C. Create a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.
- D. Create a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a local secondary index (LSI) on the fault attribute.
正解：A
解説：
Explanation
Plant id as partition key and Sensor id as a sort key. Fault can be identified quickly using the local secondary index and associated plant and sensor can be identified easily.
質問 # 110
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 Region and VPC of the source DB instance
- C. In the same Region and VPC as the target DB instance
- D. In the same VPC and Availability Zone as the target DB instance
正解：D
解説：
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html#CHAP_ReplicationInstance.VPC.Configurations.ScenarioVPCPeer 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
質問 # 111
A business is operating an on-premises application that is divided into three tiers: web, application, and MySQL database. The database is predominantly accessed during business hours, with occasional bursts of activity throughout the day. As part of the company's shift to AWS, a database expert wants to increase the availability and minimize the cost of the MySQL database tier.
Which MySQL database choice satisfies these criteria?
- A. Amazon Aurora MySQL cluster
- B. Amazon RDS for MySQL with read replica
- C. Amazon Aurora Serverless MySQL cluster
- D. Amazon RDS for MySQL with Multi-AZ
正解：C
解説：
Amazon Aurora Serverless v1 is a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. https://aws.amazon.com/rds/aurora/serverless/
質問 # 112
A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application. The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.
How can the database specialist minimize the performance degradation after failover?
- A. Enable cluster cache management for the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-0
- B. Enable cluster cache management tor the Aurora DB cluster and set the promotion priority for the writer DB instance and replica to tier-1
- C. Enable Query Plan Management for the Aurora DB cluster and perform a manual plan capture
- D. Enable Query Plan Management for the Aurora DB cluster and force the query optimizer to use the desired plan
正解：A
解説：
Explanation from Amazon documents:
Amazon Aurora PostgreSQL supports cluster cache management, which is a feature that helps reduce the impact of failover on query performance by preserving the cache of the primary DB instance on one or more Aurora Replicas. Cluster cache management allows you to assign a promotion priority tier to each DB instance in your Aurora DB cluster. The promotion priority tier determines the order in which Aurora Replicas are considered for promotion to the primary instance after a failover. The lower the numerical value of the tier, the higher the priority.
By enabling cluster cache management for the Aurora DB cluster and setting the promotion priority for the writer DB instance and replica to tier-0, the database specialist can minimize the performance degradation after failover. This solution will ensure that the primary DB instance and one Aurora Replica have the same cache contents and are in the same promotion priority tier. In the event of a failover, Aurora will promote the tier-0 replica to the primary role, and the cache will be preserved. This will reduce the number of cache misses and improve query performance after failover.
Therefore, option A is the correct solution to minimize the performance degradation after failover. Option B is incorrect because setting the promotion priority for the writer DB instance and replica to tier-1 will not preserve the cache after failover. Aurora will first try to promote a tier-0 replica, which may have a different cache than the primary instance. Option C is incorrect because enabling Query Plan Management and performing a manual plan capture will not affect the cache behavior after failover. Query Plan Management is a feature that helps you control query execution plans and improve query performance by creating and enforcing custom execution plans. Option D is incorrect because enabling Query Plan Management and forcing the query optimizer to use the desired plan will not affect the cache behavior after failover. Forcing the query optimizer to use a desired plan may improve query performance by avoiding suboptimal plans, but it will not prevent cache misses after failover.
質問 # 113
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 Amazon EC2 has an IAM role granting read access to Amazon S3
- B. Check that Amazon S3 has an IAM role granting read access to Neptune
- C. Check that an Amazon S3 VPC endpoint exists
- D. Check that a Neptune VPC endpoint exists
- E. Check that Neptune has an IAM role granting read access to Amazon S3
正解：C、E
解説：
Explanation
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."
質問 # 114
An ecommerce company is running Amazon RDS for Microsoft SQL Server. The company is planning to perform testing in a development environment with production data. The development environment and the production environment are in separate AWS accounts. Both environments use AWS Key Management Service (AWS KMS) encrypted databases with both manual and automated snapshots. A database specialist needs to share a KMS encrypted production RDS snapshot with the development account.
Which combination of steps should the database specialist take to meet these requirements? (Select THREE.)
- A. Create a manual snapshot. Share the snapshot from the production account to the development account.
- B. Create an automated snapshot. Share the snapshot from the production account to the development account.
- C. Share the snapshot that is encrypted by using the development account default KMS encryption key.
- D. Allow the production account to access the development account KMS encryption key.
- E. Share the snapshot that is encrypted by using the production account custom KMS encryption key.
- F. Allow the development account to access the production account KMS encryption key.
正解：A、E、F
解説：
Explanation from Amazon documents:
To share an encrypted Amazon RDS snapshot with another account, you need to do the following123:
Create a manual snapshot of the production database. You can't share an automated snapshot directly, but you can copy it to a manual snapshot and then share it1.
Use a custom KMS encryption key for the manual snapshot. You can't share a snapshot that is encrypted using the default KMS key of the source account1.
Share the snapshot with the development account by specifying the account ID of the target account1.
Allow the development account to access the custom KMS key of the source account by adding the target account ID to the key policy of the source account2.
Copy the shared snapshot to the development account by using a KMS key of the target account2.
Therefore, option B, D, and E are the correct steps to meet the requirements. Option A is incorrect because you can't share an automated snapshot. Option C is incorrect because you can't share a snapshot that is encrypted using the default KMS key. Option F is unnecessary because the production account does not need to access the development account KMS key.
質問 # 115
A company is building a software as a service application. As part of the new user sign-on workflow, a Python script invokes the CreateTable operation using the Amazon DynamoDB API. After the call returns, the script attempts to call PutItem.
Occasionally, the PutItem request fails with a ResourceNotFoundException error, which causes the workflow to fail. The development team has confirmed that the same table name is used in the two API calls.
How should a database specialist fix this issue?
- A. Add a ConditionExpression parameter in the PutItem request.
- B. Change the application to call DescribeTable periodically until the TableStatus is ACTIVE, then call PutItem.
- C. Set the StreamEnabled property of the StreamSpecification parameter to true, then call PutItem.
- D. Add an allow statement for the dynamodb:PutItem action in a policy attached to the role used by the application creating the table.
正解：A
質問 # 116
A company is moving its fraud detection application from on premises to the AWS Cloud and is using Amazon Neptune for data storage. The company has set up a 1 Gbps AWS Direct Connect connection to migrate 25 TB of fraud detection data from the on-premises data center to a Neptune DB instance. The company already has an Amazon S3 bucket and an S3 VPC endpoint, and 80% of the company's network bandwidth is available.
How should the company perform this data load?
- A. Use AWS Database Migration Service (AWS DMS) to transfer the data from on premises to the S3 bucket. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
- B. Use the AWS CLI to transfer the data from on premises to the S3 bucket. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
- C. Use AWS DataSync to transfer the data from on premises to the S3 bucket. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
- D. Use an AWS SDK with a multipart upload to transfer the data from on premises to the S3 bucket. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
正解：C
質問 # 117
A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)
- A. Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
- B. Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
- C. Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
- D. Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.
- E. Use Amazon QuickSight to view the SQL statement being run.
正解：B、D
解説：
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/rds-instance-high-cpu/ "Several factors can cause an increase in CPU utilization. For example, user-initiated heavy workloads, analytic queries, prolonged deadlocks and lock waits, multiple concurrent transactions, long-running transactions, or other processes that utilize CPU resources. First, you can identify the source of the CPU usage by: Using Enhanced Monitoring Using Performance Insights"
質問 # 118
A database specialist deployed an Amazon RDS DB instance in Dev-VPC1 used by their development team. Dev-VPC1 has a peering connection with Dev-VPC2 that belongs to a different development team in the same department. The networking team confirmed that the routing between VPCs is correct; however, the database engineers in Dev-VPC2 are getting a timeout connections error when trying to connect to the database in Dev- VPC1.
What is likely causing the timeouts?
- A. The database is deployed in a VPC that is in a different Availability Zone.
- B. The database is deployed with misconfigured security groups.
- C. The database is deployed with the wrong client connect timeout configuration.
- D. The database is deployed in a VPC that is in a different Region.
正解：B
質問 # 119
A business is transferring a database from one AWS Region to another using an Amazon RDS for SQL Server DB instance. The organization wishes to keep database downtime to a minimum throughout the transfer.
Which migration strategy should the organization use for this cross-regional move?
- A. Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.
- B. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.
- C. Back up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.
- D. Add an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.
正解：A
解説：
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS.
質問 # 120
A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.
What is the MOST cost-effective and operationally efficient solution?
- A. Run SQL Server Standard Edition on Amazon RDS.
- B. Run SQL Server Enterprise Edition on Amazon RDS.
- C. Run SQL Server Enterprise Edition on Amazon EC2.
- D. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.
正解：D
質問 # 121
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
解説：
https://aws.amazon.com/about-aws/whats-new/2018/11/amazon-aurora-simplifies-workload-management-with-custom-endpoints/ 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.
質問 # 122
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. Run the SELECT rds_rotate_error_log() stored procedure to rotate the logs
- B. Modify the rds.log_retention_period parameter to 1440 and wait up to 24 hours for database logs to be deleted
- C. Create a ticket with AWS Support to have the logs deleted
- D. Log in to the host and run the rm $PGDATA/pg_logs/* command
正解：B
解説：
Explanation
To set the retention period for system logs, use the rds.log_retention_period parameter. You can find rds.log_retention_period in the DB parameter group associated with your DB instance. The unit for this parameter is minutes. For example, a setting of 1,440 retains logs for one day. The default value is 4,320 (three days). The maximum value is 10,080 (seven days).
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.Concepts.PostgreSQL.ht
質問 # 123
A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify:
The networks and routes affected if a particular component fails.
The networks that have redundant routes between them.
The networks that do not have redundant routes between them.
The fastest path between two networks.
Which database engine meets these requirements?
- A. Amazon DynamoDB
- B. Amazon ElastiCache for Redis
- C. Amazon Neptune
- D. Amazon Aurora MySQL
正解：C
質問 # 124
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. Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.
- B. Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
- C. Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
- D. Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.
正解：D
解説：
Explanation
https://docs.aws.amazon.com/vpc/latest/peering/vpc-peering-security-groups.html
質問 # 125
A company is running a finance application on an Amazon RDS for MySQL DB instance. The application is governed by multiple financial regulatory agencies. The RDS DB instance is set up with security groups to allow access to certain Amazon EC2 servers only. AWS KMS is used for encryption at rest.
Which step will provide additional security?
- A. Disable the master user account
- B. Set up RDS to use SSL for data in transit
- C. Set up NACLs that allow the entire EC2 subnet to access the DB instance
- D. Set up a security group that blocks SSH to the DB instance
正解：B
質問 # 126
Amazon DynamoDB global tables are being used by a business to power an online gaming game. The game is played by gamers from all around the globe. As the game became popularity, the amount of queries to DynamoDB substantially rose. Recently, gamers have complained about the game's condition being inconsistent between nations. A database professional notices that the ReplicationLatency metric for many replica tables is set to an abnormally high value.
Which strategy will resolve the issue?
- A. Configure a DynamoDB Accelerator (DAX) cluster on each of the replicas.
- B. Configure all replica tables to use DynamoDB auto scaling.
- C. Configure the primary table to use DynamoDB auto scaling and the replica tables to use manually provisioned capacity.
- D. Configure the table-level write throughput limit service quota to a higher value.
正解：B
解説：
Explanation
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/V2globaltables_reqs_bestpractices.html
質問 # 127
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 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.
- 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. 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 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
解説：
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
質問 # 128
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. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
- B. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
- C. Enable an Amazon RDS for MySQL Multi-AZ configuration
- D. Enable a read replicas and direct read traffic to it when Amazon RDS is down
正解：D
質問 # 129
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. Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
- 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. Modify the client connection timeout to 300 seconds.
正解：A
解説：
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/
質問 # 130
A company uses a large, growing, and high performance on-premises Microsoft SQL Server instance With an Always On availability group cluster size of 120 TIE. The company uses a third-party backup product that requires system-level access to the databases. The company will continue to use this third-party backup product in the future.
The company wants to move the DB cluster to AWS with the least possible downtime and data loss. The company needs a 2 Gbps connection to sustain Always On asynchronous data replication between the company's data center and AWS.
Which combination of actions should a database specialist take to meet these requirements? (Select THREE.)
- A. Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2 Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster_ Fail over to the AWS DB cluster when it is time to migrate.
- B. Create an AWS Site-to-Site VPN connection between the companVs data center and AWS over the internet
- C. Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.
- D. Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.
- E. Establish an AWS Direct Connect hosted connection between the companfs data center and AWS
- F. Use AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server databases to Amazon RDS for SQL Server Configure Always On availability groups for SQL Server.
正解：A、D、E
解説：
Explanation
The best combination of actions to meet the company's requirements are:
A: Establish an AWS Direct Connect hosted connection between the company's data center and AWS.
This will provide a secure and high-bandwidth connection for the Always On data replication and minimize the network latency and data loss.
D: Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2. Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster.
Fail over to the AWS DB cluster when it is time to migrate. This will allow the company to use the same SQL Server version and edition as on-premises, and leverage the distributed availability group feature to span two separate availability groups across different locations. The failover process will be fast and seamless, with minimal downtime and data loss.
F: Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2. This will enable the company to continue using their existing backup solution, which requires system-level access to the databases. Amazon RDS for SQL Server does not support system-level access, so it is not a suitable option for this requirement.
質問 # 131
A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data.
How can this solution be implemented?
- A. Use the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.
- B. Use Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key.
- C. Use AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key.
- D. Use the AWS CLI to update the DynamoDB table and modify the partition key.
正解：B
解説：
https://aws.amazon.com/premiumsupport/knowledge-center/back-up-dynamodb-s3/
質問 # 132
......
DBS-C01試験は、65の複数選択と複数の応答の質問で構成されており、候補者は試験を完了するために180分かかります。この試験は、英語、日本、韓国語、および簡素化された中国語で入手できます。候補者は、テストセンターまたはオンライン監督を介して試験を受けることができます。
Amazon DBS-C01リアルな問題と知能問題集：https://www.jpntest.com/shiken/DBS-C01-mondaishu
DBS-C01問題集でAWS Certified Database高確率練習問題集：https://drive.google.com/open?id=19eXOEYre4P2SUXGuzf9zQVo97dwDs80O