Latest Professional-Cloud-Database-Engineer Pass Guaranteed Exam Dumps Certification Sample Questions
New Professional-Cloud-Database-Engineer Test Materials & Valid Professional-Cloud-Database-Engineer Test Engine
Google Cloud Certified - Professional Cloud Database Engineer certification exam is a credential offered by Google to validate the skills and expertise of professionals who design and manage databases on Google Cloud. Google Cloud Certified - Professional Cloud Database Engineer certification exam is designed for individuals who have experience in designing, implementing, and managing databases on Google Cloud Platform. Professional-Cloud-Database-Engineer exam tests the candidate's knowledge of database concepts, cloud-native database services, database design and implementation, automation, and security.
NEW QUESTION # 18
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Cloud Spanner with default encryption.
- B. Use Cloud SQL with a customer-managed encryption key (CMEK).
- C. Use Bigtable with default encryption.
- D. Use Cloud Spanner with a customer-managed encryption key (CMEK).
Answer: D
Explanation:
Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.
NEW QUESTION # 19
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
- A. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
- B. Disable and remove the internal IP address assignment.
- C. Specify an authorized network with the CIDR range of the VM.
- D. Disable and remove the external IP address assignment.
Answer: D
Explanation:
It is always more secure to use an internal IP, so removing them doesn't make sense. Eliminate A. You can use Private Google Access when VM instances only have internal IP addresses, so disabling the internal IPs and use Private Google Access doesn't make sense. Eliminate B. Specifying an authorized network when they're on the same subnet doesn't make sense. Eliminate C. A way to improve network security would be to disable external IPs since they're not needed.
NEW QUESTION # 20
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. Use Cloud Scheduler and Cloud Functions to run the daily export.
- C. Set up Cloud Composer, and create a task to export the table daily.
- D. Create a streaming Datatlow job to export the table.
Answer: B
Explanation:
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler
NEW QUESTION # 21
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Functions to run the export in Avro format.
- B. Use Dataflow to run the export in Avro format.
- C. Use Dataflow to run the export in text format.
- D. Use Cloud Functions to run the export in text format.
Answer: B
Explanation:
https://cloud.google.com/spanner/docs/import-export-overview#file-format
NEW QUESTION # 22
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 interleaving to co-locate parent and child rows.
- B. Use granular instance sizing in Cloud Spanner and Autoscaler.
- C. Manually scale down the number of nodes after the peak period has passed.
- D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
Answer: B
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 # 23
Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?
- A. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
- B. Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
- C. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
- D. Use Memorystore to handle your low-latency requirements and for real-time analytics.
Answer: B
NEW QUESTION # 24
Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?
- A. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.
Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance. - B. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
Continue to dump each database until all the databases are migrated.
Update your application connections to the new instance. - C. Create migration job using Database Migration Service.
Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.
Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
Update your application connections to the new instance. - D. Create migration job using Database Migration Service.
Set the migration job type to One-time, and perform this migration during a maintenance window.
Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance.
Answer: C
Explanation:
https://cloud.google.com/datastream/docs/overview.
NEW QUESTION # 25
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
- A. Reduce the number of automated backups that are retained to two (2).
- B. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
- C. Set the automated backups to occur every other day to lower the frequency of backups.
- D. Select a different region to store your backups.
Answer: C
NEW QUESTION # 26
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
- A. Use Memorystore for data storage.
- B. Use Cloud Spanner for data storage.
- C. Use Bigtable for data storage.
- D. Use Cloud SQL for data storage.
Answer: B
Explanation:
google Cloud Spanner is a highly scalable, reliable, and fully managed relational database service that runs on Google's infrastructure. It's designed to handle large amounts of data and provide high availability, even in the face of failures. Spanner can be used to store and manage data for a variety of applications, including e-commerce websites. Spanner is a good choice for this scenario because it can handle high write throughput and provides 99.99% uptime. It's also a good fit for applications that need to be highly available, even in the face of failures.
NEW QUESTION # 27
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. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
- B. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
- C. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
- 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 # 28
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 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.
- B. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
- C. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- D. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
Answer: D
NEW QUESTION # 29
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. 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.
- B. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
- C. Configure your Cloud SQL instance with high availability enabled.
- D. Create your database with one primary node and one read replica in the region.
Answer: A
NEW QUESTION # 30
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. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- B. Move the physical database servers from on-premises to Google Cloud.
- C. Use a change data capture (CDC) migration strategy.
- D. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
- E. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
Answer: A,C
Explanation:
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer
NEW QUESTION # 31
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
- A. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- B. Use customer-managed encryption keys with Cloud SQL.
- C. Use Cloud SQL Auth proxy.
- D. Connect to Cloud SQL using a connection that has SSL encryption.
Answer: D
NEW QUESTION # 32
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
- A. Use the native export and import functionality of the source database.
- B. Create a database on Google Cloud, and use Dataflow for database migration.
- C. Use Database Migration Service.
- D. Create a database on Google Cloud, and use database links to perform the migration.
Answer: C
Explanation:
Simplify migrations to the cloud. Available now for MySQL and PostgreSQL, with SQL Server and Oracle migrations in preview.
* Migrate to Cloud SQL and AlloyDB for PostgreSQL from on-premises, Google Cloud, or other clouds
* Replicate data continuously for minimal downtime migrations
* Serverless and easy to set up
NEW QUESTION # 33
......
Professional-Cloud-Database-Engineer Sample with Accurate & Updated Questions: https://passcollection.actual4labs.com/Google/Professional-Cloud-Database-Engineer-actual-exam-dumps.html