Database Specialty (Page 11)

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 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 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 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 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 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 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 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 has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements.The data could be used by other systems within the company.Which solution will meet these requirements with minimal effort?Read More →

A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table.The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL).The Database Specialist has restored the latest backup to a new table.To prepare the new table with identical settings, which steps should be performed? (Choose two.)Read More →