Question 101

Assuming all Snowflake accounts are using an Enterprise edition or higher, in which development and testing scenarios would be copying of data be required, and zero-copy cloning not be suitable? (Select TWO).
  • Question 102

    What are purposes for creating a storage integration? (Choose three.)
  • Question 103

    A company needs to have the following features available in its Snowflake account:
    1. Support for Multi-Factor Authentication (MFA)
    2. A minimum of 2 months of Time Travel availability
    3. Database replication in between different regions
    4. Native support for JDBC and ODBC
    5. Customer-managed encryption keys using Tri-Secret Secure
    6. Support for Payment Card Industry Data Security Standards (PCI DSS)
    In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?
  • Question 104

    An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server.
    How can this requirement be met?
  • Question 105

    A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
    What can be done to improve performance?