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 231–240 of 498

Q231

You are configuring access to a sensitive dataset in BigQuery. What role should you assign for only query access?

  • A BigQuery Data Viewer
  • B BigQuery Job User
  • C BigQuery Data Editor
  • D BigQuery Admin
Explanation BigQuery Data Viewer allows query access without modification rights; other roles provide broader access than necessary.
Q232

Which Google Cloud service is designed for serverless event-driven functions?

  • A Cloud Functions
  • B Cloud Run
  • C App Engine
  • D Cloud Storage
Explanation Cloud Functions is specifically built for serverless function execution, while others serve different purposes like containers or web applications.
Q233

A company needs to ensure their sensitive data is encrypted at rest and in transit. Which service can achieve this?

  • A BigQuery
  • B Cloud Spanner
  • C Datastore
  • D Cloud SQL
Explanation Cloud Spanner provides encryption for data both at rest and in transit, whereas the other options lack comprehensive encryption features.
Q234

You are configuring resource access using IAM policies. What happens when a user has conflicting roles granted directly and through a group?

  • A Direct role takes precedence
  • B User defaults to no access
  • C Group role takes precedence
  • D Roles are combined for access
Explanation In IAM, direct roles always take precedence over inherited ones from groups or other sources.
Q235

Which service is best for NoSQL databases on Google Cloud?

  • A Firestore
  • B Cloud Spanner
  • C BigQuery
  • D Cloud SQL
Explanation Firestore is designed specifically for NoSQL, while others support SQL formats or analytics.
Q236

A company needs to enforce stricter data residency requirements. What is the best solution in Google Cloud?

  • A Use multiple regions
  • B Set IAM policies
  • C Use a single region
  • D Enable backups
Explanation Using a single region ensures data remains within the designated area, unlike others.
Q237

You are configuring Cloud SQL replicas. What happens if the primary instance fails?

  • A No data loss occurs
  • B Read-only replica becomes primary
  • C All connections are lost
  • D Service automatically scales
Explanation The read-only replica can promote to primary when the primary fails; others do not address primary failure correctly.
Q238

Which service is best for managing relational databases?

  • A Cloud SQL
  • B BigQuery
  • C Datastore
  • D Cloud Firestore
Explanation Cloud SQL is specifically designed for relational databases, while others serve different purposes.
Q239

A company needs low-latency reads and writes for a global application. What Google Cloud solution is best?

  • A Pub/Sub
  • B Firestore
  • C Cloud Spanner
  • D Cloud SQL
Explanation Cloud Spanner offers horizontal scalability and strong consistency, making it ideal for global low-latency applications.
Q240

You are configuring a read replica in Cloud SQL. What database engine supports this feature?

  • A SQL Server
  • B MySQL
  • C Apache Cassandra
  • D Cloud Firestore
Explanation Only MySQL and PostgreSQL support read replicas in Cloud SQL, not SQL Server and others.