Exploring Data Transformation with
Google Cloud
Quiz-1
Here are the answers to the quiz:
1. **Which represents the proprietary customer datasets that a business collects from customer or
audience transactions and interactions?**
- **First-party data**
2. **New cloud tools make it possible to harness the potential of unstructured data. Which of these
use cases best demonstrates this?**
- **Analyzing social media posts to identify sentiment toward a brand**
3. **A solar energy company wants to analyze weather data to better understand the seasonal impact
on their business. On which platform could they find free-to-use weather datasets?**
- **Google Cloud Marketplace**
4. **Which is a repository designed to ingest, store, explore, process, and analyze any type or volume
of raw data, regardless of the source?**
- **Data lake**
5. **What is data governance?**
- **The process of setting internal data policies and ensuring compliance with external standards**
6. **An online retailer uses a smart analytics tool to ingest real-time customer behavior data to
surface the best suggestions for particular users. How can machine learning guide this activity?**
- **Through machine learning, with every click that the user makes, their website experience
becomes increasingly personalized.**
7. **Which data type is highly organized and well-defined?**
- **Structured data**
8. **Which step in the data value chain is where collected raw data is transformed into a form that’s
ready to derive insights from?**
- **Data processing**
9. **What is Google Cloud’s modern and serverless data warehousing solution?**
- **BigQuery**
10. **A car insurance company has a large database that stores customer details, including the
vehicles they own and past claims. The structure of the database means that information is stored in
tables, rows, and columns. What type of database is this?**
- **A relational database**
These answers should help you achieve a passing score. Good luck!
Quiz-2
Here are the answers to the quiz:
1. **Which strategy describes when databases are migrated from on-premises and private cloud
environments to the same type of database hosted by a public cloud provider?**
- **Lift and shift**
2. **What is Google's big data database service that powers many core Google services, including
Google Search, Google Analytics, Google Maps Platform, and Gmail?**
- **Bigtable**
3. **Which is the best SQL-based storage option for a transactional workload that requires local or
regional scalability?**
- **Cloud SQL**
4. **BigQuery works in a multicloud environment. How do organizations benefit from this feature?**
- **Data teams can eradicate data silos by analyzing data across multiple cloud providers.**
5. **Which Google Cloud product can be used to synchronize data across databases, storage systems,
and applications?**
- **Datastream**
6. **What are the two services that BigQuery provides?**
- **Storage and analytics**
7. **Data in the form of video, pictures, and audio recordings is well suited to object storage. Which
product is best for storing this kind of data?**
- **Cloud Storage**
8. **A data analyst for an online retailer must produce a sales report at the end of each quarter.
Which Cloud Storage class should the retailer use for data accessed every 90 days?**
- **Coldline**
9. **Which would be the best SQL-based storage option for a transactional workload that requires
global scalability?**
- **Spanner**
10. **Which characteristic is true for all Cloud Storage classes?**
- **Geo-redundancy if data is stored in a multi-region or dual-region**
These answers should help you achieve a passing score. Good luck!
Quiz-3
Here are the answers to the quiz:
1. **What does ETL stand for in the context of data processing?**
- **Extract, transform, and load**
2. **What Google Cloud business intelligence platform is designed to help individuals and teams
analyze, visualize, and share data?**
- **Looker**
3. **Streaming analytics is the processing and analyzing of data records continuously instead of in
batches. Which option is a source of streaming data?**
- **Temperature sensors**
4. **What is Google Cloud’s distributed messaging service that can receive messages from various
device streams such as gaming events, Internet of Things (IoT) devices, and application streams?**
- **Pub/Sub**
5. **Which statement is true about Dataflow?**
- **It handles infrastructure setup and maintenance for processing pipelines.**
6. **What feature of Looker makes it easy to integrate into existing workflows and share with
multiple teams at an organization?**
- **It’s 100% web based.**
These answers should help you achieve a passing score. Good luck!
