SnowPro Core

When can a Virtual Warehouse start running queries?A . 12am-5amB . Only during administrator defined time slotsC . When its provisioning is completeD . After replicationView AnswerAnswer: C

True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.A . TrueB . FalseView AnswerAnswer: B

Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answersA . SHOW TABLES;B . SHOW STORAGE BY TABLE;C . Information Schema -> TABLE_STORAGE_METRICSD . Information Schema -> TASLE_HISTORYView AnswerAnswer: A,C

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answersA . MIN(< < column value>>)B . COPYC . SUM(<< column value >>)D . UPDATEView AnswerAnswer: B,C,D

Which of the following statements is true of data loading?A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fastB . The "deal file size for loading is 16MB to match micro-partition sizeC . Marry files in the 10-lOOMB range tend to land...

How a Snowpipe charges calculated?A . Per-second/per Warehouse sizeB . Per-second/per-core granularityC . Number of Pipes in accountD . Total storage bucket sizeView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake EditionsB . Is only available to customers with Business Critical EditionC . Restricts or enables access to specific IP addressesD . Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...

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

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 statements about data sharing are true? choose 2 answersA . New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader AccountsB . All database objects can be included In a shared databaseC . Reader Accounts are created and funded by...