Free DBS-C01 Exam Braindumps (page: 33)

Page 32 of 82

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.)

  1. Create an RDS event subscription to the audit event type.
  2. Enable auditing of CONNECT and QUERY_DML events.
  3. SSH to the DB instance and review the database logs.
  4. Publish the database logs to Amazon CloudWatch Logs.
  5. Enable Enhanced Monitoring on the DB instance.

Answer(s): B,D



A large gaming company is creating a centralized solution to store player session state for multiple online games. The workload required key-value storage with low latency and will be an equal mix of reads and writes. Data should be written into the AWS Region closest to the user across the games’ geographically distributed user base. The architecture should minimize the amount of overhead required to manage the replication of data between Regions.

Which solution meets these requirements?

  1. Amazon RDS for MySQL with multi-Region read replicas
  2. Amazon Aurora global database
  3. Amazon RDS for Oracle with GoldenGate
  4. Amazon DynamoDB global tables

Answer(s): D



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?

  1. Amazon RDS for MySQL with Multi-AZ
  2. Amazon Aurora Serverless MySQL cluster
  3. Amazon Aurora MySQL cluster
  4. Amazon RDS for MySQL with read replica

Answer(s): B



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?

  1. Run SQL Server Enterprise Edition on Amazon EC2.
  2. Run SQL Server Standard Edition on Amazon RDS.
  3. Run SQL Server Enterprise Edition on Amazon RDS.
  4. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.

Answer(s): B


Reference:

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html






Post your Comments and Discuss Amazon DBS-C01 exam with other Community members:

Exam Discussions & Posts