Free Access Google.Professional-Data-Engineer.v2022-07-07.q155 Practice Test (Page 18)

Question 81

Which of the following is NOT a valid use case to select HDD (hard disk drives) as the storage for Google Cloud Bigtable?

A.You expect to store at least 10 TB of data.

B.You will mostly run batch workloads with scans and writes, rather than frequently executing random reads of a small number of rows.

C.You need to integrate with Google BigQuery.

D.You will not use the data to back a user-facing or latency-sensitive application.

Question 82

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?

A.Both batch and streaming

B.BigQuery cannot be used as a sink

C.Only batch

D.Only streaming

Question 83

You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable where the datetime of the stock trade is the beginning of the row key. Your application has thousands of concurrent users, and you notice that performance is starting to degrade as more stocks are added. What should you do to improve the performance of your application?

A.Change the row key syntax in your Cloud Bigtable table to begin with the stock symbol.

B.Change the row key syntax in your Cloud Bigtable table to begin with a random number per second.

C.Change the data pipeline to use BigQuery for storing stock trades, and update your application.

D.Use Cloud Dataflow to write summary of each day's stock trades to an Avro file on Cloud Storage.
Update your application to read from Cloud Storage and Cloud Bigtable to compute the responses.

Question 84

You want to automate execution of a multi-step data pipeline running on Google Cloud. The pipeline includes Cloud Dataproc and Cloud Dataflow jobs that have multiple dependencies on each other. You want to use managed services where possible, and the pipeline will run every day. Which tool should you use?

A.Workflow Templates on Cloud Dataproc

B.Cloud Composer

C.Cloud Scheduler

D.cron

Question 85

You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for range queries on non-key columns. What should you do?

A.Use Cloud SQL for storage. Add secondary indexes to support query patterns.

B.Use Cloud SQL for storage. Use Cloud Dataflow to transform data to support query patterns.

C.Use Cloud Spanner for storage. Add secondary indexes to support query patterns.

D.Use Cloud Spanner for storage. Use Cloud Dataflow to transform data to support query patterns.

Other Version: 154Google.Professional-Data-Engineer.v2025-09-04.q126; 813Google.Professional-Data-Engineer.v2025-03-18.q108; 948Google.Professional-Data-Engineer.v2024-12-09.q327; 1476Google.Professional-Data-Engineer.v2024-02-15.q202; 2261Google.Professional-Data-Engineer.v2023-09-14.q233; 5268Google.Professional-Data-Engineer.v2022-02-11.q268; 112Google.Examcollectionpass.Professional-Data-Engineer.v2021-12-20.by.jonathan.161q.pdf

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

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File