Google Cloud Certified - Professional Cloud Database Engineer
https://killexams.com/pass4sure/exam-detail/Google-PCDE
Question: 30
hould you do?
atabase Migration Service to migrate all databases to Cloud SQL.
atabase Migration Service for one-time migrations, and use third-party or partner tools for change dat (CDC) style migrations.
ata replication tools and CDC tools to enable migration.
a combination of Database Migration Service and partner tools to support the data migration strategy.
on: 31
rganization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of privilege (PoLP) are critical. The operations team consists of: Person A is a database administrator.
B is an analyst who generates metric reports. ation C is responsible for automatic backups.
ed to assign roles to team members for Cloud Spanner .
oles should you assign? s/spanner.databaseAdmin for Person A panner.databaseReader for Person B panner.backupWriter for Application C s/spanner.databaseAdmin for Person A panner.databaseReader for Person B
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 s
Use D
Use D a
capture
Use d
Use
Questi
Your o least
Person Applic You ne Which r
role roles/s roles/s
role roles/s
roles/spanner.backupAdmin for Application C
roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner databaseReader for Application C
roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner.backupWriter for Application C
Question: 32
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?
Setup a static external IP address in your VPC network.
Set up bring your own IP (BYOIP) in your VPC.
Set up a Cloud NAT gateway on the Compute Engine VM.
Set up Cloud NAT service.
on: 33
rganization has a critical business app that is running with a Cloud SQL for MySQL backend database. ny wants to build the most fault-tolerant and highly available solution possible. You need to ensure that tion database can survive a zonal and regional failure with a primary region of us-central1 and the back
f us-east1 .
hould you do?
vision a Cloud SQL for MySQL instance in us-central1-a. multiple-zone instance in us-west1-b.
read replica in us-east1-c.
ision a Cloud SQL for MySQL instance in us-central1-a. multiple-zone instance in us-central1-b.
read replica in us-east1-b.
ision a Cloud SQL for MySQL instance in us-central1-a. multiple-zone instance in us-east-b.
read replica in us-east1-c.
vision a Cloud SQL for MySQL instance in us-central1-a. multiple-zone instance in us-east1-b.
read replica in us-central1-b.
on: 34
Questi
Your o Your
compa the
applica up
region o
What s
Pro Create a Create a
Prov Create a Create a
Prov Create a Create a
Pro Create a Create a
Questi
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?
Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
Create an external replica, and use Cloud SQL to synchronize the data to the replica.
Question: 35
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?
Use log messages produced by Cloud SQL.
Use Query Insights for Cloud SQL.
Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
on: 36
ompany uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of produ es over the last 30 days. Your database operations team uses these recommendations to proactively mon utilization and implement corrective actions. You receive a recommendation that the instance is likely t isk space .
hould you do to address this storage alert? malize the database to the third normal form.
mpress the data using a different compression algorithm. ually or automatically increase the storage capacity.
ate another schema to load older data.
on: 37
rganization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database mance. You need to identify the root cause of the performance degradation .
hould you do?
ogs Explorer to analyze log data.
Use Cloud SQL instance monitoring in the Google Cloud Console.
Questi
Your c ction
databas itor
storage o run
out of d
What s
Nor
Co
Man
Cre
Questi
Your o perfor
What s
Use L
Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
Use Error Reporting to count, analyze, and aggregate the data.
Use Cloud Debugger to inspect the state of an application.
Question: 38
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics
workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports .
Which two approaches should you implement? (Choose two.)
Create secondary indexes on the replica.
Create additional read replicas, and partition your analytics users to use different read replicas.
Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.
Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re- enable replication and optimize performance by setting flags on the read replica.
on: 39
designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as backend database for game state storage and player authentication. You want to track in-game rewards unlock at every stage of the game. During the testing phase, you discovered that costs are much higher ated, but the query response times are within the SL
want to follow Google-recommended practices. You need the database to be performant and highly av ou keep costs low .
hould you do?
ually scale down the number of nodes after the peak period has passed. nterleaving to co-locate parent and child rows.
he Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query. ranular instance sizing in Cloud Spanner and Autoscaler.
on: 40
Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
Questi
You are the
primary that
players than
anticip
A. You ailable
while y
What s
Man
Use i
Use t
Use g
Questi
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices .
What should you do?
Use Firestore with Looker.
Use Cloud Spanner with Data Studio.
Use MongoD8 Atlas with Charts.
Use Bigtable with Looker.
For More exams visit https://killexams.com/vendors-exam-list
