For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeGCP Professional Cloud ArchitectGCP Professional Cloud Architect Practice Exam 3Question 38
    Medium1 markMultiple Choice
    Domain 1: Designing and Planning a Cloud Solution ArchitectureDomain 1BigtableBigQueryDatabase Selection

    GCP PCA · Question 38 · Domain 1: Designing and Planning a Cloud Solution Architecture

    You are designing the data architecture for a new application. You need to choose between Cloud Bigtable and BigQuery. Which TWO statements correctly describe the use cases for these services? (Select TWO)

    Answer options:

    A.

    Bigtable is optimized for high-throughput, low-latency reads and writes of key-value data.

    B.

    Bigtable supports complex SQL queries and table joins.

    C.

    BigQuery is the best choice for a real-time user profile database serving a mobile app.

    D.

    BigQuery is an enterprise data warehouse optimized for analytical (OLAP) queries over petabytes of data.

    E.

    Both Bigtable and BigQuery require you to provision and manage the underlying compute instances.

    How to approach this question

    Contrast OLTP/NoSQL (Bigtable) with OLAP/Data Warehouse (BigQuery).

    Full Answer

    Cloud Bigtable is a NoSQL database designed for operational workloads requiring high throughput and low latency (e.g., time-series data, IoT). BigQuery is a serverless data warehouse designed for analytical workloads, allowing you to run complex SQL queries across petabytes of data. They serve entirely different architectural purposes.

    Common mistakes

    Thinking BigQuery can be used as a backend database for a web app (C). BigQuery's latency is measured in seconds, not milliseconds.
    Question 37All questionsQuestion 39

    Practice the full GCP Professional Cloud Architect Practice Exam 3

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...MediumQ02**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...HardQ03**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...MediumQ04**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...EasyQ05**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...Medium
    View all 50 questions →