Tentamen (uitwerkingen)
Professional Database Engineer Exam Questions And 100% Correct Answers
- Vak
- Instelling
Professional Database Engineer Exam Questions And 100% Correct Answers...
[Meer zien]Voorbeeld 4 van de 53 pagina's
Voorbeeld 4 van de 53 pagina's
In winkelwagen
Voorbeeld van de inhoud
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
Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:
Bewezen kwaliteit door reviews
Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!
In een paar klikken geregeld
Geen gedoe — betaal gewoon eenmalig met iDeal, Bancontact of creditcard en je bent klaar. Geen abonnement nodig.
Focus op de essentie
Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Easton. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor $14.99. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 69411 samenvattingen verkocht
Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen
