You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

• A.Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
• B.Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
• C.Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
• D.Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

Comment: *

Name: *

Email: *

Verification: *

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

• A.Set up all read replicas in a different region using asynchronous replication.
• B.Set up all read replicas in the same region as the primary instance with synchronous replication.
• C.Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
• D.Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

Comment: *

Name: *

Email: *

Verification: *

Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

• A.Use an auto-incrementing value as the primary key.
• B.Normalize the data model.
• C.Promote low-cardinality attributes in multi-attribute primary keys.
• D.Promote high-cardinality attributes in multi-attribute primary keys.
• E.Use bit-reverse sequential value as the primary key.

Comment: *

Name: *

Email: *

Verification: *

Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?

• A.Use Firestore with Looker.
• B.Use MongoD8 Atlas with Charts.
• C.Use Bigtable with Looker.
• D.Use Cloud Spanner with Data Studio.

Comment: *

Name: *

Email: *

Verification: *

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

• A.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-west1-b.
  Create a read replica in us-east1-c.
• B.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-central1-b.
  Create a read replica in us-east1-b.
• C.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east-b.
  Create a read replica in us-east1-c.
• D.Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east1-b.
  Create a read replica in us-central1-b.

Comment: *

Name: *

Email: *

Verification: *