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 311–320 of 498

Q311

A company needs to migrate from an on-premises SQL Server to Google Cloud. Which solution is recommended?

  • A Cloud Pub/Sub
  • B Cloud SQL for SQL Server
  • C Cloud Datastore
  • D Cloud Dataflow
Explanation Cloud SQL for SQL Server specifically supports SQL Server migrations, while others do not relate to SQL Server.
Q312

What happens when you enable automatic backups in Cloud SQL?

  • A Daily backups only
  • B Backups are retained forever
  • C Backup is taken every minute
  • D Backups are deleted after 365 days
Explanation Automatic backups in Cloud SQL are retained for 365 days, balancing usability and storage costs.
Q313

Which service is best for managing relational databases in GCP?

  • A Cloud SQL
  • B BigQuery
  • C Firestore
  • D Datastore
Explanation Cloud SQL is designed for relational databases; BigQuery is for analytics, Firestore and Datastore are NoSQL.
Q314

A company needs to migrate its on-premises Oracle database to GCP with minimal downtime. What approach should they consider?

  • A Use Database Migration Service
  • B Export and Import database dumps
  • C Copy data manually
  • D Utilize Stackdriver monitoring
Explanation Database Migration Service supports live migration for reduced downtime.
Q315

You are configuring a Cloud Spanner instance with a regional config. What is a primary limitation of this setup?

  • A No high availability
  • B Single region failover only
  • C Limited to 1 TB of data
  • D Must be read-only
Explanation Regional configs can only failover within the same region, affecting availability.
Q316

A company needs to ensure their Cloud SQL instance can handle high availability. Which feature should they enable?

  • A Read replicas
  • B Automated backups
  • C Cloud SQL HA
  • D Instance cloning
Explanation Cloud SQL HA provides automatic failover for high availability; read replicas and backups do not ensure availability during a failure.
Q317

What happens when you disable a Google Cloud IAM role from a user group?

  • A Users retain permissions
  • B Permissions are removed
  • C Users get additional permissions
  • D Group is deleted
Explanation Disabling a role removes the associated permissions from all users in that group.
Q318

You are configuring BigQuery access control based on user roles. Which method allows the greatest flexibility?

  • A Dataset-level IAM policies
  • B Project-wide dataset permissions
  • C Table-level permissions
  • D Service account roles
Explanation Dataset-level IAM policies provide fine-grained access control over data within specific datasets.
Q319

Which service provides a fully managed NoSQL database?

  • A Cloud Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud Firestore is designed for NoSQL data storage, while others serve SQL or analytics.
Q320

A company needs to migrate data from on-premises to GCP, ensuring minimal downtime. What should they use?

  • A Online Transfer Appliance
  • B Database Migration Service
  • C Cloud Storage Transfer Service
  • D Persistent Disk Snapshots
Explanation Database Migration Service allows live migrations with minimal downtime.