- (Exam Topic 4)
Your company is loading comma-separated values (CSV) files into Google BigQuery. The data is fully imported successfully; however, the imported data is not matching byte-to-byte to the source file. What is the most likely cause of this problem?

1. A. The CSV data loaded in BigQuery is not flagged as CSV.
2. B. The CSV data has invalid rows that were skipped on import.
3. C. The CSV data loaded in BigQuery is not using BigQuery’s default encoding.
4. D. The CSV data has not gone through an ETL phase before loading into BigQuery.

Correct Answer: B

- (Exam Topic 6)
An aerospace company uses a proprietary data format to store its night data. You need to connect this new data source to BigQuery and stream the data into BigQuery. You want to efficiency import the data into BigQuery where consuming as few resources as possible. What should you do?

1. A. Use a standard Dataflow pipeline to store the raw data m BigQuery and then transform the format later when the data is used
2. B. Write a she script that triggers a Cloud Function that performs periodic ETL batch jobs on the new data source
3. C. Use Apache Hive to write a Dataproc job that streams the data into BigQuery in CSV format
4. D. Use an Apache Beam custom connector to write a Dataflow pipeline that streams the data into BigQuery in Avro format

Correct Answer: D

- (Exam Topic 4)
You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:
The user profile: What the user likes and doesn’t like to eat
The user account information: Name, address, preferred meal times
The order information: When orders are made, from where, to whom
The database will be used to store all the transactional data of the product. You want to optimize the data schema. Which Google Cloud Platform product should you use?

1. A. BigQuery
2. B. Cloud SQL
3. C. Cloud Bigtable
4. D. Cloud Datastore

Correct Answer: A

- (Exam Topic 6)
Your neural network model is taking days to train. You want to increase the training speed. What can you do?

1. A. Subsample your test dataset.
2. B. Subsample your training dataset.
3. C. Increase the number of input features to your model.
4. D. Increase the number of layers in your neural network.

Correct Answer: D
Reference: https://towardsdatascience.com/how-to-increase-the-accuracy-of-a-neural-network-9f5d1c6f407d

- (Exam Topic 6)
Your globally distributed auction application allows users to bid on items. Occasionally, users place identical bids at nearly identical times, and different application servers process those bids. Each bid event contains the item, amount, user, and timestamp. You want to collate those bid events into a single location in real time to determine which user bid first. What should you do?

1. A. Create a file on a shared file and have the application servers write all bid events to that fil
2. B. Process the file with Apache Hadoop to identify which user bid first.
3. C. Have each application server write the bid events to Cloud Pub/Sub as they occu
4. D. Push the events from Cloud Pub/Sub to a custom endpoint that writes the bid event information into Cloud SQL.
5. E. Set up a MySQL database for each application server to write bid events int
6. F. Periodically query each of those distributed MySQL databases and update a master MySQL database with bid event information.
7. G. Have each application server write the bid events to Google Cloud Pub/Sub as they occu
8. H. Use a pull subscription to pull the bid events using Google Cloud Dataflo
9. I. Give the bid for each item to the userin the bid event that is processed first.

Correct Answer: C