Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:

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

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

2. A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV_TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN_NAME = 'JDOE' DEFAULT ROLE='JDOE_PROFILE';
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?

A) Assign ownership privilege to DEV_TEAM on the newly-created schema.
B) Set up the new schema as a managed-access schema.
C) Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.
D) Set up future grants on the newly-created schemas.

3. What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

A) MIMIC CONSUMER ACCOUNT
B) TEST ACCOUNT ID
C) SIMULATED DATA SHARING CONSUMER
D) PRODUCER TEST ACCT

4. 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 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.
C) Use data replication everywhere to reduce costs associated with same-region sharing.
D) Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

5. The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD.WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?

A) Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
B) Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
C) PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
D) SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

Solutions: