최신 Professional-Cloud-Database-Engineer 무료덤프 - Google Cloud Certified

문제1

You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

A. Use the default app profile with single-cluster routing.

B. Create a custom app profile with single-cluster routing.

C. Create a custom app profile with multi-cluster routing.

D. Use the default app profile with multi-cluster routing.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제2

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

A. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

B. Ensure that the service account has the Storage Admin role.

C. Increase the amount of memory allocated to your instance.

D. Close idle connections or restart the instance before beginning the import operation.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제3

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 Memorystore for Redis with multi-zones within a region.

B. Use Cloud Spanner with multi-region configuration.

C. Use Cloud SQL for PostgreSQL with cross-region replicas.

D. Use Bigtable with multi-region clusters.

정답: C

문제4

You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

A. Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

B. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

C. Use the default networks, and leverage Cloud VPN to connect the two together.

D. Place both the application VMs and the Cloud SQL instances in the default network of each project.

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제5

Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

A. Build indexes on heavily accessed tables.

B. Use Query Insights to identify idle instances.

C. Remove inactive user accounts.

D. Run the Recommender API to identify overprovisioned instances.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

A. Create a Firestore index on the news story date.

B. Build a Firestore bundle, and deploy bundles to Cloud CDN.

C. Deploy a US multi-region Firestore location.

D. Enable serializable isolation in the Firebase app.

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제7

You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?

A. Use direct scaling to implement the Autoscaler-based architecture.

B. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

C. Use linear scaling to implement the Autoscaler-based architecture

D. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제8

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

A. Set up Traffic Director.

B. Set up Private Service Connect.

C. Set up a Shared VPC, configure multiple service projects, and create firewall rules.

D. Set up Serverless VPC Access.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제9

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

A. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

B. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

C. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.

D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제10

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

A. Create a new service account, and grant it the Cloud Spanner Database Reader role.

B. Create a new service account, and grant it the Cloud Spanner Database Admin role.

C. Create a new service account, and grant it the spanner.databases.select permission.

D. Reuse the existing service account that populates this database.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

최신 Professional-Cloud-Database-Engineer 무료덤프 - Google Cloud Certified - Professional Cloud Database Engineer

우리와 연락하기

유용한 링크

최신 업데이트