100% Real & Accurate DBS-C01 Questions and Answers with Free and Fast Updates [Q27-Q52]

100% Real & Accurate DBS-C01 Questions and Answers with Free and Fast Updates

Get Unlimited Access to DBS-C01 Certification Exam Cert Guide

Below are some steps to apply for the AWS Certified Database Specialty Exam

In order to apply for the AWS Certified Database - Specialty, You have to follow these steps

1. Sign in to AWS Training
2. Click Certification in the top navigation
3. Click AWS Certification Account Button
4. Followed by Schedule New Exam
5. Search the AWS Certified Database - Specialty exam
6. Click either the Schedule at PSI or Schedule at Pearson VUE button
7. Select Date, time and Schedule your test

 

NEW QUESTION # 27
A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an
8XL-sized instance, and the read replicas are each XL-sized instances.
Users report that database queries are returning stale data. The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary.
Which changes will reduce the lag? (Choose two.)

• A. Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.
• B. Increase the instance size of the primary DB instance within the same instance class.
• C. Increase the instance size of the read replicas to the same size and class as the primary DB instance.
• D. Deploy two additional read replicas matching the existing replica DB instance size.
• E. Move the read replicas to the same Availability Zone as the primary DB instance.

Answer: A,C

Explanation:
Explanation
https://www.quora.com/What-is-the-difference-between-a-RDS-read-replica-and-an-Amazon-Aurora-Read-repli
https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-high-replica-lag/

NEW QUESTION # 28
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. Use Amazon QuickSight to view the SQL statement being run.
• B. Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
• C. Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
• D. Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.
• E. Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.

Answer: B,D

Explanation:
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"

NEW QUESTION # 29
A company is due for renewing its database license. The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud. The migration should incur the least possible downtime on the downstream database applications. The company's network infrastructure has limited network bandwidth that is shared with other applications.
Which solution should a database specialist use for a timely migration?

• A. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Periodically perform incremental backups of the source database to be shipped in another Snowball Edge appliance to handle syncing change data capture (CDC) data from the source to the target database.
• B. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS SCT to handle syncing change data capture (CDC) data from the source to the target database.
• C. Use AWS DMS to migrate the full load of the source database over a VPN tunnel using the internet for its primary connection. Allow AWS DMS to handle syncing change data capture (CDC) data from the source to the target database.
• D. Perform a full backup of the source database to AWS Snowball Edge appliances and ship them to be loaded to Amazon S3. Use AWS DMS to migrate change data capture (CDC) data from the source database to Amazon S3. Use a second AWS DMS task to migrate all the S3 data to the target database.

Answer: D

Explanation:
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html Using Amazon S3 as a target for AWS Database Migration Service

NEW QUESTION # 30
A company wants to improve its ecommerce website on AWS. A database specialist decides to add Amazon ElastiCache for Redis in the implementation stack to ease the workload off the database and shorten the website response times. The database specialist must also ensure the ecommerce website is highly available within the company's AWS Region.
How should the database specialist deploy ElastiCache to meet this requirement?

• A. Launch an ElastiCache for Redis cluster and select read replicas in different Availability Zones.
• B. Launch an ElastiCache cluster in the primary Availability Zone and restore the cluster's snapshot to a different Availability Zone during disaster recovery.
• C. Launch two ElastiCache for Redis clusters in two different Availability Zones. Configure Redis streams to replicate the cache from the primary cluster to another.
• D. Launch an ElastiCache for Redis cluster using the AWS CLI with the -cluster-enabled switch.

Answer: A

Explanation:
Explanation
https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/AutoFailover.html You can enable Multi-AZ only on Redis (cluster mode disabled) clusters that have at least one available read replica. Clusters without read replicas do not provide high availability or fault tolerance.

NEW QUESTION # 31
A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries and stored procedures.
The company wants to minimize database server maintenance and operating costs after the migration is completed. The company also wants to minimize the need to rewrite code as part of the migration effort.
Which solution will meet these requirements?

• A. Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.
• B. Migrate the database to an Amazon EMR cluster that includes multiple primary nodes.
• C. Migrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.
• D. Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.

Answer: A

Explanation:
Correct Answer: A
Explanation from Amazon documents:
Amazon Aurora PostgreSQL is a fully managed relational database service that is compatible with PostgreSQL. Aurora PostgreSQL offers up to three times better performance than standard PostgreSQL, as well as high availability, scalability, security, and durability. Aurora PostgreSQL also supports Babelfish, which is a new feature that enables Aurora to understand queries from applications written for Microsoft SQL Server. Babelfish allows you to migrate your SQL Server databases to Aurora PostgreSQL with minimal or no code changes, and run complex T-SQL queries and stored procedures on Aurora PostgreSQL.
Migrating the database to Amazon Aurora PostgreSQL and turning on Babelfish will meet the requirements of minimizing database server maintenance and operating costs, and minimizing the need to rewrite code as part of the migration effort. This solution will allow the company to benefit from the performance, reliability, and cost-efficiency of Aurora PostgreSQL, while preserving the compatibility and functionality of SQL Server. The company will also avoid the hassle and expense of managing and licensing SQL Server on premises or on AWS.
Therefore, option A is the correct solution to meet the requirements. Option B is not suitable because Amazon S3 is an object storage service that is not designed for OLTP workloads. Amazon Redshift Spectrum is a feature that allows you to query data in S3 using Amazon Redshift, but it is not compatible with SQL Server or T-SQL. Option C is not optimal because Amazon RDS for SQL Server is a managed relational database service that supports SQL Server, but it does not offer the same performance, scalability, or cost savings as Aurora PostgreSQL. Kerberos authentication is a security feature that does not affect the migration effort or the operating costs. Option D is not suitable because Amazon EMR is a big data processing service that runs Apache Hadoop and Spark clusters, not relational databases. EMR does not support SQL Server or T-SQL, and it is not optimized for OLTP workloads.

NEW QUESTION # 32
Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.
Which procedures should the database professional do prior to establishing the read replica? (Select two.)

• A. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
• B. Modify the read replica parameter group setting and set the value to 1.
• C. Identify a potential downtime window and stop the application calls to the source DB instance.
• D. Ensure that automatic backups are enabled for the source DB instance.
• E. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).

Answer: A,D

Explanation:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

NEW QUESTION # 33
A company is running a mobile app that has a backend database in Amazon DynamoDB. The app experiences sudden increases and decreases in activity throughout the day. The companys operations team notices that DynamoDB read and write requests are being throttled at different times, resulting in a negative customer experience Which solution will solve the throttling issue without requiring changes to the app?

• A. use DynamoDB Accelerator (DAX).
• B. use on-demand capacity mode tor the DynamoDB table.
• C. Deploy an Amazon ElastiCache cluster in front of the DynamoDB table.
• D. Add a DynamoD3 table in a secondary AWS Region. Populate the additional table by using DynamoDB Streams.

Answer: B

Explanation:
Option C is correct because it solves the throttling issue without requiring changes to the app.
On-demand capacity mode is a flexible billing option for DynamoDB that automatically accommodates your workload as it ramps up or down. With on-demand mode, you pay per request for the data reads and writes your application performs on your tables, and you don't need to specify how much read and write throughput you expect. On-demand mode can handle sudden increases and decreases in activity without throttling, as long as the request rate does not exceed the default table quotas1. To use on-demand mode, you only need to update the table settings in the AWS Management Console or by using the AWS SDK2. You don't need to modify any application logic, as on-demand mode is compatible with existing DynamoDB API calls.

NEW QUESTION # 34
A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration.
The solution must also be cost-effective.
Which approach should the Database Specialist take?

• A. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an AmazonEC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to anAurora DB cluster.
• B. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once theSnowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration tomigrate the data directly from Amazon S3 to Amazon RDS.
• C. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during theschema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
• D. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp).
  Rundata transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.

Answer: A

NEW QUESTION # 35
A gaming company is designing a mobile gaming app that will be accessed by many users across the globe.
The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users.
Which solution meets these requirements?

• A. Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache
• B. Use Amazon Neptune for storage
• C. Use Amazon Aurora for storage and enable cross-Region Aurora Replicas
• D. Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling

Answer: D

NEW QUESTION # 36
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. Modify the DB instance allocated storage to meet the forecasted requirements.
• B. Configure RDS Storage Auto Scaling.
• C. Configure RDS instance Auto Scaling.
• D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.

Answer: C

NEW QUESTION # 37
A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower. The company has narrowed down the cause of this issue to the database and not the application.
Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?

• A. Modify the logging database parameter to log all the queries related to locking in the database and thencheck the logs after the next slow period for this information.
• B. Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify anyqueries that are related to spikes in the graph during the next slow period.
• C. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and diskspace consumption. Watch these dashboards during the next slow period.
• D. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring toolthat will run reports based on the output error logs.

Answer: B

NEW QUESTION # 38
A company's database specialist implements an AWS Database Migration Service (AWS DMS) task for change data capture (CDC) to replicate data from an on- premises Oracle database to Amazon S3. When usage of the company's application increases, the database specialist notices multiple hours of latency with the CDC.
Which solutions will reduce this latency? (Choose two.)

• A. Create a Multi-AZ replication instance.
• B. Replicate tables in parallel by creating multiple DMS tasks for sets of tables that do not participate in common transactions.
• C. Load tables in parallel by creating multiple replication instances for sets of tables that participate in common transactions.
• D. Configure the DMS task to run in limited large binary object (LOB) mode.
• E. Configure the DMS task to run in full large binary object (LOB) mode.

Answer: B,D

NEW QUESTION # 39
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. Create a support request and work with AWS Support to identify the source of the issue.
• B. Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.
• C. Use AWS X-Ray deployed with Amazon RDS to track query system traces.
• D. Enable RDS Performance Insights and determine which query is creating the problem. Request changes to the query to address the problem.

Answer: D

Explanation:
Explanation
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/

NEW QUESTION # 40
A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.
What could be the reason for this?

• A. When stopping the DB instance, the duration for stopping the DB instance should have been selected.
• B. Stopped DB instances will automatically restart if the instance is not manually started after 7 days.
• C. When stopping the DB instance, the option to create a snapshot should have been selected.
• D. Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.

Answer: B

Explanation:
https://aws.amazon.com/premiumsupport/knowledge-center/rds-stop-seven-days/

NEW QUESTION # 41
A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days.
Which solution will meet these requirements in the MOST operationally efficient way?

• A. Change the retention period of the snapshot to 45 days.
• B. Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.
• C. Create a manual copy of the snapshot.
• D. Export the contents of the snapshot to an Amazon S3 bucket.

Answer: C

Explanation:
Correct Answer: A
Explanation from Amazon documents:
Amazon RDS for Microsoft SQL Server supports two types of database snapshots: automated and manual. Automated snapshots are taken daily and are retained for a period of time that you specify, from 1 to 35 days. Manual snapshots are taken by you and are retained until you delete them.
To save a particular automated database snapshot for longer than the maximum number of days, the database administrator can create a manual copy of the snapshot. This can be done using the AWS Management Console, the AWS CLI, or the RDS API. The manual copy of the snapshot will be retained until it is deleted, regardless of the retention period of the automated snapshot. This solution is the most operationally efficient way to meet the requirements, because it does not require any additional steps or resources.
Therefore, option A is the correct solution to meet the requirements. Option B is not operationally efficient because it requires exporting the contents of the snapshot to an Amazon S3 bucket, which can be time-consuming and costly. Option C is not possible because the maximum retention period for automated snapshots is 35 days, not 45 days. Option D is not operationally efficient because it requires creating a native SQL Server backup and saving it to an Amazon S3 bucket, which can also be time-consuming and costly.

NEW QUESTION # 42
A company uses an Amazon Redshift cluster to run its analytical workloads. Corporate policy requires that the company's data be encrypted at rest with customer managed keys. The company's disaster recovery plan requires that backups of the cluster be copied into another AWS Region on a regular basis.
How should a database specialist automate the process of backing up the cluster data in compliance with these policies?

• A. Create a new AWS Key Management Service (AWS KMS) customer managed key in the destination Region. Create a snapshot copy grant in the destination Region specifying the new key. In the source Region, configure cross-Region snapshots for the Amazon Redshift cluster specifying the destination Region, the snapshot copy grant, and retention periods for the snapshot.
• B. Copy the AWS Key Management Service (AWS KMS) customer managed key from the source Region to the destination Region. Set up an AWS Glue job in the source Region to copy the latest snapshot of the Amazon Redshift cluster from the source Region to the destination Region. Use a time-based schedule in AWS Glue to run the job on a daily basis.
• C. Use the same customer-supplied key materials to create a CMK with the same private key in the destination Region. Configure cross-Region snapshots in the source Region targeting the destination Region. Specify the corresponding CMK in the destination Region to encrypt the snapshot.
• D. Copy the AWS Key Management Service (AWS KMS) customer-managed key from the source Region to the destination Region. Create Amazon S3 buckets in each Region using the keys from their respective Regions. Use Amazon EventBridge (Amazon CloudWatch Events) to schedule an AWS Lambda function in the source Region to copy the latest snapshot to the S3 bucket in that Region. Configure S3 Cross-Region Replication to copy the snapshots to the destination Region, specifying the source and destination KMS key IDs in the replication configuration.

Answer: A

Explanation:
Correct answer: B. Create a new AWS Key Management Service (AWS KMS)
Explanation from Amazon documents:
Amazon Redshift supports encryption at rest using AWS Key Management Service (AWS KMS) customer master keys (CMKs). To copy encrypted snapshots across Regions, you need to create a snapshot copy grant in the destination Region and specify a CMK in that Region. You also need to configure cross-Region snapshots in the source Region and provide the destination Region, the snapshot copy grant, and retention periods for the snapshots. This way, you can automate the process of backing up the cluster data in compliance with the corporate policies.
Option A is incorrect because you cannot copy a CMK from one Region to another. You can only import key material from an external source into a CMK in a specific Region. Option C is incorrect because it involves unnecessary steps of copying snapshots to S3 buckets and using S3 Cross-Region Replication. Option D is incorrect because it is not possible to create a CMK with the same private key as another CMK in a different Region. You can only use customer-supplied key material to create a CMK with a specific key ID in a specific Region.

NEW QUESTION # 43
A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.
Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)

• A. Define the database resources in a nested stack
• B. Export the database resources as stack outputs
• C. Set a stack policy for the database resources
• D. Create and review a change set before applying it
• E. Review the stack drift before modifying the template

Answer: C,D

Explanation:
Explanation
https://docs.amazonaws.cn/en_us/AWSCloudFormation/latest/UserGuide/best-practices.html#cfn-best-practices-

NEW QUESTION # 44
A company is using Amazon Redshift. A database specialist needs to allow an existing Redshift cluster to access data from other Redshift clusters. Amazon RDS for PostgreSQL databases, and AWS Glue Data Catalog tables.
Which combination of steps will meet these requirements with the MOST operational efficiency? (Choose three.)

• A. Create external tables in the existing Redshift database to connect to the AWS Glue Data Catalog tables.
• B. Use data sharing to access data from the other Redshift clusters.
• C. Take a snapshot of the required tables from the other Redshift clusters. Restore the snapshot into the existing Redshift cluster.
• D. Use federated queries to access data in Amazon RDS.
• E. Unload the RDS tables and the tables from the other Redshift clusters into Amazon S3. Run COPY commands to load the tables into the existing Redshift cluster.
• F. Use AWS Glue jobs to transfer the AWS Glue Data Catalog tables into Amazon S3. Create external tables in the existing Redshift database to access this data.

Answer: A,B,D

Explanation:
Correct Answer: B, D, E
Explanation from Amazon documents:
To allow an existing Redshift cluster to access data from other Redshift clusters, Amazon RDS for PostgreSQL databases, and AWS Glue Data Catalog tables, the database specialist should use the following features123:
Create external tables in the existing Redshift database to connect to the AWS Glue Data Catalog tables. This feature allows you to query data stored in Amazon S3 using the AWS Glue Data Catalog as the metadata store. You can create external tables in your Redshift database that reference the data catalog tables and use SQL to query the data in S3. This feature is operationally efficient because it does not require moving or copying the data from S3 to Redshift1.
Use federated queries to access data in Amazon RDS. This feature allows you to query and join data from one or more Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL databases with data already in your Amazon Redshift cluster. You can use SQL to query the RDS databases directly from your Redshift cluster without having to load or unload any data. This feature is operationally efficient because it reduces data movement and storage costs, and simplifies data access and analysis2.
Use data sharing to access data from the other Redshift clusters. This feature allows you to securely share live data across different Redshift clusters without the complexity and delays associated with data copies and data movement. You can share data within or across AWS accounts using a consumer-producer model. The producer cluster grants privileges on one or more schemas, called datashares, to the consumer clusters. The consumer clusters can then query the shared data in the producer cluster as if it were local tables. This feature is operationally efficient because it enables real-time and transactionally consistent data access, and eliminates data duplication and stale data issues3.
Therefore, option B, D, and E are the correct steps to meet the requirements with the most operational efficiency. Option A is not efficient because it involves taking and restoring snapshots, which can be time-consuming and costly. Option C is not efficient because it involves unloading and loading data between S3 and Redshift, which can also incur additional time and cost. Option F is not necessary because it involves transferring the AWS Glue Data Catalog tables into S3, which can be avoided by using external tables to connect to the data catalog tables directly.

NEW QUESTION # 45
A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

• A. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
• B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
• C. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
• D. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

Answer: C

NEW QUESTION # 46
A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQLDB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?

• A. Insufficient resources on the master
• B. New volumes created from snapshots load lazily in the background
• C. Overload of a single replication thread by excessive writes on the master
• D. Long-running statements on the master

Answer: D

NEW QUESTION # 47
A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

• A. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
• B. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
• C. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
• D. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

Answer: D

Explanation:
https://aws.amazon.com/blogs/database/best-practices-for-migrating-rds-for-mysql-databases-to-amazon-aurora/
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica

NEW QUESTION # 48
A gaming company uses Amazon Aurora Serverless for one of its internal applications. The company's developers use Amazon RDS Data API to work with the Aurora Serverless DB cluster. After a recent security review, the company is mandating security enhancements. A database specialist must ensure that access to RDS Data API is private and never passes through the public internet.
What should the database specialist do to meet this requirement?

• A. Create an interface VPC endpoint that uses AWS PrivateLink for RDS Data API.
• B. Modify the Aurora Serverless cluster by unchecking the publicly accessible option.
• C. Create a gateway VPC endpoint for RDS Data API.
• D. Modify the Aurora Serverless cluster by selecting a VPC with private subnets.

Answer: A

Explanation:
Explanation
https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-data-api-now-supports-aws-privatelink/

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

Answer: C

Explanation:
Explanation
as Local secondary index can only be created while creating the Dynamodb table. and query needs to use third attribute on top of primary and sort key, so Local Secondary index has primary and sort key as well as the third attribute. Global secondary index can be created without primary and sort key

NEW QUESTION # 50
A database specialist at a large multi-national financial company is in charge of designing the disaster recovery strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its data store. The application requires a recovery time objective (RTO) of 1 minute and a recovery point objective (RPO) of 2 minutes.
Which operationally efficient disaster recovery strategy should the database specialist recommend for the DynamoDB table?

• A. Use a DynamoDB global table replica in another Region. Enable point-in-time recovery for both tables.
• B. Use a DynamoDB Accelerator table in another Region. Enable point-in-time recovery for the table.
• C. Create an AWS Backup plan and assign the DynamoDB table as a resource.
• D. Create a DynamoDB stream that is processed by an AWS Lambda function that copies the data to a DynamoDB table in another Region.

Answer: B

NEW QUESTION # 51
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. 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.
• 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. 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.

Answer: D

Explanation:
Explanation
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-encrypte

NEW QUESTION # 52
......

Reliable Study Materials for DBS-C01 Exam Success For Sure: https://www.itexamsimulator.com/DBS-C01-brain-dumps.html

100% Latest Most updated DBS-C01 Questions and Answers: https://drive.google.com/open?id=1OtiF8Bba0cXd2qfafRF_AEdESpkztvtk