SnowPro Core

What is the minimum duration charged when starting a virtual warehouse?A . 1 secondB . 1 minuteC . 1 hourD . 1 dayView AnswerAnswer: B

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

Account-level storage usage can be monitored via:A . The snowflake wet Interface (UI) in the Databases section.B . The Snowflake web interface (UI) in the Account -> Billing a usage sectionC . The Information Schema -> ACCOUNT_USAGE_HISTORY ViewD . The Account usage Schema - > ACCOUNT_USAGE_METRICS ViewView AnswerAnswer: B Explanation:...

What is the recommended method for loading data into Snowflake?A . Load row by rowB . Load data in batchC . Load data by writing it In the Snowflake Web Interface (UI)D . Load data via frequent, angle row DML'sView AnswerAnswer: B

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

True or False: During data unloading, only JSON and CSV files can be compressed.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

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,D

Select the three types of tables that exist within Snowflake. Choose 3 answersA . TemporaryB . TransientC . ProvisionedD . PermanentView AnswerAnswer: A,B,D Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

True or False: Snowpipe via RFST API can only reference External Stages as source.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

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...