Exam (elaborations)
Professional Database Engineer Exam Questions And 100% Correct Answers
- Course
- Institution
Professional Database Engineer Exam Questions And 100% Correct Answers...
[Show more]
Content preview
Professional Database Engineer Exam Questions And 100%Correct Answers
C
You are creating a new application on a VM that is located on your corporate network.
The application will be using Java Database Connectivity (JDBC) to connect to the Cloud
SQL for PostgreSQL. Your Cloud SQL instance is setup to use the IP address
192.168.3.48. You have SSL turned off for your Cloud SQL instance. You would like your
application to communicate with your database instance without having to update
configuration within your database. What do you do?
A. Provide a connection string using your Google username and password to the
external/public IP address of your Cloud SQL instance. B. Using a database username
and password provide a connection string to the internal/private IP address of your
Cloud SQL instance.
C. Define a connection string using Cloud SQL Auth proxy configured with a service
account that points to the internal, private IP address of your Cloud SQL instance.
D. Define a connection string using Cloud SQL Auth proxy configured with a service
account that points to the external, public IP address of your Cloud SQL instance.
D, E
Your e-commerce website is using Cloud SQL for its database workloads. You must
ensure your website is up and available to anyone anywhere in the world 24/7. You need
to set up your Cloud SQL instance for HA. You want to follow Google-recommended
practices. What would you do? (Select two.)
A. Manual backups configuration
B. You create an on-prem PostgreSQL database as the HA option.
C. Automated backups, configured for single zone availability
D. Enable point-in-time recovery
E. Configuring automated backups for scheduling.
Your company is intent on migrating to Google Cloud. For whatever reason, it has been
,determined that your current data center will be shut down in about six months' time.
You are running a large, highly transactional Oracle application footprint on VMWare.
You need to come up with a solution design with least disruption to the existing
architecture and provide ease of migration to Google Cloud. What do you do?
A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware
Engine).
B. Migrate applications along with Oracle databases to Compute Engine.
C. Migrate applications to Cloud SQL.
D. Migrate applications and Oracle databases to GKE.
C
Your customer runs a global chat application on a multi-regional Cloud Spanner
instance. Since the deployment of a new version, the application has been experiencing
poor performance. Your customer contacts you to investigate. Initial troubleshooting
showed read latency to be high. What would you do?
A. Use query parameters to accelerate queries that run frequently.
B. Change the configuration from multi-region to a single region in Cloud Spanner.
C. Run SQLs to analyze SPANNER_SYS.READ_STATS* tables.
D. Run SQLs to analyze SPANNER_SYS.QUERY_STATS* tables.
END
Your company uses PostgreSQL databases on-premise and AWS. Your objective is to
perform multiple migrations of these databases to Cloud SQL with the intent of
minimizing cost and downtime. You would like to align with Googlerecommended
practices, using native data migration tools provided by Google. You also want to
closely monitor the migrations as part of the cutover strategy. What should you do?
A. Migrate all databases to Cloud SQL using the Database Migration Service.
B. Migrate all databases to Cloud SQL using the Database Migration Service for
one-time migrations and leverage third-party or partner tools for change data capture
style migrations.
C. To enable migration, use data replication tools and CDC tools.
D. The Database Migration Service together with a partner tool supports a data
migration strategy.
C
,You are setting up the Bare Metal Solution environment. You want to update the
operating system with the most recent version available and it requires a new software
package from a public source. You have to connect the Bare Metal Solution environment
to the internet for the software update. What would you do?
A. Setup static external IP address in your VPC network.
B. Bring your own IP BYOIP in your VPC.
C. On Compute Engine VM, configure the Cloud NAT gateway.
D. On the Cloud Console, configure the Cloud NAT service.
B
Your company is hosting a MySQL workload in Cloud SQL. You suddenly experience a
performance decline in your database. You must find the root cause of the performance
degradation. What should you do?
A. Use the Logs Explorer to identify the log data.
B. Use Cloud Monitoring to monitor CPU, memory, and storage usage metrics.
C. Use Error Reporting to count, analyze and aggregate the data.
D. Use Cloud Debugger to inspect the state of an application.
B
You work for a large retail and ecommerce company that is just 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 for a reliable customer experience. You require a repository for sales
transactions and current inventory, and you need to have the same relational schema as
is used by the existing platform. What should you do?
A. Store your data in Firestore in a multi-region location, and place your compute
resources in one of the constituent regions.
B. Deploy Cloud Spanner using a multi-region instance, and place your compute
resources close to the default leader region.
C. In Memorystore, create an in-memory cache and stage the cache to the respective
geographic region where your application resides. D. Deploy a Bigtable instance with a
cluster in one region and a replica cluster in another geographic region.
You are hosting an application in Google Cloud. An application located in a single region
, with the use of Cloud SQL for transactional data. The majority of the users of your
application are operating within the same time zone and expect it to be up 7 days a
week, between 6 AM and 10 PM. You want to make sure that regular maintenance
updates to your Cloud SQL instance will not create any downtime for your users. What
would you do?
A. Schedule a Maintenance Window when no user will be on the system. Control the
cadence of the update by setting non-production instances to 'earlier' and production
instances to 'later'.
B. Create your database with one primary node and one read replica in the region.
C. Allow maintenance notifications for users and schedule the maintenance activities to
a specific time after the notifications have been sent.
D. Configure high availability for your Cloud SQL instance.
A
Your team has just released a new version of a highly consumed application to
accommodate the additional user traffic. Not long 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 must resolve the replication lag. What do you do?
A. Run and optimize the queries that take long, or configure parallel replication flags.
B. Kill all running queries and recreate the replicas.
C. Modify the primary to increase the disk size and add vCPU.
D. Modify the primary instance to add more memory.
A
Your company operates under a highly regulated environment. SoC and the security
PoLP is paramount. Operations Team Members include: Person A, a database
administrator.
Person B, an analyst who generates metric reports.
Application C automates the backups of data.
You need to grant Cloud Spanner roles to those listed above personnel. What would you
do?
A. Person A: roles/spanner.databaseAdmin
Person B: roles/spanner.databaseReader
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67866 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now
