Prep and try our ADA-C02 valid and latest training questions & answers

Snowflake ADA-C02 Exam Overview:

Snowflake ADA-C02 Exam Syllabus Topics:

Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:

1. An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?

A) Individually grant imported privileges onto the schema in the share.
B) Create views over the incoming shared database and apply the desired RBAC onto these views.
C) Apply RBAC directly onto the partner's shared secure views.
D) Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.

2. When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

A) CURRENT CLIENT
B) CURRENT ACCOUNT
C) CURRENT ROLE
D) CURRENT USER

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

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

4. A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business-Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Choose two.)

A) Increase the minimum number of clusters started in the multi-cluster configuration to 5.
B) Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
C) Increase the multi-cluster maximum to 20 or more clusters.
D) Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
E) Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

5. What is a characteristic of Snowflake's transaction locking and concurrency modeling?

A) Transaction locking in Snowflake is enforced exclusively at the row and table levels.
B) A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
C) Queries executed within a given transaction see that transaction's uncommitted changes.
D) If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

Solutions: