2022 Latest SnowPro-Core DUMPS Q&As with Explanations Verified & Correct Answers [Q65-Q82]

NO.65 Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers

NO.66 Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

NO.67 Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

NO.68 Which formats are supported for unloading data from Snowflake?
Choose 2 answers

NO.69 True or False: Snowflake charges additional fees to Data providers for each share they create.

NO.70 Which of the following commands sets the Virtual Warehouse for a session?

NO.71 Which type of table corresponds to a single Snowflake session?

NO.72 What command is used to load files into an Internal Stage within Snowflake? Select one.

NO.73 True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

NO.74 True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

NO.75 Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)

NO.76 When loading data into Snowflake, the COPY command supports:
Choose 2 answers

NO.77 Which of the following are options when creating a Virtual Warehouse?

NO.78 Which of the following are common use cases for zero-copy cloning?
Choose 3 answers

NO.79 For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.

NO.80 What is the maximum compressed row size in Snowflake?

NO.81 A Virtual Warehouse’s auto-suspend and auto-resume settings apply to:

NO.82 Which of the following DML commands isn’t supported by Snowflake?