ADA-C02 試験問題を無料オンラインアクセス

What roles can be used to create network policies within Snowflake accounts? (Choose three.)

• A.SECURITYADMIN
• B.Any role with the global permission of CREATE NETWORK POLICY
• C.Any role that owns the database where the network policy is created
• D.ACCOUNTADMIN
• E.ORGADMIN
• F.SYSADMIN

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

• A.Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.
• B.Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.
• C.Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.
• D.Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.

What are benefits of using Snowflake organizations? (Choose two.)

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

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?

• A.Set the data retention policy on the primary database to 60 days.
• B.Set the data retention policy on the primary database to 30 days and the schemas to 60 days.
• C.Set the data retention policy on the schemas in the secondary database to 60 days.
• D.Set the data retention policy on the secondary database to 60 days.

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

• A.Database: Usage
  Schema: Usage, Create Stream
  Table: Select
• B.Database: Usage
  Schema: Usage
  Table: Select, Create Stream
• C.Database: Usage, Create Stream
  Schema: Usage
  Table: Select
• D.Database: Usage
  Schema: Usage
  Table: Select