Google Cloud

Google Cloud Certified – Professional Cloud Database Engineer

PR000256

Become a certified Professional Cloud Database Engineer with exam code PR000256 to validate your database skills in Google Cloud.

498 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 301–310 of 498

Q301

Which Google Cloud service provides real-time analytics with a fully managed solution?

  • A BigQuery
  • B Cloud Storage
  • C Cloud SQL
  • D Cloud Dataproc
Explanation BigQuery is designed for real-time analytics, while the others serve different purposes.
Q302

A company needs to run low-latency relational workloads. Which database should they choose?

  • A Cloud Firestore
  • B Cloud Spanner
  • C Cloud Datastore
  • D Bigtable
Explanation Cloud Spanner is optimized for relational scalability and low latency, unlike the others.
Q303

You are configuring IAM roles for your database. What happens if a user has multiple roles with conflicting permissions?

  • A Higher role permissions take precedence.
  • B User access is denied entirely.
  • C Conflicting roles cancel each other out.
  • D Permissions are combined into a new role.
Explanation In IAM, more permissive roles typically take precedence, while others don't affect access.
Q304

Which service is best for schema management in Cloud SQL?

  • A Cloud Spanner
  • B Database Migration Service
  • C Cloud SQL Admin API
  • D Cloud Firestore
Explanation Cloud SQL Admin API specializes in schema management, unlike the others which focus on different functionalities.
Q305

A company needs a scalable NoSQL database for real-time analytics. Which solution should they choose?

  • A Cloud SQL
  • B Bigtable
  • C Cloud Spanner
  • D Firestore
Explanation Bigtable is specifically designed for real-time analytics at scale, unlike the other options which serve different use cases.
Q306

What happens when you apply a read-only IAM role to a Cloud SQL user?

  • A User can create databases
  • B User can only read data
  • C User can delete data
  • D User can modify schema
Explanation Applying a read-only IAM role restricts the user to read operations only, prohibiting any data modification or schema changes.
Q307

Which Google Cloud service is best for serverless database solutions?

  • A FireStore
  • B BigQuery
  • C Cloud Spanner
  • D Cloud SQL
Explanation FireStore is optimized for serverless applications, unlike the others which are not inherently serverless.
Q308

A company needs a highly available NoSQL database. Which option should they choose?

  • A Cloud SQL
  • B Cloud Firestore
  • C Bigtable
  • D Cloud Memorystore
Explanation Bigtable is designed for high availability and scalability in NoSQL environments, whereas others have different focuses.
Q309

You are configuring IAM roles for a Cloud SQL instance. What happens if a user is granted 'roles/cloudsql.viewer'?

  • A Can manage Cloud SQL instances.
  • B Can read and list instances.
  • C Can modify database data.
  • D Can delete Cloud SQL databases.
Explanation 'roles/cloudsql.viewer' allows viewing instances, but not modifying them.
Q310

Which service is best for managed NoSQL databases?

  • A Cloud Firestore
  • B Google Cloud SQL
  • C Cloud Bigtable
  • D Cloud Spanner
Explanation Cloud Firestore is designed for NoSQL functionality, while others serve relational or big data use cases.