ActualVCE Professional-Cloud-Database-Engineer dumps & Google Cloud Certified Sure Practice with 134 Questions
New Professional-Cloud-Database-Engineer Exam Questions| Real Professional-Cloud-Database-Engineer Dumps
Google Professional-Cloud-Database-Engineer certification exam is a valuable credential for IT professionals who want to demonstrate their expertise in managing databases on the Google Cloud Platform. By earning this certification, you can validate your practical skills and knowledge in designing, developing, and administering scalable and secure databases on Google Cloud. Google Cloud Certified - Professional Cloud Database Engineer certification can help you enhance your job prospects, increase your earning potential, and gain recognition as a proficient database professional.
To become a Google Professional-Cloud-Database-Engineer, candidates must have a deep understanding of database management systems, including relational databases, NoSQL databases, and data warehousing solutions. They must also have experience in designing and implementing scalable and resilient database architectures using GCP's database services such as Cloud SQL, Cloud Spanner, and Bigtable. Additionally, candidates must have a good understanding of SQL and programming languages such as Java or Python.
NEW QUESTION # 17
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?
- A. Close idle connections or restart the instance before beginning the import operation.
- B. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- C. Ensure that the service account has the Storage Admin role.
- D. Increase the amount of memory allocated to your instance.
Answer: C
NEW QUESTION # 18
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?
- A. Use data replication tools and CDC tools to enable migration.
- B. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
- C. Use Database Migration Service to migrate all databases to Cloud SQL.
- D. Use a combination of Database Migration Service and partner tools to support the data migration strategy.
Answer: C
Explanation:
https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines
NEW QUESTION # 19
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
- A. Use Key Visualizer for Bigtable.
- B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
- C. Add more nodes to the Bigtable cluster.
- D. Isolate the data analysts and operations user groups to use different Bigtable instances.
Answer: A
Explanation:
https://cloud.google.com/bigtable/docs/performance#troubleshooting
NEW QUESTION # 20
You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?
- A. Use Cloud SQL for PostgreSQL with both cross-region read replicas.
- B. Use a Bigtable instance with clusters in multiple regions.
- C. Use Cloud Spanner in a multi-region configuration.
- D. Use Firestore in Datastore mode.
Answer: A
NEW QUESTION # 21
You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?
- A. Keep the total CPU utilization under 45% in each region.
- B. Place the bulk of the read and write workloads closer to the default leader region.
- C. Add more read-write replicas.
- D. Use staleness of at least 15 seconds.
Answer: C
NEW QUESTION # 22
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- B. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- C. Migrate applications and Oracle databases to Compute Engine.
- D. Migrate applications to Cloud SQL.
Answer: A
Explanation:
https://cloud.google.com/blog/products/databases/migrate-databases-to-google-cloud-vmware-engine-gcve
NEW QUESTION # 23
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
- A. Identify and optimize slow running queries, or set parallel replication flags.
- B. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
- C. Edit the primary instance to add additional memory.
- D. Stop all running queries, and re-create the replicas.
Answer: B
NEW QUESTION # 24
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 # 25
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?
- A. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- B. Use sharded Cloud SQL instances with one or more stores per database instance.
- C. Use a Biglable cluster with autoscaling.
- D. Use Cloud Spanner with a custom autoscaling solution.
Answer: D
Explanation:
https://cloud.google.com/spanner/docs/autoscaling-overview
1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit 2. Scale is done manually on SQL Cloud
NEW QUESTION # 26
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
- A. Migrate the existing database to Cloud Spanner.
- B. Migrate the existing database to Cloud SQL for PostgreSQL.
- C. Migrate the existing database to Firestore.
- D. Migrate the existing database to PostgreSQL running on Compute Engine.
Answer: B
NEW QUESTION # 27
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 Cloud SQL instance monitoring in the Google Cloud Console.
- D. Use log messages produced by Cloud SQL.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/using-query-insights#introduction
NEW QUESTION # 28
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
- A. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- B. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- C. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
- D. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
Answer: D
NEW QUESTION # 29
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.databaseUser
- C. roles/spanner.databaseReader
- D. roles/spanner.viewer
Answer: C
Explanation:
https://cloud.google.com/spanner/docs/iam?hl=it
NEW QUESTION # 30
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
- A. Set up Cloud NAT service.
- B. Setup a static external IP address in your VPC network.
- C. Set up a Cloud NAT gateway on the Compute Engine VM.
- D. Set up bring your own IP (BYOIP) in your VPC.
Answer: C
Explanation:
https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat The docs specifically says "Setting up a NAT gateway on a Compute Engine VM" is the way to give BMS internet access.
NEW QUESTION # 31
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?
- A. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
- B. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
- C. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- D. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external
NEW QUESTION # 32
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 each application code, set up a dedicated user account.
- B. For the application server, set up a service account.
- C. For the application server, set up a common shared user account.
- D. For each application code, set up a common shared user account.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account
NEW QUESTION # 33
Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?
- A. Select Cloud SQL.
- B. Select Bigtable.
- C. Select Bare Metal Solution for Oracle.
- D. Select Cloud Spanner.
Answer: D
Explanation:
The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases.
NEW QUESTION # 34
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?
- A. Increase the number of processing units.
- B. Shard data required by the application into multiple instances.
- C. Decrease the number of processing units.
- D. Modify the database schema, and add additional indexes.
Answer: A
NEW QUESTION # 35
......
Professional-Cloud-Database-Engineer Braindumps – Professional-Cloud-Database-Engineer Questions to Get Better Grades: https://www.actualvce.com/Google/Professional-Cloud-Database-Engineer-valid-vce-dumps.html
Get New Professional-Cloud-Database-Engineer Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=1GJs9Iu7vqTGVgKj-c7BFvNC5_-0IDIlM