A company is planning to close for several days. A Database Specialist needs to stop all applications alongwith the DB instances to ensure employees do not have access to the systems during this time. All databasesare running on Amazon RDS for MySQL.
The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs,the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.
How should the Database Specialist edit the script to fix this issue?

• A.Stop the read replicas before stopping their source instances
• B.Use the AWS CLI to stop each read replica and source instance at the same
• C.Stop the source instances before stopping their read replicas
• D.Delete each read replica before stopping its corresponding source instance

Comment: *

Name: *

Email: *

Verification: *

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 this change?

• A.Instantaneously after the change is made to the parameter group
• B.In the next scheduled maintenance window of the DB instances
• C.After the DB instances are manually rebooted
• D.Within 24 hours after the change is made to the parameter group

Comment: *

Name: *

Email: *

Verification: *

In North America, a business launched a mobile game that swiftly expanded to 10 million daily active players.
The game's backend is hosted on AWS and makes considerable use of a TTL-configured Amazon DynamoDB table.
When an item is added or changed, its TTL is set to 600 seconds plus the current epoch time. The game logic is reliant on the purging of outdated data in order to compute rewards points properly. At times, items from the table are read that are many hours beyond their TTL expiration.
How should a database administrator resolve this issue?

• A.Use a client library that supports the TTL functionality for DynamoDB.
• B.Include a query filter expression to ignore items with an expired TTL.
• C.Set the ConsistentRead parameter to true when querying the table.
• D.Create a local secondary index on the TTL attribute.

Comment: *

Name: *

Email: *

Verification: *

A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume.
Which AWS services should the Database Specialist consider? (Choose two.)

• A.Amazon DynamoDB
• B.Amazon Redshift
• C.Amazon Neptune
• D.Amazon Elasticsearch Service
• E.Amazon ElastiCache

Comment: *

Name: *

Email: *

Verification: *

A company is going through a security audit. The audit team has identified cleartext master user password in the AWS CloudFormation templates for Amazon RDS for MySQL DB instances. The audit team has flagged this as a security risk to the database team.
What should a database specialist do to mitigate this risk?

• A.Change all the databases to use AWS IAM for authentication and remove all the cleartext passwords in CloudFormation templates.
• B.Remove the passwords from the CloudFormation template and store them in a separate file. Replace the passwords by running CloudFormation using a sed command.
• C.Use an AWS Secrets Manager resource to generate a random password and reference the secret in the CloudFormation template.
• D.Remove the passwords from the CloudFormation templates so Amazon RDS prompts for the password when the database is being created.

Comment: *

Name: *

Email: *

Verification: *