SnowPro Core

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answersA . SnowSQLB . ODBCC . RD . HIVEView AnswerAnswer: A,B

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:A . Scaling rhythmicallyB . Scaling maxC . Scaling outD . Scaling UpView AnswerAnswer: C

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.A . TrueB . FalseView AnswerAnswer: A

What happens when a Data Provider revokes privileges to a Share on an object in their source database?A . The object immediately becomes unavailable for all Data ConsumersB . Any additional data arriving after this point in time will not be visible to Data ConsumersC . The Data Consumers stop...

The number of queries that a Warehouse can concurrently process is determined by: Choose 2 answersA . The complexity of each queryB . The CONCURRENT_QUERY_UMIT parameter set on the Snowflake accountC . The size of the data required for each queryD . The tool that s executing the queryView AnswerAnswer:...

Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answersA . JavaB . JavaScriptC . SQLD . PythonView AnswerAnswer: B,C

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?A . More micro-partitionsB . Better query schedulingC . Double the numbers of servers In the compute dusterD . Higher storage costsView AnswerAnswer: C

True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).A . TrueB . FalseView AnswerAnswer: B

On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answersA . Amazon Web ServicesB . Private Virtual CloudC . Oracle CloudD . Microsoft Azure CloudView AnswerAnswer: A,D

For a multi-cluster Warehouse, the number of credits billed is calculated on:A . The number of queries that ran using the Warehouse.B . The size of the Warehouse and the number of clusters that ran within a given time period.C . The sue of the Warehouse and the maximum number...