← Back to exam page

DBS-C01 – AWS Certified Database - Specialty

Loading demo links...

Showing 4–6 of 15 questions

Question 4

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available. Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates. The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.

What might account for this? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The new minor version has not yet been designated as preferred and requires a manual upgrade.
  • ○

    Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.
  • ○

    Applying minor version upgrades requires sufficient free space.
  • ○

    The AWS CLI command did not include an apply-immediately parameter.
  • ○

    Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.
Question 5

A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards. Millions of players around the world will complete in annual tournaments. The company wants to implement an architecture that is highly available. The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform.

Which combination of steps should the company take to meet these requirements? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.
  • ○

    Deploy an ElastiCache for Memcached global datastore.
  • ○

    Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.
  • ○

    Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.
  • ○

    Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.
Question 6

A company hosts an on-premises Microsoft SQL Server Enterprise edition database with Transparent Data Encryption (TDE) enabled. The database is 20 TB in size and includes sparse tables. The company needs to migrate the database to Amazon RDS for SQL Server during a maintenance window that is scheduled for an upcoming weekend. Data-at-rest encryption must be enabled for the target DB instance.

Which combination of steps should the company take to migrate the database to AWS in the MOST operationally efficient manner? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Use AWS Database Migration Service (AWS DMS) to migrate from the on-premises source database to the RDS for SQL Server target database.
  • ○

    Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.
  • ○

    Restore the backup to the RDS for SQL Server DB instance. Enable TDE for the RDS for SQL Server DB instance.
  • ○

    Set up an AWS Snowball Edge device. Copy the database backup to the device. Send the device to AWS. Restore the database from Amazon S3.
  • ○

    Encrypt the data with client-side encryption before transferring the data to Amazon RDS.