- All Exams Instant Download
Which migration approach would result in the LEAST amount of downtime?
A small startup firm wishes to move a 4 TB MySQL database from on-premises to AWS through an Amazon RDS for MySQL DB instance. Which migration approach would result in the LEAST amount of downtime?A . Deploy a new RDS for MySQL DB instance and configure it for access from...
When will the instances be allocated to this new parameter group once the database specialist performs this change?
A database professional maintains a fleet of Amazon RDS database instances that are configured to utilize the default database parameter group. A database expert must connect a custom parameter group with certain database instances. When will the instances be allocated to this new parameter group once the database specialist performs...
What should the database specialist review first to improve the utility of DAX?
A database specialist is designing an enterprise application for a large company. The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX). The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads. What should the database specialist...
How should a Database Specialist address these requirements?
An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application. The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased...
What should the database specialist do to address the issue?
A company with 500,000 employees needs to supply its employee list to an application used by human resources. Every 30 minutes, the data is exported using the LDAP service to load into a new Amazon DynamoDB table. The data model has a base table with Employee ID for the partition...
Which solution meets these requirements?
A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users. Which solution meets these requirements?A...
Which combination of actions should a database specialist take to improve the cluster's performance?
A company is using Amazon Redshift as its data warehouse solution. The Redshift cluster handles the following types of workloads: * Real-time inserts through Amazon Kinesis Data Firehose * Bulk inserts through COPY commands from Amazon S3 * Analytics through SQL queries Recently, the cluster has started to experience performance...
How can a Database Specialist address these requirements with minimal user involvement?
A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora...
What method should the database administrator use to configure the encryption to fulfill these specifications?
Amazon RDS for Oracle with Transparent Data Encryption is used by a financial services organization (TDE). At all times, the organization is obligated to encrypt its data at rest. The decryption key must be widely distributed, and access to the key must be restricted. The organization must be able to...
Which actions can a database specialist perform to resolve this issue?
A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries are executed. Amazon CloudWatch metrics indicate that the instance requires more I/O capacity. Which actions can a database specialist perform to resolve this issue? (Choose two.)A ....
