Topic 1 Question 98
Your customer has implemented a solution that uses Cloud Spanner and notices some read latency-related performance issues on one table. This table is accessed only by their users using a primary key. The table schema is shown below.
You want to resolve the issue. What should you do?Remove the profile_picture field from the table.
Add a secondary index on the person_id column.
Change the primary key to not have monotonically increasing values.
Create a secondary index using the following Data Definition Language (DDL):
ユーザの投票
コメント(17)
- 正解だと思う選択肢: D
Create a secondary index using the following Data Definition. If we watch the next video, he talks about a change to monotonically when we insert rows. Finally when we talk about read and we have a perdormance issues, we must create a index. https://www.youtube.com/watch?v=r6uj0HMNQNQ
👍 7BenKenGo62022/09/02 - 👍 4mattcl2022/11/06
- 正解だと思う選択肢: C
you should be careful when choosing a primary key to not accidentally create hotspots in your database. One cause of hotspots is having a column whose value monotonically increases as the first key part, because this results in all inserts occurring at the end of your key space. This pattern is undesirable because Spanner divides data among servers by key ranges, which means all your inserts will be directed at a single server that will end up doing all the work.
👍 3Aninina2022/10/31
シャッフルモード