Online Access Free ADA-C02 Practice Test

A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?

• A.Move all the Snowflake accounts to a single region, and implement data sharing.
• B.Use data replication everywhere to reduce costs associated with same-region sharing.
• C.Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.
• D.Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

What SCIM integration types are supported in Snowflake? (Choose three.)

• A.Amazon Web Services (AWS)
• B.Custom
• C.Google Cloud Platform (GCP)
• D.Okta
• E.Azure Active Directory (Azure AD)
• F.Duo Security Provisioning Connector

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

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

What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)

• A.The account name is immutable and cannot be changed.
• B.The account name must be unique among all Snowflake customers.
• C.The account name must be specified when the account is created.
• D.The account requires at least one ORGADMIN role within one of the organization's accounts.
• E.The account name must be unique within the organization.

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)

• A.MODIFY
• B.OWNERSHIP
• C.USAGE
• D.OPERATE
• E.MONITOR