You are implementing a single Cloud SQL MySQL second-generation database that contains business-critical transaction data. You want to ensure that the minimum amount of data is lost in case of catastrophic failure.
Which two features should you implement? (Choose two.)

• A.Sharding
• B.Read replicas
• C.Binary logging
• D.Automated backups
• E.Semisynchronous replication

Comment: *

Name: *

Email: *

Verification: *

For this question, refer to the Helicopter Racing League (HRL) case study. Your team is in charge of creating a payment card data vault for card numbers used to bill tens of thousands of viewers, merchandise consumers, and season ticket holders. You need to implement a custom card tokenization service that meets the following requirements:
* It must provide low latency at minimal cost.
* It must be able to identify duplicate credit cards and must not store plaintext card numbers.
* It should support annual key rotation.
Which storage approach should you adopt for your tokenization service?

• A.Encrypt the card data with a deterministic algorithm and shard it across multiple Memorystore instances.
• B.Store the card data in Secret Manager after running a query to identify duplicates.
• C.Encrypt the card data with a deterministic algorithm stored in Firestore using Datastore mode.
• D.Use column-level encryption to store the data in Cloud SQL.

Comment: *

Name: *

Email: *

Verification: *

What is the command for creating a storage bucket that has once per month access and is named 'archive_bucket'?

• A.gsutil rm -coldline gs://archive_bucket
• B.gsutil mb gs://archive_bucket
• C.gsutil mb -c coldline gs://archive_bucket
• D.gsutil mb -c nearline gs://archive_bucket

Comment: *

Name: *

Email: *

Verification: *

You are tasked with building an online analytical processing (OLAP) marketing analytics and reporting tool. This requires a relational database that can operate on hundreds of terabytes of data. What is the Google- recommended tool for such applications?

• A.Cloud Spanner, because it is globally distributed
• B.Cloud SQL, because it is a fully managed relational database
• C.Cloud Firestore, because it offers real-time synchronization across devices
• D.BigQuery, because it is designed for large-scale processing of tabular data

Comment: *

Name: *

Email: *

Verification: *

Your company pushes batches of sensitive transaction data from its application server VMs to Cloud Pub/ Sub for processing and storage. What is the Google-recommended way for your application to authenticate to the required Google Cloud services?

• A.Ensure that VM service accounts are granted the appropriate Cloud Pub/Sub IAM roles.
• B.Ensure that VM service accounts do not have access to Cloud Pub/Sub, and use VM access scopes to grant the appropriate Cloud Pub/Sub IAM roles.
• C.Generate an OAuth2 access token for accessing Cloud Pub/Sub, encrypt it, and store it in Cloud Storage for access from each VM.
• D.Create a gateway to Cloud Pub/Sub using a Cloud Function, and grant the Cloud Function service account the appropriate Cloud Pub/Sub IAM roles.

Comment: *

Name: *

Email: *

Verification: *