CCNA Pca Optimising Processes Questions — Page 2 of 2

MCQmedium

A company runs a critical application on Compute Engine with a 1-year commitment for cost savings. They want to also optimize for performance by using machine types with more memory. They plan to update to a different machine series during the commitment term. Which committed use discount type allows this flexibility?

A.Preemptible discount

B.Sustained use discount

C.Spend-based committed use discount

D.Resource-based committed use discount

AnswerC

Spend-based discounts provide commitment to a dollar amount, allowing flexible selection of machine types as long as the spend is maintained.

Why this answer

Spend-based committed use discounts apply to a dollar amount of spend on eligible instance types, allowing flexibility to change machine types as long as the spend commitment is met. Resource-based committed use discounts are tied to specific machine types (e.g., n1-standard-4) and cannot be changed without breaking the commitment.

Practice this question →

MCQeasy

A company wants to migrate a MySQL database running on-premises to Cloud SQL with minimal downtime. Which GCP service should they use?

A.Migrate for Compute Engine

B.Storage Transfer Service

C.Transfer Appliance

D.Database Migration Service

AnswerD

DMS provides minimal-downtime migration for MySQL to Cloud SQL.

Why this answer

Database Migration Service (DMS) supports homogeneous migrations for MySQL, PostgreSQL, and SQL Server with minimal downtime using continuous replication. Migrate for Compute Engine is for VM migration, Transfer Appliance for bulk data, and Storage Transfer Service for object storage.

Practice this question →

Multi-Selecteasy

A development team uses BigQuery for analytical queries. They want to reduce query costs for a large table that is frequently filtered by a date column and a customer_id column. Which TWO table design strategies will reduce the amount of data scanned? (Choose 2)

Select 2 answers

A.Partition the table by date.

B.Create an index on customer_id.

C.Use wildcard tables with date suffixes.

D.Normalize the table into multiple tables.

E.Cluster the table on customer_id.

AnswersA, E

Date partitioning allows queries to scan only relevant partitions.

Why this answer

Partitioning by date limits scans to relevant partitions. Clustering on customer_id further organizes data within partitions for efficient filtering. Both reduce data scanned.

Indexes and normalization are not applicable in BigQuery.

Practice this question →

MCQmedium

An application running on Compute Engine frequently makes connection requests to a Cloud SQL for PostgreSQL instance. The connections are short-lived and many are created per second. What should be implemented to reduce latency and connection overhead?

A.Deploy PgBouncer on the application server or as a sidecar

B.Increase the number of vCPUs on the Cloud SQL instance

C.Enable connection scaling in Cloud SQL

D.Use Cloud SQL Auth Proxy with private IP

AnswerA

PgBouncer acts as a connection pooler, maintaining a pool of persistent connections to the database and reusing them for application requests, reducing latency and overhead.

Why this answer

Connection pooling reuses database connections instead of creating new ones for each request. PgBouncer is a lightweight connection pooler for PostgreSQL. Cloud SQL Auth Proxy is for secure connections but does not pool.

Practice this question →

MCQmedium

An e-commerce application uses Firestore for product catalog. They need to run complex analytical queries on the catalog data, such as aggregations and joins, without impacting production performance. What is the best approach?

A.Create a second Firestore database for analytics

B.Use Cloud SQL to query Firestore directly

C.Use Firestore `!=` operator to filter data

D.Export Firestore data to BigQuery for analytics

AnswerD

BigQuery is designed for analytical workloads and integrates with Firestore via exports.

Why this answer

Firestore is not designed for analytical queries. Exporting to BigQuery allows running complex analytics without impacting Firestore performance. Using a second Firestore database increases cost but doesn't improve analytics.

Cloud SQL does not natively integrate with Firestore. Using the `!=` operator doesn't solve analytical needs.

Practice this question →

MCQmedium

A company is designing a disaster recovery strategy for a critical application. They need to ensure that if the primary region fails, the application can fail over to a secondary region with a Recovery Point Objective (RPO) of 1 hour and a Recovery Time Objective (RTO) of 15 minutes. The application uses Cloud Spanner. Which Cloud Spanner configuration meets these requirements?

A.Multi-region configuration (e.g., nam3)

B.Single-region configuration

C.Backup and restore in another region

D.Dual-region with asynchronous replication

AnswerA

Multi-region configurations replicate data synchronously across regions, providing automatic failover with RPO=0 and RTO<15 minutes, meeting the requirements.

Why this answer

Cloud Spanner multi-region configurations provide automatic replication across regions with synchronous replication, achieving RPO near zero and RTO in seconds. Single-region configurations do not provide geographic failover. A two-region setup like nam3 (US Central + US East) or eur3 (Europe) provides synchronous replication with strong consistency.

Active/active is the default. Multi-region configs are recommended for DR.

Practice this question →

MCQmedium

An organization deploys a web application on Compute Engine behind a global HTTPS load balancer. They want to reduce latency for users worldwide and minimize load on backend instances. Which GCP service should they use?

A.Cloud Armor

B.Cloud NAT

C.Cloud CDN

D.VPC Network Peering

AnswerC

Cloud CDN caches content at Google's edge locations to reduce latency and backend load.

Why this answer

Cloud CDN uses Google's global edge caches to serve content closer to users, reducing latency and backend load. Cloud Armor provides security, Cloud NAT is for outbound connectivity, and VPC peering is for network connectivity, not caching.

Practice this question →

MCQmedium

A company is migrating a 200 TB on-premises file server to Cloud Storage. The network bandwidth is limited to 100 Mbps. The migration must complete within 30 days. Which approach should they use?

A.Use Storage Transfer Service from another cloud

B.Use gsutil rsync over the network

C.Use Cloud Data Fusion

D.Use Transfer Appliance

AnswerD

Transfer Appliance can physically ship 200 TB of data, which can be transferred within days. This meets the 30-day requirement.

Why this answer

Transfer Appliance is a physical device that can transfer up to 480 TB in a single shipment. At 100 Mbps, transferring 200 TB over the network would take approximately 200 TB * 1024 GB/TB * 8 bits/byte / (100 Mbps) ≈ 16,384 seconds ≈ 190 days, far exceeding 30 days. Therefore, using Transfer Appliance is the only feasible option.

Practice this question →

MCQeasy

A company is adopting Site Reliability Engineering (SRE) practices. After a major incident, they want to conduct a review to understand what went wrong and how to prevent recurrence, without blaming individuals. Which SRE practice should they follow?

A.Define SLOs and SLIs

B.Create an error budget policy

C.Perform capacity planning

D.Conduct a blameless postmortem

AnswerD

A blameless postmortem is an SRE practice to review incidents without blame, focusing on systemic improvements.

Why this answer

A blameless postmortem focuses on learning from incidents without assigning blame. Error budgets are for measuring reliability, SLOs/SLIs are for defining targets, and capacity planning is for scaling.

Practice this question →

Multi-Selecthard

A company runs a latency-sensitive web application on Compute Engine in us-east1. They want to improve response times for users in Europe and Asia without changing the application architecture. Which TWO actions should they take? (Choose 2.)

Select 2 answers

A.Use preemptible VMs to reduce cost

B.Enable Cloud CDN on the load balancer

C.Deploy additional instances in us-west1

D.Create a multi-region load balancer and deploy backends in europe-west1 and asia-east1

E.Use Cloud Armor to block high-latency requests

AnswersB, D

Cloud CDN caches static content at edge locations, improving latency for all users.

Why this answer

Cloud CDN caches static content at edge locations globally, reducing latency for users worldwide. Placing a load balancer in multiple regions (multi-region load balancing with proximity-based routing) directs users to the nearest backend region. Using only us-west1 would still leave European users far away.

Cloud Armor is for security, not performance. Spot VMs are for cost savings, not latency.

Practice this question →

MCQhard

A company is migrating a large Oracle database (5 TB) from on-premises to Cloud SQL for PostgreSQL. They require minimal downtime and automated schema conversion. Which Google Cloud service should they use?

A.Velostrata (Migrate for Compute Engine)

B.Transfer Appliance

C.Database Migration Service (DMS)

D.Storage Transfer Service

AnswerC

DMS supports Oracle to Cloud SQL for PostgreSQL migration with minimal downtime and automated schema conversion.

Why this answer

Database Migration Service (DMS) supports homogeneous and heterogeneous migrations with minimal downtime and includes schema conversion for Oracle to PostgreSQL via the Database Migration Service with converters. Velostrata is for VM migration, Transfer Appliance for bulk data, and Storage Transfer Service for cloud-to-cloud data.

Practice this question →

MCQhard

A startup is designing a real-time leaderboard for a multiplayer game. The leaderboard must update within seconds of a score change and handle millions of concurrent players. Strong consistency is not required, but availability is critical. Which database is most suitable?

A.Cloud Memorystore

B.Cloud Spanner

C.Cloud Firestore

D.Cloud Bigtable

AnswerD

Bigtable offers high throughput and low latency for simple key-value operations like leaderboards, and eventual consistency is acceptable.

Why this answer

Cloud Bigtable is optimized for high-throughput, low-latency reads and writes, and can serve as a leaderboard backend if row keys are designed properly. It offers eventual consistency, which is acceptable here. Cloud Spanner provides strong consistency but is more expensive and may have higher latency.

Firestore is good for real-time updates but may not handle millions of concurrent updates easily. Memorystore (Redis) can also do leaderboards but is not a database for persistent storage; it's a cache.

Practice this question →