exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 339 discussion

A company is creating a three-tier web application consisting of a web server, an application server, and a database server. The application will track GPS coordinates of packages as they are being delivered. The application will update the database every 0-5 seconds.
The tracking will need to read a fast as possible for users to check the status of their packages. Only a few packages might be tracked on some days, whereas millions of package might be tracked on other days. Tracking will need to be searchable by tracking ID customer ID and order ID. Order than 1 month no longer read to be tracked.
What should a solutions architect recommend to accomplish this with minimal cost of ownership?

  • A. Use Amazon DynamoDB Enable Auto Scaling on the DynamoDB table. Schedule an automatic deletion script for items older than 1 month.
  • B. Use Amazon DynamoDB with global secondary indexes. Enable Auto Scaling on the DynamoDB table and the global secondary indexes. Enable TTL on the DynamoDB table.
  • C. Use an Amazon RDS On-Demand instance with Provisioned IOPS (PIOPS). Enable Amazon CloudWatch alarms to send notifications when PIOPS are exceeded. Increase and decrease PIOPS as needed.
  • D. Use an Amazon RDS Reserved Instance with Provisioned IOPS (PIOPS). Enable Amazon CloudWatch alarms to send notification when PIOPS are exceeded. Increase and decrease PIOPS as needed.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
Goozian
Highly Voted 3 years, 6 months ago
Really these type of questions has come in SAA Exam ?! it seems it's belong to Database specialty exam !!
upvoted 35 times
manan728
3 years, 5 months ago
This question was on my test that I passed on Nov 20 2021. I picked B (Dynamo global secondary indexes option). Roughly half of the questions are from this 500 examtopics dump. But other half were unheard of new and lengthy ones in my test. Some of those questions had similarities but had twisted options. Good luck ya'll.
upvoted 5 times
coco0507
2 years, 10 months ago
Can you just stop mentioning….
upvoted 9 times
shail_1981
2 years, 4 months ago
Very irritating
upvoted 1 times
...
...
...
vvsandipvv
3 years, 6 months ago
true has never been spoken so truely
upvoted 9 times
...
...
dmscountera
Highly Voted 3 years, 7 months ago
B https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/time-to-live-ttl-before-you-start.html
upvoted 15 times
noahsark
3 years, 7 months ago
I think I agree with B: Global secondary indexes for tracking / read fast https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SecondaryIndexes.html TTL for order than 1 month https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html
upvoted 7 times
...
...
sofiella
Most Recent 2 years, 3 months ago
A solutions architect would recommend option B, Use Amazon DynamoDB with global secondary indexes. Enable Auto Scaling on the DynamoDB table and the global secondary indexes. Enable TTL on the DynamoDB table. This solution leverages DynamoDB's ability to handle large amounts of read and write traffic, scale automatically, and provide low-latency performance. The global secondary indexes will allow the data to be searchable by tracking ID, customer ID, and order ID, which is required by the application. The TTL feature will automatically remove items older than 1 month, reducing the cost of data storage. Additionally, DynamoDB's pay-per-request pricing model will minimize the cost of ownership.
upvoted 2 times
...
sofiella
2 years, 3 months ago
Option A is the recommended solution because it uses Amazon DynamoDB, which is a highly available and managed NoSQL database service designed to handle massive amounts of read and write traffic with low latency. With DynamoDB's built-in auto scaling capability, the database can automatically adjust its provisioned capacity to handle changing traffic patterns, minimizing the need for manual intervention and reducing the operational overhead of scaling the database. Additionally, DynamoDB's global secondary indexes allow for fast search by tracking ID, customer ID, and order ID, while the built-in time-to-live (TTL) feature can automatically delete items older than 1 month, reducing the need for manual deletion scripts.
upvoted 1 times
...
nothankyouspankyou
2 years, 9 months ago
C. "TCO" - so On-Demand here, and "searchable using the tracking ID, the customer ID, and the order ID" - thats 3, and DynamoDB can only be queried using Primary Key, Sort Key, and indexes.
upvoted 2 times
...
naveenagurjara
2 years, 10 months ago
Selected Answer: B
Looks like we have to first clear the specialty exams and then attempt SAA
upvoted 6 times
...
Edgarrt
3 years, 4 months ago
Selected Answer: B
"Amazon DynamoDB auto scaling uses the AWS Application Auto Scaling service to dynamically adjust provisioned throughput capacity on your behalf, in response to actual traffic patterns. This enables a table or a global secondary index to increase its provisioned read and write capacity to handle sudden increases in traffic, without throttling. When the workload decreases, Application Auto Scaling decreases the throughput so that you don't pay for unused provisioned capacity" https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/AutoScaling.html "If you use the AWS Management Console to create a table or a global secondary index, DynamoDB auto scaling is enabled by default"
upvoted 4 times
Edgarrt
3 years, 4 months ago
"You can modify the settings for a DB instance that uses Provisioned IOPS SSD storage by using the Amazon RDS console, AWS CLI, or Amazon RDS API. Specify the storage type, allocated storage, and the amount of Provisioned IOPS that you require. You can choose from a range between 1,000 IOPS and 100 GiB of storage up to 80,000 IOPS and 64 TiB (64,000 GiB) of storage. The range depends on your database engine and instance type" even so i prefer B. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html#USER_PIOPS.Autoscaling
upvoted 1 times
...
...
gargaditya
3 years, 5 months ago
Dynamo DB is serverless/there is no Autoscaling to be enabled at node level/for size. There is no size to eb provisioned. We only provision capacity modes- on demand vs provisioned. But, ========= https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/AutoScaling.html It appears that Dynamo DB too has autoscaling, though this is in terms of RCU and WCU and NOT at node level or for Database size as it is serverless. Recall that RDS has autoscaling feature only in terms of size NOT no of nodes. Aurora has autoscaling of storage size enabled by default.It has additional option to scale nodes automatically(read replicas). ======================
upvoted 1 times
gargaditya
3 years, 5 months ago
now,analysing the options, RDS does not support autoscaling of nodes('autoscaling' for RDS refers to storage size scaling only)--so C and D are out Further, option saying to manually increase/decrease IOPS that too at instance level which does not make sense. Even further, io1/io2 (EC2 volumes used by the RDS)can handle only upto 32k IOPS or 64k IOPS(with nitro). Millions is possible only with instant store which is not permanent storage. And in D,you may get upfront discount on EC2,but need to pay even when instances not used(committed usage). Better option is serverless with A/B ie Dynamo DB. Between A and B, B has both the conditions satisfied. Global Secondary indexes may help with search using values other than primary keys. TTL is used to expire items in table. Answer=B
upvoted 8 times
...
...
A41
3 years, 6 months ago
I think it is B. Items are removed from any local secondary index and global secondary index in the same way as a DeleteItem operation. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/howitworks-ttl.html
upvoted 2 times
...
jkwek
3 years, 6 months ago
Answer is B. Revealed in url https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html
upvoted 2 times
...
KK_uniq
3 years, 6 months ago
B is ok . Global secondary index
upvoted 2 times
...
haaris786
3 years, 6 months ago
B sounds good to me.
upvoted 2 times
...
syu31svc
3 years, 6 months ago
"Tracking will need to be searchable by tracking ID customer ID and order ID" B answers this point by having indexes
upvoted 4 times
...
admin1
3 years, 7 months ago
B https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html
upvoted 2 times
...
brqx
3 years, 7 months ago
The question ask for minimal cost. Enabling Global Secondary index would we have minimal cost ? I think A is better.
upvoted 1 times
chimsedammua
3 years, 7 months ago
https://aws.amazon.com/about-aws/whats-new/2017/02/amazon-dynamodb-now-supports-automatic-item-expiration-with-time-to-live-ttl/
upvoted 3 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago