ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 161 - Professional Cloud Architect discussion

Report
Export

You are moving an application that uses MySQL from on-premises to Google Cloud. The application will run on Compute Engine and will use Cloud SQL. You want to cut over to the Compute Engine deployment of the application with minimal downtime and no data loss to your customers. You want to migrate the application with minimal modification. You also need to determine the cutover strategy. What should you do?

A.
1. Set up Cloud VPN to provide private network connectivity between the Compute Engine application and the on-premises MySQL server.
Answers
A.
1. Set up Cloud VPN to provide private network connectivity between the Compute Engine application and the on-premises MySQL server.
B.
Stop the on-premises application.
Answers
B.
Stop the on-premises application.
C.
Create a mysqldump of the on-premises MySQL server.
Answers
C.
Create a mysqldump of the on-premises MySQL server.
D.
Upload the dump to a Cloud Storage bucket.
Answers
D.
Upload the dump to a Cloud Storage bucket.
E.
Import the dump into Cloud SQL.
Answers
E.
Import the dump into Cloud SQL.
F.
Modify the source code of the application to write queries to both databases and read from its local database.
Answers
F.
Modify the source code of the application to write queries to both databases and read from its local database.
G.
Start the Compute Engine application.
Answers
G.
Start the Compute Engine application.
H.
Stop the on-premises application.
Answers
H.
Stop the on-premises application.
I.
1. Set up Cloud SQL proxy and MySQL proxy.
Answers
I.
1. Set up Cloud SQL proxy and MySQL proxy.
J.
Create a mysqldump of the on-premises MySQL server.
Answers
J.
Create a mysqldump of the on-premises MySQL server.
K.
Upload the dump to a Cloud Storage bucket.
Answers
K.
Upload the dump to a Cloud Storage bucket.
L.
Import the dump into Cloud SQL.
Answers
L.
Import the dump into Cloud SQL.
M.
Stop the on-premises application.
Answers
M.
Stop the on-premises application.
N.
Start the Compute Engine application.
Answers
N.
Start the Compute Engine application.
O.
1. Set up Cloud VPN to provide private network connectivity between the Compute Engine application and the on-premises MySQL server.
Answers
O.
1. Set up Cloud VPN to provide private network connectivity between the Compute Engine application and the on-premises MySQL server.
P.
Stop the on-premises application.
Answers
P.
Stop the on-premises application.
Q.
Start the Compute Engine application, configured to read and write to the on-premises MySQL server.
Answers
Q.
Start the Compute Engine application, configured to read and write to the on-premises MySQL server.
R.
Create the replication configuration in Cloud SQL.
Answers
R.
Create the replication configuration in Cloud SQL.
S.
Configure the source database server to accept connections from the Cloud SQL replica.
Answers
S.
Configure the source database server to accept connections from the Cloud SQL replica.
T.
Finalize the Cloud SQL replica configuration.
Answers
T.
Finalize the Cloud SQL replica configuration.
U.
When replication has been completed, stop the Compute Engine application.
Answers
U.
When replication has been completed, stop the Compute Engine application.
V.
Promote the Cloud SQL replica to a standalone instance.
Answers
V.
Promote the Cloud SQL replica to a standalone instance.
W.
Restart the Compute Engine application, configured to read and write to the Cloud SQL standalone instance.
Answers
W.
Restart the Compute Engine application, configured to read and write to the Cloud SQL standalone instance.
X.
1. Stop the on-premises application.
Answers
X.
1. Stop the on-premises application.
Y.
Create a mysqldump of the on-premises MySQL server.
Answers
Y.
Create a mysqldump of the on-premises MySQL server.
Z.
Upload the dump to a Cloud Storage bucket.
Answers
Z.
Upload the dump to a Cloud Storage bucket.
[.
Import the dump into Cloud SQL.
Answers
[.
Import the dump into Cloud SQL.
\.
Start the application on Compute Engine.
Answers
\.
Start the application on Compute Engine.
Suggested answer: A
asked 18/09/2024
Mathias Bergman
25 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first