SnowPro Core

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide-connecting.html

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

Which of the following objects can be cloned? (Choose four.)A . TablesB . Named File FormatsC . SchemasD . SharesE . DatabasesF . UsersView AnswerAnswer: A,C,E,F

When creating a user it is advisable sable to: Choose 2 answersA . Set the user to be initially disabledB . Force an immediate password changeC . Set a default role for the userD . Set the number of minutes to unlock to 15 minutesE . Set the users access...

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.A . TrueB . FalseView AnswerAnswer: B

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:A . The Pipe load history is reset to emptyB . The REFRESH parameter is set to TRUEC . Previously loaded files will be ignoredD . All of the aboveView AnswerAnswer: B

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answersA . Their default role should be set to SYSTEMADMIN (the lower of the two)B . They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those...

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?A . 4B . 16C . 32D . 128View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.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...

If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:A . All Snowflake sessions using the warehouse are terminated.B . The last query using the warehouse completes.C . There are no users loaned into Snowflake.D . The Warehouse is inactive for a specified period of time.View...