Google Associate Cloud Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
Your company operates a highly successful web platform, accumulating 3 petabytes of customer activity data in a sharded MySQL database within your on-premise data center. Due to storage limitations, the decision has been made to migrate this data to GCP, ensuring it remains available throughout the day. Business analysts, who are proficient in SQL, require a seamless transition. What is the optimal storage solution on GCP that ensures data availability and facilitates ease of analysis for these analysts?
Explanation:
Correct Answer: D
Option A (Google Cloud SQL) is not suitable because, while it supports MySQL and offers a straightforward migration path, it cannot handle petabyte-scale data, with storage limits around 30TB for second-generation instances.
Option B (Google Cloud Storage) is incorrect as it provides object storage without an SQL interface, making it unsuitable for analysts requiring SQL query capabilities.
Option C (Google Cloud Datastore) is not the right choice because it is a NoSQL document database that does not support standard SQL, only GQL, which is similar but not identical.
Option D (Google BigQuery) is the optimal solution. It is a serverless, highly scalable, and cost-effective cloud data warehouse that supports petabyte-scale data and offers a standard SQL dialect compliant with ANSI:2011, ensuring a seamless transition for business analysts.
References: