- (Exam Topic 4)
Your company produces 20,000 files every hour. Each data file is formatted as a comma separated values (CSV) file that is less than 4 KB. All files must be ingested on Google Cloud Platform before they can be processed. Your company site has a 200 ms latency to Google Cloud, and your Internet connection bandwidth is limited as 50 Mbps. You currently deploy a secure FTP (SFTP) server on a virtual machine in Google Compute Engine as the data ingestion point. A local SFTP client runs on a dedicated machine to transmit the CSV files as is. The goal is to make reports with data from the previous day available to the executives by 10:00 a.m. each day. This design is barely able to keep up with the current volume, even though the bandwidth utilization is rather low.
You are told that due to seasonality, your company expects the number of files to double for the next three months. Which two actions should you take? (choose two.)

1. A. Introduce data compression for each file to increase the rate file of file transfer.
2. B. Contact your internet service provider (ISP) to increase your maximum bandwidth to at least 100 Mbps.
3. C. Redesign the data ingestion process to use gsutil tool to send the CSV files to a storage bucket in parallel.
4. D. Assemble 1,000 files into a tape archive (TAR) fil
5. E. Transmit the TAR files instead, and disassemble the CSV files in the cloud upon receiving them.
6. F. Create an S3-compatible storage endpoint in your network, and use Google Cloud Storage Transfer Service to transfer on-premices data to the designated storage bucket.

Correct Answer: CE

- (Exam Topic 5)
Which of the following is NOT one of the three main types of triggers that Dataflow supports?

1. A. Trigger based on element size in bytes
2. B. Trigger that is a combination of other triggers
3. C. Trigger based on element count
4. D. Trigger based on time

Correct Answer: A
There are three major kinds of triggers that Dataflow supports: 1. Time-based triggers 2. Data-driven triggers. You can set a trigger to emit results from a window when that window has received a certain number of data elements. 3. Composite triggers. These triggers combine multiple time-based or data-driven triggers in some logical way
Reference: https://cloud.google.com/dataflow/model/triggers

- (Exam Topic 6)
You use a dataset in BigQuery for analysis. You want to provide third-party companies with access to the same dataset. You need to keep the costs of data sharing low and ensure that the data is current. Which solution should you choose?

1. A. Create an authorized view on the BigQuery table to control data access, and provide third-party companies with access to that view.
2. B. Use Cloud Scheduler to export the data on a regular basis to Cloud Storage, and provide third-party companies with access to the bucket.
3. C. Create a separate dataset in BigQuery that contains the relevant data to share, and provide third-party companies with access to the new dataset.
4. D. Create a Cloud Dataflow job that reads the data in frequent time intervals, and writes it to the relevant BigQuery dataset or Cloud Storage bucket for third-party companies to use.

Correct Answer: B

- (Exam Topic 6)
You work for a mid-sized enterprise that needs to move its operational system transaction data from an on-premises database to GCP. The database is about 20 TB in size. Which database should you choose?

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

Correct Answer: A

- (Exam Topic 6)
You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?

1. A. Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.
2. B. Create a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.
3. C. Create a Cloud SQL instance in one zone, and configure an external read replica in a zone in a different region.
4. D. Create a Cloud SQL instance in a region, and configure automatic backup to a Cloud Storage bucket in the same region.

Correct Answer: C