[Oct-2023] Dumps Practice Exam Questions Study Guide for the SnowPro-Core Exam [Q171-Q194]

NO.171 What is the default character set used when loading CSV files into Snowflake?

NO.172 True or False: Data Providers can share data with only the Data Consumer.

NO.173 In a Snowflake role hierarchy, what is the top-level role?

NO.174 Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

NO.175 True or False: An active warehouse is required to run a COPY INTO statement.

NO.176 True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

NO.177 For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

NO.178 What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

NO.179 Fail-safe is unavailable on which table types?

NO.180 True or False: Snowflake charges a premium for storing semi-structured data.

NO.181 Which of the following describes external functions in Snowflake?

NO.182 Account-level storage usage can be monitored via:

NO.183 True or False: The COPY command must specify a File Format in order to execute.

NO.184 How many network policies can be assigned to an account or specific user at a time?

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

NO.186 Which of the following statements about data sharing are true?
choose 2 answers

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

NO.188 True or False: Users are able to see the result sets of queries executed by other users that share their same role.

NO.189 What is cached during a query on a virtual warehouse?

NO.190 What is the lowest Snowflake edition that offers Time Travel up to 90 days.

NO.191 Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

NO.192 Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.

NO.193 True or False: Snowflake charges a premium for storing semi-structured data.

NO.194 True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.