最新のADA-C02問題集で試験を準備する

Snowflake ADA-C02 試験概要:

Snowflake ADA-C02 試験シラバストピック:

Snowflake SnowPro Advanced Administrator ADA-C02 認定 ADA-C02 試験問題：

1. What are benefits of using Snowflake organizations? (Choose two.)

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

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

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

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

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

4. What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

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

5. What are characteristics of data replication in Snowflake? (Choose three.)

A) To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
B) Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.
C) Replication can only occur within the same cloud provider.
D) Users must be granted REPLICATIONADMIN privileges in order to enable replication.
E) The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
F) Databases created from shares can be replicated.

質問と回答：