- (Exam Topic 1)
You are building a model to predict whether or not it will rain on a given day. You have thousands of input features and want to see if you can improve training speed by removing some features while having a minimum effect on model accuracy. What can you do?

1. A. Eliminate features that are highly correlated to the output labels.
2. B. Combine highly co-dependent features into one representative feature.
3. C. Instead of feeding in each feature individually, average their values in batches of 3.
4. D. Remove the features that have null values for more than 50% of the training records.

Correct Answer: B

- (Exam Topic 5)
When you design a Google Cloud Bigtable schema it is recommended that you .

1. A. Avoid schema designs that are based on NoSQL concepts
2. B. Create schema designs that are based on a relational database design
3. C. Avoid schema designs that require atomicity across rows
4. D. Create schema designs that require atomicity across rows

Correct Answer: C
All operations are atomic at the row level. For example, if you update two rows in a table, it's possible that one row will be updated successfully and the other update will fail. Avoid schema designs that require atomicity across rows.
Reference: https://cloud.google.com/bigtable/docs/schema-design#row-keys

- (Exam Topic 6)
Your infrastructure includes a set of YouTube channels. You have been tasked with creating a process for sending the YouTube channel data to Google Cloud for analysis. You want to design a solution that allows your world-wide marketing teams to perform ANSI SQL and other types of analysis on up-to-date YouTube channels log data. How should you set up the log data transfer into Google Cloud?

1. A. Use Storage Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination.
2. B. Use Storage Transfer Service to transfer the offsite backup files to a Cloud Storage Regional bucket as a final destination.
3. C. Use BigQuery Data Transfer Service to transfer the offsite backup files to a Cloud Storage Multi-Regional storage bucket as a final destination.
4. D. Use BigQuery Data Transfer Service to transfer the offsite backup files to a Cloud Storage Regional storage bucket as a final destination.

Correct Answer: B

- (Exam Topic 5)
Which SQL keyword can be used to reduce the number of columns processed by BigQuery?

1. A. BETWEEN
2. B. WHERE
3. C. SELECT
4. D. LIMIT

Correct Answer: C
SELECT allows you to query specific columns rather than the whole table.
LIMIT, BETWEEN, and WHERE clauses will not reduce the number of columns processed by
BigQuery.
Reference:
https://cloud.google.com/bigquery/launch-checklist#architecture_design_and_development_checklist

- (Exam Topic 6)
You are a head of BI at a large enterprise company with multiple business units that each have different priorities and budgets. You use on-demand pricing for BigQuery with a quota of 2K concurrent on-demand slots per project. Users at your organization sometimes don’t get slots to execute their query and you need to correct this. You’d like to avoid introducing new projects to your account.
What should you do?

1. A. Convert your batch BQ queries into interactive BQ queries.
2. B. Create an additional project to overcome the 2K on-demand per-project quota.
3. C. Switch to flat-rate pricing and establish a hierarchical priority model for your projects.
4. D. Increase the amount of concurrent slots per project at the Quotas page at the Cloud Console.

Correct Answer: C
Reference https://cloud.google.com/blog/products/gcp/busting-12-myths-about-bigquery