[Q18-Q38] 実際にあるADA-C02問題集でリアルSnowflake問題集PDFを提供しています [2026年08月]

Share

実際にあるADA-C02問題集でリアルSnowflake問題集PDFを提供しています [2026年08月]

実際のJPNTest ADA-C02問題集PDFで100%合格率を保証します

質問 # 18
What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?

  • A. ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
    ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
    ALTER ACCOUNT my_account SET
    PREVENT_UNLOAD_TO_INLINE_URL = false;
  • B. ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
    ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
    ALTER ACCOUNT my_account SET
    PREVENT_UNLOAD_TO_INLINE_URL = true;
  • C. ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
    ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
    ALTER ACCOUNT my_account SET
    PREVENT_UNLOAD_TO_INLINE_URL = false;
  • D. ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
    ALTER ACCOUNT my_account SET
    REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
    ALTER ACCOUNT my_account SET
    PREVENT_UNLOAD_TO_INLINE_URL = true;

正解:B

解説:
To prevent data exfiltration, Snowflake requires storage integrations for both stage creation and stage operations, ensuring that unmanaged external locations cannot be used. Additionally, setting PREVENT_UNLOAD_TO_INLINE_URL = true blocks unloading directly to unsecured inline URLs. This configuration enforces secure stage usage tied to storage integrations.


質問 # 19
When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

  • A. CURRENT ACCOUNT
  • B. CURRENT USER
  • C. CURRENT CLIENT
  • D. CURRENT ROLE

正解:A

解説:
When building secure views for data sharing, the CURRENT_ACCOUNT function is used to identify and authorize the consuming account. This ensures that row-level security can be enforced per consumer account accessing the shared data.


質問 # 20
In general, the monthly billing for database replication is proportional to which variables? (Choose two.)

  • A. The amount of table data in the primary database that changes as a result of data loading or DML operations
  • B. The number and size of warehouses defined in the primary account
  • C. The frequency of the secondary database refreshes from the primary database
  • D. The frequency of changes to the primary database as a result of data loading or DML operations
  • E. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

正解:A、C

解説:
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.


質問 # 21
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. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
  • B. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
  • C. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
  • D. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

正解:C

解説:
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.


質問 # 22
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 save costs by running the warehouse as little as possible
  • B. To keep the query result cache warm for good performance on repeated queries
  • C. To keep the data cache warm to support good performance of similar queries
  • D. To save costs on warehouse shutdowns and startups for different queries

正解:C

解説:
Setting AUTO_SUSPEND to 0 or NULL prevents the warehouse from suspending, which keeps the data cache warm. This improves performance for dashboards and workloads that frequently run similar queries, since the warehouse avoids cache loss from suspending and resuming.


質問 # 23
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. SECURITYADMIN
  • C. SYSADMIN
  • D. Any role that owns the database where the network policy is created
  • E. ACCOUNTADMIN
  • F. ORGADMIN

正解:B、E、F

解説:
SECURITYADMIN, ACCOUNTADMIN, and ORGADMIN roles can create network policies in Snowflake accounts. These roles have the necessary privileges to manage account-level security policies.


質問 # 24
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. MONITOR
  • C. OPERATE
  • D. USAGE
  • E. MODIFY

正解:B、D

解説:
USAGE privilege is required to run queries on the warehouse.
MONITOR privilege allows tracking and viewing compute credit usage for the warehouse.


質問 # 25
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

  • A. No, because the materialized view may not be up-to-date.
  • B. No, because the optimizer might decide against it.
  • C. No, because joins are not supported by materialized views.
  • D. Yes, because materialized views are always faster.

正解:B

解説:
Even if a query matches the definition of a materialized view, the Snowflake optimizer may decide not to rewrite the query to use it. The optimizer evaluates factors such as freshness, cost, and efficiency before choosing whether or not to substitute the materialized view.


質問 # 26
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

解説:
The network policy applied at the account level is stored as an account parameter. Using a SHOW PARAMETERS command with the filter for NETWORK POLICY at the account scope returns the currently configured value, which identifies the network policy associated with the account.


質問 # 27
What is a characteristic of Snowflake's transaction locking and concurrency modeling?

  • A. A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
  • B. If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.
  • C. Queries executed within a given transaction see that transaction's uncommitted changes.
  • D. Transaction locking in Snowflake is enforced exclusively at the row and table levels.

正解:A

解説:
Snowflake uses multi-version concurrency control (MVCC), which allows queries and DML statements to operate without blocking each other. This architecture eliminates the possibility of deadlocks because transactions work on snapshots of data rather than locking rows or tables in ways that could cause contention.


質問 # 28
Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Choose two.)

  • A. Adding region availability to the listing
  • B. Dropping a column from a table
  • C. Renaming a table
  • D. Unpublishing the data listing
  • E. Deleting data from a table

正解:B、C

解説:
Dropping a column from a table or renaming a table breaks the shared schema and can cause dependent queries to fail for consumers. These are considered breaking changes to shared data in the Snowflake Marketplace.


質問 # 29
Which tasks can be performed by the ORGADMIN role? (Choose three.)

  • A. Create secure views on application tables within the organization.
  • B. View usage information for all accounts in the organization.
  • C. Create one or more accounts in the organization.
  • D. Perform zero-copy cloning on account data.
  • E. View a list of all regions enabled for the organization.
  • F. Create a reader account to share data with another organization.

正解:B、C、E

解説:
The ORGADMIN role can create accounts in the organization, view all enabled regions, and access usage information across all organization accounts. Creating secure views and zero-copy cloning are not ORGADMIN tasks. Reader accounts can be created, but only for sharing within the same organization, not with another organization.


質問 # 30
For Snowflake network policies, what will occur when the account level and user level network policies are both defined?

  • A. The user_level policy will override the account_level policy.
  • B. The account_level policy will override the user_level policy.
  • C. The user_level network policies will not be supported.
  • D. A network policy error will be generated with no definitions provided.

正解:A

解説:
When both account-level and user-level network policies are defined in Snowflake, the user-level policy overrides the account-level policy for that specific user.


質問 # 31
A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?

  • A. Move all the Snowflake accounts to a single region, and implement data sharing.
  • B. Use data replication everywhere to reduce costs associated with same-region sharing.
  • C. Use bi-directional data sharing among offices in the same region and replication among offices across the continents.
  • D. Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.

正解:C

解説:
Direct data sharing is the most cost-efficient method when accounts are in the same region and cloud. For cross-continent or cross-cloud sharing, Snowflake requires replication. Combining both - data sharing within the same region and replication across continents - ensures compliance, minimizes costs, and enables bi-directional sharing.


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

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

正解:D

解説:
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.


質問 # 33
A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

  • A. Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.
  • B. Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.
  • C. Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.
  • D. Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

正解:D

解説:
A multi-cluster warehouse with MIN_CLUSTERS = 2 matches typical usage, while auto-suspend and auto-resume ensure resources are only used when needed. Allowing auto-scaling handles peak periods efficiently, and giving USAGE (not MANAGE) to ANALYST users is secure and appropriate.


質問 # 34
What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)

  • A. The account name must be specified when the account is created.
  • B. The account name must be unique within the organization.
  • C. The account name is immutable and cannot be changed.
  • D. The account requires at least one ORGADMIN role within one of the organization's accounts.
  • E. The account name must be unique among all Snowflake customers.

正解:A、B

解説:
When creating a new account within a Snowflake organization, the account name must be specified at creation and it must be unique within the organization. It does not need to be unique across all Snowflake customers, only within that specific organization.


質問 # 35
A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE
default_role = DEVELOPER_ROLE;
The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

  • A. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.
  • B. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.
  • C. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.
  • D. The new role can only take effect after USERADMIN has logged out.

正解:B

解説:
Creating a user in Snowflake does not automatically grant them roles beyond PUBLIC. To use DEVELOPER_ROLE, the USERADMIN (or another role with MANAGE GRANTS privilege) must explicitly grant DEVELOPER_ROLE to PTORRES. Without this grant, the user cannot assume the role.


質問 # 36
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 pre-signed URLs.
  • B. A secure view with a column for file URLs.
  • C. A secure view with a column for the stage name and a column for the file path.
  • D. A secure view with a column for METADATA$FILENAME.

正解:C

解説:
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.


質問 # 37
What SCIM integration types are supported in Snowflake? (Choose three.)

  • A. Amazon Web Services (AWS)
  • B. Duo Security Provisioning Connector
  • C. Google Cloud Platform (GCP)
  • D. Okta
  • E. Azure Active Directory (Azure AD)
  • F. Custom

正解:D、E、F

解説:
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.


質問 # 38
......

検証済みADA-C02問題集と解答で最新ADA-C02をダウンロード:https://www.jpntest.com/shiken/ADA-C02-mondaishu

弊社を連絡する

我々は12時間以内ですべてのお問い合わせを答えます。

オンラインサポート時間:( UTC+9 ) 9:00-24:00
月曜日から土曜日まで

サポート:現在連絡