You are tasked to provide a solution for storing and analyzing petabytes of historical financial transaction data. The data needs to be queried using SQL, and the solution should be serverless. What GCP service would you recommend?
Choose an answer
Tap an option to check your answer.
Correct answer: BigQuery.
Why this is the answer
*Explanation:* For storing and analyzing petabytes of historical financial transaction data with SQL queries in a serverless manner, the ideal choice is **BigQuery**. BigQuery offers a serverless, highly scalable platform for analyzing large volumes of data using SQL. Cloud SQL is not suitable for petabyte-scale data, Cloud Spanner is not serverless, Cloud Datastore is not designed for such data volumes, and Cloud Bigtable lacks full SQL query capabilities, making BigQuery the most appropriate solution.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed