ADA-C02問題集、Snowflake実際の試験問題

質問 1

A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?

A. The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

B. The table is not big enough to take advantage of the clustering key.

C. Sales across stores are not uniformly distributed.

D. The STORE_ID should be numeric.

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 2

What SCIM integration types are supported in Snowflake? (Choose three.)

A. Custom

B. Amazon Web Services (AWS)

C. Google Cloud Platform (GCP)

D. Azure Active Directory (Azure AD)

E. Okta

F. Duo Security Provisioning Connector

正解: A,D,E

解説: (PassTest メンバーにのみ表示されます)

質問 3

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

A. To keep the query result cache warm for good performance on repeated queries

B. To save costs on warehouse shutdowns and startups for different queries

C. To keep the data cache warm to support good performance of similar queries

D. To save costs by running the warehouse as little as possible

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 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(),
OBJECT_CONSTRUCT(*)
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

B. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
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(1)));

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 5

Which statement allows a Snowflake Administrator to retrieve the network policy applied to their Snowflake account?

A. SHOW PARAMETERS LIKE ‘NETWORK POLICY’ IN ACCOUNT;

B. SHOW NETWORK POLICIES;

C. SHOW NETWORK POLICIES IN ACCOUNT;

D. DESC NETWORK POLICY <policy_name>;

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 6

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

A. Create new roles

B. Create new users

C. Manage system grants

D. Reset a Snowflake user's password

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 7

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:
At 80% usage notify the account Administrators.
At 100% usage suspend the warehouse and notify the account Administrators.
At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

A. create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

B. create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

C. create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do notify and suspend
on 120 percent do notify and suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

D. create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

正解: B

解説: (PassTest メンバーにのみ表示されます)

Snowflake SnowPro Advanced Administrator ADA-C02 - ADA-C02 模擬練習