Free Access Google.Professional-Data-Engineer.v2026-02-05.q279 Practice Test (Page 2)

Question 1

Given the record streams MJTelco is interested in ingesting per day, they are concerned about the cost of Google BigQuery increasing. MJTelco asks you to provide a design solution. They require a single large data table called tracking_table. Additionally, they want to minimize the cost of daily queries while performing fine-grained analysis of each day's events. They also want to use streaming ingestion. What should you do?

A.Create a table called tracking_table with a TIMESTAMP column to represent the day.

B.Create sharded tables for each day following the pattern tracking_table_YYYYMMDD.

C.Create a table called tracking_table and include a DATE column.

D.Create a partitioned table called tracking_table and include a TIMESTAMP column.

Question 2

You have 100 GB of data stored in a BigQuery table. This data is outdated and will only be accessed one or two times a year for analytics with SQL. For backup purposes, you want to store this data to be immutable for
3 years. You want to minimize storage costs. What should you do?

A.1 Create a BigQuery table clone.
2. Query the clone when you need to perform analytics.

B.1 Create a BigQuery table snapshot.
2 Restore the snapshot when you need to perform analytics.

C.1. Perform a BigQuery export to a Cloud Storage bucket with archive storage class.
2 Enable versionmg on the bucket.
3. Create a BigQuery external table on the exported files.

D.1 Perform a BigQuery export to a Cloud Storage bucket with archive storage class.
2 Set a locked retention policy on the bucket.
3. Create a BigQuery external table on the exported files.

Question 3

You are choosing a NoSQL database to handle telemetry data submitted from millions of Internet-of- Things (IoT) devices. The volume of data is growing at 100 TB per year, and each data entry has about
100 attributes. The data processing pipeline does not require atomicity, consistency, isolation, and durability (ACID). However, high availability and low latency are required.
You need to analyze the data by querying against individual fields. Which three databases meet your requirements? (Choose three.)

A.MySQL

B.HDFS with Hive

C.Redis

D.Cassandra

E.MongoDB

F.HBase

Question 4

If you're running a performance test that depends upon Cloud Bigtable, all the choices except one below are recommended steps. Which is NOT a recommended step to follow?

A.Do not use a production instance.

B.Run your test for at least 10 minutes.

C.Before you test, run a heavy pre-test for several minutes.

D.Use at least 300 GB of data.

Question 5

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?