Question 6

Company A would like to share data in Snowflake with Company B.
Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?
  • Question 7

    An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows:
    1) Use Tri-Secret Secure in Snowflake
    2) Share some information stored in a view with another Snowflake customer
    3) Hide portions of sensitive information from some columns
    4) Use zero-copy cloning to refresh the non-production environment from the production environment To meet these requirements, which design elements must be implemented? (Choose three.)
  • Question 8

    A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows.

    The general query patterns for the table are:
    1. DeviceId, lOT_timestamp and Customerld are frequently used in the filter predicate for the select statement
    2. The columns City and DeviceManuf acturer are often retrieved
    3. There is often a count on Uniqueld
    Which field(s) should be used for the clustering key?
  • Question 9

    When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)
  • Question 10

    Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)