What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?
Correct Answer: C
For users assigned theACCOUNTADMINrole, Snowflake recommends enforcing Multi-Factor Authentication (MFA) to enhance security. TheACCOUNTADMINrole has extensive permissions, making it crucial to secure accounts held by such users against unauthorized access. MFA adds an additional layer of security by requiring a second form of verification beyond just the username and password, significantly reducing the risk of account compromise. References: Snowflake Security Best Practices
Question 347
Which Snowflow object does not consume and storage costs?
Correct Answer: C
Temporary tables in Snowflake do not consume storage costs. They are designed for transient data that is needed only for the duration of a session. Data stored in temporary tables is held in the virtual warehouse's cache and does not persist beyond the session's lifetime, thereby not incurring any storage charges. Reference: Snowflake Documentation: Temporary Tables
Question 348
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
Correct Answer: C,E
Snowflake virtual warehouses support a configuration file and command line options in SnowSQL to specify a default warehouse, which is characteristic C. Additionally, the size of a virtual warehouse can be changed at any time, which is characteristic E. Thesefeatures provide flexibility and ease of use in managing compute resources2. References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation
Question 349
Which drivers or connectors are supported by Snowflake? (Select TWO)
Correct Answer: C,E
Snowflake supports several official connectors and drivers, including: * Go Snowflake Driver * Snowflake Connector for Python Perl, COBOL, and MongoDB drivers are not supported by Snowflake. Reference: Snowflake Docs: Client Drivers and Connectors
Question 350
How does Snowflake handle the data retention period for a table if a stream has not been consumed?
Correct Answer: C
In Snowflake, the use of streams impacts how the data retention period for a table is handled, particularly in scenarios where the stream has not been consumed. The key point to understand is that Snowflake's streams are designed to capture data manipulation language (DML) changes such as INSERTS, UPDATES, and DELETES that occur on a source table. Streams maintain a record of these changes until they are consumed by a DML operation or a COPY command that references the stream. When a stream is created on a table and remains unconsumed, Snowflake extends the data retention period of the table to ensure that the changes captured by the stream are preserved. This extension is specifically up to the point in time represented by the stream's offset, which effectively ensures that the data necessary for consuming the stream's contents is retained. This mechanism is in place to prevent data loss and ensure the integrity of the stream's data, facilitating accurate and reliable data processing and analysis based on the captured DML changes. This behavior emphasizes the importance of managing streams and their consumption appropriately to balance between data retention needs and storage costs. It's also crucial to understand how this temporary extension of the data retention period impacts the overall management of data within Snowflake, including aspects related to data lifecycle, storage cost implications, and the planning of data consumption strategies. Reference: Snowflake Documentation on Streams: Using Streams Snowflake Documentation on Data Retention: Understanding Data Retention
