2024年Professional Cloud Database Engineer_在线真题试卷与模拟练习_2024年Professional Cloud Database Engineer_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to
Ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your
Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional
Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of
Migration to Google Cloud. What should you do?

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced
Degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial
Troubleshooting, you observed high read latency. What should you do?

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to
Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration
Tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the
Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the
Root cause of the performance degradation. What should you do?

You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google
Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer
Experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your
Existing platform uses. What should you do?

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your
Users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular
Maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you

Received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read

Replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?

Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical.
The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for
Game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the
Testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow
Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your
Marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability
According to Google-recommended practices. What should you do?

Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on
Your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to
Millions of read and write requests per second. What should you do?

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 hotspots in the Cloud Spanner database. You want to
Follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database
Performance to easily identify applications with long-running and resource-intensive queries. What should you do?

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?

Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused
Excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag
In data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without
Making changes to the current reports. Which two approaches should you implement? (Choose two.)

You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming
Increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to: configure
Where data is stored control where the encryption keys are stored govern the access to data
What should you do?

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance
Overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal
Downtime. What should you do?