[Apr-2024] The Best Google Cloud Certified Study Guide for the Professional-Cloud-Database-Engineer Exam
Professional-Cloud-Database-Engineer certification guide Q&A from Training Expert TestBraindump
Google Professional-Cloud-Database-Engineer exam is an excellent choice for individuals who are looking to validate their skills and knowledge in the latest database technologies and showcase their expertise to potential employers or clients. Passing Professional-Cloud-Database-Engineer exam can open up new career opportunities in cloud database engineering and provide a competitive edge in the job market.
To prepare for the Professional-Cloud-Database-Engineer Exam, candidates should have a solid understanding of database concepts and technologies, as well as experience working with databases on the Google Cloud Platform. They should also be familiar with cloud computing concepts and technologies, such as virtualization, networking, and storage. Candidates can prepare for the exam by taking online courses, attending training sessions, and studying the official exam guide provided by Google.
NEW QUESTION # 13
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. Shard data required by the application into multiple instances.
- B. Modify the database schema, and add additional indexes.
- C. Increase the number of processing units.
- D. Decrease the number of processing units.
Answer: C
Explanation:
In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%20the%20CPU%20utilization%20of%20the%20instance%20is%20above%20the%20recommended%20level%2C%20you%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%20auto%20scaling. "Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling." Indexes and schema are reviewed post identifying query with slow performance. Refer : https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#review-schema
NEW QUESTION # 14
You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:
Can read tables, views, and DDL
Can write rows to the tables
Can add columns and indexes
Cannot drop the database
What should you do?
- A. Assign the Cloud Spanner Admin role.
- B. Assign the Cloud Spanner Database Admin role.
- C. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
- D. Assign the Cloud Spanner Database User role.
Answer: D
Explanation:
https://cloud.google.com/spanner/docs/iam#spanner.databaseUser
NEW QUESTION # 15
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
- A. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
- B. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
- C. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
- D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
Answer: D
NEW QUESTION # 16
Your team is building an application that stores and analyzes streaming time series financial dat a. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
- A. Use Cloud Spanner.
- B. Use Bigtable
- C. Use Firestore.
- D. Use BigQuery.
Answer: B
Explanation:
Financial data, such as transaction histories, stock prices, and currency exchange rates.
https://cloud.google.com/bigtable/docs/overview#what-its-good-for
With SSD:
Reads - up to 10,000 rows per second
Writes - up to 10,000 rows per second
Scans - up to 220 MB/s
https://cloud.google.com/bigtable/docs/performance#typical-workloads
NEW QUESTION # 17
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Move the physical database servers from on-premises to Google Cloud.
- B. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- C. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- D. Use a change data capture (CDC) migration strategy.
- E. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
Answer: D,E
NEW QUESTION # 18
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?
- A. Create another schema to load older data.
- B. Manually or automatically increase the storage capacity.
- C. Compress the data using a different compression algorithm.
- D. Normalize the database to the third normal form.
Answer: C
NEW QUESTION # 19
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?
- A. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- B. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
- C. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
- D. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
Answer: C
NEW QUESTION # 20
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
- A. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
- B. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
- C. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
- D. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
Answer: D
NEW QUESTION # 21
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
- A. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
- B. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
- C. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
- D. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
Answer: B
Explanation:
Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C. https://cloud.google.com/compute/docs/disks/performance
NEW QUESTION # 22
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. Increase the amount of memory allocated to your instance.
- B. Close idle connections or restart the instance before beginning the import operation.
- C. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- D. Ensure that the service account has the Storage Admin role.
Answer: D
NEW QUESTION # 23
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
- A. Run the cron job on a Compute Engine instance to continue the export.
- B. Set up Cloud Composer, and create a task to export the table daily.
- C. Create a streaming Datatlow job to export the table.
- D. Use Cloud Scheduler and Cloud Functions to run the daily export.
Answer: D
Explanation:
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler
NEW QUESTION # 24
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?
- A. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
- B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- C. Verify that the new replica is created automatically.
- D. Start the original primary instance and resume replication.
Answer: B
NEW QUESTION # 25
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
- A. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
- B. Set up different organizations for each database type, and apply policy constraints at the organization level.
- C. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
- D. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
Answer: C
NEW QUESTION # 26
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat a. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?
- A. Create your database with one primary node and one read replica in the region.
- B. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
- C. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
- D. Configure your Cloud SQL instance with high availability enabled.
Answer: B
Explanation:
Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
NEW QUESTION # 27
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
- A. Use Bigtable.
- B. Use Cloud Spanner.
- C. Use Cloud SQL for MySQL
- D. Use Firestore.
Answer: B
Explanation:
Spanner covers the SLA
NEW QUESTION # 28
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 service account.
- B. For each application code, set up a dedicated user 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: A
Explanation:
https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account
NEW QUESTION # 29
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. Add more read-write replicas.
- B. Use staleness of at least 15 seconds.
- C. Keep the total CPU utilization under 45% in each region.
- D. Place the bulk of the read and write workloads closer to the default leader region.
Answer: D
Explanation:
https://cloud.google.com/spanner/docs/instance-configurations#multi-region-best-practices Best practices For optimal performance, follow these best practices: Design a schema that prevents hotspots and other performance issues. For optimal write latency, place compute resources for write-heavy workloads within or close to the default leader region. For optimal read performance outside of the default leader region, use staleness of at least 15 seconds. To avoid single-region dependency for your workloads, place critical compute resources in at least two regions. A good option is to place them next to the two different read-write regions so that any single region outage will not impact all of your application. Provision enough compute capacity to keep high priority total CPU utilization under 45% in each region.
NEW QUESTION # 30
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?
- A. Recommend solid-state drives (SSD).
- B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
- C. Recommend mixed storage types.
- D. Recommend hard disk drives (HDD).
Answer: A
Explanation:
if you plan to store extensive historical data for a large number of remote-sensing devices and then use the data to generate daily reports, the cost savings for HDD storage might justify the performance tradeoff. On the other hand, if you plan to use the data to display a real-time dashboard, it probably would not make sense to use HDD storage-reads would be much more frequent in this case, and reads that are not scans are much slower with HDD storage.
NEW QUESTION # 31
......
The Best Google Professional-Cloud-Database-Engineer Study Guides and Dumps of 2024: https://www.testbraindump.com/Professional-Cloud-Database-Engineer-exam-prep.html
Professional-Cloud-Database-Engineer Certification Overview Latest Professional-Cloud-Database-Engineer PDF Dumps: https://drive.google.com/open?id=1A_ph1QPXcCy05XMR5UltEyMnQ6EVpVKM
