An Administrator has a warehouse that is intended to have a credit quota of 3000 for every calendar year. The Administrator must create a resource monitor that performs these tasks:
At 80% usage, notify the account Administrators.
At 100% usage, suspend the warehouse and notify the account Administrators.
At 120% usage, stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command meets these requirements?
An Administrator receives data from a Snowflake partner. The partner shares a dataset containing multiple secure views. The Administrator wants to configure access so that only specific roles can view specific secure views.
How can this be achieved?
An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:
B. etween 50 and 100 concurrent users will run reports.
C. osts must be minimized according to the number of users active at a particular time.
The virtual warehouse must automatically suspend and resume based on user activity.
Which configuration meets these requirements?
Which benefits result from creating and maintaining resource monitors in Snowflake?
Choose three
Which of the following are characteristics of Dynamic Data Masking?
Choose two
Which information must be obtained from the Identity Provider (IdP) to enable federated authentication in Snowflake?
Choose two
An Administrator must create a sample from the LINEITEM table. The sample must not be repeatable, and the sampling function must select data in blocks of rows.
Which SELECT command generates a sample of 20% of the table?
The following commands have been run:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?
A retailer has a TRANSACTIONS table (100M rows, 1.2 TB) clustered by the STORE_ID column (varchar(50)). The vast majority of analysis on this table is grouped by STORE_ID to evaluate store performance.
The retailer operates 1000 stores, but 20 stores account for most sales. The Administrator observes that most queries currently have poor pruning, processing large numbers of bytes even for simple queries.
Why is this happening?
Which roles may be used to create network policies in Snowflake accounts?
Choose three
In general, monthly database-replication billing is proportional to which variables?
Choose two
Which steps are needed to configure OKTAAPI token integration in Snowflake?
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the accountant role.
An application using the accountant role must use this warehouse to run financial reports and track the compute credits consumed by the warehouse. What minimum warehouse privileges should be granted to the role to satisfy these requirements?
Choose two