ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 83 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 83
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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 RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.
  • B. Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1 Region. Use Amazon QuickSight for displaying dashboard results.
  • C. Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
  • D. Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by steves at July 27, 2020, 7:36 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
IhorK
1 year, 9 months ago
Selected Answer: D
- complex analytical queries - less than 1 second - 2 Regions Amazon Aurora Global Database cross-Region replication latencies below 1 second, recovery point objective (RPO) of 1 second and a recovery time objective (RTO) of less than 1 minute.
upvoted 1 times
...
renfdo
2 years, 4 months ago
Selected Answer: D
Use an Amazon Aurora global database.
upvoted 1 times
...
Arun32
2 years, 6 months ago
Surely D : Global Database uses storage-based replication with typical latency of less than 1 second, using dedicated infrastructure that leaves your database fully available to serve application workloads. https://aws.amazon.com/rds/aurora/global-database/
upvoted 4 times
...
novice_expert
3 years, 1 month ago
Selected Answer: D
Use an Amazon Aurora global database.
upvoted 1 times
...
guru_ji
3 years, 7 months ago
Correct Answer: D Dynamo DB ==>> No direct analytical queries (No joins).
upvoted 2 times
...
LB
3 years, 7 months ago
D - Aurora Global Database - The solution needs to support complex analytical queries. Which eliminates Dynamodb from the equation.
upvoted 2 times
...
sbhujbal
3 years, 7 months ago
option B is not possible since Quicksight cannot talk with DynamoDB and hence only possible option is D
upvoted 3 times
...
Aesthet
3 years, 7 months ago
D final answer
upvoted 3 times
...
myutran
3 years, 7 months ago
Ans: D
upvoted 3 times
...
halol
3 years, 7 months ago
why it's not A, I can see A and D make sense !
upvoted 1 times
aws4myself
3 years, 7 months ago
Because they have asked for 1 sec replication lag.
upvoted 1 times
...
...
Ashoks
3 years, 7 months ago
I would go with D. Covers cross region 1 sec latency and complex query
upvoted 4 times
...
pdboi3355
3 years, 7 months ago
D - "This means that committed transactional changes from the writer are replicated globally to the Regions that you select, typically within 1 second." -- based on link below
upvoted 2 times
...
goodh32
3 years, 7 months ago
Answer is B Complex query and analytics is key to use RDS, not DynamoDB
upvoted 2 times
goodh32
3 years, 7 months ago
**editing: Answer is for Aurora (D) - which is Relational ready for complex queries
upvoted 2 times
...
...
qwertyuio
3 years, 7 months ago
D. Quicksight don't support Dynamodb
upvoted 3 times
GeeBeeEl
3 years, 7 months ago
I dont agree with you, see https://aws.amazon.com/blogs/database/how-to-perform-advanced-analytics-and-build-visualizations-of-your-amazon-dynamodb-data-by-using-amazon-athena/
upvoted 2 times
jove
3 years, 5 months ago
That blog suggests to export data from DynamoDB to S3 first and use Athena to read from S3. This process is slow. In this question, the dashboard requires an instant access to the application's data. Answer is D
upvoted 1 times
...
...
...
Ebi
3 years, 7 months ago
Answer is D
upvoted 1 times
...
Kitty0403
3 years, 8 months ago
Answer is B
upvoted 1 times
Kitty0403
3 years, 8 months ago
Changing to B https://aws.amazon.com/blogs/database/aurora-postgresql-disaster-recovery-solutions-using-amazon-aurora-global-database/
upvoted 2 times
Kitty0403
3 years, 8 months ago
Sorry I meant D
upvoted 2 times
Kitty0403
3 years, 8 months ago
1 sec is the key.. dyanmodb takes 2000ms for replication
upvoted 2 times
...
...
...
...
steves
3 years, 8 months ago
Going with B, less than 1 second replication required.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel