[2026年07月31日] 最速準備で試験合格！ADA-C02問題の事前予備
ADA-C02のPDF問題集リアル2026最近更新された問題
質問 # 32
In general, the monthly billing for database replication is proportional to which variables? (Choose two.)
- A. The frequency of changes to the primary database as a result of data loading or DML operations
- B. The amount of table data in the primary database that changes as a result of data loading or DML operations
- C. The number and size of warehouses defined in the primary account
- D. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts
- E. The frequency of the secondary database refreshes from the primary database
正解：B、E
解説：
Replication billing is proportional to the amount of table data in the primary database that changes and needs to be replicated.
The frequency of secondary database refreshes determines how often changed data is transferred, directly impacting replication costs.
質問 # 33
What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?
- A. 30 days
- B. 90 days
- C. 1 day
- D. 14 days
正解：C
解説：
Transient databases, schemas, and tables are designed for temporary or non-critical data and therefore have a default Time Travel retention period of one day. Even in Enterprise Edition and higher, the default retention for transient objects remains one day, although permanent objects can have longer retention periods configured.
質問 # 34
A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business-Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Choose two.)
- A. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
- B. Increase the multi-cluster maximum to 20 or more clusters.
- C. Increase the minimum number of clusters started in the multi-cluster configuration to 5.
- D. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.
- E. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
正解：A、E
解説：
The best way to handle the once-a-month complex workload is to use a separate, appropriately-sized warehouse dedicated to that workload and to optimize the complex queries with techniques like clustering keys or materialized views. These approaches resolve queueing and performance issues without overspending on always running more clusters.
質問 # 35
An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?
- A. Leverage the CURRENT_DATE function for date calculations.
- B. Assign everyone on the sales team to the same security role.
- C. Wrap the query in a User-Defined Function (UDF) to match syntax execution.
- D. Assign everyone on the sales team to the same virtual warehouse.
正解：A
解説：
Query result caching in Snowflake requires queries to be textually identical. Using CURRENT_TIMESTAMP causes queries to differ on each execution. By switching to CURRENT_DATE, the query becomes stable within a day, allowing Snowflake to reuse persisted results and improve performance.
質問 # 36
What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?
- A. SIMULATED DATA SHARING CONSUMER
- B. TEST ACCOUNT ID
- C. MIMIC CONSUMER ACCOUNT
- D. PRODUCER TEST ACCT
正解：C
解説：
The session parameter MIMIC_CONSUMER_ACCOUNT allows a data provider to test how secure views will appear to a specific consumer account. This ensures the integrity and correctness of secure views before they are shared.
質問 # 37
What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)
- A. Contact Snowflake Support to retrieve Fail-safe data.
- B. SELECT SYSTEM$CANCEL_QUERY('problematic_query_id');
- C. CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => 'problematic_query_id');
- D. CREATE TABLE prd_table_bkp as SELECT * from table(result_scan('problematic_query_id'));
- E. ALTER TABLE prd_table SWAP WITH prd_table_bkp;
正解：C、E
解説：
Creating a clone of a table at a point in time before a problematic statement uses Snowflake Time Travel to restore the table’s previous state without copying data. This allows recovery of the table as it existed before the issue occurred.
Swapping tables enables a fast rollback by exchanging the original production table with the restored backup table. This operation is metadata-only and allows immediate restoration of the previous version of the data with minimal downtime.
質問 # 38
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 system (20) seed (1);
- D. select * from LINEITEM tablesample block (20 rows);
正解：A
解説：
SYSTEM sampling performs block sampling, meaning Snowflake selects entire blocks of rows rather than evaluating each row individually. This satisfies the requirement that the sampling function take data by blocks of rows. Using SYSTEM (20) returns approximately 20% of the table and, since no seed value is specified, the result is not repeatable.
質問 # 39
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)
- A. OWNERSHIP
- B. MODIFY
- C. USAGE
- D. OPERATE
- E. MONITOR
正解：C、E
解説：
USAGE privilege is required to run queries on the warehouse.
MONITOR privilege allows tracking and viewing compute credit usage for the warehouse.
質問 # 40
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. SHOW REGIONS;
- C. SHOW ORGANIZATION ACCOUNTS;
- D. GRANT ROLE ORGADMIN TO USER <username>;
- E. SHOW USERS;
正解：B、C
解説：
Only the ORGADMIN role can run SHOW REGIONS and SHOW ORGANIZATION ACCOUNTS, which provide organization-wide information. These commands are not available to the ACCOUNTADMIN role.
質問 # 41
An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?
- A. Create it as a transient table with a retention time of 0 days.
- B. Create it as a temporary table with a retention time of 0 days.
- C. Create it as an external table, which will not incur Time Travel costs.
- D. Create it as a permanent table with a retention time of 0 days.
正解：A
解説：
A transient table is best suited for staging because it avoids long-term storage costs by not maintaining Fail-safe and can have Time Travel retention set to 0 days. This minimizes storage costs while still providing performance comparable to permanent tables, making it the optimal choice for daily staging data.
質問 # 42
What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?
- A. Database: Usage
Schema: Usage
Table: Select - B. Database: Usage
Schema: Usage, Create Stream
Table: Select - C. Database: Usage, Create Stream
Schema: Usage
Table: Select - D. Database: Usage
Schema: Usage
Table: Select, Create Stream
正解：B
解説：
Database: USAGE is required to access the database.
Schema: USAGE and CREATE STREAM are required to create streams in the schema.
Table: SELECT is needed so the stream can track changes on the table.
質問 # 43
An Administrator needs to configure a virtual warehouse in Snowflake for a new use case with these details:
1. There will be 50-100 concurrent users running reports
2. Minimize costs based on the number of active users at a given time
3. The virtual warehouse should suspend and resume automatically based on user activity
Which configuration will meet these requirements?
- A. create or replace warehouse reporting_wh
warehouse_size = xxxlarge
auto_suspend = 60
auto_resume = true; - B. create or replace warehouse reporting_wh
warehouse_size = medium
auto_suspend = 600
auto_resume = true; - C. create or replace warehouse reporting_wh
warehouse_size = xxxlarge
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = false; - D. create or replace warehouse reporting_wh
warehouse_size = medium
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = true;
正解：D
解説：
Supporting 50-100 concurrent users requires a multi-cluster warehouse so compute resources can scale to handle high concurrency. Setting a maximum cluster count allows Snowflake to automatically add clusters when query demand increases and reduce them when demand drops, which helps minimize cost based on active users. Enabling auto_suspend and auto_resume ensures the warehouse automatically stops when idle and restarts when queries arrive, further optimizing cost and operational efficiency.
質問 # 44
What roles can be used to create network policies within Snowflake accounts? (Choose three.)
- A. ACCOUNTADMIN
- B. SECURITYADMIN
- C. ORGADMIN
- D. Any role that owns the database where the network policy is created
- E. SYSADMIN
- F. Any role with the global permission of CREATE NETWORK POLICY
正解：A、B、C
解説：
SECURITYADMIN, ACCOUNTADMIN, and ORGADMIN roles can create network policies in Snowflake accounts. These roles have the necessary privileges to manage account-level security policies.
質問 # 45
A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?
- A. Location : AWS_WEST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH; - B. Location : AWS_EAST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH; - C. Location : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH; - D. Location : AWS_WEST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;
正解：D
解説：
To update a secondary database with changes from its primary, the ALTER DATABASE <secondary_db> REFRESH; command must be executed in the secondary account/region. In this case, that means running the command on PROD_AWS_WEST in AWS_WEST.
質問 # 46
The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD.WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?
- A. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
- B. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
- C. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
- D. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
正解：A
解説：
Although ACCOUNTADMIN created the table, the future ownership grant ensures ownership of new tables in PROD.WORKING is assigned to PROD_WORKING_OWNER. Since PROD_WORKING_OWNER was granted to SYSADMIN, both roles, along with ACCOUNTADMIN (which always has ultimate rights), can alter or drop the table XYZ.
質問 # 47
What steps are required to set up OKTAAPI token integration in Snowflake?
- A. create or replace security integration okta_provisioning
type = scim
scim_client = 'okta'
run_as_role = 'OKTA PROVISIONER';
Update this step every 6 months. - B. use role ACCOUNTADMIN;
select system$ generate_scim_access_token ('OKTA PROVISIONING');
Update these steps every 12 months. - C. grant role okta_provisioner to role ACCOUNTADMIN;
create or replace security integration okta_provisioning
type = scim
scim_client = 'okta'
run_as_role = 'OKTA PROVISIONER';
Update these steps every 12 months. - D. use role ACCOUNTADMIN;
select system$ generate_scim_access_token ('OKTA PROVISIONING');
Update these steps every 6 months.
正解：D
解説：
Use the ACCOUNTADMIN role to generate the SCIM access token for Okta with system$generate_scim_access_token.
The access token must be regenerated and updated in Okta every 6 months for continued integration.
質問 # 48
Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.
Company A's Administrator created a share.
What object should be added to the share to allow Company B access to the files?
- A. A secure view with a column for file URLs.
- B. A secure view with a column for METADATA$FILENAME.
- C. A secure view with a column for pre-signed URLs.
- D. A secure view with a column for the stage name and a column for the file path.
正解：D
解説：
Sharing a secure view with a column for the stage name and a column for the file path allows Company B to access the referenced files through Snowflake's external or internal stage, without exposing direct URLs. This maintains security and supports seamless access for the recipient.
質問 # 49
An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?
- A. Apply RBAC directly onto the partner's shared secure views.
- B. Create views over the incoming shared database and apply the desired RBAC onto these views.
- C. Individually grant imported privileges onto the schema in the share.
- D. Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.
正解：B
解説：
Permissions cannot be applied directly to objects in a shared database. To enforce role-based access, the Administrator must create views over the shared secure views in a local database and then apply RBAC privileges to those new views. This allows controlling which roles can see which data.
質問 # 50
What SCIM integration types are supported in Snowflake? (Choose three.)
- A. Okta
- B. Amazon Web Services (AWS)
- C. Custom
- D. Duo Security Provisioning Connector
- E. Azure Active Directory (Azure AD)
- F. Google Cloud Platform (GCP)
正解：A、C、E
解説：
Snowflake supports SCIM integrations with Okta, Azure Active Directory (Azure AD), and custom SCIM integrations. These allow automated provisioning and de-provisioning of users and roles. SCIM is not provided directly through AWS, GCP, or Duo.
質問 # 51
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
- A. Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
- B. Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
- C. Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
- D. Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.
正解：D
解説：
The correct step is to use ALTER USER ... SET MINS_TO_BYPASS_MFA = <minutes> which temporarily suspends MFA for the specified duration, allowing the user to log in and reconfigure their MFA without revoking enrollment. This preserves MFA setup and is the supported method in Snowflake.
質問 # 52
What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)
- A. Multiple resource monitors can be applied to a single virtual warehouse.
- B. Resource monitors add no additional load to virtual warehouse compute.
- C. The cost of running a resource monitor is only 10% of a credit, per day of operation.
- D. Resource monitors can be applied to more than one virtual warehouse.
- E. Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
- F. Multiple triggers can be configured across various virtual warehouse thresholds.
正解：A、D、F
解説：
Multiple resource monitors can be assigned to a single virtual warehouse for granular credit control.
Resource monitors support multiple triggers at different usage thresholds.
A single resource monitor can govern multiple virtual warehouses.
質問 # 53
In which scenario will use of an external table simplify a data pipeline?
- A. When continuously writing data from a Snowflake table to external storage
- B. When accessing a Snowflake table that references data files located in cloud storage
- C. When accessing a Snowflake table from an external database within the same region
- D. When accessing a Snowflake table from a relational database
正解：B
解説：
External tables in Snowflake are specifically designed to reference and query data files located in external cloud storage. This simplifies data pipelines by allowing direct SQL access to external data without the need for loading it into Snowflake.
質問 # 54
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 notify and suspend
on 120 percent do notify and 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
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; - D. 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
解説：
The requirement is to enforce a yearly quota of 3000 credits with notifications and suspensions at 80%, 100%, and 120%. The correct command must include frequency = yearly, and specify triggers: notify at 80%, suspend (and notify) at 100%, and suspend immediate (and notify) at 120%.
質問 # 55
What are characteristics of Dynamic Data Masking? (Choose two.)
- A. A single masking policy can be applied to columns with different data types.
- B. A masking policy can be applied to the VALUE column of an external table.
- C. The role that creates the masking policy will always see unmasked data in query results.
- D. A single masking policy can be applied to columns in different tables.
- E. A masking policy that is currently set on a table can be dropped.
正解：D、E
解説：
A masking policy applied to a table or column can be dropped or replaced as needed.
The same masking policy can be reused and applied to columns in different tables.
質問 # 56
......
ADA-C02問題集と練習テスト（62試験問題)：https://jp.fast2test.com/ADA-C02-premium-file.html