Snowflake ADA-C02 試験概要:

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

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

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

A) Users must be granted REPLICATIONADMIN privileges in order to enable replication.
B) The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
C) To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
D) Databases created from shares can be replicated.
E) 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.
F) Replication can only occur within the same cloud provider.

2. DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA.Schema1. The SYSADMIN role clones DatabaseA to DatabaseA_clone.
What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Choose two.)

A) SELECT on all tables and views in DatabaseA_clone.Schema1
B) SELECT on all tables, and only secure views in DatabaseA_clone.Schema1
C) USAGE on the schema DatabaseA_clone
D) USAGE on the database DatabaseA_clone.Schema1
E) SELECT on all tables, and only non-secure views in DatabaseA_clone.Schema1

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

4. A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name: VWH_META
Column 1: SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2: CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH_META?

A) SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1)));
B) SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
OBJECT_CONSTRUCT(*)
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
C) SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(SELECT LAST_QUERY_ID(-1)));
D) SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

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

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

質問と回答：