Professional-Cloud-Database-Engineer 무료 덤프문제 온라인 액세스

You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?

• A.Use Bigtable with multi-region clusters.
• B.Use Cloud SQL for PostgreSQL with cross-region replicas.
• C.Use Memorystore for Redis with multi-zones within a region.
• D.Use Cloud Spanner with multi-region configuration.

Your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability (HA). You need to configure a scalable database solution to support anticipated rapid growth and optimal application performance. What should you do?

• A.Create a spanner instance across regions for optimal performance.
• B.Create an AlloyDB instance in HA mode with a cross-region read replica.
• C.Create a Cloud SQL instance in HA mode with a cross-region read replica.
• D.Implement Bigtable with replication across multiple regions and configure to prioritize data accuracy.

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

• A.Use Cloud Spanner in a multi-region configuration.
• B.Use highly available Cloud SQL with multiple zones.
• C.Use Cloud Spanner in a regional configuration.
• D.Use Cloud SQL with cross-region replicas.

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.Promote high-cardinality attributes in multi-attribute primary keys.
• B.Promote low-cardinality attributes in multi-attribute primary keys.
• C.Use bit-reverse sequential value as the primary key.
• D.Normalize the data model.
• E.Use an auto-incrementing value as the primary key.

Your organization has a ticketing system that needs an online marketing analytics and reporting application.
You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

• A.BigQuery
• B.Bigtable
• C.Cloud SQL
• D.Cloud Spanner