Free Access Google.Professional-Cloud-Architect.v2022-04-27.q264 Practice Test (Page 42)

Question 201

For this question, refer to the TerramEarth case study. You need to implement a reliable, scalable GCP solution for the data warehouse for your company, TerramEarth. Considering the TerramEarth business and technical requirements, what should you do?

A.Replace the existing data warehouse with BigQuery. Use table partitioning.

B.Replace the existing data warehouse with a Compute Engine instance with 96 CPUs.

C.Replace the existing data warehouse with BigQuery. Use federated data sources.

D.Replace the existing data warehouse with a Compute Engine instance with 96 CPUs. Add an additional Compute Engine pre-emptible instance with 32 CPUs.

Correct Answer: A

Topic 7, Mountkrik Games Case 2
Company Overview
Mountkirk Games makes online, session-based, multiplayer games for mobile platforms. They build all of their games using some server-side integration. Historically, they have used cloud providers to lease physical servers.
Due to the unexpected popularity of some of their games, they have had problems scaling their global audience, application servers, MySQL databases, and analytics tools.
Their current model is to write game statistics to files and send them through an ETL tool that loads them into a centralized MySQL database for reporting.
Solution Concept
Mountkirk Games is building a new game, which they expect to be very popular. They plan to deploy the game's backend on Google Compute Engine so they can capture streaming metrics, run intensive analytics, and take advantage of its autoscaling server environment and integrate with a managed NoSQL database.
Business Requirements
* Increase to a global footprint.
* Improve uptime - downtime is loss of players.
* Increase efficiency of the cloud resources we use.
* Reduce latency to all customers.
Technical Requirements
Requirements for Game Backend Platform
* Dynamically scale up or down based on game activity.
* Connect to a transactional database service to manage user profiles and game state.
* Store game activity in a timeseries database service for future analysis.
* As the system scales, ensure that data is not lost due to processing backlogs.
* Run hardened Linux distro.
Requirements for Game Analytics Platform
* Dynamically scale up or down based on game activity
* Process incoming data on the fly directly from the game servers
* Process data that arrives late because of slow mobile networks
* Allow queries to access at least 10 TB of historical data
* Process files that are regularly uploaded by users' mobile devices
Executive Statement
Our last successful game did not scale well with our previous cloud provider, resulting in lower user adoption and affecting the game's reputation. Our investors want more key performance indicators (KPIs) to evaluate the speed and stability of the game, as well as other metrics that provide deeper insight into usage patterns so we can adapt the game to target users. Additionally, our current technology stack cannot provide the scale we need, so we want to replace MySQL and move to an environment that provides autoscaling, low latency load balancing, and frees us up from managing physical servers.

Question 202

For this question, refer to the TerramEarth case study.
TerramEarth's CTO wants to use the raw data from connected vehicles to help identify approximately when a vehicle in the development team to focus their failure. You want to allow analysts to centrally query the vehicle data. Which architecture should you recommend?
A)

A.Option A

B.Option B

C.Option C

D.Option D

Question 203

For this question, refer to the Dress4Win case study.
Dress4Win has asked you for advice on how to migrate their on-premises MySQL deployment to the cloud.
They want to minimize downtime and performance impact to their on-premises solution during the migration.
Which approach should you recommend?

A.Setup a MySQL replica server/slave in the cloud environment, and configure it for asynchronous replication from the MySQL master server on-premises until cutover.

B.Create a dump of the on-premises MySQL master server, and then shut it down, upload it to the cloud environment, and load into a new MySQL cluster.

C.Create a dump of the MySQL replica server into the cloud environment, load it into: Google Cloud Datastore, and configure applications to read/write to Cloud Datastore at cutover.

D.Create a new MySQL cluster in the cloud, configure applications to begin writing to both on-premises and cloud MySQL masters, and destroy the original cluster at cutover.

Question 204

You are moving an application that uses MySQL from on-premises to Google Cloud. The application will run on Compute Engine and will use Cloud SQL. You want to cut over to the Compute Engine deployment of the application with minimal downtime and no data loss to your customers. You want to migrate the application with minimal modification. You also need to determine the cutover strategy. What should you do?

A.1. Stop the on-premises application.
2.Create a mysqldump of the on-premises MySQL server.
3.Upload the dump to a Cloud Storage bucket.
4.Import the dump into Cloud SQL.
5.Start the application on Compute Engine.

B.1. Set up Cloud SQL proxy and MySQL proxy.
2.Create a mysqldump of the on-premises MySQL server.
3.Upload the dump to a Cloud Storage bucket.
4.Import the dump into Cloud SQL.
5.Stop the on-premises application.
6.Start the Compute Engine application.

C.1. Set up Cloud VPN to provide private network connectivity between the Compute Engine application and the on-premises MySQL server.
2.Stop the on-premises application.
3.Create a mysqldump of the on-premises MySQL server.
4.Upload the dump to a Cloud Storage bucket.
5.Import the dump into Cloud SQL.
6.Modify the source code of the application to write queries to both databases and read from its local database.
7.Start the Compute Engine application.
8.Stop the on-premises application.

D.1. Set up Cloud VPN to provide private network connectivity between the Compute Engine application and the on-premises MySQL server.
2.Stop the on-premises application.
3.Start the Compute Engine application, configured to read and write to the on-premises MySQL server.
4.Create the replication configuration in Cloud SQL.
5.Configure the source database server to accept connections from the Cloud SQL replica.
6.Finalize the Cloud SQL replica configuration.
7.When replication has been completed, stop the Compute Engine application.
8.Promote the Cloud SQL replica to a standalone instance.
9.Restart the Compute Engine application, configured to read and write to the Cloud SQL standalone instance.

Question 205

For this question, refer to the TerramEarth case study. A new architecture that writes all incoming data to BigQuery has been introduced. You notice that the data is dirty, and want to ensure data quality on an automated daily basis while managing cost.
What should you do?

A.Create a Cloud Function that reads data from BigQuery and cleans it. Trigger it. Trigger the Cloud Function from a Compute Engine instance.

B.Use Cloud Dataprep and configure the BigQuery tables as the source. Schedule a daily job to clean the data.

C.Set up a streaming Cloud Dataflow job, receiving data by the ingestion process. Clean the data in a Cloud Dataflow pipeline.

D.Create a SQL statement on the data in BigQuery, and save it as a view. Run the view daily, and save the result to a new table.

Other Version: 1231Google.Professional-Cloud-Architect.v2025-03-22.q201; 961Google.Professional-Cloud-Architect.v2024-10-18.q291; 1242Google.Professional-Cloud-Architect.v2023-10-16.q124; 2932Google.Professional-Cloud-Architect.v2022-12-12.q249; 6129Google.Professional-Cloud-Architect.v2022-08-15.q243; 127Google.Prepawaytest.Professional-Cloud-Architect.v2021-09-17.by.quintion.207q.pdf

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 151Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 165TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 150Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 201

Question 202

Question 203

Question 204

Question 205

Download PDF File