COF-C03 Question 240
Single answer3.3 Identify the different Snowflake Connectors and integrationsA company stores customer support tickets in ServiceNow and wants analysts to query that data in Snowflake with minimal custom code. The data should be loaded on a recurring basis using a Snowflake-supported integration pattern rather than building and maintaining a custom application with the Python Connector or JDBC. Which Snowflake capability is the best fit for this requirement?
- A
Use Snowflake Connector for ServiceNow to ingest ServiceNow data into Snowflake
- B
Use SnowSQL to create an ODBC DSN that continuously syncs ServiceNow tables into Snowflake
- C
Use the Snowflake Python Connector because connectors are only for querying Snowflake, not bringing in third-party SaaS data
- D
Use a database replication failover group so Snowflake can replicate ServiceNow data directly into the account
Show answer and explanation
Correct answer: A
Explanation
This question tests the ability to distinguish between Snowflake client connectivity tools and Snowflake-supported connectors/integrations for external systems. In this scenario, the requirement is to ingest data from a third-party SaaS platform, ServiceNow, into Snowflake with minimal custom code. The best match is Snowflake Connector for ServiceNow. By contrast, SnowSQL, JDBC, ODBC, and the Python Connector are primarily client interfaces used to connect applications to Snowflake, not purpose-built SaaS ingestion connectors. Replication/failover features apply to Snowflake-managed objects, not external operational systems. For SnowPro Core, candidates should recognize the difference between drivers/connectors for accessing Snowflake and specialized connectors/integrations for loading or exchanging data with other platforms.
- A. Correct.
Correct. Snowflake provides a Snowflake Connector for ServiceNow for integrating ServiceNow data into Snowflake. This is the most appropriate choice when the goal is to bring ServiceNow data into Snowflake with less custom development and ongoing maintenance than building a bespoke ingestion application.
- B. Incorrect.
Incorrect. SnowSQL is a command-line client for connecting to Snowflake and running SQL or scripts. An ODBC DSN is used by ODBC-based client applications to connect to Snowflake. Neither SnowSQL nor an ODBC DSN provides a native mechanism to continuously synchronize ServiceNow tables into Snowflake.
- C. Incorrect.
Incorrect. The Python Connector is used by custom Python applications to connect to Snowflake, submit SQL, and work with results. While it can be part of a custom ingestion solution, it does not by itself provide a Snowflake-supported SaaS connector for ServiceNow. This option reflects the misconception that Snowflake connectors are limited to client connectivity only.
- D. Incorrect.
Incorrect. Replication and failover groups are used for replicating Snowflake account objects and databases across regions or accounts for business continuity and disaster recovery. They do not replicate data directly from an external SaaS application such as ServiceNow into Snowflake.