GCP Associate Cloud Engineer Practice Question 46: BigQuery Adhoc Analytics
Google Cloud Associate Cloud Engineer · Test 5 · question 6 of 10
Analysts want to run ad hoc SQL queries over several petabytes of historical sales data, with no infrastructure to provision, and pay for the amount of data the queries process.
Which service should you use?
Show answer and explanation
Answer:
BigQuery is a serverless, petabyte scale data warehouse. There are no servers to manage, it uses standard SQL, and with on-demand pricing you pay for the bytes processed by each query.
Option A is a transactional database that is limited to a few tens of terabytes and would need an instance sized and managed by you. Option B is a low latency NoSQL store that does not support ad hoc SQL analytics. Option C is a document database meant for application data, not for analytical scans across petabytes.
Reference: What is BigQuery?