A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?

• A.New volumes created from snapshots load lazily in the background
• B.Long-running statements on the master
• C.Insufficient resources on the master
• D.Overload of a single replication thread by excessive writes on the master

Comment: *

Name: *

Email: *

Verification: *

A worldwide digital advertising corporation collects browser information in order to provide targeted visitors with contextually relevant pictures, websites, and connections. A single page load may create many events, each of which must be kept separately. A single event may have a maximum size of 200 KB and an average size of 10 KB. Each page load requires a query of the user's browsing history in order to deliver suggestions for targeted advertising. The advertising corporation anticipates daily page views of more than 1 billion from people in the United States, Europe, Hong Kong, and India. The information structure differs according to the event. Additionally, browsing information must be written and read with a very low latency to guarantee that consumers have a positive viewing experience.
Which database solution satisfies these criteria?

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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Add values for the rcuCount and wcuCount parameters to the Mappings section of the template. Configure DynamoDB to provision throughput capacity using the stack's mappings.
• B.Add values for the rcuCount and wcuCount parameters as outputs of the template. Configure DynamoDB to provision throughput capacity using the stack outputs.
• C.Add values for the rcuCount and wcuCount parameters to the Mappings section of the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.
• D.Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.

Comment: *

Name: *

Email: *

Verification: *

A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read-only workload scaling. A failover event occurs and application performance is poor for several minutes. During this time, application servers in all Availability Zones are healthy and responding normally.
What should the company do to eliminate this application performance issue?

• A.Configure both Aurora Replicas to have the same instance class as the primary DB instance.
  ImplementAurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DBinstance and to tier-1 for the replicas.
• B.Deploy an AWS Lambda function that calls the DescribeDBInstances action to establish which instancehas failed, and then use the PromoteReadReplica operation to promote one Aurora Replica to be theprimary DB instance. Configure an Amazon RDS event subscription to send a notification to an AmazonSNS topic to which the Lambda function is subscribed.
• C.Configure both of the Aurora Replicas to the same instance class as the primary DB instance.
  Enablecache coherence on the DB cluster, set the primary DB instance failover priority to tier-0, and assign afailover priority of tier-1 to the replicas.
• D.Configure one Aurora Replica to have the same instance class as the primary DB instance.
  ImplementAurora PostgreSQL DB cluster cache management. Set the failover priority to tier-0 for the primary DBinstance and one replica with the same instance class. Set the failover priority to tier-1 for the otherreplicas.

Comment: *

Name: *

Email: *

Verification: *

A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT department has established an AWS Direct Connect link from the company's data center. The company's Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from being set over the network. The migration appears to be working successfully, and the data can be queried from a desktop machine.
Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster. Both Analysts are unable to connect to Aurora. Their user names and passwords have been verified as valid and the Database Specialist can connect to the DB cluster using their accounts. The Database Specialist also verified that the security group configuration allows network from all corporate IP addresses.
What should the Database Specialist do to correct the Data Analysts' inability to connect?

• A.Restart the DB cluster to apply the SSL change.
• B.Instruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.
• C.Add explicit mappings between the Data Analysts' IP addresses and the instance in the security group assigned to the DB cluster.
• D.Modify the Data Analysts' local client firewall to allow network traffic to AWS.

Comment: *

Name: *

Email: *

Verification: *