ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 52 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 52
Topic #: 1
[All Professional Cloud Database Engineer Questions]

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

  • A. Migrate to Cloud SQL for SQL Server.
  • B. Migrate to Cloud SQL for PostgreSQL.
  • C. Migrate to Compute Engine.
  • D. Migrate to Google Kubernetes Engine (GKE).
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by range9005 at Dec. 22, 2022, 12:35 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dynamic_dba
Highly Voted 2 years, 1 month ago
C. Cloud SQL doesn’t support SSAS, SSRS or SSIS. Eliminate A. Migrating to a different database platform doesn’t make sense. Eliminate B. Minimal disruption to the existing architecture rules out GKE. Eliminate D. Leaves C. Migrate to a GCE VM.
upvoted 5 times
...
cert_pz
Most Recent 6 months, 1 week ago
A) Migrating to Cloud SQL for SQL Server (option A) is the optimal solution for ensuring minimal disruption while leveraging a managed service that maintains compatibility with your existing Microsoft SQL Server architecture. This approach streamlines the migration process and minimizes operational overhead. C. Migrate to Compute Engine: While deploying SQL Server on Compute Engine gives you more control over the environment, it requires more management effort (e.g., handling backups, patches, scaling) compared to a managed service like Cloud SQL. This could lead to higher operational overhead and potential disruptions during migration.
upvoted 1 times
...
Pime13
12 months ago
Selected Answer: C
Still C: https://cloud.google.com/sql/docs/sqlserver/features even though SSRS and SSIS are available (running runs a separate host and connects to Cloud SQL) SSAS is not supported.
upvoted 2 times
...
theseawillclaim
1 year, 7 months ago
Selected Answer: C
You'd need GCE, as Cloud SQL does not support SSAS, SRS and SSIS, as of September 26th, 2023. https://cloud.google.com/sql/docs/sqlserver/features
upvoted 1 times
...
Pilot50
2 years ago
Selected Answer: C
I always wonder why the answers provided are wrong! so wrong and not even close to the reality! why examtopics.com are doing this?
upvoted 3 times
juliorevk
1 year, 6 months ago
They really should just get rid of the answers and just have the discussion unless they plan on making the answers or at least more accurate.
upvoted 2 times
...
ArtistS
1 year, 4 months ago
If they provide the answer as well, you will never see the exam topic any more
upvoted 2 times
...
absero1609
2 years ago
I think they do this on purpose. They simply give a random answer on each question and let us fight in the comment section to find the truth answer. The good thing is that we have to work out ass to find the correct answer and we might learn something new along the way (or at least in my case) :D
upvoted 6 times
felipeschossler
2 years ago
I have to agree 100% witg absero1609 kkkkkkkkkkkkk, researching in the comments and reading the docs that actually let me learn fast for the exam.
upvoted 3 times
...
...
...
Nirca
2 years, 1 month ago
Selected Answer: C
C. Migrate to Compute Engine is the minimal disruption method. customer will keep his SA logins and other system/dba/admin capabilities. and the SSAS SRS SSIS solutions will be migrated as well as "lift & shift" method.
upvoted 1 times
...
GCP72
2 years, 4 months ago
Selected Answer: C
C is the correct answer https://cloud.google.com/sql/docs/sqlserver/features#general_features_unavailable_for
upvoted 3 times
...
pk349
2 years, 4 months ago
The following features are unavailable in Cloud SQL and not supported by Google Cloud support. General features unavailable for Cloud SQL • SQL Server Reporting Services (SSRS) • SQL Server Analysis Services (SSAS) • SQL Server Integration Services (SSIS)
upvoted 2 times
...
pk349
2 years, 4 months ago
C: Migrate to Compute Engine
upvoted 1 times
...
chelbsik
2 years, 4 months ago
Selected Answer: C
SSAS, SSRS, SSIS are unavailable for CloudSQL https://cloud.google.com/sql/docs/sqlserver/features
upvoted 1 times
...
range9005
2 years, 4 months ago
I guess C Migrate to Compute Engine Because Cloud SQL doesn't support SSAS....
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago