Free Access Google.Professional-Data-Engineer.v2024-12-09.q327 Practice Test (Page 51)

Question 246

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.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.

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

Question 247

The CUSTOM tier for Cloud Machine Learning Engine allows you to specify the number of which types of cluster nodes?

A.Workers

B.Masters, workers, and parameter servers

C.Workers and parameter servers

D.Parameter servers

Question 248

You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is current. Which solution should you choose?

A.Create an authorized view on the BigQuery table to control data access, and provide third-party companies with access to that view.

B.Use Cloud Scheduler to export the data on a regular basis to Cloud Storage, and provide third-party companies with access to the bucket.

C.Create a separate dataset in BigQuery that contains the relevant data to share, and provide third-party companies with access to the new dataset.

D.Create a Cloud Dataflow job that reads the data in frequent time intervals, and writes it to the relevant BigQuery dataset or Cloud Storage bucket for third-party companies to use.

Question 249

You are deploying a new storage system for your mobile application, which is a media streaming service. You decide the best fit is Google Cloud Datastore. You have entities with multiple properties, some of which can take on multiple values. For example, in the entity 'Movie' the property 'actors' and the property 'tags' have multiple values but the property 'date released' does not. A typical query would ask for all movies with actor=<actorname> ordered by date_released or all movies with tag=Comedy ordered by date_released. How should you avoid a combinatorial explosion in the number of indexes?

A.Option B.

B.Option D

C.Option A

D.Option C

Question 250

Which of the following statements about Legacy SQL and Standard SQL is not true?

A.Standard SQL is the preferred query language for BigQuery.

B.If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.

C.One difference between the two query languages is how you specify fully-qualified table names (i.e.
table names that include their associated project name).

D.You need to set a query language for each dataset and the default is Standard SQL.

Other Version: 1187Google.Professional-Data-Engineer.v2026-02-05.q279; 1481Google.Professional-Data-Engineer.v2025-09-04.q126; 1473Google.Professional-Data-Engineer.v2025-03-18.q108; 2882Google.Professional-Data-Engineer.v2024-02-15.q202; 3279Google.Professional-Data-Engineer.v2023-09-14.q233; 4663Google.Professional-Data-Engineer.v2022-07-07.q155; 6671Google.Professional-Data-Engineer.v2022-02-11.q268; 112Google.Examcollectionpass.Professional-Data-Engineer.v2021-12-20.by.jonathan.161q.pdf

Latest Upload: 240PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 331Nokia.4A0-113.v2026-05-01.q69; 335EC-COUNCIL.312-49v11.v2026-04-30.q214; 255Microsoft.MB-820.v2026-04-30.q101; 235Salesforce.MC-202.v2026-04-30.q57; 249BICSI.INSTC_V8.v2026-04-29.q53; 366NMLS.MLO.v2026-04-28.q82; 267NCARB.Project-Management.v2026-04-28.q27; 484EMC.D-AV-DY-23.v2026-04-27.q184; 1232ServiceNow.CSA.v2026-04-27.q483

Question 246

Question 247

Question 248

Question 249

Question 250

Download PDF File