Snowflake ADA-C01 問題集

質問 1：
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:
1. At 80% usage notify the account Administrators.
2. At 100% usage suspend the warehouse and notify the account Administrators.
3. 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
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
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;
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
A. No, because the optimizer might decide against it.
B. No, because joins are not supported by materialized views.
C. Yes, because materialized views are always faster.
D. No, because the materialized view may not be up-to-date.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?
A. Use the RESULT_SCAN function to post-process the output of the first query.
B. Prevent the virtual warehouse from suspending between the running of the first and second queries.
C. Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
D. Assign additional clusters to the virtual warehouse.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
A. ACCOUNTADMIN and SYSADMIN
B. ACCOUNTADMIN only
C. Any role with GRANT USAGE on SECURITY INTEGRATION
D. ACCOUNTADMIN and SECURITYADMIN
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).
A. The account requires at least one ORGADMIN role within one of the organization's accounts.
B. The account name must be unique among all Snowflake customers.
C. The account name must be unique within the organization.
D. The account name must be specified when the account is created.
E. The account name is immutable and cannot be changed.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)