A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.
Which solution meets these requirements?

• A.Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1Region. Use Amazon QuickSight for displaying dashboard results.
• B.Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the apnortheast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cacheapplication data from the replica to generate the dashboards.
• C.Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replicain the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.
• D.Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replicainstance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.

Comment: *

Name: *

Email: *

Verification: *

A company wants to automate the creation of secure test databases with random credentials to be stored safely for later use. The credentials should have sufficient information about each test database to initiate a connection and perform automated credential rotations. The credentials should not be logged or stored anywhere in an unencrypted form.
Which steps should a Database Specialist take to meet these requirements using an AWS CloudFormation template?

• A.Add a Mapping property from the database Amazon Resource Name (ARN) to the secret ARN. Then, create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add the database with the MasterUserName and MasterUserPassword properties set to the user name of the secret.
• B.Create the database with the MasterUserName and MasterUserPassword properties set to the default values. Then, create the secret with the user name and password set to the same default values. Add a Secret Target Attachment resource with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database. Finally, update the secret's password value with a randomly generated string set by the GenerateSecretString property.
• C.Add a resource of type AWS::SecretsManager::Secret and specify the GenerateSecretString property.
  Then, define the database user name in the SecureStringTemplate template. Create a resource for the database and reference the secret string for the MasterUserName and MasterUserPassword properties.
  Then, add a resource of type AWS::SecretsManagerSecretTargetAttachment with the SecretId and TargetId properties set to the Amazon Resource Names (ARNs) of the secret and the database.
• D.Create the secret with a chosen user name and a randomly generated password set by the GenerateSecretString property. Add an SecretTargetAttachment resource with the SecretId property set to the Amazon Resource Name (ARN) of the secret and the TargetId property set to a parameter value matching the desired database ARN. Then, create a database with the MasterUserName and MasterUserPassword properties set to the previously created values in the secret.

Comment: *

Name: *

Email: *

Verification: *

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

• A.Create an Amazon Aurora Serverless DB cluster
• B.Create an Amazon DocumentDB cluster
• C.Create an Amazon DynamoDB table with provisioned capacity mode
• D.Create an Amazon DynamoDB table with on-demand capacity mode

Comment: *

Name: *

Email: *

Verification: *

A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?

• A.Enable an Amazon RDS for MySQL Multi-AZ configuration
• B.Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
• C.Enable a read replicas and direct read traffic to it when Amazon RDS is down
• D.Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down

Comment: *

Name: *

Email: *

Verification: *

A global digital advertising company captures browsing metadata to contextually display relevant images,pages, and links to targeted users. A single page load can generate multiple events that need to be storedindividually. The maximum size of an event is 200 KB and the average size is 10 KB. Each page load mustquery the user's browsing history to provide targeting recommendations. The advertising company expectsover 1 billion page visits per day from users in the United States, Europe, Hong Kong, and India. The structureof the metadata varies depending on the event. Additionally, the browsing metadata must be written and readwith very low latency to ensure a good viewing experience for the users.
Which database solution meets these requirements?

• A.Amazon RDS Multi-AZ deployment
• B.Amazon DocumentDB
• C.Amazon DynamoDB global table
• D.Amazon Aurora Global Database

Comment: *

Name: *

Email: *

Verification: *