Google Professional Cloud Database Engineer exam dumps

Google Professional Cloud Database Engineer practice question 85 of 259

Professional Cloud Database Engineer. Professional level, Google Cloud. Free question with the correct answer and a full explanation.

Google Professional Cloud Database Engineer Question 85

Select 2Google Cloud Platform

Your team is developing a new application that will store user-generated content such as images, videos, and JSON metadata for each file. The application must support fast search capabilities on the JSON metadata, while also ensuring scalability and cost-efficiency. Which Google Cloud storage solutions should you choose to meet these requirements?

  1. A

    Cloud Storage for storing images and videos, and BigQuery for querying JSON metadata

  2. B

    Cloud SQL for storing all images, videos, and JSON metadata in a relational database

  3. C

    Firestore for storing JSON metadata and Cloud Storage for storing images and videos

  4. D

    Spanner for storing images, videos, and JSON metadata in a single database

  5. E

    Bigtable for storing JSON metadata and Cloud Storage for storing images and videos

Show answer and explanation

Correct answers: A, C

Explanation

The best solution involves using Cloud Storage for unstructured data like images and videos, as it provides scalable and cost-efficient storage. For semi-structured data like JSON metadata, either BigQuery or Firestore can be used depending on the application requirements. BigQuery excels at querying large-scale data for analytics, while Firestore is better for real-time, transactional workloads.

  • A. Correct.

    Cloud Storage is ideal for unstructured data like images and videos, while BigQuery offers powerful querying capabilities for structured and semi-structured data like JSON metadata.

  • B. Incorrect.

    Cloud SQL is not well-suited for storing large-scale unstructured data like images and videos, and it also struggles with scalability for semi-structured data like JSON metadata.

  • C. Correct.

    Firestore is a good choice for semi-structured data such as JSON metadata due to its NoSQL capabilities, while Cloud Storage is excellent for unstructured data such as images and videos.

  • D. Incorrect.

    Spanner is a powerful distributed relational database but is not optimized for storing unstructured data like images and videos, making it less cost-efficient for this use case.

  • E. Incorrect.

    Bigtable is optimized for high-throughput and low-latency workloads but is not ideal for querying semi-structured data like JSON metadata.

Timed practice exam

Take a Google Professional Cloud Database Engineer practice test under exam conditions

60 questions in 120 minutes, drawn from this bank, with a score report and a per-question review when you finish.

Start timed exam

More Google Professional Cloud Database Engineer practice questions

  1. 86.You are tasked with designing a cost-efficient database solution for a startup that expects...
  2. 87.Your team is evaluating database solutions for a new application on Google Cloud. The application...
  3. 88.You are designing a database solution on Google Cloud for a retail company that requires high...
  4. 89.You are tasked with designing a database solution for an application that requires high...
  5. 90.You are designing a database solution in Google Cloud for a new e-commerce application that will...
Back to the Google Professional Cloud Database Engineer exam dumps