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 391–400 of 498

Q391

Which Google Cloud service enables real-time data analytics?

  • A BigQuery
  • B Cloud Storage
  • C Cloud Spanner
  • D Cloud Memorystore
Explanation BigQuery is optimized for real-time analytics, while others focus on storage or transactional data.
Q392

A company needs to store sensitive user information securely. Which database should they choose?

  • A Cloud SQL
  • B Cloud Bigtable
  • C Firestore
  • D Cloud Datastore
Explanation Cloud Bigtable is best for handling sensitive data through encryption and offers high performance while the others may not be optimal for scaling.
Q393

What happens when a high capacity Cloud Spanner instance reaches maximum storage?

  • A Instance shuts down immediately
  • B New writes are rejected
  • C Read operations continue unaffected
  • D Capacity automatically scales up
Explanation Cloud Spanner stops accepting new writes to prevent overuse, while reads may still work pending capacity.
Q394

Which service is best for managed PostgreSQL in GCP?

  • A Cloud SQL
  • B BigQuery
  • C Firestore
  • D Cloud Spanner
Explanation Cloud SQL is specifically designed for managed PostgreSQL unlike the others.
Q395

A company needs to migrate its on-premises Oracle database to GCP with minimal downtime. Which service combination should they use?

  • A Database Migration Service and Cloud SQL
  • B Dataflow and Cloud Bigtable
  • C Cloud Spanner and Firestore
  • D Cloud Datastore and BigQuery
Explanation Database Migration Service facilitates low-downtime migrations, making this option optimal.
Q396

What happens when you enable binary logging in Cloud SQL?

  • A Increased read replicas
  • B Data is automatically backed up
  • C Tracks changes for replication
  • D Enhances query performance
Explanation Binary logging is used primarily for replication and data recovery, not the other options.
Q397

Which service is best for managed PostgreSQL databases?

  • A Google Cloud SQL
  • B BigQuery
  • C Cloud Spanner
  • D Firestore
Explanation Google Cloud SQL specifically supports managed PostgreSQL, while other options serve different purposes.
Q398

A company needs to migrate a large on-premises Oracle database to Google Cloud. What is the best practice?

  • A Use Google's Database Migration Service
  • B Manually export and import data
  • C Deploy a new Oracle instance in GCE
  • D Use a third-party migration tool only
Explanation Google's Database Migration Service is designed for efficient migrations to Cloud SQL or other Google databases.
Q399

You are configuring Cloud Firestore security rules. What happens if a rule permits access only to users with 'isAdmin' set to true, but a document does not have that field?

  • A Access is denied to all users
  • B Access is granted to all users
  • C Access is granted to specific users
  • D Access depends on user role
Explanation If the 'isAdmin' field is missing, the rule defaults to deny access based on the condition specified.
Q400

Which service provides fully managed NoSQL database?

  • A Firestore
  • B Cloud SQL
  • C Cloud Spanner
  • D Bigtable
Explanation Firestore is a fully managed NoSQL database, while Cloud SQL and Cloud Spanner cater to SQL databases, and Bigtable is for wide-column stores.