This test assesses a candidate's ability to work with Google Cloud Platform (GCP) services, including BigQuery, Cloud Storage, and Compute Engine. The test includes multiple-choice questions (MCQs), real-world scenarios, and command-line tasks to evaluate practical knowledge and troubleshooting skills.
Topics Covered:
- BigQuery:
Writing optimized SQL queries
Partitioning & clustering for performance
Working with JSON and nested data
Best practices for cost control
- Cloud Storage
Managing storage classes and lifecycle policies
Object permissions and public access
Using gsutil and gcloud commands for storage management
Synchronization and data transfer strategies
- Compute Engine
Creating and managing VM instances
Startup scripts and automated provisioning
Disk resizing and storage management
Troubleshooting networking and firewall issues
Example Question:
SELECT name, COUNT(*)
FROM my_dataset.customers
WHERE country = 'US';