2021 SnowPro Core Certification Exam Questions

1. SnowPro Core Training Questions SnowPro Core Certification Exam https://www.passquestion.com/SnowPro-Core.html

2. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 1 True or False: It is possible to unload structured data to semi-structured formats such as JSON True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet. and parquet. A. True A. True B. False B. False Answer: A Answer: A

3. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 2 Data storage for individual tables can be monitored using which commands and/or object(s)? Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers Choose 2 answers A. SHOW TABLES; A. SHOW TABLES; B. SHOW STORAGE BY TABLE; B. SHOW STORAGE BY TABLE; C. Information Schema -> TABLE_STORAGE_METRICS C. Information Schema -> TABLE_STORAGE_METRICS D. Information Schema -> TASLE_HISTORY D. Information Schema -> TASLE_HISTORY Answer: A,D Answer: A,D

4. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 3 When creating a user it is advisable sable to: Choose 2 answers When creating a user it is advisable sable to: Choose 2 answers A. Set the user to be initially disabled A. Set the user to be initially disabled B. Force an immediate password change B. Force an immediate password change C. Set a default role for the user C. Set a default role for the user D. Set the number of minutes to unlock to 15 minutes D. Set the number of minutes to unlock to 15 minutes E. Set the users access to expire within a specified timeframe E. Set the users access to expire within a specified timeframe Answer: B,C Answer: B,C

5. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 4 True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake usernames and credentials from the sso service and loads them into the customer's Snowflake account. account. A. True A. True B. false: B. false: Answer: B Answer: B

6. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 5 Which of the following statements are true of Snowflake data loading? Choose 3 answers Which of the following statements are true of Snowflake data loading? Choose 3 answers A. VARIANT "nut" values are not the same as SQL Null values A. VARIANT "nut" values are not the same as SQL Null values B. It is recommended to do frequent, single row DMLS B. It is recommended to do frequent, single row DMLS C. It is recommended to validate the data before loading into the Snowflake target C. It is recommended to validate the data before loading into the Snowflake target table D. It is recommended to use staging tables to manage MERGE statements table D. It is recommended to use staging tables to manage MERGE statements Answer: A,C,D Answer: A,C,D

7. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 6 As a best practice, clustering keys should only be defined on tables of which minimum size? As a best practice, clustering keys should only be defined on tables of which minimum size? A. Multi-Kilobyte (KB) Range A. Multi-Kilobyte (KB) Range B. Multi-Megabyte (MB) Range B. Multi-Megabyte (MB) Range C. Multi-Gigabyte (GB) Range C. Multi-Gigabyte (GB) Range D. Multi-Terabyte (TB) Range D. Multi-Terabyte (TB) Range Answer: D Answer: D

8. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 7 What is the maximum compressed row size in Snowflake? What is the maximum compressed row size in Snowflake? A. 8KB A. 8KB B. 16MB B. 16MB C. 50MB C. 50MB D. 4000GB D. 4000GB Answer: B Answer: B

9. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 8 In which layer of its architecture does Snowflake store its metadata statistics? In which layer of its architecture does Snowflake store its metadata statistics? A. Storage Layer A. Storage Layer B. Compute Layer B. Compute Layer C. Database Layer C. Database Layer D. Cloud Service Layer D. Cloud Service Layer Answer: D Answer: D

10. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 9 Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers Choose 2 answers A. Java A. Java B. JavaScript B. JavaScript C. SQL C. SQL D. Python D. Python Answer: B,C Answer: B,C

11. Practice PassQuestion SnowPro Core Training Questions ensure your 100% success Question 10 A Virtual Warehouse's auto-suspend and auto-resume settings apply to: A Virtual Warehouse's auto-suspend and auto-resume settings apply to: A. The primary duster in the virtual warehouse A. The primary duster in the virtual warehouse B. The entire Virtual Warehouse B. The entire Virtual Warehouse C. The database the Virtual Warehouse resides in C. The database the Virtual Warehouse resides in D. The queries currently being run by the Virtual Warehouse D. The queries currently being run by the Virtual Warehouse Answer: B Answer: B