- (Exam Topic 4)
Your company has recently grown rapidly and now ingesting data at a significantly higher rate than it was previously. You manage the daily batch MapReduce analytics jobs in Apache Hadoop. However, the recent increase in data has meant the batch jobs are falling behind. You were asked to recommend ways the development team could increase the responsiveness of the analytics without increasing costs. What should you recommend they do?

1. A. Rewrite the job in Pig.
2. B. Rewrite the job in Apache Spark.
3. C. Increase the size of the Hadoop cluster.
4. D. Decrease the size of the Hadoop cluster but also rewrite the job in Hive.

Correct Answer: A

- (Exam Topic 5)
Which of these sources can you not load data into BigQuery from?

1. A. File upload
2. B. Google Drive
3. C. Google Cloud Storage
4. D. Google Cloud SQL

Correct Answer: D
You can load data into BigQuery from a file upload, Google Cloud Storage, Google Drive, or Google Cloud Bigtable. It is not possible to load data into BigQuery directly from Google Cloud SQL. One way to get data from Cloud SQL to BigQuery would be to export data from Cloud SQL to Cloud Storage and then load it from there.
Reference: https://cloud.google.com/bigquery/loading-data

- (Exam Topic 5)
The Dataflow SDKs have been recently transitioned into which Apache service?

1. A. Apache Spark
2. B. Apache Hadoop
3. C. Apache Kafka
4. D. Apache Beam

Correct Answer: D
Dataflow SDKs are being transitioned to Apache Beam, as per the latest Google directive Reference: https://cloud.google.com/dataflow/docs/

- (Exam Topic 6)
Government regulations in your industry mandate that you have to maintain an auditable record of access to certain types of datA. Assuming that all expiring logs will be archived correctly, where should you store data that is subject to that mandate?

1. A. Encrypted on Cloud Storage with user-supplied encryption key
2. B. A separate decryption key will be given to each authorized user.
3. C. In a BigQuery dataset that is viewable only by authorized personnel, with the Data Access log used to provide the auditability.
4. D. In Cloud SQL, with separate database user names to each use
5. E. The Cloud SQL Admin activity logs will be used to provide the auditability.
6. F. In a bucket on Cloud Storage that is accessible only by an AppEngine service that collects user information and logs the access before providing a link to the bucket.

Correct Answer: B

- (Exam Topic 5)
If a dataset contains rows with individual people and columns for year of birth, country, and income, how
many of the columns are continuous and how many are categorical?

1. A. 1 continuous and 2 categorical
2. B. 3 categorical
3. C. 3 continuous
4. D. 2 continuous and 1 categorical

Correct Answer: D
The columns can be grouped into two types—categorical and continuous columns:
A column is called categorical if its value can only be one of the categories in a finite set. For example, the native country of a person (U.S., India, Japan, etc.) or the education level (high school, college, etc.) are categorical columns.
A column is called continuous if its value can be any numerical value in a continuous range. For example, the capital gain of a person (e.g. $14,084) is a continuous column.
Year of birth and income are continuous columns. Country is a categorical column.
You could use bucketization to turn year of birth and/or income into categorical features, but the raw columns are continuous.
Reference: https://www.tensorflow.org/tutorials/wide#reading_the_census_data