- (Exam Topic 6)
You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to significantly refactor the application that uses this database and cost to operate is of primary concern.
Which service do you select for storing and serving your data?

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

Correct Answer: D

- (Exam Topic 1)
Your company handles data processing for a number of different clients. Each client prefers to use their own suite of analytics tools, with some allowing direct query access via Google BigQuery. You need to secure the data so that clients cannot see each other’s data. You want to ensure appropriate access to the data. Which three steps should you take? (Choose three.)

1. A. Load data into different partitions.
2. B. Load data into a different dataset for each client.
3. C. Put each client’s BigQuery dataset into a different table.
4. D. Restrict a client’s dataset to approved users.
5. E. Only allow a service account to access the datasets.
6. F. Use the appropriate identity and access management (IAM) roles for each client’s users.

Correct Answer: BDF

- (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)
What are all of the BigQuery operations that Google charges for?

1. A. Storage, queries, and streaming inserts
2. B. Storage, queries, and loading data from a file
3. C. Storage, queries, and exporting data
4. D. Queries and streaming inserts

Correct Answer: A
Google charges for storage, queries, and streaming inserts. Loading data from a file and exporting data are free operations.
Reference: https://cloud.google.com/bigquery/pricing

- (Exam Topic 3)
Given the record streams MJTelco is interested in ingesting per day, they are concerned about the cost of Google BigQuery increasing. MJTelco asks you to provide a design solution. They require a single large data table called tracking_table. Additionally, they want to minimize the cost of daily queries while performing fine-grained analysis of each day’s events. They also want to use streaming ingestion. What should you do?

1. A. Create a table called tracking_table and include a DATE column.
2. B. Create a partitioned table called tracking_table and include a TIMESTAMP column.
3. C. Create sharded tables for each day following the pattern tracking_table_YYYYMMDD.
4. D. Create a table called tracking_table with a TIMESTAMP column to represent the day.

Correct Answer: B