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

문제1

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

A. Use the mysqldump utility on the primary database instance to export the backup.

B. Create a read replica, and then use the mysqldump utility to export each table.

C. Use Cloud SQL serverless exports.

D. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

정답: C

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

문제2

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 회원만 볼 수 있음)

문제3

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

A. Compress the data using a different compression algorithm.

B. Normalize the database to the third normal form.

C. Create another schema to load older data.

D. Manually or automatically increase the storage capacity.

정답: D

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

문제4

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

A. Use Dataflow to run the export in text format.

B. Use Cloud Functions to run the export in Avro format.

C. Use Cloud Functions to run the export in text format.

D. Use Dataflow to run the export in Avro format.

정답: D

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

문제5

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

A. Use Cloud SQL for MySQL

B. Use Firestore.

C. Use Bigtable.

D. Use Cloud Spanner.

정답: D

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

문제6

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

A. Use Cloud SQL federated queries.

B. Use Identity and Access Management (IAM) authentication.

C. Use Managed Active Directory authentication.

D. Use PostgreSQL database's built-in authentication.

정답: B

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

문제7

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

A. View Cloud SQL operations to view historical query information.

B. Review application logs to identify database calls.

C. Use the Query Insights dashboard to identify high execution times.

D. White a Logs Explorer query to identify database queries with high execution times.

정답: C

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

문제8

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

A. Use BigQuery, and load data in batches.

B. C.Deploy the database using Bigtable.

C. Deploy the database using Cloud SQL.

D. Deploy the database using Cloud Spanner.

정답: B

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

문제9

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?

A. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

B. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

C. Create a VM in Compute Engine, and run a cron job.

D. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).

정답: A

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

문제10

Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

A. Watch Cloud Trace for application requests that are failing.

B. Watch the Cloud SQL recommenders for overprovisioned instances.

C. Watch the Cloud SQL instance monitor for CPU utilization metrics.

D. Watch Query Insights for long running queries.

정답: D

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

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

우리와 연락하기

유용한 링크

최신 업데이트