Updated Nov-2024 Exam Professional-Cloud-Database-Engineer Dumps - Pass Your Certification Exam
Latest Real Google Professional-Cloud-Database-Engineer Exam Dumps Questions
Google Professional-Cloud-Database-Engineer exam is intended for individuals with experience in database administration and development, including knowledge of SQL and database design principles. Candidates should also have experience working with Google Cloud Platform, including knowledge of its database services such as Cloud SQL, Cloud Spanner, and Cloud Bigtable. Successful candidates will be able to implement and manage highly available, scalable, and secure databases on Google Cloud Platform, and provide optimal database solutions to meet an organization's needs. Google Cloud Certified - Professional Cloud Database Engineer certification is suitable for professionals working in roles such as database administrator, database developer, data engineer, and cloud architect.
Google Professional-Cloud-Database-Engineer exam is a certification exam offered by Google Cloud. It is designed for professionals who want to demonstrate their expertise in designing, developing, and managing database solutions on Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification is called Google Cloud Certified - Professional Cloud Database Engineer.
Google Professional-Cloud-Database-Engineer certification exam is designed for professionals who want to demonstrate their expertise in designing, developing, and managing Google Cloud Platform (GCP) database solutions. Professional-Cloud-Database-Engineer exam measures the candidate's ability to design, implement, and manage highly available and scalable relational and NoSQL databases on GCP. It also tests their knowledge of various GCP database services such as Cloud SQL, Cloud Spanner, and Cloud Bigtable.
NEW QUESTION # 58
You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?
- A. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Use Cloud SQL Auth proxy to connect to the instance. - B. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Use Cloud SQL Auth proxy to connect to the instance. - C. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Connect to the instance using a connection pool to best manage connections to the instance. - D. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Connect to the instance using a connection pool to best manage connections to the instance.
Answer: A
NEW QUESTION # 59
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?
- A. Create a new service account, and grant it the spanner.databases.select permission.
- B. Create a new service account, and grant it the Cloud Spanner Database Reader role.
- C. Reuse the existing service account that populates this database.
- D. Create a new service account, and grant it the Cloud Spanner Database Admin role.
Answer: B
Explanation:
https://cloud.google.com/iam/docs/overview
NEW QUESTION # 60
Your company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?
- A. roles/spanner.backupWriter
- B. roles/spanner.databaseReader
- C. roles/spanner.databaseUser
- D. roles/spanner.viewer
Answer: B
Explanation:
https://cloud.google.com/spanner/docs/iam?hl=it
NEW QUESTION # 61
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?
- A. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C - D. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C
Answer: C
NEW QUESTION # 62
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?
- A. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
- B. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
- C. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
- D. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
Answer: C
Explanation:
The best answer is deploy an HA configuration and have a read replica you could promote to the primary in a different region
NEW QUESTION # 63
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
- B. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
- C. Use Cloud Composer to execute a select * from table(s) query and export results.
- D. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
Answer: D
Explanation:
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler
NEW QUESTION # 64
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
- A. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
- B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
- C. Set your production instance's maintenance window to non-business hours.
- D. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
Answer: C
NEW QUESTION # 65
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?
- A. Create a custom app profile with multi-cluster routing.
- B. Use the default app profile with multi-cluster routing.
- C. Use the default app profile with single-cluster routing.
- D. Create a custom app profile with single-cluster routing.
Answer: C
NEW QUESTION # 66
Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?
- A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- B. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
- C. Edit the instance to change the storage type from HDD to SSD.
- D. Create a read replica of the instance with SSDs, and perform a failover to the new instance
Answer: B
NEW QUESTION # 67
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
- A. Develop a custom data replication service to send data into BigQuery.
- B. Use Cloud SQL federated queries.
- C. Use Database Migration Service to replicate tables into BigQuery.
- D. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
Answer: D
Explanation:
"Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. Datastream supports change data streaming from Oracle and MySQL databases to Google Cloud Storage (GCS). The service offers streamlined integration with Dataflow templates to power up to date materialized views in BigQuery for analytics, replicate their databases into Cloud SQL or Cloud Spanner for database synchronization, or leverage the event stream directly from GCS to realize event-driven architectures."
NEW QUESTION # 68
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
- A. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
- B. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
- C. Restore the Cloud SQL instance from the automatic backups in region 3.
- D. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery
NEW QUESTION # 69
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
- A. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- B. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
- C. Use Database Migration Service to migrate your database.
- D. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
Answer: B
Explanation:
PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database. + PgBouncer is a simple PostgreSQL connection pool that allows for several thousand connections at a time. Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech-industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank. https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max-connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%20bank.
NEW QUESTION # 70
You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?
- A. Use granular instance sizing in Cloud Spanner and Autoscaler.
- B. Manually scale down the number of nodes after the peak period has passed.
- C. Use interleaving to co-locate parent and child rows.
- D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
Answer: A
Explanation:
Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances, https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular-instance-sizing
NEW QUESTION # 71
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
- A. Use Cloud Audit Logs to verify the status.
- B. Perform the gcloud sql operations list command.
- C. Check the cloudsql.googleapis.com/postgres.log instance log.
- D. Use the Google Cloud Console.
Answer: A
NEW QUESTION # 72
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For the application server, set up a common shared user account.
- B. For each application code, set up a common shared user account.
- C. For the application server, set up a service account.
- D. For each application code, set up a dedicated user account.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account
NEW QUESTION # 73
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
- A. Use workload identity federation to impersonate a service account.
- B. Ask existing users to set their Google password to match their corporate password.
- C. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
- D. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
Answer: D
NEW QUESTION # 74
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?
- A. Use Query Insights for Cloud SQL.
- B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- C. Use log messages produced by Cloud SQL.
- D. Use Cloud SQL instance monitoring in the Google Cloud Console.
Answer: B
NEW QUESTION # 75
Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?
- A. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
- C. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- D. Migrate all the databases to Cloud SQL.
Answer: C
NEW QUESTION # 76
You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?
- A. C.Deploy the database using Bigtable.
- B. Use BigQuery, and load data in batches.
- C. Deploy the database using Cloud Spanner.
- D. Deploy the database using Cloud SQL.
Answer: A
Explanation:
Bigtable is a scalable, fully managed, and high-performance NoSQL database service that can handle semi-structured data and support real-time monitoring and analysis. Cloud SQL is a relational database service that does not support semi-structured dat a. BigQuery is a data warehouse service that is optimized for batch processing and analytics, not real-time monitoring. Cloud Spanner is a relational database service that supports semi-structured data with JSON data type, but it is more expensive and complex than Bigtable for this use case.
NEW QUESTION # 77
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
- A. Use Bigtable with clusters in multiple regions to deploy the database
- B. Use BigQuery to deploy the database
- C. Use Cloud SQL with a regional read replica to deploy the database.
- D. Use Cloud Spanner to deploy the database.
Answer: B
NEW QUESTION # 78
......
Professional-Cloud-Database-Engineer Dumps To Pass Google Cloud Certified Exam in One Day: https://torrentpdf.guidetorrent.com/Professional-Cloud-Database-Engineer-dumps-questions.html