Free Access Google.Professional-Data-Engineer.v2022-02-11.q268 Practice Test (Page 35)

Question 166

Which of these sources can you not load data into BigQuery from?

A.File upload

B.Google Drive

C.Google Cloud Storage

D.Google Cloud SQL

Question 167

Which of these statements about BigQuery caching is true?

A.By default, a query's results are not cached.

B.BigQuery caches query results for 48 hours.

C.Query results are cached even if you specify a destination table.

D.There is no charge for a query that retrieves its results from cache.

Question 168

You are analyzing the price of a company's stock. Every 5 seconds, you need to compute a moving average of the past 30 seconds' worth of data. You are reading data from Pub/Sub and using DataFlow to conduct the analysis. How should you set up your windowed pipeline?

A.Use a sliding window with a duration of 30 seconds and a period of 5 seconds. Emit results by setting the following trigger: AfterWatermark.pastEndOfWindow()

B.Use a fixed window with a duration of 30 seconds. Emit results by setting the following trigger:
AfterWatermark.pastEndOfWindow().plusDelayOf(Duration.standardSeconds(5))

C.Use a sliding window with a duration of 5 seconds. Emit results by setting the following trigger:
AfterProcessingTime.pastFirstElementInPane().plusDelayOf(Duration.standardSeconds(30))

D.Use a fixed window with a duration of 5 seconds. Emit results by setting the following trigger:
AfterProcessingTime.pastFirstElementInPane().plusDelayOf(Duration.standardSeconds(30))

Question 169

You designed a database for patient records as a pilot project to cover a few hundred patients in three clinics.
Your design used a single database table to represent all patients and their visits, and you used self-joins to generate reports. The server resource utilization was at 50%. Since then, the scope of the project has expanded.
The database must now store 100 times more patient records. You can no longer run the reports, because they either take too long or they encounter errors with insufficient compute resources. How should you adjust the database design?

A.Add capacity (memory and disk space) to the database server by the order of 200.

B.Shard the tables into smaller ones based on date ranges, and only generate reports with prespecified date ranges.

C.Normalize the master patient-record table into the patient table and the visits table, and create other necessary tables to avoid self-join.

D.Partition the table into smaller tables, with one for each clinic. Run queries against the smaller table pairs, and use unions for consolidated reports.

Question 170

Your financial services company is moving to cloud technology and wants to store 50 TB of financial time-
series data in the cloud. This data is updated frequently and new data will be streaming in all the time.
Your company also wants to move their existing Apache Hadoop jobs to the cloud to get insights into this
data. Which product should they use to store the data?

A.Cloud Bigtable

B.Google BigQuery