- All Exams Instant Download
Which stage type can be altered and dropped?
Which stage type can be altered and dropped?A . Database stage B. External stage C. Table stage D. User stageView AnswerAnswer: B
What is the minimum Snowflake edition required to create a materialized view?
What is the minimum Snowflake edition required to create a materialized view?A . Standard Edition B. Enterprise Edition C. Business Critical Edition D. 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.
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?A . Each Snowflake account can be hosted in a different cloud vendor and region. B. Each Snowflake account must be hosted in a different cloud vendor and region C. All Snowflake accounts...
When is the result set cache no longer available? (Select TWO)
When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the query B. When another user executes the query C. When the underlying data has changed D. When the warehouse used to execute the query is suspended E. When it has...
What are value types that a VARIANT column can store? (Select TWO)
What are value types that a VARIANT column can store? (Select TWO)A . STRUCT B. OBJECT C. BINARY D. ARRAY E. CLOBView AnswerAnswer: B, D Explanation: Characteristics of a VARIANT A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT...
Which command can be used to load data into an internal stage?
Which command can be used to load data into an internal stage?A . LOAD B. copy C. GET D. PUTView AnswerAnswer: D Explanation: https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)A . Via the Snowflake Web Interface (Ul) B. Via the data_share=true parameter C. Via SQL commands D. Via Virtual WarehousesView AnswerAnswer: AC Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)A . SCIM B. Federated authentication C. TLS 1.2 D. Key-pair authentication E. OAuth F. OCSP authenticationView AnswerAnswer: B, D, E
Will the developer be able to modify the table to read the masked data?
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).A . Compute Credits = 50 Credits Cloud Services = 10 B. Compute Credits = 80 Credits Cloud Services = 5 C. Compute Credits = 10 Credits Cloud Services = 9 D. Compute Credits = 120 Credits...
