Your retail analytics team must store years of raw click-stream logs, product images, and IoT sensor files while keeping costs low. They do not want to define a schema until analysts are ready to explore the information. In Google Cloud, which approach best meets this need?
Insert the data into Cloud SQL so the relational engine can enforce ACID transactions on each record.
Load all data into BigQuery tables after defining fixed schemas for every file type.
Save the raw files in Cloud Spanner to gain global strong consistency for analytics workloads.
Store the files in Cloud Storage and treat the bucket as a data lake, applying schemas only when the data is queried.
A data lake built on Cloud Storage is designed to hold large volumes of varied, raw data at low cost. Because data is kept in its native format, no schema has to be imposed when the files are written (schema-on-read). BigQuery, Cloud SQL, and Cloud Spanner all require a predefined schema and are optimized for structured or transactional workloads, making them a poorer fit when the goal is simply to retain diverse raw data for future discovery.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a data lake, and why is Cloud Storage suitable for it?
Open an interactive chat with Bash
How does schema-on-read differ from schema-on-write?
Open an interactive chat with Bash
Why is Cloud Storage more cost-effective than databases like Cloud SQL or Cloud Spanner for storing raw data?
Open an interactive chat with Bash
What is a data lake and how does it work in Cloud Storage?
Open an interactive chat with Bash
What does schema-on-read mean and why is it important?
Open an interactive chat with Bash
How does Cloud Storage differ from BigQuery, Cloud SQL, and Cloud Spanner for storing raw data?
Open an interactive chat with Bash
GCP Cloud Digital Leader
Exploring Data Transformation with Google Cloud
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .