Google Professional Cloud Database Engineer Question 83
Single answerGoogle Cloud PlatformYour organization needs to store large volumes of semi-structured and unstructured data, such as JSON files, logs, and multimedia content. The data needs to be queried efficiently for analytics purposes. Which Google Cloud storage and database solution should you recommend for this use case?
- A
Cloud Firestore
- B
Cloud Storage for storage and BigQuery for analytics
- C
Cloud SQL
- D
Bigtable
Show answer and explanation
Correct answer: B
Explanation
The combination of Cloud Storage and BigQuery is the best solution for handling large volumes of semi-structured and unstructured data. Cloud Storage provides cost-effective, scalable storage for the data, while BigQuery allows efficient querying and analytics, making it the optimal choice for this use case.
- A. Incorrect.
Cloud Firestore is a fully managed NoSQL document database designed for structured and semi-structured data in mobile, web, and server applications, but it is not optimized for handling unstructured data and analytics at scale.
- B. Correct.
Cloud Storage is ideal for storing unstructured data (e.g., multimedia, logs, JSON) and integrates with BigQuery, which excels at querying and analyzing such data efficiently for analytics purposes.
- C. Incorrect.
Cloud SQL is a relational database service suited for structured data and transactional workloads. It is not designed for unstructured or semi-structured data at scale.
- D. Incorrect.
Bigtable is a NoSQL database optimized for low-latency, high-throughput workloads involving structured or semi-structured data (e.g., time-series data), but it is not ideal for unstructured data or direct analytics.