Why data services matter in GCP - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why use managed data services in the cloud?

Imagine you have a small bakery and you want to keep track of your sales and inventory. You can either keep a notebook yourself or use a specialized app that automatically updates and backs up your data. In cloud computing, why is it better to use managed data services like BigQuery or Cloud SQL instead of managing your own database servers?

A Using managed data services means you lose control over your data and cannot access it directly.

B Managed data services do not support automatic scaling, so you must manually adjust resources.

C Managed data services handle backups, scaling, and maintenance automatically, reducing manual work and errors.

D Managing your own database servers is always cheaper and requires less technical knowledge.

💡 Hint

Think about what tasks a bakery owner would prefer to automate to save time and avoid mistakes.

Managed data services automate tasks like backups, scaling, and maintenance. This helps users focus on their core work without worrying about infrastructure details.

❓ Architecture

intermediate

Choosing the right data service for analytics

Your company collects large amounts of customer data daily. You want to run fast, complex queries to find trends and generate reports. Which Google Cloud data service is best suited for this task?

A Cloud Bigtable, because it is optimized for large-scale transactional workloads.

B Cloud BigQuery, because it is designed for fast, large-scale data analytics and SQL queries.

C Cloud SQL, because it supports relational databases and is best for small datasets.

D Cloud Storage, because it stores files and is optimized for unstructured data.

💡 Hint

Think about which service is built for running fast queries on big data.

BigQuery is a fully managed data warehouse designed for fast SQL queries on large datasets, making it ideal for analytics.

❓ security

advanced

Securing data in cloud data services

You want to ensure that only authorized users can access sensitive data stored in Cloud SQL. Which approach best improves security?

A Use Cloud IAM roles to grant least privilege access and enable data encryption at rest and in transit.

B Share the database credentials with all team members to avoid access delays.

C Store database credentials in plain text files on user machines for easy access.

D Disable encryption to improve performance and rely on network firewalls only.

💡 Hint

Think about how to limit access and protect data both when stored and moving over the network.

Using IAM roles enforces least privilege access. Encryption protects data at rest and in transit, enhancing security.

❓ service_behavior

advanced

Behavior of Cloud Storage with versioning enabled

You enable versioning on a Cloud Storage bucket. What happens when you upload a new file with the same name as an existing file?

A The new file is saved as a new version, and the old version is retained and accessible.

B The new file is rejected because a file with the same name already exists.

C The new file overwrites the old file and the old version is lost permanently.

D The bucket automatically deletes the old file before saving the new one.

💡 Hint

Think about what versioning means for file storage.

Versioning keeps previous versions of files when new files with the same name are uploaded, allowing recovery of older versions.

✅ Best Practice

expert

Optimizing cost and performance for data pipelines

You design a data pipeline that processes streaming data and stores results in BigQuery. To optimize cost and performance, which practice should you follow?

A Store all raw data only in Cloud Storage and never load it into BigQuery to avoid costs.

B Stream every single event immediately into BigQuery without batching to minimize latency at all costs.

C Use multiple small BigQuery tables instead of partitioned tables to organize data better.

D Batch data into larger chunks before loading into BigQuery to reduce streaming insert costs and improve query performance.

💡 Hint

Consider how batching affects cost and query speed in BigQuery.

Batching reduces the number of streaming inserts, lowering costs and improving query efficiency. Partitioned tables also help manage data effectively.