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 401–410 of 498

Q401

A company needs to migrate a relational database to Google Cloud. Which service should they choose for minimal downtime?

  • A Database Migration Service
  • B Cloud Memorystore
  • C Cloud Functions
  • D Datastore
Explanation The Database Migration Service is designed for low-downtime migrations of relational databases, while the other options are not intended for this purpose.
Q402

What happens when you set a Cloud SQL instance to private IP?

  • A Instance is accessible over the public internet
  • B Instance can only be accessed via VPN
  • C Instance is isolated from all networks
  • D Instance becomes read-only
Explanation Setting a Cloud SQL instance to private IP limits access to private networks, typically VPN or VPC peering, while the other options misstate its capabilities.
Q403

Which service allows real-time data processing in GCP?

  • A Cloud Dataflow
  • B Cloud Storage
  • C Cloud SQL
  • D BigQuery
Explanation Cloud Dataflow is designed for real-time processing; others are not.
Q404

A company needs to ensure data stored in Firestore is secure. Which IAM role should they assign?

  • A Firestore Viewer
  • B Firestore Editor
  • C Firestore Owner
  • D Viewer Role
Explanation Firestore Owner provides comprehensive permissions, while others are more limited.
Q405

What happens when you set a Cloud SQL instance to 'public' access?

  • A Endpoint becomes visible externally
  • B Data is encrypted automatically
  • C Backups are disabled
  • D Firewall rules are ignored
Explanation Public access exposes the endpoint; the other options are incorrect actions or settings.
Q406

Which service is designed for real-time analytics in Google Cloud?

  • A BigQuery
  • B Cloud Storage
  • C Cloud SQL
  • D Firestore
Explanation BigQuery is optimized for real-time analytics, while others are not primarily designed for this purpose.
Q407

A company needs to securely manage database access. What should they implement?

  • A IAM roles and permissions
  • B Cloud Functions
  • C Stackdriver Monitoring
  • D Cloud Pub/Sub
Explanation IAM roles and permissions effectively manage access, while others do not directly address security management.
Q408

What happens when you configure a database to use public IP addresses without proper security?

  • A Increased security and data integrity
  • B Potential exposure to attacks
  • C Enhanced performance
  • D Immediate connection failures
Explanation Public IP configuration without security increases vulnerability, while others suggest incorrect outcomes.
Q409

Which service is best for serverless data warehousing?

  • A BigQuery
  • B Cloud SQL
  • C Firestore
  • D Cloud Spanner
Explanation BigQuery is designed for serverless analysis while others require provisioning and management.
Q410

A company needs real-time processing of streaming data. Which service should they use?

  • A Cloud Run
  • B Pub/Sub
  • C Cloud Storage
  • D Cloud Functions
Explanation Pub/Sub is designed for real-time message ingestion and processing, while others are not optimized for streaming.