DBS-C01 (Page 7)

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?Read More →

A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system.New compliance requirements specify that the database must be encrypted at rest.Which action will meet these requirements?Read More →

A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account.The template configures provisioned throughput capacity using hard-coded values.The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned.Which solution will enable this change?Read More →

A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts.Post-migration, the company purged unwanted data from the instance.The company now want to downsize storage to save money.The solution must have the least impact on production and near-zero downtime.Which solution would meet these requirements?Read More →

A large financial services company uses Amazon ElastiCache for Redis for its new application that has a global user base.A database administrator must develop a caching solution that will be available across AWS Regions and include low-latency replication and failover capabilities for disaster recovery (DR).The company’s security team requires the encryption of cross-Region data transfers.Which solution meets these requirements with the LEAST amount of operational effort?Read More →

A company is using an Amazon RDS for MySQL DB instance for a production application.During the company’s upcoming scheduled maintenance window, a database specialist will perform a major version upgrade to the DB instance.The application is critical, so the company wants to minimize the maintenance time and allow for a rollback if a problem occurs.Which solution will meet these requirements?Read More →

A bank is using an Amazon RDS for MySQL DB instance in a proof of concept.A database specialist is evaluating automated database snapshots and cross-Region snapshot copies as -part of this proof of concept.After validating three automated snapshots successfully, the database specialist realizes that the fourth snapshot was not created.Which of the following are possible reasons why the snapshot was not created? (Choose two.)Read More →

A retail company uses Amazon Redshift Spectrum to run complex analytical queries on objects that are stored in an Amazon S3 bucket.The objects are joined with multiple dimension tables that are stored in an Amazon Redshift database.The company uses the database to create monthly and quarterly aggregated reports.Users who attempt to run queries are reporting the following error message: error: Spectrum Scan Error: Access throttledWhich solution will resolve this error?Read More →

A company is using a 1 TB Amazon RDS for PostgreSQL DB instance to store user data.During a security review, a security engineer sees that the DB instance is not encrypted at rest.How should a database specialist correct this issue with the LEAST amount of downtime and no data loss?Read More →

A company has a Microsoft SQL Server 2017 Enterprise edition on Amazon RDS database with the Multi-AZ option turned on.Automatic backups are turned on and the retention period is set to 7 days.The company needs to add a read replica to the RDS DB instance.How should a database specialist achieve this task?Read More →