You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for range queries on nonkey columns. What should you do?

• A.Use Cloud SQL for storage. Add secondary indexes to support query patterns.
• B.Use Cloud Spanner for storage. Use Cloud Dataflow to transform data to support query patterns.
• C.Use Cloud Spanner for storage. Add secondary indexes to support query patterns.
• D.Use Cloud SQL for storage. Use Cloud Dataflow to transform data to support query patterns.

Comment: *

Name: *

Email: *

Verification: *

You are designing storage for very large text files for a data pipeline on Google Cloud. You want to support ANSI SQL queries. You also want to support compression and parallel load from the input locations using Google recommended practices. What should you do?

• A.Transform text files to compressed Avro using Cloud Dataflow. Use BigQuery for storage and query.
• B.Transform text files to compressed Avro using Cloud Dataflow. Use Cloud Storage and BigQuery permanent linked tables for query.
• C.Compress text files to gzip using the Grid Computing Tools. Use BigQuery for storage and query.
• D.Compress text files to gzip using the Grid Computing Tools. Use Cloud Storage, and then import into Cloud Bigtable for query.

Comment: *

Name: *

Email: *

Verification: *

Your company needs to upload their historic data to Cloud Storage. The security rules don't allow access from external IPs to their on-premises resources. After an initial upload, they will add new data from existing on-premises applications every day. What should they do?

• A.Execute gsutil rsyncfrom the on-premises servers.
• B.Write a job template in Cloud Dataproc to perform the data transfer.
• C.Install an FTP server on a Compute Engine VM to receive the files and move them to Cloud Storage.
• D.Use Cloud Dataflow and write the data to Cloud Storage.

Comment: *

Name: *

Email: *

Verification: *

Government regulations in the banking industry mandate the protection of client's personally identifiable information (PII). Your company requires PII to be access controlled encrypted and compliant with major data protection standards In addition to using Cloud Data Loss Prevention (Cloud DIP) you want to follow Google-recommended practices and use service accounts to control access to PII. What should you do?

• A.Use Cloud Storage to comply with major data protection standards. Use multiple service accounts attached to IAM groups to grant the appropriate access to each group
• B.Use one service account to access a Cloud SQL database and use separate service accounts for each human user
• C.Use Cloud Storage to comply with major data protection standards. Use one service account shared by all users
• D.Assign the required identity and Access Management (IAM) roles to every employee, and create a single service account to access protect resources

Comment: *

Name: *

Email: *

Verification: *

You have some data, which is shown in the graphic below. The two dimensions are X and Y, and the
shade of each dot represents what class it is. You want to classify this data accurately using a linear
algorithm. To do this you need to add a synthetic feature. What should the value of that feature be?

• A.cos(X)
• B.X^2
• C.X^2+Y^2
• D.Y^2

Comment: *

Name: *

Email: *

Verification: *