Amazon DBS-C01 Online Practice Questions and Exam Preparation

Amazon DBS-C01 Online Questions & Answers

• Question 291:

  A database specialist is managing an application in the us-west-1 Region and wants to set up disaster recovery in the us-east-1 Region. The Amazon Aurora MySQL DB cluster needs an RPO of 1 minute and an RTO of 2 minutes. Which approach meets these requirements with no negative performance impact?

  A. Enable synchronous replication.
  B. Enable asynchronous binlog replication.
  C. Create an Aurora Global Database.
  D. Copy Aurora incremental snapshots to the us-east-1 Region.
  C. Create an Aurora Global Database.

  ---

  Explanation/Reference:

  https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora- global-database-disaster-recovery.html

• Question 292:

  A company has migrated a single MySQL database to Amazon Aurora. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account. Testing results in minimal changes to the test data. The Development team wants each environment refreshed nightly so each test database contains fresh production data every day.

  Which migration approach will be the fastest and most cost-effective to implement?

  A. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
  B. Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
  C. Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.
  D. Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
  A. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

• Question 293:

  A company is running critical applications on AWS. Most of the application deployments use Amazon Aurora MySQL for the database stack. The company uses AWS CloudFormation to deploy the DB instances.

  The company's application team recently implemented a CI/CD pipeline. A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CllCD platform. Updates to the CloudFormation stack must not update existing production database resources.

  Which CloudFormation stack policy action should the database engineer implement to meet these requirements?

  A. Use a Deny statement for the Update:Modify action on the production database resources.
  B. Use a Deny statement for the action on the production database resources.
  C. Use a Deny statement for the Update:Delete action on the production database resources.
  D. Use a Deny statement for the Update:Replace action on the production database resources.
  D. Use a Deny statement for the Update:Replace action on the production database resources.

  ---

  Explanation/Reference:

  Correct Answer: D from Amazon documents: A CloudFormation stack policy is a JSON document that defines the update actions that can be performed on designated resources in a CloudFormation stack. A stack policy can be used to prevent accidental updates or deletions of stack resources, such as a production database. The Update:Replace action is an update action that replaces an existing resource with a new one during a stack update. This action can cause data loss or downtime for the resource. To prevent this action from affecting the production database resources, the database engineer should use a Deny statement for the Update:Replace action on the production database resources in the stack policy. This statement will override any Allow statements for the same action and resource, and protect the production database resources from being replaced during a stack update. Therefore, option D is the correct stack policy action to meet the requirements. Option A is incorrect because the Update:Modify action is not a valid update action for a stack policy. The valid update actions are Update:Replace, Update:Skip, and Delete. Option B is incorrect because it does not specify a valid update action for the Deny statement. Option C is incorrect because the Update:Delete action is not a valid update action for a stack policy. The valid update actions are Update:Replace, Update:Skip, and Delete.

• Question 294:

  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. 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.
  B. 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.
  C. 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.
  D. Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
  A. 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.

  ---

  Explanation/Reference:

  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

• Question 295:

  A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.

  Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

  A. Grant least privilege to groups, users, and roles
  B. Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database
  C. Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
  D. Use policy conditions to restrict access to selective IP addresses
  E. Use AccessList Controls policy type to restrict users for database instance deletion
  F. Enable AWS CloudTrail logging and Enhanced Monitoring
  A. Grant least privilege to groups, users, and roles
  C. Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
  D. Use policy conditions to restrict access to selective IP addresses

  ---

  Explanation/Reference:

  https://aws.amazon.com/blogs/database/using-iam-multifactor-authentication-with-amazon- rds/ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/security_iam_id-based- policy-html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/DataDurability.html

• Question 296:

  A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.

  What should the database specialist do to meet these requirements? (Choose two.)

  A. Create an RDS event subscription to the audit event type.
  B. Enable auditing of CONNECT and QUERY_DML events.
  C. SSH to the DB instance and review the database logs.
  D. Publish the database logs to Amazon CloudWatch Logs.
  E. Enable Enhanced Monitoring on the DB instance.
  B. Enable auditing of CONNECT and QUERY_DML events.
  D. Publish the database logs to Amazon CloudWatch Logs.

  ---

  Explanation/Reference:

  https://aws.amazon.com/blogs/database/configuring-an-audit-log-to-capture- database-activities-for-amazon-rds-for-mysql-and-amazon-aurora-with-mysql-compatibility/

• Question 297:

  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 Aurora MySQL
  B. Amazon Neptune
  C. Amazon ElastiCache for Redis
  D. Amazon DynamoDB
  B. Amazon Neptune

• Question 298:

  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 Amazon S3. Use Amazon Redshift Spectrum for query processing.
  C. Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.
  D. Migrate the database to an Amazon EMR cluster that includes multiple primary nodes.
  A. Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.

  ---

  Explanation/Reference:

  Correct Answer: A 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.

• Question 299:

  A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be deployed in an active-active configuration with automatic data synchronization between Regions.

  Which solution will meet these requirements with the LOWEST latency?

  A. Amazon RDS with cross-Region read replicas
  B. Amazon DynamoDB global tables
  C. Amazon Aurora global database
  D. Amazon Athena and Amazon S3 with S3 Cross Region Replication
  B. Amazon DynamoDB global tables

• Question 300:

  A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and India. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.

  Which database solution satisfies these criteria?

  A. Amazon DocumentDB
  B. Amazon RDS Multi-AZ deployment
  C. Amazon DynamoDB global table
  D. Amazon Aurora Global Database
  C. Amazon DynamoDB global table