Free Snowflake ADA-C01 Exam Actual Questions

The questions for ADA-C01 were last updated On Mar 27, 2025

At ValidExamDumps, we consistently monitor updates to the Snowflake ADA-C01 exam questions by Snowflake. Whenever our team identifies changes in the exam questions,exam objectives, exam focus areas or in exam requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these actual questions, our customers can successfully pass the Snowflake SnowPro Advanced: Administrator Certification exam on their first attempt without needing additional materials or study guides.

Other certification materials providers often include outdated or removed questions by Snowflake in their Snowflake ADA-C01 exam. These outdated questions lead to customers failing their Snowflake SnowPro Advanced: Administrator Certification exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions, guaranteeing their presence in your actual exam. Our main priority is your success in the Snowflake ADA-C01 exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.

 

Question No. 1

What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

Show Answer Hide Answer
Correct Answer: C, E

According to the CREATE ACCOUNT documentation, the account name must be specified when the account is created, and it must be unique within an organization, regardless of which Snowflake Region the account is in. The other options are incorrect because:

* The account does not require at least one ORGADMIN role within one of the organization's accounts. The account can be created by an organization administrator (i.e. a user with the ORGADMIN role) through the web interface or using SQL, but the new account does not inherit the ORGADMIN role from the existing account. The new account will have its own set of users, roles, databases, and warehouses.

* The account name is not immutable and can be changed. The account name can be modified by contacting Snowflake Support and requesting a name change. However, changing the account name may affect some features that depend on the account name, such as SSO or SCIM.

* The account name does not need to be unique among all Snowflake customers. The account name only needs to be unique within the organization, as the account URL also includes the region and cloud platform information. For example, two accounts with the same name can exist in different regions or cloud platforms, such as myaccount.us-east-1.snowflakecomputing.com and myaccount.eu-west-1.aws.snowflakecomputing.com.


Question No. 2

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?

Show Answer Hide Answer
Correct Answer: D

According to the Snowflake documentation1, secure views are only exposed to authorized users who have been granted the role that owns the view. Therefore, applying RBAC directly onto the partner's shared secure views (option A) is not possible, as the administrator does not own those views. Individually granting imported privileges onto the schema in the share (option B) is also not feasible, as the privileges granted on the schema do not apply to existing secure views, only to future ones2. Cloning the data and inserting it into a company-owned share (option C) is not recommended, as it would create unnecessary duplication of data and increase storage costs. The best option is to create views over the incoming shared database and apply the desired RBAC onto these views (option D). This way, the administrator can control the access to the data based on the roles in their account, without modifying the original data or views from the partner.


Question No. 3

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

Show Answer Hide Answer
Correct Answer: B

According to the Network Policies documentation, a network policy can be applied to an account, a security integration, or a user. If there are network policies applied to more than one of these, the most specific network policy overrides more general network policies. The following summarizes the order of precedence:

* Account: Network policies applied to an account are the most general network policies. They are overridden by network policies applied to a security integration or user.

* Security Integration: Network policies applied to a security integration override network policies applied to the account, but are overridden by a network policy applied to a user.

* User: Network policies applied to a user are the most specific network policies. They override both accounts and security integrations.

Therefore, if both the account_level and user_level network policies are defined, the user_level policy will take effect and the account_level policy will be ignored. The other options are incorrect because:

* The account_level policy will not override the user_level policy, as explained above.

* The user_level network policies will be supported, as they are part of the network policy feature.

* A network policy error will not be generated, as there is no conflict between the account_level and user_level network policies.


Question No. 4

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

Show Answer Hide Answer
Correct Answer: A

A masking policy is a SQL expression that transforms the data in a column based on the role that queries the column1. The is_role_in_session function returns true if the specified role is in the current session2. Therefore, the masking policy in option A will mask the column data with asterisks whenever it is queried through a view owned by the MASKED_VIEW_ROLE3. The other options use different functions that do not check the ownership of the view, but rather the current role, the invoker role, or the available roles in the session45. These functions may not return the desired result if the role that owns the view is different from the role that queries the view.


Question No. 5

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

Show Answer Hide Answer
Correct Answer: B

Snowflake's query optimizer can automatically rewrite queries against the base table or regular views to use the materialized view instead, if the query matches the definition of the materialized view1. However, this is not always guaranteed, as the optimizer might decide against using the materialized view based on various factors, such as the freshness of the data, the size of the result set, the complexity of the query, and the availability of the materialized view2. Therefore, the answer is no, because the optimizer might decide against it.