Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:

1. 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 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.
B) Create a separate table for all the non-PII columns and grant the role DEVELOPER access to the new table.
C) Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.
D) Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.

2. A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTS rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTS that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

A) The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.
B) The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
C) There should be another 2XL warehouse deployed to handle a portion of the load queries.
D) The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

3. What access control policy will be put into place when future grants are assigned to both database and schema objects?

A) An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.
B) Schema privileges will take precedence over database privileges.
C) Database, privileges will take precedence over schema privileges.
D) An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

4. Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

A) Reset a Snowflake user's password
B) Manage system grants
C) Create new roles
D) Create new users

5. An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.
What select command will generate a sample of 20% of the table?

A) select * from LINEITEM sample system (20);
B) select * from LINEITEM tablesample block (20 rows);
C) select * from LINEITEM sample bernoulli (20);
D) select * from LINEITEM tablesample system (20) seed (1);

Solutions: