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

Snowflake ADA-C02 試験概要:

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

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

問題 #1

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

A. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('ACCOUNT_LOCATOR','ENABLE_ACCOUNT_DATABASE_REPLICATION','true');
B. GRANT ROLE ORGADMIN TO USER <username>;
C. SHOW REGIONS;
D. SHOW ORGANIZATION ACCOUNTS;
E. SHOW USERS;

問題 #2

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

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

問題 #3

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.

問題 #4

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 tablesample block (20 rows);
B. select * from LINEITEM sample system (20);
C. select * from LINEITEM tablesample system (20) seed (1);
D. select * from LINEITEM sample bernoulli (20);

問題 #5

Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

A. alter user user1 set MINS_TO_BYPASS_MFA=1440;
B. alter user user1 set TEMPORARY_MFA_BYPASS=1440;
C. alter user user1 set HOURS_TO_BYPASS_MFA=24;
D. alter user user1 set DISABLE_MFA=1440;

解説：