You are deploying a PHP App Engine Standard service with Cloud SQL as the backend. You want to minimize the number of queries to the database. What should you do?
A.
Set the memcache service level to dedicated. Create a key from the hash of the query, and return database values from memcache before issuing a query to Cloud SQL.
B.
Set the memcache service level to dedicated. Create a cron task that runs every minute to populate the cache with keys containing query results.
C.
Set the memcache service level to shared. Create a cron task that runs every minute to save all expected queries to a key called ג€cached_queriesג€.
D.
Set the memcache service level to shared. Create a key called ג€cached_queriesג€, and return database values from the key before using a query to Cloud SQL.
A dedicated memset is always better than shared until cost-effectiveness specify in the exam as objective. So Option C and D are ruled out.
From A and B, Option B is sending and updating query every minutes which is over killing. So reasonable option left with A which balance performance and cost.
My answer will be A
Dedicated and shared will resolve the problem, the key is: store all queries in only one key "cached_queries" is not good, we have limits: https://cloud.google.com/appengine/docs/standard/python/memcache
Create a key of each query is better.
A. Set the memcache service level to dedicated. Create a key from the hash of the query, and return database values from memcache before issuing a query to Cloud SQL.
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.
hiteshrup
Highly Voted 3 years, 3 months agoArtistS
4 months, 2 weeks agoEroc
Highly Voted 4 years, 5 months agonitinz
3 years agodlzhang
2 years, 9 months agotartar
3 years, 7 months agoAbhi_ma_cdl_22
Most Recent 4 days, 21 hours agoSur_Nikki
10 months, 4 weeks agomegumin
1 year, 4 months agoAzureDP900
1 year, 5 months agoACE_ASPIRE
1 year, 7 months agoDrishaS4
1 year, 8 months agogaojun
1 year, 12 months agoehgm
2 years, 3 months agovincy2202
2 years, 4 months agonqthien041292
2 years, 4 months agojoe2211
2 years, 4 months agovictory108
2 years, 10 months agoun
2 years, 10 months agoAusias18
2 years, 12 months agoga
3 years, 1 month ago