Exam Professional Data Engineer topic 1 question 132 discussion

Answer: B Description: All the criteria meets for Spanner

A - BigQuery with NO Region ? (Looks wrong) B - Spanner (SQL support and Scalable and have replicas ) - Looks correct C - SQL (can't store so many records) (wrong) D - Bigtable - NO SQL (wrong) Vote for B

A - NO - BigQuery with must have a selected regional or multi-regional file storage B - YES - Spanner is specifically designed for this high and consistent throughput C - NO - I am not sure about what many said in this discussion as Cloud SQL can store this amount of records if u have just a few columns. Anyway, for sure Spanner is better and it is a GCP product. D - Bigtable - it's a NoSQL solution, no ANSI

B is the answer

B is the answer.

Guys, read documentation well. A is wrong, BigQuery has Maximum rows per request (50,000). https://cloud.google.com/bigquery/quotas It is B

Spanner is globally available and meets all the requirements

Correct is A. There's no sense to having read replicas outside of US considering than the company is US based. If you generate a dataset without specifing the Data Location it's gonna be stored in "US Multiregion" by default

B: Cloud Spanner is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale. https://cloud.google.com/spanner/ Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, schemas, SQL (ANSI 2011 with extensions), and automatic, synchronous replication for high availability. https://cloud.google.com/spanner/docs/ https://cloud.google.com/spanner/docs/instances#available-configurations-multi-region

B is correct, Bigquery cannot support 250K data ingestion/second , as ANSI SQL support is required , no other options left except Spanner.

B is correct

B, as Cloud Spanner has three types of replicas: read-write replicas, read-only replicas, and witness replicas.

Correct Answer : C Explanation:- B -> This option is incorrect, as we do not have option to configure read-replica in Cloud Spanner, Multi-region instance configurations use a combination of all three types’ read-write replicas, read-only replicas, and witness replicas C -> This is correct option, In Cloud Sql we have option to create a master node for read-write replicas and read-only replicas in other regions D -> This option is incorrect, as Bigtable do not support ANSI SQL

I was wrong Bigtable doesn not support ansi SQL. B instead

I think it is D. THere is limitation of QPS of Cloud Spanner of 2000 qps, https://cloud.google.com/spanner/docs/instances#multi-region-performance

Answer B

Answer : B