3 Months Free Update
3 Months Free Update
3 Months Free Update
An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Select TWO).
An Administrator wants to delegate the administration of a company's data exchange to users who do not have access to the ACCOUNTADMIN role.
How can this requirement be met?
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?
When a role is dropped, which role inherits ownership of objects owned by the dropped role?
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous
loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any
anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Select TWO).
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).
An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to
make a transient copy of this table and wants the transient table to have all the same permissions as the original table.
How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the
requirements? (Select TWO).
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the
database APP_DB containing only one schema, APP_SCHEMA. The company's Time Travel retention policy is currently set for 30 days for both accounts. An Administrator
has been asked to extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?
Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?
What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).
What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).
What is a characteristic of Snowflake's transaction locking and concurrency modeling?