Snowflake – Post Assessment Name* Email* Phone Number* – 1. Which of the following will allow a user in consumer account to create a database from the share. Select two. ACCOUNTADMIN roleSYSADMIN roleIMPORT SHARE privilegesSECURITY ADMIN role 2. What happens when different value is specified for the minimum & the maximum cluster? Select all that apply The mode is called auto-scaleIf the number of concurrent users and queries increase on the virtual warehouse, additional clustersare started, up to the defined maximum cluster valueIf the demand is decreased the number of clusters are gradually shutdown, up to the definedminimum cluster valueSnowflake starts minimum required clusters in the multi-cluster virtual warehouse that canaccommodate the number of users & number of queriesSnowflake starts all clusters in the multi-cluster virtual warehouse 3. On the Snowflake Web UI, which of the following are buttons in the top bar? Select all that apply SecurityDatabasesSharesRoles 4. You are planning to utilize the multi-cluster virtual warehouse to provide auto-scaling and performance for your users. You want to make sure that the user queries don’t wait in queue and if auto-scaling is required the cluster should auto scale immediately. What is the correct value for Scaling Policy to achieve this? SCALING_POLICY = STANDARDSCALING_POLICY = PERFORMANCESCALING_POLICY = ECONOMY 5. Snowflake automatically determines the most efficient algorithm to compress columns in a micro partitions TrueFalse 6. A Snowflake share …….. has information about the consumer(s)is a container that contains objects to be sharedis only available to enterprise customers 7. You are planning to utilize the multi-cluster virtual warehouse to provide auto-scaling and performance for your users. You want to make sure that the auto scaling doesn’t start clusters immediately and is cost effective. What is the correct value for Scaling Policy to achieve this? SCALING_POLICY = ECONOMYSCALING_POLICY = PERFORMANCESCALING_POLICY = STANDARD 8. Which of the following are characteristics of Snowflake releases? no down timerequire restartallow user to choose whether to upgrade or nottransparent to user 9. What are some of the ways to improve performance in Snowflake? Select all that apply Secondary IndicesQuery Result CachingClustering KeysDedicated Virtual WarehouseMulti Clustering Virtual Warehouse 10. The default table type for new tables in Snowflake is.. PermanentTransientTemporary 11. What snowflake objects can be shared? TablesExternal TablesSecure ViewsRegular ViewsSecure Materialized ViewsSecure UDFs 12. How many number of shares can be created in a Snowflake Account? 10Unlimited50100 13. How many number of consumer accounts can be added to a single share? 101001000Unlimited 14. When a data is shared with an existing snowflake customer, the compute is charged to ProviderConsumerNo Charges applied 15. When a data is shared with an non snowflake customer, the compute is charged to ProviderConsumerNo Charges applied 16. In the Snowflake container hierarchy, what container is represented as a URL (for example: https://AB12345.snowflakecomputing.com)? DatabaseSchemaRoleAccount 17. MFA can be used for connecting to Snowflake via the Snowflake JDBC driver TRUEFALSE 18. Which of the following Snowflake Editions automatically store data in an encrypted state? StandardEnterpriseBusiness Critical 19. What are the names of the three Snowflake Editions offered when signing up for a trial account? Free-Tier BasicStandardEnterpriseBusiness Critical 20. Tri-secret requires that customers manage their own keys TRUEFALSE Submit Should be Empty: Now create your own Jotform - It's free!Create your own Jotform
