Google Professional Cloud Database Engineer (GCP-PCDE) Certification Exam Sample Questions

GCP-PCDE Exam Dumps, GCP-PCDE Examcollection, GCP-PCDE Braindumps, GCP-PCDE Questions PDF, GCP-PCDE VCE, GCP-PCDE Sample Questions, GCP-PCDE Official Cert Guide PDF, Google Professional Cloud Database Engineer PDFWe have prepared Google Professional Cloud Database Engineer (GCP-PCDE) certification sample questions to make you aware of actual exam properties. This sample question set provides you with information about the Google Professional Cloud Database Engineer exam pattern, question formate, a difficulty level of questions and time required to answer each question. To get familiar with Google Cloud Platform - Professional Cloud Database Engineer (GCP-PCDE) exam, we suggest you try our Sample Google Professional Cloud Database Engineer Certification Practice Exam in simulated Google certification exam environment.

To test your knowledge and understanding of concepts with real-time scenario based questions, we strongly recommend you to prepare and practice with Premium Google GCP-PCDE Certification Practice Exam. The premium certification practice exam helps you identify topics in which you are well prepared and topics in which you may need further training to achieving great score in actual Google Cloud Platform - Professional Cloud Database Engineer (GCP-PCDE) exam.

Google GCP-PCDE Sample Questions:

01. During a heterogeneous migration from Oracle to Cloud SQL for PostgreSQL, a conversion step maps every Oracle DATE column to the PostgreSQL date type. Post-load validation shows that appointment records match on row count, but the time of day recorded against each appointment has disappeared.
What is the correct remedy?
a) Add a separate column for the time of day, and populate it from the application for records created from now on.
b) Set a session time zone on the destination so that the stored values render with their time component.
c) Re-run the row-count validation against a larger sample to confirm whether the loss is systematic.
d) Map the affected columns to a timestamp type and reload them, because the source type carries a time component.
 
02. After a MySQL migration, an application team reports that a report which used to list customer names in a stable order now returns them differently, and one nightly load has begun failing on a unique index that never rejected rows before.
What is the most likely cause?
a) The destination was created with a different collation, which changes both sort order and which values compare as equal.
b) The unique index was created before the data was loaded, so it indexed a table that was still incomplete at the time.
c) Statistics on the destination are stale, so the query planner has begun choosing a different join order for the report.
d) The destination instance has fewer vCPUs than the source, so parallel sorting and parallel index builds are disabled.
 
03. Several teams provision their own Cloud SQL instances. An audit finds instances in production without high availability and without automated backups, created by teams that were unaware of the standard.
Which two measures make the standard hold by default?
(Choose two.)
a) Publish a provisioning module that sets high availability and backup configuration, and require teams to use it.
b) Apply an organization policy constraint so that non-compliant instances are refused at creation.
c) Circulate the standard to every team, ask their leads to confirm they have read it, and record the replies.
d) Run a weekly report of instances that lack high availability, and email the owning teams.
e) Grant a central platform team sole permission to create database instances.
 
04. An application reads from three Cloud SQL read replicas. Replication lag on all three has been climbing for a week, and adding a fourth replica last month made no difference. The primary's processor utilization is moderate and its storage has headroom.
What is the likely constraint?
a) The read query load, which has outgrown the capacity of the three replicas combined.
b) The primary's processor capacity, which is limiting how quickly it can ship changes.
c) The volume of writes the primary produces, which every replica has to apply in full.
d) The network path between the primary and the replicas, which is saturated by three streams.
 
05. You are planning the initial load phase of a large migration into Cloud SQL. Steady-state traffic after cutover is modest, but the load phase writes the entire dataset in a few hours.
What should the destination sizing plan say?
a) Take the source server's specification as the size, since the data being loaded is the same data.
b) Provision extra compute for the load phase, and return it to the steady-state size afterwards.
c) Size the instance for steady-state traffic, because the load phase runs before any user depends on it.
d) Size the instance for the load phase, and keep that capacity permanently to absorb future growth.
 
06. Before a new highly available Cloud SQL deployment is accepted into production, you are writing the validation checklist.
Which two checks belong on it?
(Choose two.)
a) That the standby instance can serve read queries during normal operation.
b) That the primary and standby are placed in different regions.
c) That a triggered failover completes inside the documented recovery time objective.
d) That the instance's automated backup can be restored into the same instance in under a minute.
e) That the application resumes serving after a failover without a person intervening.
 
07. Change capture has been running for four days against a busy source. Replication delay fell steadily for the first two days, then flattened well above the threshold the cutover plan requires, and it has not moved since.
What should you investigate first?
a) Whether the source's transaction log retention is long enough to cover four days.
b) Whether the network link between the source and the destination has enough bandwidth.
c) Whether the ceiling reached is the destination's apply rate or the source's change rate.
d) Whether the destination instance is running out of storage for the replicated data.
 
08. A new internal application will serve one country, with a workload a single relational primary handles comfortably and no requirement for cross-region writes. A team member proposes Spanner so that the design will not have to change if the application ever expands globally.
How should you assess the proposal?
a) Adopt it, because migrating a relational schema later is expensive and the design should anticipate growth.
b) Adopt it, but deploy in a regional configuration to keep the cost close to a single-primary service.
c) Recommend a single-primary service now and plan a migration to Spanner for the next financial year.
d) Recommend the service that meets the stated requirements, and revisit the decision if they change.
 
09. Every database instance is created from a shared infrastructure module that sets high availability and backup configuration. An audit still finds two production instances without automated backups. Both were created from the module.
What should the pipeline add?
a) A check after creation that reads the instance's actual configuration and fails the run if it does not match the standard.
b) A required review on any change to the module, so the standard cannot regress.
c) A rule that pins every caller to the latest published version of the module.
d) A quarterly audit of production instances against the standard, with the findings reported to each owning team.
 
10. Two candidate Cloud SQL configurations are being compared for a write-heavy workload. Both offer the same processor and memory. A cost comparison has been produced that considers only those two dimensions.
What does the comparison need to include before it can support a decision?
a) The number of databases each configuration will host, since consolidation changes the per-database cost.
b) The network egress charges each configuration will attract from the application tier.
c) The storage type and provisioned capacity, which govern the I/O the workload depends on.
d) The licensing model of the database engine, and how it differs between machine configurations.

Answers:

Question: 01
Answer: d		 Question: 02
Answer: a		 Question: 03
Answer: a, b		 Question: 04
Answer: c		 Question: 05
Answer: b
Question: 06
Answer: c, e		 Question: 07
Answer: c		 Question: 08
Answer: d		 Question: 09
Answer: a		 Question: 10
Answer: c

Note: Please update us by writing an email on feedback@vmexam.com for any error in Google Cloud Platform - Professional Cloud Database Engineer (GCP-PCDE) certification exam sample questions

Rating: 4.9 / 5 (76 votes)