SnowPro Core V1

True or False: Snowflake charges a premium for storing semi-structured data.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

Which interfaces can be used to create and/or manage Virtual Warehouses?A . The Snowflake Web Interface (UI)B . SQL commandsC . Data integration toolsD . All of the aboveView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses.html

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

True or False: Users are able to see the result sets of queries executed by other users that share their same role.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

What is the minimum Snowflake edition required to create a materialized view?A . Standard EditionB . Enterprise EditionC . Business Critical EditionD . Virtual Private Snowflake EditionView AnswerAnswer: B Explanation: Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.A . TrueB . FalseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/jdbc.html Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed...

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake EditionsB . Is only available to customers with Business Critical EditionC . Restricts or enables access to specific IP addressesD . Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...

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

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

Which of the following statements is true of data loading?A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fastB . The "deal file size for loading is 16MB to match micro-partition sizeC . Marry files in the 10-lOOMB range tend to land...