Snowflake ADA-C02 試験概要:

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

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

問題 #1
What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?

A. 14 days
B. 30 days
C. 1 day
D. 90 days

問題 #2
In which scenario will use of an external table simplify a data pipeline?

A. When accessing a Snowflake table that references data files located in cloud storage
B. When accessing a Snowflake table from an external database within the same region
C. When continuously writing data from a Snowflake table to external storage
D. When accessing a Snowflake table from a relational database

問題 #3
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()));

問題 #4
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.

問題 #5
What roles can be used to create network policies within Snowflake accounts? (Choose three.)

A. Any role with the global permission of CREATE NETWORK POLICY
B. ACCOUNTADMIN
C. Any role that owns the database where the network policy is created
D. SYSADMIN
E. SECURITYADMIN
F. ORGADMIN

解説：