
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?
A
Migrate the data to Google Cloud SQL for a straightforward transition.
B
Store the data as flat files in Google Cloud Storage.
C
Utilize Google Cloud Datastore for storing the data.
D
Transfer the data into Google BigQuery to leverage its petabyte-scale capabilities and SQL support.