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

What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).

• A.Resource monitors add no additional load to virtual warehouse compute.
• B.Multiple resource monitors can be applied to a single virtual warehouse.
• C.Resource monitors can be applied to more than one virtual warehouse.
• D.Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
• E.Multiple triggers can be configured across various virtual warehouse thresholds.
• F.The cost of running a resource monitor is only 10% of a credit, per day of operation.

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

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

In which scenario will use of an external table simplify a data pipeline?

• A.When accessing a Snowflake table that references data files located in cloud storage
• B.When accessing a Snowflake table from an external database within the same region
• C.When accessing a Snowflake table from a relational database
• D.When continuously writing data from a Snowflake table to external storage

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).

• A.OWNERSHIP on the task
• B.OWNERSHIP on the database and schema containing the task
• C.EXECUTE TASK on the task
• D.OPERATE on the task
• E.USAGE on the database and schema containing the task

A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region.
When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other roles can only see rows for their own regions?

• A.create or replace row access policy region policy as (region_value varchar) returns boolean ->
  'ALL ACCESS_ROLE' = current_role ()
  and exists (
  select 1 from entitlement_table
  where role = current_role ()
  and region = region_value
  )
• B.create or replace row access policy region policy as (region_value varchar) returns boolean ->
  'ALL ACCESS ROLE' = current_role ()
  )
• C.create or replace row access policy region policy as (region_value varchar) returns boolean ->
  'ALL_ACCESS_ROLE' = current_role ()
  or exists (
  select 1 from entitlement_table
  where role = current_role ()
  and region = region_value
  )
• D.create or replace row access policy region policy as (region_value varchar) returns boolean -> exists ( select 1 from entitlement_table where role = current_role () and region = region_value )