You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?
A. Take no backups, and turn off transaction log retention.
B. Turn on automated backup, and turn on transaction log retention.
C. Take one manual backup per day, and turn off transaction log retention.
D. Turn on automated backup, and turn off transaction log retention.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?
A. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
B. Create a read replica in another region, and promote the read replica if a failure occurs.
C. Enable high availability (HA) for the database to make it regional.
D. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
正解:C
質問 3:
Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?
A. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage.
B. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Keep backups older than one day stored in Actifio OnVault storage.
C. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.
D. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
A. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
B. Specify an authorized network with the CIDR range of the VM.
C. Disable and remove the external IP address assignment.
D. Disable and remove the internal IP address assignment.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?
A. Use gcloud sql instances failover <ReplicaInstanceName>.
B. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
C. Use gcloud sql instances failover <PrimaryInstanceName>.
D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
正解:C
質問 6:
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. White a Logs Explorer query to identify database queries with high execution times.
B. Use the Query Insights dashboard to identify high execution times.
C. Review application logs to identify database calls.
D. View Cloud SQL operations to view historical query information.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
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 Cloud Functions to run the export in text format.
B. Use Dataflow to run the export in Avro format.
C. Use Cloud Functions to run the export in Avro format.
D. Use Dataflow to run the export in text format.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
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. Use linear scaling to implement the Autoscaler-based architecture
C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 9:
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
A. Use the mysqldump utility and binary logs.
B. Use Cloud SQL for MySQL external replica.
C. Use external server replication.
D. Use Data Migration Service.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
小林** -
Professional-Cloud-Database-Engineer教科書という感じが少なく読みやすさは抜群です。合格しました。
Pass4Testさん、ありがと