You have historical data covering the last three years in BigQuery and a data pipeline that delivers new data to BigQuery daily. You have noticed that when the Data Science team runs a query filtered on a date column and limited to 30-90 days of data, the query scans the entire table. You also noticed that your bill is increasing more quickly than you expected. You want to resolve the issue as cost-effectively as possible while maintaining the ability to conduct SQL queries. What should you do?

• A.Modify your pipeline to maintain the last 30-90 days of data in one table and the longer history in a different table to minimize full table scans over the entire history.
• B.Recommend that the Data Science team export the table to a CSV file on Cloud Storage and use Cloud Datalab to explore the data by reading the files directly.
• C.Re-create the tables using DDL. Partition the tables by a column containing a TIMESTAMP or DATE Type.
• D.Write an Apache Beam pipeline that creates a BigQuery table per day. Recommend that the Data Science team use wildcards on the table name suffixes to select the data they need.

Comment: *

Name: *

Email: *

Verification: *

Your company maintains a hybrid deployment with GCP, where analytics are performed on your
anonymized customer data. The data are imported to Cloud Storage from your data center through parallel
uploads to a data transfer server running on GCP. Management informs you that the daily transfers take
too long and have asked you to fix the problem. You want to maximize transfer speeds. Which action
should you take?

• A.Increase the CPU size on your server.
• B.Increase the size of the Google Persistent Disk on your server.
• C.Increase your network bandwidth from your datacenter to GCP.
• D.Increase your network bandwidth from Compute Engine to Cloud Storage.

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

Cloud Bigtable is a recommended option for storing very large amounts of
____________________________?

• A.multi-keyed data with very high latency
• B.multi-keyed data with very low latency
• C.single-keyed data with very low latency
• D.single-keyed data with very high latency

Comment: *

Name: *

Email: *

Verification: *

What are two of the benefits of using denormalized data structures in BigQuery?

• A.Reduces the amount of data processed, reduces the amount of storage required
• B.Increases query speed, makes queries simpler
• C.Reduces the amount of storage required, increases query speed
• D.Reduces the amount of data processed, increases query speed

Comment: *

Name: *

Email: *

Verification: *