Professional Cloud Architect · Free Practice Question Medium
Question 24
Your company is planning to modernize its data infrastructure to support analytics on archived financial transaction logs while also ensuring the logs are available for disaster recovery purposes. The data volume is approximately 200 TB, and the company wants a cost-effective, serverless solution with minimal operational overhead. Which two steps should they take? (Choose two)
-
A
Store the financial logs in Cloud Spanner
-
B
Load the financial logs into BigQuery
-
C
Load the financial logs into Cloud Bigtable
-
D
Transfer the financial logs to Cloud SQL
-
E
Upload the financial logs into Cloud Storage
Reveal correct answers
Correct answers: B, E
A.
While Cloud Spanner is a scalable, globally distributed database, it is optimized for transactional data rather than archival and analytical workloads. It would also be significantly more expensive than Cloud Storage for archiving purposes.
B.
BigQuery is a serverless, scalable analytics solution ideal for performing analytics on large datasets like financial logs. By loading the logs into BigQuery, the company can easily leverage its SQL-based analytics capabilities.
C.
Cloud Bigtable is suitable for real-time analytics on large-scale structured data but is not ideal for archival purposes. It is also more complex to set up for long-term storage compared to Cloud Storage.
D.
Cloud SQL is a managed relational database service suitable for transactional applications. It is not optimized for the storage and analysis of large, archival datasets like financial logs.
E.
Cloud Storage is a cost-effective solution for storing large amounts of data, such as financial logs, for disaster recovery purposes. It provides durability and availability with options for archival storage like Nearline and Coldline, which are optimized for infrequently accessed data.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
