What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Select TWO).

• A. IdP account details
• B. URL endpoint for SAML requests
• C. IdP encryption key
• D. SAML response format
• E. Authentication certificate

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Select TWO).

• A. Increase the minimum number of clusters started in the multi-cluster configuration to 5.
• B. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
• C. Increase the multi-cluster maximum to 20 or more clusters.
• D. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
• E. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

• A. Any role with GRANT USAGE on SECURITY INTEGRATION
• B. ACCOUNTADMIN and SECURITYADMIN
• C. ACCOUNTADMIN only
• D. ACCOUNTADMIN and SYSADMIN

An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER.
CREATE TABLE customer_data (
customer_first_name string,
customer_last_name string,
customer_address string,
customer_email string,
... some other columns,
);
The application team would like to access the customer data, but the email field must be obfuscated.
How can the Administrator protect the sensitive information, while maintaining the usability of the data?

• A. Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.
• B. Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.
• C. Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
• D. Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.

What are benefits of using Snowflake organizations? (Select TWO).

• A. User administration is simplified across all accounts within the organization.
• B. Administrators can simplify data movement across all accounts within the organization.
• C. Administrators can monitor and understand usage across all accounts in the organization.
• D. Administrators can change Snowflake account editions on-demand based on need.
• E. Administrators have the ability to create accounts in any available cloud provider or region.