- All Exams Instant Download
What should the team do to meet this requirement?
A company is using an Amazon RDS for MySQL DB instance for its internal applications. A security audit shows that the DB instance is not encrypted at rest. The company’s application team needs to encrypt the DB instance. What should the team do to meet this requirement?A . Stop the...
Which approach will be the most cost-effective in meeting these requirements?
A database professional is developing an application that will respond to single-instance requests. The program will query large amounts of client data and offer end users with results. These reports may include a variety of fields. The database specialist want to enable users to query the database using any of...
How should the Database Specialist satisfy this new requirement?
A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be...
Which combination of steps should the Database Specialist take to meet the logging and retention requirements?
A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will...
Which AWS service or functionality will assist in automating and achieving this goal?
A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case. A database administrator wishes to streamline the process of storing and updating these settings....
Where should the AWS DMS replication instance be placed for the MOST optimal performance?
A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in...
Which combination of steps should a database specialist take to meet these requirements?
A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions. The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis. Which combination of steps should a database specialist take to...
How can a database professional guarantee that consumers view the most current data after a failover?
A corporation is transitioning from an IBM Informix database to an Amazon RDS for SQL Server Multi-AZ implementation with Always On Availability Groups (AGs). SQL Server Agent tasks are scheduled to execute at 5-minute intervals on the Always On AG listener to synchronize data between the Informix and SQL Server...
Which solution meets these requirements?
A company has a on-premises Oracle Real Application Clusters (RAC) database. The company wants to migrate the database to AWS and reduce licensing costs. The company's application team wants to store JSON payloads that expire after 28 hours. The company has development capacity if code changes are required. Which solution...
To prepare the new table with identical settings, which steps should be performed?
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,...
