SnowPro Core

Which of the following commands are not blocking operations? Choose 2 answersA . UPDATEB . INSERTC . MERGED . COPYView AnswerAnswer: B,D

True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.A . TrueB . FalseView AnswerAnswer: B

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: B

Which formats are supported for unloading data from Snowflake? Choose 2 answersA . Delimited (CSV, TSV, etc.)B . AvroC . JSOND . ORCView AnswerAnswer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

Which of the following statements is true of Snowflake?A . It was built specifically for the cloudB . It was built as an on-premises solution and then ported to the cloudC . It was designed as a hybrid database to allow customers to store data either on premises or in...

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . TrueB . FalseView AnswerAnswer: B

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):A . SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMINB . SECURITYADMIN ACCOUNTADMIN, SYSADMINC . SECURITYADMIN, ACCOUNTADMIND . ACCOUNTADMINView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

Which statement best describes Snowflake tables?A . Snowflake tables are logical representations of underlying physical dataB . Snowflake tables ate the physical instantiation of data loaded Into SnowflakeC . Snowflake tables require that clustering keys be defined to perform optimallyD . Snowflake tables are owned by a userView AnswerAnswer: A...

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?A . INITTIALLY_SUSPENDED = TRUE/FALSEB . START_AFTCR_CREATE = TRUE/FALSEC . START_TTIME = 60 // (seconds from now)D . STARE . TIME = CURRENF . DATE()View AnswerAnswer: A