Your company uses Salesforce for customer relationship management (CRM). ServiceNow for IT service management, and a Cloud SQL database to store customer transaction data. You need to seamlessly…

The correct answer is C. Leverage Pub/Sub and BigQuery to connect the services and transform the data. Important note: The stated correct answer (C) appears to be incorrect for this scenario. Based on Google Cloud's documentation and the specific requirements, B (Application Integration) is almost certainly the right answer. Why B is correct: Google Cloud Application Integration…

Submitted by andreas_gr· Mar 30, 2026Designing and planning a cloud solution architecture

Question

Your company uses Salesforce for customer relationship management (CRM). ServiceNow for IT service management, and a Cloud SQL database to store customer transaction data. You need to seamlessly connect, map. and transform data between these systems to ensure data consistency and enable real-time reporting. You want to follow Google-recommended practices. What should you do?

Options

ALeverage Workflows to connect the services and transform the data.
BLeverage Application Integration to connect the services and transform the data.
CLeverage Pub/Sub and BigQuery to connect the services and transform the data.
DLeverage Pub/Sub and Datastream to connect the services and transform the data.

How the community answered

(31 responses)

A
6% (2)
B
16% (5)
C
74% (23)
D
3% (1)

Explanation

Important note: The stated correct answer (C) appears to be incorrect for this scenario. Based on Google Cloud's documentation and the specific requirements, B (Application Integration) is almost certainly the right answer.

Why B is correct: Google Cloud Application Integration is an iPaaS (Integration Platform as a Service) with pre-built connectors for Salesforce and ServiceNow, native data mapping and transformation capabilities, and is Google's recommended tool for exactly this use case - connecting enterprise SaaS applications with bidirectional data sync and consistency guarantees.

Why the others are wrong:

A (Workflows): Workflows orchestrates sequences of API calls and cloud services, but lacks native data mapping/transformation or pre-built SaaS connectors - it's for process automation, not application integration.
C (Pub/Sub + BigQuery): This is a streaming analytics pipeline, good for real-time reporting but not designed for bidirectional data sync, mapping, or transformation between enterprise systems like Salesforce and ServiceNow.
D (Pub/Sub + Datastream): Datastream is a CDC (Change Data Capture) tool for replicating data from databases - it doesn't integrate with SaaS platforms like Salesforce or ServiceNow.

Memory tip: When you see Salesforce + ServiceNow + "connect/map/transform" in a question, think Application Integration (Google's enterprise iPaaS). Pub/Sub + BigQuery is the pattern for streaming analytics pipelines, not cross-system data consistency.

Verify the source of this question - the listed answer (C) looks like it may be a mistake.

Topics

#Data Integration#Real-time Analytics#Event-driven Architecture#Data Warehousing

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-ARCHITECT Practice