Tag - SnowPro Core exam

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . InformaticaB . Power BlC . AdobeD . Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Which statements are true of micro-partitions? Choose 2 answersA . They are approximately 16MB in sizeB . They are stored compressed only if COMPRESS=TRUE on TableC . They are ImmutableD . They are only encrypted in the Enterprise edition and aboveView AnswerAnswer: A,C Explanation: Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69

What is a key feature of Snowflake architecture?A . Zero-copy cloning creates a mirror copy of a database that updates with the originalB . Software updates are automatically applied on a quarterly basisC . Snowflake eliminates resource contention with its virtual warehouse implementationD . Multi-cluster warehouses allow users to run...

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answersA . On-premise availabilityB . SimplicityC . Open source basedD . ConcurrencyE . PerformanceView AnswerAnswer: B,D,E

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1;B . show grants of user USER1;C . describe user USER1;D . show grants on user USER1;View AnswerAnswer: A

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIMB . Federated authenticationC . TLS 1.2D . Key-pair authenticationE . OAuthF . OCSP authenticationView AnswerAnswer: B,D,E

How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of executionB . Querying (select) the size of the stream content...

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.A . TrueB . FalseView AnswerAnswer: B